rposixct

Adding missing rows


The format of my excel data file is:

 day                 value
 01-01-2000 00:00:00    4
 01-01-2000 00:01:00    3
 01-01-2000 00:02:00    1
 01-01-2000 00:04:00    1

I open my file with this:

ts = read.csv(file=pathfile, header=TRUE, sep=",")

How can I add additional rows with zero number in column “value” into the data frame. Output example:

 day                  value
 01-01-2000 00:00:00    4
 01-01-2000 00:01:00    3
 01-01-2000 00:02:00    1
 01-01-2000 00:03:00    0
 01-01-2000 00:04:00    1

Solution

  • Try:

    ts = read.csv(file=pathfile, header=TRUE, sep=",", stringsAsFactors=F)
    ts.tmp = rbind(ts,list("01-01-2000 00:03:00",0))
    ts.out = ts.tmp[order(ts.tmp$day),]
    

    Notice that you need to force load the strings in first column as character and not factors otherwise you will have issue with the rbind. To get the day column to be a factor after than just do:

    ts.out$day = as.factor(ts.out$day)