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_jsonmethod
Military timezone codes here