获取数据帧中不同子集的最大值和和值。同时绘制每个子集

import pandas as pd
import matplotlib.pyplot as plt

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

# 划分子集
subset1 = df[df['subset'] == 1]
subset2 = df[df['subset'] == 2]
subset3 = df[df['subset'] == 3]

# 计算最大值和和值
max_value1 = subset1['value'].max()
sum_value1 = subset1['value'].sum()

max_value2 = subset2['value'].max()
sum_value2 = subset2['value'].sum()

max_value3 = subset3['value'].max()
sum_value3 = subset3['value'].sum()

# 绘制图形
plt.figure(figsize=(10, 6))

plt.subplot(2, 2, 1)
plt.plot(subset1['value'])
plt.title('Subset 1')

plt.subplot(2, 2, 2)
plt.plot(subset2['value'])
plt.title('Subset 2')

plt.subplot(2, 2, 3)
plt.plot(subset3['value'])
plt.title('Subset 3')

plt.subplot(2, 2, 4)
plt.bar(['Subset 1', 'Subset 2', 'Subset 3'], [sum_value1, sum_value2, sum_value3])
plt.title('Sum Value')

plt.tight_layout()
plt.show()