Python将字符串转换为datetime以查找差异

Question

我有一个CSV文件，它导出日期如下- 2020-04-10T17:04:17.536Z和2020-04-13T15:18:07.327Z

df2和df3将其分为以下格式- 2020-04-10和2020-04-13

我希望能够将这两个日期相减得到天数，但仍然得到错误- TypeError: strptime()参数1必须是字符串，而不是序列

我对任何类型的编程都是非常陌生的，非常感谢任何帮助。

此外，一些df3将是空的，那么我如何设置它来插入当前日期，以便它有一些要减去的内容？

import_file_path = filedialog.askopenfilename()
df1 = pd.read_csv (import_file_path)
df2 = df1['CreateDate'].str.split('T').str[0]
df3 = df1['ResolvedDate'].str.split('T').str[0]


create_date = df2
resolved_date = df3
def Avg_Lifetime(date_str):
    return datetime.strptime(date_str, '%Y, %m, %d')
    
    
created = Avg_Lifetime(create_date)
resolved = Avg_Lifetime(resolved_date)

df9 = resolved - created

Answer 1

d = {'created':['2020-04-10T17:04:17.536Z'],
     'resolved':['2020-04-13T15:18:07.327Z']}

df = pd.DataFrame(d)

df['created']=pd.to_datetime(df['created'])
df['resolved']=pd.to_datetime(df['resolved'])

df['difference'] = df['resolved']-df['created']