import pandas as pd

#fname_out = '240725/outputs/BX_all_1.csv'
fname_out='240725/BX_all.T04_d35-19.txt'
dtypes = {
        '%  Week': int,
        'Time': float,
        'offset': float,
        'RAIM': int,
        'SV': int,
        'FDMA': int,
        'SVChan': int,
        'SVType': int,
        'SVFlags': int,
        'Az': float,
        'El': float,
        'Freq': int,
        'Track': int,
        'Phase': float,
        'Range': float,
        'Doppler': float,
        'CNo': float,
        'Count': int,
        'Flags': int,
        'Antenna': int,
        'TrackState': int,
        'ScintFlags': int,
        }

line_no = 0
with open(fname_out) as file:
    for line in file:
        if '%  Week ' in line:
            break
        line_no += 1
print(line.rstrip())
print(f'{line_no=}')

df = pd.read_csv(fname_out, delimiter='\t', header=line_no, dtype=dtypes)
print(f'{df.columns=}')
df.rename(columns=lambda x: x.strip(), inplace=True)  # drop whitespace
df.rename(columns={'%  Week': 'Week'}, inplace=True)
df.rename(columns={'TRACK': 'Track'}, inplace=True)

print(f'{df.columns=}')
print(df)