How to join two dataframes by nearest time-date?

data.table should work for this (can you explain the error you’re coming up against?), although it does tend to convert POSIXlt to POSIXct on its own (perhaps do that conversion on your datetime column manually to keep data.table happy). Also make sure you’re setting the key column before using roll. (I’ve created my own example … Read more