libra2hdo.py

import pandas as pd

def read_libra(path):
    data = pd.read_csv(path, skiprows=3, sep=';')
    data.rename(columns={'#date':'date'}, inplace=True)
    return data

def read_hdo(path):
    tmp = pd.read_csv(path, encoding='latin-1', nrows=5, header=4)
    cols = tmp.columns
    data = pd.read_csv(path, encoding='latin-1', skiprows=6, names=cols)
    return data