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