我有以下数据框
flight_departure arrival_at_desination boarding total_flight_time total_flight_time/2 time_to_collect_bags
0:00 4:00 23:30 4:00 2:00 4:30
9:00 14:30 8:30 5:30 2:45 15:00
flight_departure- 0:00 signifies 12:00 AM
arrival_at_desination- 4:00 signifies 4 AM
boarding = flight_departure-30 minutes(23:30)
total_flight_time=arrival_at_desination-flight_departure(4 hours)
total_flight_time/2-calculates hald time(2 hours in this case)
time_to_collect_bags=arrival_at_desination+30 minutes(4:30AM)
当我尝试执行以下操作时
df['arrival_at_desination']-df['flight_departure']
它给了我以下错误
TypeError: unsupported operand type(s) for -: 'datetime.time' and 'datetime.time'
我应该如何减去两个 datetime.time 列？
您必须转换为日期时间格式才能转换试试这个
arrival = pd.to_datetime(df['arrival_at_desination'])
dept = pd.to_datetime(df['flight_departure'])
diff = arrival - dept
这就是我得到的，希望能有所帮助
0 -1 days +20:00:00
1 -1 days +18:30:00
否则将日期添加到数据中，与时间连接并执行上述操作
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
