Преобразуйте следующие временные метки измерений в единую временную метку ⇐ Python

[Anonymous]

У меня есть файл .csv, в котором множество различных свойств измеряются с частотой 10 Гц. Первая строка с метками времени выглядит следующим образом:
0 NaN
1 29/07/2021 11:00
2 00:00.1
3 00:00.2
4 00:00.3
5 00:00.4
6 00:00.5
7 00:00.6
8 00:00.7
9 00:00.8
10 00:00.9
11 29/07/2021 11:00
12 00:01.1
13 00:01.2
14 00:01.3
...

Name: TIMESTAMP, Length: 36601, dtype: object

Я никогда не видел, чтобы данные записывались таким образом. Есть ли способ преобразовать все строки с заданными миллисекундами в формат даты и времени, как в строке 1, но с мс, и добавить мс к строкам 1, 11 и т. д.? Итак, у меня есть:
0 NaN
1 29/07/2021 11:00:00.1
2 29/07/2021 11:00:00.2
3 29/07/2021 11:00:00.3
...


data = pd.read_csv('file.csv', skiprows=1, header=None, names=['timestamp'])

absolute_timestamps = []

base_time = None

for index, row in data.iterrows():
timestamp = row['timestamp']

if isinstance(timestamp, float):
continue

if '/' in timestamp:
base_time = datetime.strptime(timestamp, "%d/%m/%Y %H:%M")
current_time = base_time
else:
try:
seconds, milliseconds = map(float, timestamp.split(':'))
delta = timedelta(seconds=seconds, milliseconds=milliseconds*100)
current_time = base_time + delta

absolute_timestamps.append(current_time)
except ValueError:
continue

result_df = pd.DataFrame(absolute_timestamps, columns=['absolute_timestamp'])

print(result_df)

Это дает мне пустой DataFrame.
MRE файла csv:
TIMESTAMP,Ux,Uy,Uz,Ts,CO2,H2O,press,t_hmp,e_hmp,rh_hmp
,m/s,m/s,m/s,C,mg/m^3,g/m^3,kPa,C,kPa,percent
29/07/2021 11:00,0.241,-0.2965,0.258,25.99887,675.759,15.90253,98.67521,27.66419,2.129122,57.44878
00:00.1,0.3545,-0.34425,0.21125,25.87463,675.9955,15.9117,98.65817,27.66253,2.136629,57.65696
00:00.2,0.38175,-0.28125,0.2045,25.95746,675.7098,15.93659,98.65817,27.65421,2.137441,57.70692
00:00.3,0.3465,-0.22175,0.20025,26.05753,674.4702,15.98516,98.67521,27.65919,2.137509,57.69193
00:00.4,0.08875,-0.326,0.2305,26.0351,676.1616,15.89104,98.65817,27.67419,2.139629,57.69859
00:00.5,0.012,-0.4945,0.26625,26.00403,675.5728,15.90638,98.65817,27.6925,2.142476,57.71358
00:00.6,0.10225,-0.42525,0.2155,25.9816,670.6963,16.13573,98.67521,27.63588,2.132997,57.64863
00:00.7,0.06425,-0.39075,0.01075,26.0144,671.8867,16.07627,98.69327,27.66419,2.137578,57.67694
00:00.8,0.2435,-0.51875,0.1525,25.98849,668.4075,16.23631,98.65817,27.66419,2.136035,57.6353
00:00.9,0.22075,-0.61475,0.033,25.80215,674.759,15.92974,98.68423,27.62256,2.132384,57.67694
29/07/2021 11:00,0.28025,-0.7262501,-0.053,25.84531,677.9393,15.76822,98.67521,27.65587,2.137896,57.71358
00:01.1,0.27025,-0.7032501,-0.13675,25.83667,679.4952,15.69851,98.65817,27.64421,2.136132,57.70525
00:01.2,0.232,-0.694,-0.05075,25.83496,679.4978,15.70536,98.65817,27.70084,2.145746,57.77353
00:01.3,0.165,-0.6102501,-0.0565,25.86084,679.2551,15.71204,98.67521,27.68085,2.14386,57.79018
00:01.4,0.23975,-0.636,-0.0815,25.82632,679.4276,15.70096,98.64916,27.71249,2.147887,57.79185
00:01.5,0.27175,-0.591,-0.021,25.82806,679.7066,15.69168,98.65817,27.63921,2.137542,57.76021
00:01.6,0.188,-0.60025,-0.04875,25.84009,678.5519,15.75871,98.64916,27.70416,2.145296,57.75022
00:01.7,0.14625,-0.566,0.001,25.80905,680.5561,15.66352,98.67521,27.64587,2.139792,57.79851
00:01.8,0.1705,-0.67675,0.01,25.79874,680.9865,15.64016,98.65817,27.66253,2.141258,57.78186
00:01.9,0.162,-0.6135001,-0.08125,25.7901,681.2719,15.61947,98.69327,27.67252,2.142385,57.77853

