pandas - 熊猫df histo，格式化我的x代码，并包含空白(Pandas df histo, format my x ticker and include empty)

Question

I got this pandas df:

(我得到了这个熊猫df：)

index      TIME
12:07      2019-06-03  12:07:28
10:04      2019-06-04  10:04:25
11:14      2019-06-09  11:14:25
...

I use this command to do an histogram to plot how much occurence for each 15min periods

(我使用此命令进行直方图绘制每15分钟的发生次数)

df['TIME'].groupby([df["TIME"].dt.hour, df["TIME"].dt.minute]).count().plot(kind="bar")

my plot look like this:

(我的情节看起来像这样：)

How can I get x tick like 10:15 in lieu of (10, 15) and how manage to add x tick missing like 9:15, 9:30... to get a complet time line??

(我怎样才能像10:15一样获得x刻度来代替（10，15），以及如何设法像9：15、9：30那样添加x刻度缺失……以获得完整的时间线？)

  ask by Jonathan Roy translate from so

Answer 1

You can resample your TIME column to 15 mins intervalls and count the number of rows.

(您可以将TIME列resample到15分钟间隔并计数行数。)

Then plot a regular bar chart.

(然后绘制常规条形图。)

df = pd.DataFrame({'TIME': pd.to_datetime('2019-01-01') + pd.to_timedelta(pd.np.random.rand(100) * 3, unit='h')})
df = df[df.TIME.dt.minute > 15] # make gap
df.resample('15T', on='TIME').count().plot.bar()