在 pandas 折线图中绘制多列

2022-01-21 00:00:00 python pandas dataset linegraph

问题描述

我正在尝试在折线图中绘制多个列,其中月"作为 X 轴,每个计数"作为新行.我希望它有 5 行,'Count-18..Count-14'.我尝试绘制 1 行作为测试,但是当我运行以下代码时,我得到以下输出但没有图表.有什么想法吗?

I am trying to plot a multiple columns in a line graph with 'Month' as the X axis and each 'Count' as a new line. I want it to have 5 lines, 'Count-18..Count-14'. I tried plotting 1 line as a test but when I run the following code I get the following output with no graph. Any ideas?

ax = plt.gca()

DomReg1418.plot(kind='line',x='Month',y='Count-18',ax=ax)


解决方案

当你有一个 DataFrame 有一列用作 X 轴和其他作为绘制线条的来源,您应该:

When you have a DataFrame with one column to be used as X axis and other as a source of lines to draw, you should:

  • 将索引设置为X"列(在您的情况下为 Month),
  • 运行绘图,
  • 用分号结束命令,以阻止文本消息关于图片对象.

代码如下:

DomReg1418.set_index('Month').plot();

对于测试,我在前 6 个月输入了 X 和 3 个 Count 列并执行上述命令,得到如下结果:

For the test, I entered X and 3 Count columns, for first 6 months and executed the above command, getting the following result:

相关文章