Reading data from Tristan on Hesperides in xlsx files.
To read output.json file, use the convert_axes
kwarg:
import pandas as pd
data_frame = pd.read_json("./hesp_rafaelhermida_2019/TristanHespData.json", convert_axes=False)
to read data correctly, since the index column has the format DOYHHMMSS
where
DOY
: Day Of the YearHH
: HoursMM
: MinutesSS
: Seconds is not the expected format forread_json
method
Military timezone codes here