Skip to content Skip to sidebar Skip to footer

Time Difference Between Timestamps In A Pandas Dataframe As Histogram

I have a data frame with one column that is all timestamps like below. What I need to do is now calculate the difference between each of the timestamps and then use those differenc

Solution 1:

given a dummy df

# df
#                    timestamp
# 0 2020-09-16 00:00:02.713264
# 1 2020-09-16 00:00:02.827854
# 2 2020-09-16 00:00:05.919288
# 3 2020-09-16 00:00:05.940775
# 4 2020-09-16 00:00:06.682184

you should be able to use

ax = df['timestamp'].diff().dropna().dt.total_seconds().plot.hist()
ax.set_xlabel('timedelta[s]')

...which should spawn a plot like enter image description here


Post a Comment for "Time Difference Between Timestamps In A Pandas Dataframe As Histogram"