Hi Neil, thanks for the heads up. I missed the xarray to bwc conversion functionality. I will give it a try.
The format of the pandas dataframe is very simple and it's something i came up with. The format of time series in Ørsted is standardized only at the database level.
WS_35m WD_35m ... WD_285m SD_285m
timestamp ...
2022-08-10 05:00:00 NaN NaN ... NaN NaN
2022-08-10 05:10:00 1.579420 111.637028 ... 200.177297 0.271540
2022-08-10 05:20:00 1.589379 132.519061 ... NaN NaN
2022-08-10 05:30:00 1.740071 133.400359 ... 161.574321 0.226531
2022-08-10 05:40:00 1.764799 143.742655 ... 163.586885 0.169169
... ... ... ... ...
2023-01-31 23:10:00 NaN NaN ... NaN NaN
2023-01-31 23:20:00 NaN NaN ... NaN NaN
2023-01-31 23:30:00 NaN NaN ... NaN NaN
2023-01-31 23:40:00 NaN NaN ... NaN NaN
2023-01-31 23:50:00 NaN NaN ... NaN NaN
[25170 rows x 9 columns]