這是我到目前為止的代碼:
import pandas as pd
df = pd.read_csv('/content/drive/MyDrive/Colab Datasets/KickstarterRevised.csv')
df['deadline'] = pd.to_datetime(df['deadline'])
df['launched'] = pd.to_datetime(df['launched'])
df['difference'] = df['deadline'].sub(df['launched'], axis=0)
df['difference']
0 58 days 23:24:00
1 45 days 00:00:00
2 30 days 01:00:00
3 55 days 16:25:00
4 35 days 00:00:00
...
4994 40 days 00:00:00
4995 8 days 10:50:00
4996 38 days 18:53:00
4997 30 days 00:00:00
4998 30 days 00:00:00
Name: difference, Length: 4999, dtype: timedelta64[ns]
uj5u.com熱心網友回復:
正如您從代碼中看到的,df['difference']是一個帶有dtype: timedelta64[ns]. 要獲得日期,只需使用.astype("timedelta64[D]"),見下文
df['difference'] = df['deadline'].sub(df['launched'], axis=0).astype('timedelta64[D]')
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/321375.html
上一篇:替換日期時間物件上的分鐘
