均值、最大值和最小值与日期时间的散点图

import matplotlib.pyplot as plt
import pandas as pd

# 示例数据
data = {
    'datetime': pd.date_range(start='1/1/2020', periods=1000, freq='H'),
    'mean': [i % 100 for i in range(1000)],
    'max': [i % 150 for i in range(1000)],
    'min': [i % 50 for i in range(1000)]
}
df = pd.DataFrame(data)

# 绘制均值散点图
plt.figure(figsize=(10, 6))
plt.scatter(df['datetime'], df['mean'], alpha=0.5, label='Mean')
plt.scatter(df['datetime'], df['max'], alpha=0.5, label='Max')
plt.scatter(df['datetime'], df['min'], alpha=0.5, label='Min')
plt.xlabel('Date Time')
plt.ylabel('Values')
plt.legend()
plt.show()

# 示例数据中插入缺失值
df.loc[100:150, 'mean'] = None

# 插值填充缺失值
df['mean'] = df['mean'].interpolate()

# 绘制均值散点图
plt.figure(figsize=(10, 6))
plt.scatter(df['datetime'], df['mean'], alpha=0.5, label='Mean')
plt.xlabel('Date Time')
plt.ylabel('Values')
plt.legend()
plt.show()