python - 截断日期时间对象 pandas

Question

我想从我的日期时间对象中截断时间。我的最小示例如下所示:

    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'])

我想从我的日期时间对象中截断时间。我的目标是这样的:

    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

您只需要:

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

输出:

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