python数据可视化实例

# 成绩折线图
import pandas as pd
import matplotlib.pyplot as plt
df = pd.read_excel('成绩表.xlsx')
x = df['姓名']
y1 = df['数学']
y2 = df['语文']
y3 = df['英语']
plt.rcParams['font.sans-serif'] = ['Heiti TC']
plt.figure(figsize=(10, 6))
plt.plot(x, y1, label='数学', color='r', marker='o')
plt.plot(x, y2, label='语文', color='g', marker='o', linestyle='--')
plt.plot(x, y3, label='英语', color='b', marker='o', linestyle='-.')
plt.grid(axis='y')
plt.xlabel('姓名')
plt.ylabel('分数')
plt.legend(['数学', '语文', '英语'])
plt.yticks(range(50, 150, 10))
plt.show()

# 天气预报折线图实例
import pandas as pd
import matplotlib.pyplot as plt
df = pd.read_excel('五一气温.xlsx')
#plt.rcParams['font.sans-serif'] = ['SimHei']