I'm trying to create a frequency table of some dates with pandas TimeGrouper however it returns error

Question

I'm trying to create frequency table from some dates by pandas TimeGrouper but I receive the following error

input:

t = pd.to_datetime(t)

t = pd.Series(t)

t

output:

0   2019-04-10 10:49:00

1   2019-04-10 10:49:00

2   2019-04-10 10:49:00

3   2019-04-10 10:49:00

4   2019-04-10 10:49:00

5   2019-04-10 10:48:00

6   2019-04-10 10:48:00

7   2019-04-10 10:48:00

8   2019-04-10 10:48:00

9   2019-04-10 10:48:00

Name: tweet.created_at, dtype: datetime64[ns]

input:

t.groupby(pd.core.resample.TimeGrouper('H').count().plot(kind='bar'))

output:

Error: Only valid with DatetimeIndex, TimedeltaIndex or PeriodIndex, but got an instance of 'RangeIndex'

'TimeGrouper' is deprecated. https://stackoverflow.com/a/39186403/6361531 — Scott Boston, Apr 25 '19 at 16:21
uhum. now I wend through your link and used this: t.groupby(pd.Grouper(freq='H')).count().plot() again the same error — Vahid the Great, Apr 25 '19 at 16:28

score 1 · Accepted Answer · edited Jun 14 '19 at 13:03

1

I use this trick to get around:

t.reset_index().set_index(t.name).resample('H').count().plot()

edited Jun 14 '19 at 13:03

Vahid the Great

393
5
18

answered Apr 25 '19 at 16:14

Quang Hoang

146,074
10
56
74

uhum. it returned the following error: return self._engine.get_loc(key). Key Error: 1 – Vahid the Great Apr 25 '19 at 16:21
1

Sorry, that's because `t` has different name, try `set_index('tweet.created_at')` instead of `set_index(1)`. – Quang Hoang Apr 25 '19 at 16:25
1

Or more generally `set_index(t.name)`. – Quang Hoang Apr 25 '19 at 16:26
Wow! Thanks a lot man! It worked. I LOVE YOU. Long live China! – Vahid the Great Apr 25 '19 at 16:31
2

1. I have nothing to do with China. 2. If it works, consider upvote and accept the answer :-). – Quang Hoang Apr 25 '19 at 16:33
1

1. Long live Vietnam* 2. Sure bro. I voted but since my level is not high yet, the website said that my vote will be considered but not displayed. Thanks a lot again! – Vahid the Great Apr 25 '19 at 16:46

I'm trying to create a frequency table of some dates with pandas TimeGrouper however it returns error

1 Answers1