利用Pandas读取Excel数据并简单处理1

import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
# 读取Excel数据
excel_path="C:/Users/CURRY/Desktop/DHW/DHW.xlsx"
d=pd.read_excel(excel_path,sheet_name='Sheet1')

# 遍历，每隔24小时求平均，由逐时水温得到逐日平均水温
j=0
s=0
sum=[]
sum.append(0)
DailyWaterTemp=[]
for i in range(0,8760):
    s=s+d.HourlyWaterTemp[i]
    sum.append(s)
    if (i+1)%24==0:
        j=j+1
        a=(j-1)*24
        b=j*24
        DailyWaterTemp.append((sum[b]-sum[a])/24)

# 绘制全年水温变化
t=np.linspace(1,365,365)
plt.figure(num=3,figsize=(8,5))
plt.plot(t,DailyWaterTemp,color='red',linewidth=0.75,linestyle='--',label='DailyWaterTemp')
plt.xlabel('time[d]')
plt.ylabel('Temperature[℃]')
ax=plt.gca()
ax.set_title('Daily Water Temperature',fontsize='16',color='black')
plt.show()