从 pandas 时间序列生成周日框线图的最佳方法 [英] Best way to generate day-of-week boxplots from a Pandas timeseries

问题描述

我正在尝试为时间序列(例如5分钟的温度观测)创建一组星期几框图.

我的代码:

# ts is our timeseries
ts = df.SomeColumn

dow_map = {}
days = ['MON','TUE','WED','THU','FRI','SAT','SUN']
dow_idx = ts.index.dayofweek

i = 0
for d in days:
    dow_map[d] = ts[dow_idx == i]
    i = i + 1

df = pd.DataFrame(dow_map)
df.boxplot()

结果:

---------------------------------------------------------------------------
Exception                                 Traceback (most recent call last)
<ipython-input-898-6070c45e4c4b> in <module>()
     41     i = i + 1
     42 
---> 43 df = pd.DataFrame(dow_map)
     44 df.boxplot()
...
Exception: Reindexing only valid with uniquely valued Index objects

我确实通过在每周的每一天创建一个DataFrame，然后将它们连接到最终的DataFrame中来找到成功的方法，但这似乎效率不高...

解决方案

1st创建数据框并使用Weekdays方法获取星期几:

import pandas as pd
import numpy.random as random
n=1000
df = pd.DataFrame(random.randn(n), pd.date_range('2010-01-01', periods=n), columns=["data"])
df['Dates'] = df.index
df['week_days'] =df.index.weekday
df

现在旋转该表，使week_days作为列(也可以将Needdaydays更改为days的字符串格式，但留给您使用.

x =df.pivot(index='Dates', columns='week_days', values='data')
x.boxplot()

i am trying to create a set of day-of-week boxplots for a timeseries (e.g. 5-minute temperature observations).

My code:

# ts is our timeseries
ts = df.SomeColumn

dow_map = {}
days = ['MON','TUE','WED','THU','FRI','SAT','SUN']
dow_idx = ts.index.dayofweek

i = 0
for d in days:
    dow_map[d] = ts[dow_idx == i]
    i = i + 1

df = pd.DataFrame(dow_map)
df.boxplot()

results in:

---------------------------------------------------------------------------
Exception                                 Traceback (most recent call last)
<ipython-input-898-6070c45e4c4b> in <module>()
     41     i = i + 1
     42 
---> 43 df = pd.DataFrame(dow_map)
     44 df.boxplot()
...
Exception: Reindexing only valid with uniquely valued Index objects

I did find succcess by creating DataFrames for each day-of-week and then concat-ing them into a final DataFrame, but this seems inefficient...

解决方案

1st Create data frame and use weekdays method to get days of week:

import pandas as pd
import numpy.random as random
n=1000
df = pd.DataFrame(random.randn(n), pd.date_range('2010-01-01', periods=n), columns=["data"])
df['Dates'] = df.index
df['week_days'] =df.index.weekday
df

now pivot that table so that the week_days are as columns (could also change the needdays to string formats of days but leaving that for you.

x =df.pivot(index='Dates', columns='week_days', values='data')
x.boxplot()

这篇关于从 pandas 时间序列生成周日框线图的最佳方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！