转换Datetime列以在Python的数据帧中仅显示天

Question

我有一个数据帧如下

ID                                      Frq   LastOrderDate          Delta
39924946-a3b0-420a-ac55-11c499274fd8    10    2019-10-17 18:39:50    05:20:10
a4355b4f-2ec4-4f91-a424-3492ac749dd1    47    2019-10-17 18:12:40    05:47:20
83861ce3-0627-40a6-9ac5-d66428015e22    3     2019-10-17 18:04:34    05:55:26
ba3d51fb-f19f-421c-85ae-ef1ffe7c270c    16    2019-10-17 17:48:09    06:11:51
00141b15-4def-4a33-98ff-dfad74714b53    1     2019-03-01 16:47:24    230 days 07:12:36

Delta列是“2019-10-18”日期的减号

我想把这个专栏只显示为一天。我尝试使用datetime库并简单地使用Delta.days，但没有成功

Answer 1

给你：

from io import StringIO

s = StringIO("""
ID                                      Frq   LastOrderDate     
39924946-a3b0-420a-ac55-11c499274fd8    10    2019-10-17 18:39:50    
a4355b4f-2ec4-4f91-a424-3492ac749dd1    47    2019-10-17 18:12:40    
83861ce3-0627-40a6-9ac5-d66428015e22    3     2019-10-17 18:04:34    
ba3d51fb-f19f-421c-85ae-ef1ffe7c270c    16    2019-10-17 17:48:09    
00141b15-4def-4a33-98ff-dfad74714b53    1     2019-03-01 16:47:24    
""")

df = pd.read_csv(s, sep="\s+")

df.Frq = pd.to_datetime(df.Frq)

df['Delta'] = df.Frq - pd.to_datetime('2019-10-18')