You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
My tempo tsdf has timestamp column data starting from 2023-02-01 00:00:00 which has tag data for each second. I am trying to aggregate this data on a hourly basis using resample and interpolate but while doing via both these options the timestamp column shows data starting from the previous day 2023-01-31 23:30:00 and the next 1 hour.
PS: I do not have any data of the previous day in my original data frame.
However I want to enforce the start time from what is in my dataset 2023-02-01 00:00:00.
Do we have a provision to enforce this? Believe it is similar to loffset of pandas.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
My tempo tsdf has timestamp column data starting from 2023-02-01 00:00:00 which has tag data for each second. I am trying to aggregate this data on a hourly basis using resample and interpolate but while doing via both these options the timestamp column shows data starting from the previous day 2023-01-31 23:30:00 and the next 1 hour.
PS: I do not have any data of the previous day in my original data frame.
However I want to enforce the start time from what is in my dataset 2023-02-01 00:00:00.
Do we have a provision to enforce this? Believe it is similar to loffset of pandas.
`
tempo_tsdf = TSDF(csvdata_df, ts_col="TimeStampUTC", partition_cols = ["Day"])
#Using interpolate
tempo_tsdf.interpolate(
freq="hr",
func="mean",
target_cols= ["tag"],
method="linear"
)
#using resample
tempo_tsdf.resample(freq='hr', func='mean')
`
Beta Was this translation helpful? Give feedback.
All reactions