merge() creates NA values if date is POSIXct formatted

[mhasanbulli]

If date column is formatted as POSIXct, seq() function produces dates with daylight saving applied. This results in a sequence of days with hour components 23:00:00. When merge happens here

  dtDateValue = merge(dtDateValue, setnames(dtDateValue[ ,list(DateCol = seq(min(get(cDateColumnName)), max(get(cDateColumnName)),"days")), vcGroupingColumnNames], "DateCol", cDateColumnName),  c(vcGroupingColumnNames, cDateColumnName),  all = T)

dtDateValue is updated with NA values for days that have the daylight savings are applied.

Adding na.value = "white" to scale_fill_continuous() reveals those NA values like below.

One solutions is that user formats the dates with as.Date() before plotting. Or, you might consider using as.POSIXct() with tz set to UTC in seq() and then merge.

[dasather]

Sorry for not getting back on this until now.

I've never worked with DST and I'm afraid I don't know how to recreate this. I tried this https://stackoverflow.com/questions/23611556/missing-hour-in-seq-function-generating-time-in-r but I didn't have the missing hour. Can you please help?

[mhasanbulli]

That is all good. I will get latest and see what I can do. Then, send a pull request.