使用数据分割可视化仅显示月份和年份

import pandas as pd
import matplotlib.pyplot as plt

df = pd.read_csv('your_data.csv')  # 替换为你的数据文件路径

df['date'] = pd.to_datetime(df['date'])  # 假设日期列名为'date'
df['year'] = df['date'].dt.year
df['month'] = df['date'].dt.month

pivot_df = df.pivot_table(index=['year', 'month'], values='your_value_column', aggfunc='sum')  # 替换'your_value_column'为你的数值列名
pivot_df.plot(kind='bar', figsize=(12, 6))
plt.title('Data by Year and Month')
plt.xlabel('Year-Month')
plt.ylabel('Value')
plt.show()

date,value
2020-01-01,100
2020-02-01,150
2021-01-01,200
2021-02-01,250

import pandas as pd
import matplotlib.pyplot as plt

# 读取数据
df = pd.read_csv('data.csv')

# 转换日期格式并提取年份和月份
df['date'] = pd.to_datetime(df['date'])
df['year'] = df['date'].dt.year
df['month'] = df['date'].dt.month

# 创建可视化
pivot_df = df.pivot_table(index=['year', 'month'], values='value', aggfunc='sum')
pivot_df.plot(kind='bar', figsize=(12, 6))
plt.title('Data by Year and Month')
plt.xlabel('Year-Month')
plt.ylabel('Value')
plt.show()