Leigh Dodds on Nostr: I think this is a new one for me in terms of terrible #energydata Have been handed an ...
I think this is a new one for me in terms of terrible #energydata
Have been handed an XLSX file (sigh) where a key identifier is only available in the worksheet name (ffs!) but the kicker is a DateTime column that has been pre-formatted with a specific format string of "mm:ss.0". (wtf?!)
So you can't tell which half-hour of the day a row is for without manually reformatting the column.
Apparently the data provider is unable to change it 🙃
Have been handed an XLSX file (sigh) where a key identifier is only available in the worksheet name (ffs!) but the kicker is a DateTime column that has been pre-formatted with a specific format string of "mm:ss.0". (wtf?!)
So you can't tell which half-hour of the day a row is for without manually reformatting the column.
Apparently the data provider is unable to change it 🙃