Pandas - Data Series - TypeError: Index must be DatetimeIndex

Question

C is a Data series with shape of (10000000, ) with dtypes of dtype(< M8[ns]). I want to create a dataseries which only contain one hour of C.

 c.between_time('22:00:00','23:00:00')

This is the error that I get

 TypeError: Index must be DatetimeIndex

How should I fix it?

you probably need to add the index to the series of type "DateTimeIndex" (and of course it becomes a dataframe), the index currently must be integers — Hypothetical Ninja
– Hypothetical Ninja, Commented Oct 31, 2015 at 15:23

Hypothetical Ninja · Accepted Answer · 2015-10-31 15:37:58Z

4

Try creating a dataframe by initializing an empty dataframe.
I created a sample of 3 dummy times in Series

import pandas as pd  
C = pd.Series(['22:00:00','22:30:00','23:00:00'])

df = pd.DataFrame()
df['C'] = C

#set index to the obervations after converting them to type datetimeIndex
df.index = pd.to_datetime(C)
print df

print df.between_time(df['C'][0],df['C'][2])

edited Oct 31, 2015 at 15:37

answered Oct 31, 2015 at 15:31

Hypothetical Ninja

4,07714 gold badges52 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Hypothetical Ninja Over a year ago

is this what you want?

Hamid K Over a year ago

Thanks, I have a quick question: some of my entries are in the form of 2015-10-05 02:21:36 and some in the form of 2015-10-05. Do you know how can I remove the second ones?

Hamid K Over a year ago

The output of this gives me NAN: df = df.ix[df.time.str.len() > 14]

Hypothetical Ninja Over a year ago

What are the contents of the column called 'time' ?

Hypothetical Ninja Over a year ago

I think you should ask a separate question for it as it is out of scope of the original question.

Collectives™ on Stack Overflow

Pandas - Data Series - TypeError: Index must be DatetimeIndex

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related