問題描述
我有一個數據框:
<class 'pandas.core.frame.DataFrame'>
DatetimeIndex: 982 entries, 2009-10-30 00:00:00 to 2012-12-16 00:00:00
Data columns (total 4 columns):
rain 981 non-null values
temp_max 982 non-null values
temp_min 982 non-null values
temp 982 non-null values
dtypes: float64(4)
對于每年/每月的求和，我使用:
For summing per Year/Month i use :
mdata = data.groupby([lambda x: x.year, lambda x: x.month]).agg([sum])
但我需要季節性分析(夏季、冬季等)，那么我如何創建特定月份的總和，例如每年的 [1 ,2 ,3]?
But i need Seasonal analysis (summer, winter etc), so how i can create the Sum of specific months like [1 ,2 ,3] of each year?
泰
推薦答案
是的，對我來說似乎很簡潔的一種解決方案是使用 Seasons 字典，然后使用函數對數據進行分組.作為組鍵傳遞的任何函數，每個索引值都會調用一次，返回值用作組名.
Yes, one solution which seems neat to me is to use a Seasons dictionary and then group the data using a function. Any function passed as a group key is called once per index value and the return values are used as the group names.
import pandas as pd
import numpy as np
from pandas import DataFrame
import datetime
# Create a year's worth of data
base = datetime.date.today() - datetime.timedelta(365)
Datelist = [base + datetime.timedelta(days = x) for x in range(365)]
DF = DataFrame(np.random.rand(365), index = Datelist)
# Create a Seasonal Dictionary that will map months to seasons
SeasonDict = {11: 'Winter', 12: 'Winter', 1: 'Winter', 2: 'Spring', 3: 'Spring', 4: 'Spring', 5: 'Summer', 6: 'Summer', 7: 'Summer',
8: 'Autumn', 9: 'Autumn', 10: 'Autumn'}
# Write a function that will be used to group the data
def GroupFunc(x):
return SeasonDict[x.month]
# Call the function with the groupby operation.
Grouped = DF.groupby(GroupFunc)
Grouped.sum()
該函數獲取每個索引值并在季節字典中查找月份并返回與月份鍵對應的值.該值隨后成為組名.
The function takes each index value and looks up the month in the Seasons Dictionary and returns the value corresponding to the month key. This value then becomes the group name.
或者，您可以使用示例中的 lambda(效率更高，但我認為上面的內容更容易理解):
Alternatively you can use the lambda as in your example (which is more efficient, but I thought the above would be easier to understand):
DF.groupby(lambda x: SeasonDict[x.month]).sum()
根據評論的附加代碼在我看來，您最好對數據進行切片.因此，您可以執行以下操作
ADDITIONAL CODE AS PER COMMENTS It seems to me like you would be better off slicing the data. So you could do the following
DF['Season'] = ""
for row in DF.index:
DF.Season[row] = SeasonDict[row.month]
DFWinter = DF[DF.Season == 'Winter']
現在您有了一個包含冬季數據的新數據框，可以隨意使用.不同之處在于 groupby 操作允許您對所有數據進行相同的操作，而聽起來您想以不同的方式調查數據集不同部分的屬性.為此，最好進行切片，在這種情況下使用布爾切片.
Now you have a new data frame with the winter data in, to play with as you desire. The difference is that the groupby operations allow you to undertake the same operations on all the data, whereas it sounds like you wanted to investigate the properties of different parts of your data set in different ways. To do that its better to slice, in this case using Boolean slicing.
這篇關于Pandas、groupby 和特定月份的求和的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！