Pandas绘图自定义X轴设置问题求助

Hey there! Let's work through your Pandas data processing and plotting challenge step by step—including fixing that X-axis issue you're stuck on. I'll use example code that you can adapt to your actual dataset.

First, let's assume you have a raw DataFrame with year, category, and value columns. We'll split it into separate 2016 and 2017 DataFrames (I'll use set_index here to make merging/calculations easier later):

import pandas as pd
import matplotlib.pyplot as plt

# Replace this with your actual dataset
raw_data = {
    'Year': [2016, 2016, 2017, 2017],
    'Category': ['Electronics', 'Clothing', 'Electronics', 'Clothing'],
    'Sales': [45000, 32000, 54000, 36800]
}
df = pd.DataFrame(raw_data)

# Split into 2016 and 2017 subsets
df_2016 = df[df['Year'] == 2016].set_index('Category')
df_2017 = df[df['Year'] == 2017].set_index('Category')

Next, let's compute the percentage change from 2016 to 2017 for each category. If your DataFrames have matching indices (like above), this is straightforward. If not, using merge is safer to ensure alignment:

# Option 1: If indices match (same categories in both years)
df_2017['Pct_Change_From_2016'] = ((df_2017['Sales'] - df_2016['Sales']) / df_2016['Sales']) * 100

# Option 2: If indices don't match (use merge to align data)
merged_df = pd.merge(df_2016, df_2017, on='Category', suffixes=('_2016', '_2017'))
merged_df['Pct_Change_From_2016'] = ((merged_df['Sales_2017'] - merged_df['Sales_2016']) / merged_df['Sales_2016']) * 100

Now let's tackle that X-axis problem. Common issues include overlapping labels, incorrect tick values, or wanting custom labels. Here are solutions for the most frequent scenarios:

Scenario 1: X-axis labels are overlapping or cut off #

This happens often with long category names. Fix it by rotating labels and adjusting layout:

# Plot 2016 vs 2017 sales
ax = merged_df.plot(kind='bar', x='Category', y=['Sales_2016', 'Sales_2017'], figsize=(10, 6))

# Rotate labels to avoid overlap, align them properly
plt.xticks(rotation=45, ha='right')
# Add clear labels and title
plt.xlabel('Product Category')
plt.ylabel('Total Sales')
plt.title('2016 vs 2017 Sales Performance')
# Auto-adjust layout to prevent label cutoff
plt.tight_layout()
plt.show()

Scenario 2: Customize X-axis tick labels #

If you want to replace default category names with more descriptive text:

# Define custom labels for your categories
custom_x_labels = ['Consumer Electronics', 'Apparel & Accessories']

ax = merged_df.plot(kind='bar', y=['Sales_2016', 'Sales_2017'], figsize=(10, 6))
# Replace default ticks with your custom labels
ax.set_xticklabels(custom_x_labels)
plt.xlabel('Product Category')
plt.show()

Scenario 3: Adjust X-axis range or ticks for continuous data #

If your X-axis is a continuous value (like months instead of categories), you can set explicit ticks:

# Example: If you had monthly data
monthly_data = pd.DataFrame({
    'Month': range(1, 13),
    '2016_Sales': [3800, 4200, 3900, 4500, 4800, 5200, 5500, 5300, 4900, 4700, 5100, 6000],
    '2017_Sales': [4100, 4500, 4200, 4800, 5100, 5600, 5900, 5700, 5300, 5100, 5500, 6400]
})

ax = monthly_data.plot(kind='line', x='Month', y=['2016_Sales', '2017_Sales'], figsize=(10,6))
# Set X-axis ticks to show every month (1-12)
ax.set_xticks(range(1,13))
plt.xlabel('Month (2016/2017)')
plt.ylabel('Monthly Sales')
plt.show()

If you're facing a specific X-axis issue (like missing ticks, incorrect scaling, etc.), feel free to share more details about your plot and dataset!

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