Truncate datetime object pandas

Question

I would like to truncate the time from my datetime object. My min example looks like this:

    date  
 s1  7/26/2018 9:31       
 s2  7/26/2018 9:32      
 s3  7/26/2018 9:33       
 s4  7/26/2018 9:34      
 s5  7/26/2018 9:35       
 s6  7/26/2018 9:36     

data = [{'date': '7/26/2018 9:31'},{'date': '7/26/2018 9:32'}, 
{'date': '7/26/2018 9:33'},{'date': '7/26/2018 9:34'},
{'date': '7/26/2018 9:35'},{'date': '7/26/2018 9:36'}]

df = pd.DataFrame(data, index=['s1', 's2','s3','s4','s5','s6'])

I would like to truncate the time from my datetime object. My goal looks like this:

    date  
 s1  7/26/2018       
 s2  7/26/2018       
 s3  7/26/2018        
 s4  7/26/2018       
 s5  7/26/2018        
 s6  7/26/2018      

Answer 1

You simply need:

pd.to_datetime(df.date).dt.date

Output:

s1    2018-07-26
s2    2018-07-26
s3    2018-07-26
s4    2018-07-26
s5    2018-07-26
s6    2018-07-26
Name: date, dtype: object