
        
        
            
                
                
                    dates = pd.date_range("2020-12-25 12:30:00", "2020-12-26 12:40:00")
df = pd.DataFrame({"A":dates})
df
                
            
               A
0  2020-12-25 12:30:00
1  2020-12-26 12:30:00

Here, column A is of type datetime. We can extract the date (without the time) like so:


        
        
            
                
                
                    df["B"] = df["A"].dt.normalize()
df
                
            
               A           B
0  2020-12-25  2020-12-25
1  2020-12-26  2020-12-26

Here, the normalize() method resets the time to midnight.

Note that the new column B is also of datetime as confirmed below:


        
        
            
                
                
                    df.dtypes
                
            
            A    datetime64[ns]
B    datetime64[ns]

When date is type DatetimeIndex

Consider the following DatetimeIndex:


        
        
            
                
                
                    dates = pd.date_range(start="2020-12-25 15:30:00", periods=3)
dates
                
            
            DatetimeIndex(['2020-12-25 15:30:00', '2020-12-26 15:30:00',
               '2020-12-27 15:30:00'],
              dtype='datetime64[ns]', freq='D')

To remove the time unit from these dates, use the normalize() method:


        
        
            
                
                
                    dates.normalize()
                
            
            DatetimeIndex(['2020-12-25', '2020-12-26', '2020-12-27'], dtype='datetime64[ns]', freq='D')

normalize() resets the time unit to midnight.

Published by Isshin Inada

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!