如何绘制日度数据并设置X轴为Jan/Feb格式的月度标签

Yes, this is totally possible! The key steps involve converting your date strings to proper datetime objects (so matplotlib can recognize them as time values) and then customizing the x-axis tick formatting to display month abbreviations instead of individual dates.

Here's how to modify your code to meet the requirement:

1. Convert Date Strings to Datetime Objects #

First, we need to turn the date_utc column from plain strings into datetime values. This lets matplotlib handle the time axis correctly.

import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
from matplotlib.dates import MonthLocator, DateFormatter

# Your original data
d = {'date_utc': ['01 01', '01 02', '02 03', '02 22', '03 05', '04 20'], 'total_green': [3.0, 7.0, 10.0, 14.0, 2.0, 8.0]}
dfTime = pd.DataFrame(data=d)

# Convert date strings to datetime (add a default year since it's missing)
dfTime['date_utc'] = pd.to_datetime(dfTime['date_utc'], format='%m %d', year=2023)

2. Plot the Time Series with Custom X-Axis Formatting #

Now, when plotting, we'll use matplotlib's date locators and formatters to set the x-axis ticks to show month abbreviations (Jan, Feb, etc.):

fig, ax = plt.subplots(figsize=(40, 15))
# Plot with datetime x-axis
sns.lineplot(data=dfTime, x='date_utc', y='total_green', linewidth=2.5)

# Customize axes and title
ax.set_title("Green Words used on Instagram over Time", fontsize=26)
ax.set_xlabel("Month", fontsize=18)
ax.set_ylabel("Green Words", fontsize=18)

# Set x-axis to show month abbreviations
# Place ticks at the start of each month
ax.xaxis.set_major_locator(MonthLocator())
# Format ticks as 3-letter month abbreviations
ax.xaxis.set_major_formatter(DateFormatter('%b'))

# Optional: Adjust tick label font size for readability
ax.tick_params(axis='x', labelsize=16)

plt.show()

• Datetime Conversion: By converting date_utc to datetime, we give matplotlib the context it needs to handle time-based axis scaling and formatting.
• Month Locator: MonthLocator() tells matplotlib to place ticks at the beginning of each month present in your data.
• Date Formatter: DateFormatter('%b') uses the 3-letter month abbreviation (e.g., Jan for January, Feb for February) as the tick label text.
• Optional Adjustments: The tick_params line increases the font size of the x-axis labels to make them easier to read, especially given your large figure size.

This will result in a line plot where the x-axis shows month abbreviations instead of individual dates, while still plotting your daily data points correctly.

内容的提问来源于stack exchange，提问作者mk2080