Skip to main content
 首页 » 编程设计

python之截断日期时间对象 pandas

2025年05月04日13jyk

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

    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       

请您参考如下方法:

您只需要:

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