python计算多站点n年每个月的降水平均值

发布时间 2023-06-27 17:13:11作者: 蓝色大螃蟹
#!usr/bin/env python
# -*- coding:utf-8 -*-
"""
@author: Su
@file: calculatejsjp.py
@time: 2023/06/09
@desc:
"""
import pandas as pd

# 读取数据
Data = pd.read_excel('G:/drought/processdata/rawdata/乌兰察布.xlsx')

#按站点分组并计算每月平均值
result = Data.groupby(['name','month'])['rain'].agg('mean')
print(result)

df = pd.DataFrame(result)

writer = pd.ExcelWriter('G:/drought/processdata/output.xlsx')
df.to_excel(writer,sheet_name='Sheet1')
writer._save()

得出的结果