Что я хочу преобразовать:
TIMESTAMP,Ux,Uy,Uz,Ts,CO2,H2O,press,t_hmp,e_hmp,rh_hmp
,m/s,m/s,m/s,C,mg/m^3,g/m^3,kPa,C,kPa,percent
29/07/2021 11:00:00.0,0.241,-0.2965,0.258,25.99887,675.759,15.90253,98.67521,27.66419,2.129122,57.44878
29/07/2021 11:00:00.1,0.3545,-0.34425,0.21125,25.87463,675.9955,15.9117,98.65817,27.66253,2.136629,57.65696
29/07/2021 11:00:00.2,0.38175,-0.28125,0.2045,25.95746,675.7098,15.93659,98.65817,27.65421,2.137441,57.70692
29/07/2021 11:00:00.3,0.3465,-0.22175,0.20025,26.05753,674.4702,15.98516,98.67521,27.65919,2.137509,57.69193
29/07/2021 11:00:00.4,0.08875,-0.326,0.2305,26.0351,676.1616,15.89104,98.65817,27.67419,2.139629,57.69859
29/07/2021 11:00:00.5,0.012,-0.4945,0.26625,26.00403,675.5728,15.90638,98.65817,27.6925,2.142476,57.71358
29/07/2021 11:00:00.6,0.10225,-0.42525,0.2155,25.9816,670.6963,16.13573,98.67521,27.63588,2.132997,57.64863
29/07/2021 11:00:00.7,0.06425,-0.39075,0.01075,26.0144,671.8867,16.07627,98.69327,27.66419,2.137578,57.67694
29/07/2021 11:00:00.8,0.2435,-0.51875,0.1525,25.98849,668.4075,16.23631,98.65817,27.66419,2.136035,57.6353
29/07/2021 11:00:00.9,0.22075,-0.61475,0.033,25.80215,674.759,15.92974,98.68423,27.62256,2.132384,57.67694
29/07/2021 11:00:01.0,0.28025,-0.7262501,-0.053,25.84531,677.9393,15.76822,98.67521,27.65587,2.137896,57.71358
29/07/2021 11:00:01.1,0.27025,-0.7032501,-0.13675,25.83667,679.4952,15.69851,98.65817,27.64421,2.136132,57.70525
29/07/2021 11:00:01.2,0.232,-0.694,-0.05075,25.83496,679.4978,15.70536,98.65817,27.70084,2.145746,57.77353
29/07/2021 11:00:01.3,0.165,-0.6102501,-0.0565,25.86084,679.2551,15.71204,98.67521,27.68085,2.14386,57.79018
29/07/2021 11:00:01.4,0.23975,-0.636,-0.0815,25.82632,679.4276,15.70096,98.64916,27.71249,2.147887,57.79185
29/07/2021 11:00:01.5,0.27175,-0.591,-0.021,25.82806,679.7066,15.69168,98.65817,27.63921,2.137542,57.76021
29/07/2021 11:00:01.6,0.188,-0.60025,-0.04875,25.84009,678.5519,15.75871,98.64916,27.70416,2.145296,57.75022
29/07/2021 11:00:01.7,0.14625,-0.566,0.001,25.80905,680.5561,15.66352,98.67521,27.64587,2.139792,57.79851
29/07/2021 11:00:01.8,0.1705,-0.67675,0.01,25.79874,680.9865,15.64016,98.65817,27.66253,2.141258,57.78186
29/07/2021 11:00:01.9,0.162,-0.6135001,-0.08125,25.7901,681.2719,15.61947,98.69327,27.67252,2.142385,57.77853


Подробнее здесь: https://stackoverflow.com/questions/791 ... -timestamp