Mathematica中基于CSV文件绘制日期时间轴图表的问题求助

Hey there! I get that you're trying to plot a time-series chart with datetime on the x-axis and integer values on the y-axis from a CSV, but hitting some roadblocks. Let's break this down step by step to get you sorted.

First, Let's Validate the Basics #

• Confirm your CSV has two distinct columns: one containing properly formatted datetime values (e.g., 2024-05-01 14:30) and another with clean integer entries (no text, missing values, or decimals where they shouldn't be).
• If your datetime is split into separate "date" and "time" columns, you'll need to combine them into a single datetime column first before plotting.

Example Working Code (Python + Matplotlib) #

If you're using Python, here's a reliable snippet that handles datetime parsing and clean plotting:

import pandas as pd
import matplotlib.pyplot as plt
from matplotlib.dates import DateFormatter

# Load your CSV - replace column names with your actual ones
df = pd.read_csv('your_data.csv', parse_dates=['datetime_col'], index_col='datetime_col')

# Create the plot
fig, ax = plt.subplots(figsize=(10, 6))
ax.plot(df.index, df['integer_col'], marker='o', linestyle='-', color='#2c3e50')

# Format x-axis dates to be readable
date_format = DateFormatter("%Y-%m-%d %H:%M")
ax.xaxis.set_major_formatter(date_format)
plt.xticks(rotation=45)

# Add labels and title
ax.set_xlabel('Date & Time')
ax.set_ylabel('Integer Value')
ax.set_title('Datetime vs Integer Time Series')

plt.tight_layout()
plt.show()

Common Fixes for Typical Errors #

• Datetime parsing failures: If pandas can't auto-detect your datetime format, explicitly define it with the format parameter in read_csv (e.g., format="%d/%m/%Y %H:%M" for day/month/year timestamps).
• Non-numeric y-axis values: Use pd.to_numeric(df['integer_col'], errors='coerce') to turn invalid entries into NaNs, then drop them with df.dropna() to avoid plotting errors.
• Overlapping x-axis labels: The rotation=45 and tight_layout() in the example fixes this, but you can also use ax.xaxis.set_major_locator() to show fewer ticks for cleaner spacing.

If you can share the exact error message you're seeing, or a small sample of your CSV data (redact any sensitive info!), I can help you pinpoint the exact issue.

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