import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sn
# 设置中文字体和负号正常显示
plt.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['axes.unicode_minus'] = False
# 读取数据
df = pd.read_excel(r'../datas/ftx.xlsx')
print(df.head(20))
# 定义季度划分函数
def fn(n):
if n >0 and n < 4:
return 's1'
elif n > 3 and n < 7:
return 's2'
elif n > 6 and n < 10:
ret