效果图
import pandas as pd
import numpy as np
import matplotlib as mpl
import matplotlib.pyplot as plt
mpl.rcParams['font.sans-serif']=['SimHei']
df =pd.read_excel(r'E:\同花顺全部数据\T3-4月获利合并.xlsx')
print(df.columns)
plt.rcParams['axes.unicode_minus'] = False #显示负号
plt.xlabel('开盘涨幅')
plt.ylabel('开盘买开盘卖获利情况')
x=np.array(df['开盘涨幅'])
y=np.array(df['开买开卖'])
plt.scatter(x,y)
plt.show()