pandas 季度,使用python和pandas按季度分组数据

84 阅读 0 评论 56 点赞

我是靠谱客的博主从容大白，这篇文章主要介绍pandas 季度,使用python和pandas按季度分组数据，现在分享给大家，希望可以做个参考。

I want to use Pandas and Python to iterate through my .csv file and group the data by seasons calculating the mean for each season in the year. Currently the quarterly script does Jan-Mar, Apr-Jun etc. I want the seasons correlate to months by - 11: 'Winter', 12: 'Winter', 1: 'Winter', 2: 'Spring', 3: 'Spring', 4: 'Spring', 5: 'Summer', 6: 'Summer', 7: 'Summer',

8: 'Autumn', 9: 'Autumn', 10: 'Autumn'

I have the following data:

Date,HAD

01/01/1951,1

02/01/1951,-0.13161201

03/01/1951,-0.271796132

04/01/1951,-0.258977158

05/01/1951,-0.198823057

06/01/1951,0.167794502

07/01/1951,0.046093808

08/01/1951,-0.122396694

09/01/1951,-0.121824587