I'm currently working on two different computers, but running the exact same code on both computers leads on one of the two computers generating:
ValueError: cannot create timedelta string converter for [-1 days +23:05:00.000000000]
The error is caused by the command:
df_gt["Duration"] = pd.to_timedelta(df_gt[ "Duration"])
And the df is created by an csv import via:
df_gt = pd.read_csv(gt_data, sep='\t', header=(0))
First, I thought the error was caused by the negative number. I have seen problems with negative numbers in the past, but this should have been the same problem on the other computer.
Then, I wondered if it might be caused by a different csv/time setting on this computer generating other formats, but when printing the value, I get exactly the same format(at least by visual inspection). I still think the problem is somewhere in this domain but I'm not sure how an other computer can effect this internal code.
Some hardware info:
The computer on which everything is working is running Windows 10 Home, and uses Pycharm Professional 2017.1. The other is running Windows 7 Professional sp 1 and uses Spyder 2.3.1. The code is in Python 3.
Thanks in advance,
Jeff
EDIT:
In the original question there was still
.total_seconds()
attached to the command, this was by mistake. (Just an attempt by my self to resolve this)