我在 excel 中有 2 個不同的列（我在 Python 中使用 pandas 匯入）如下
data['issue created'] = ['12/31/2015 11:59:45 PM', '12/31/2015 11:59:44 PM', '12/31/2015 11:59:29 PM', '12/31/2015 11:59:29 PM']
data['issue closed']= ['12/31/2015 11:57:46 PM', '12/31/2015 11:56:58 PM', '12/31/2015 11:56:30 PM', '12/31/2015 11:55:32 PM']
我如何減去這 2 列以獲得新的列，這給了我經過的時間？
data['elapsed duration'] = data['issue closed'] - data['issue created']
uj5u.com熱心網友回復：
您需要將列轉換為datetime型別。它們現在可能是一種object型別（本質上是 pandas 中的字串）。
data['issue created'] = pd.to_datetime(data['issue created'])
data['issue closed'] = pd.to_datetime(data['issue closed'])
然后，這將使您可以像您寫的那樣將它們減去到一個新列中。
uj5u.com熱心網友回復：
您需要先將日期列轉換為實際日期：
df['issue created'] = pd.to_datetime(df['issue created'])
df['issue closed'] = pd.to_datetime(df['issue closed'])
df['elapsed time'] = df['issue created'] - df['issue closed']
輸出：
>>> df
issue created issue closed elapsed time
0 2015-12-31 23:59:45 2015-12-31 23:57:46 0 days 00:01:59
1 2015-12-31 23:59:44 2015-12-31 23:56:58 0 days 00:02:46
2 2015-12-31 23:59:29 2015-12-31 23:56:30 0 days 00:02:59
3 2015-12-31 23:59:29 2015-12-31 23:55:32 0 days 00:03:57
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/448029.html