python中matplotlib出错_Python matplotlib 画直方图出错？

sql3 = 'select sum(comment_num) as total_col,create_time from article GROUP BY create_time'

df = pd.read_sql(sql3, conn)

print(df)

# 总数

# N = 22

# 宽度

width = 0.45

# ind = np.arange(N)

plt.bar(df['create_time'], df['total_col'], width, color='r', label='total_col')

plt.xlabel(u"发表日期")

plt.ylabel(u"总评论数")

plt.title(u"每日发表文章的总评论数直方分布图")

plt.legend()

plt.show()

df：

total_col create_time

0 2.0 2017-04-27

1 0.0 2017-05-09

2 3.0 2017-05-10

3 6.0 2017-05-11

4 3.0 2017-05-12

5 2.0 2017-05-13

6 1.0 2017-05-14

7 0.0 2017-05-15

8 5.0 2017-05-16

9 0.0 2017-05-17

10 1.0 2017-05-18

11 0.0 2017-05-19

12 6.0 2017-05-22