CODEWITHSUNDEEP
pythonpandasindexingseconds
Runner Bean
Runner Bean

Reputation: 5165

pandas remove seconds from datetime index

I have a pandas dataFrame called 'df' as follows

                       value    
2015-09-27 03:58:30    1.0  
2015-09-27 03:59:30    1.0  
2015-09-27 04:00:30    1.0  
2015-09-27 04:01:30    1.0

I just want to strip out the seconds to get this

                       value    
2015-09-27 03:58:00    1.0  
2015-09-27 03:59:00    1.0  
2015-09-27 04:00:00    1.0  
2015-09-27 04:01:00    1.0

How can i do this?

ive tried things like

df.index.to_series().apply(datetime.replace(second=0, microsecond=0))

but i always get errors 

TypeError: descriptor 'replace' of 'datetime.datetime' object needs an argument

Upvotes: 13

Views: 13459

Answers (1)

Nickil Maveli
Nickil Maveli

Reputation: 29711

You could use datetime.replace to alter the second's attribute as shown:

df.index = df.index.map(lambda x: x.replace(second=0))

Image

Upvotes: 27

Related Questions