Align qc and status columns of timeseries dataframes

[veenstrajelmer]

There are several hatyan dataframes in rotation:

• hatyan.read_dia() returns a df with values and qualitycode columns. maybe re-introduce status?
• hatyan.ddlpy_to_hatyan() returns a df with values, QC and Status columns
• kenmerkendewaarden.xarray_to_hatyan() returns a df with values, qualitycode and status columns
• other hatyan read/write functions return/expect something different?

Status column was removed from dia-df in https://github.com/Deltares/hatyan/pull/300/files. Adding status to dia-df again is possible by adding:

            # add status column
            block_status_list = diablocks_pd.loc[block_id,'STA'].split('!')
            for block_status_one in block_status_list:
                status_tstart = pd.to_datetime(block_status_one[4:17],format='%Y%m%d;%H%M').tz_localize("UTC+01:00")
                status_tstop = pd.to_datetime(block_status_one[18:31],format='%Y%m%d;%H%M').tz_localize("UTC+01:00")
                status_val = block_status_one[-1]
                data_pd_oneblock.loc[status_tstart:status_tstop,'status'] = status_val

to hatyan.read_dia(): https://github.com/Deltares/hatyan/blob/8ebaa8e792d8aacd2397ef843bbc2ac3c145f790/hatyan/timeseries.py#L1571-L1575

Todo:

• [x] update columns in hatyan.ddlpy_to_hatyan()
• [x] re-introduce status in hatyan.read_dia()
• [x] warning when passing df with status column to hatyan.write_dia()
• [x] run all tests and example scripts
• [x] update whatsnew