r - reshaping daily time series data -

-

i have daily time series data starting 1980 , ends @ 2013 , following format https://www.dropbox.com/s/i6qu6epxzdksvg7/a.xlsx?dl=0. codes far are

   # trying reshape data    require(reshape)    data <- melt(data1, id.vars=c("year","month"))

however, did not me desired output. have data in 4 columns ( year, month, day , data ) or 2 columns ( date , data) in time series ( starting 1st jan 1980 , ends 31st dec 2013)

i grateful guidance on how done.

with kind regards

extending jason's / dominic's solution gives example of how plot data xts time series asked for:

    library(xts)     dat<-read.csv('~/downloads/stack_a.csv')     dat.m <-reshape(dat,direction='long',idvar=c('year','month'),varying=list(3:33),v.names='value')     dat.m <- dat.m[order(dat.m[,1],dat.m[,2],dat.m[,3]),] # order year, month, day(time)      dat.m$date <-paste0(dat.m$year,'-',dat.m$month,'-',dat.m$time) # concatenate these 3 columns     dat.m <- na.omit(dat.m) # remove nas introduced in original data      dat.xts <- as.xts(dat.m$value,order.by = as.date(dat.m$date))     names(dat.xts) <- 'value'     plot(dat.xts)

Comments

Post a Comment

Popular posts from this blog

node.js - How to mock a third-party api calls in the backend -

-
i'm testing application mocha , supertest, test like var request = require('supertest'), app = require('./bootstrap.js'); describe('...', function() { it('...', function() { request(app) .get('/some/url') // ... }); }); the bootstrap.js real application before listen ports all works perfect have add calls third-party api , testing slow so when do, test example takes 5 seconds request(app) .get('/my/endpoint/that/makes/call/others') // ... how can make fake calls during test real when running application? you can use nock purpose.
Read more

amazon web services - Installing MobileFirst 7.0 server on AWS -

-
are there instructions installing mobilefirst server 7.0 on aws ec2(amazon web services). found article ( https://www.ibm.com/developerworks/community/blogs/worklight/entry/how_to_install_worklight_server_on_amazon_ec21?lang=en ), seems outdated latest versions. appreciate if has generic document installing mobilefirst on cloud services aws. mobilefirst platform foundation 7.0 not different worklight 6.2 etc, it's same new features, etc. you setup account ec2 vm, running linux, , mfpf supports linux. nothing different perspective. meaning, blog post you've found true mfpf 7.0.
Read more

Non Unique Username with ASP.Net Identity 2.0 -

-
i have situation username not unique. email used username , 1 email can have many different passwords in database , legitimate. how use asp.net identity 2.0 in situation. var result = await signinmanager.passwordsigninasync(model.username, model.password, model.rememberme, shouldlockout: false); above line expects 1 user in database. if multiple records returned - returns failure. expected logic doesn't work me. how override logic? alternatively, ready customize login problem - not sure things done part of passwordsigninasync. adding cookies etc. please help. i made work. had use username + password combination unique username. these different situations in industry different types of needs.
Read more