英文:
Line plot x axis using pandas python
问题
结果
年份 月份 最小天数 平均天数 中位数天数 计数
2015 1 9 12.56666666 10 4
2015 2 10 13.67678788 9 3
........................................................
2016 12 12 15.7889990 19 2
以此类推...
我想创建一个折线图，根据年份和月份来绘制最小天数、平均天数、中位数天数和计数。我该如何做？
到目前为止尝试的代码
axes = result.plot.line(subplots=True)
type(axes)
这个代码运行得很好，但我也得到了年份和月份的子图。我希望年份和月份在x轴上。
**尝试的代码2:**
import matplotlib.pyplot as plt
fig, ax = plt.subplots()
result.groupby('年份').plot(x='年份', y='中位数天数', ax=ax, legend=False)
这段代码的问题是它只按年份分组。我需要月份（2015年1月，2015年2月等）。另一个问题是这给我一个单一的子图用于中位数。如何添加均值、最小值等子图？
**编辑:**
P.S. 如果有人可以回答，如果月份整数被替换为月份名称（一月、二月等），那将是很棒的。
英文:
result
year Month Min_days Avg_days Median_days Count
2015 1 9 12.56666666 10 4
2015 2 10 13.67678788 9 3
........................................................
2016 12 12 15.7889990 19 2
and so on...
I wish to create a line plot plotting min_days, avg_days, median_days, count according to month and year say. how can I do that
Codes tried till now
axes = result.plot.line(subplots=True)
type(axes)
This works great but I m also getting subplots of year and month. I want year and month to be on x axis
Code2 tried:
import matplotlib.pyplot as plt
fig, ax = plt.subplots()
result.groupby('Year').plot(x='Year', y='Median_days', ax=ax, legend=False)
The issue with this code is it groupbys only year. I need month too (Jan 2015, Feb 2015 and so on). Also another issue is This gives me a single subplot for Median. How to add subplots for mean, min etc
Edit:
P.S. Also if someone can answer in case month int is replaced with month names (Jan, Feb etc. it would be great)
答案1
得分: 1
一个解决方法是首先创建一个年-月列：
result["year-month"] = pd.to_datetime(
result.year.astype(str) + "-" + result.Month.astype(str)
)
fig, ax = plt.subplots()
for col in ["Min_days", "Avg_days", "Median_days", "Count"]:
ax.plot(result["year-month"], result[col], label=col)
ax.legend(loc="best")
ax.tick_params(axis="x", rotation=30)
根据您提供的有限数据，您会得到：
英文:
One solution could be to first create a year-month column:
result["year-month"] = pd.to_datetime(
result.year.astype(str) + "-" + result.Month.astype(str)
)
fig, ax = plt.subplots()
for col in ["Min_days", "Avg_days", "Median_days", "Count"]:
ax.plot(result["year-month"], result[col], label=col)
ax.legend(loc="best")
ax.tick_params(axis="x", rotation=30)
With the limited data you've given us, you'll get:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论