import pandas as pd

base_dir = "/home/robert/projekte/python/gcstruct/Siebrecht/"


def read_csv():
    header = ["Kontonummer", "Wert", "Fehler", "Beschreibung"]
    df_log = pd.read_csv(
        base_dir + "Siebrecht_12_2021.txt",
        decimal=",",
        sep="\t",
        encoding="latin-1",
        converters={0: str, 1: str, 2: str, 3: str},
        header=None,
        names=header,
    )  # , skiprows=3)
    df_log["Marke_HBV"] = df_log["Kontonummer"].str.slice(4, 8)
    df_log["Site"] = df_log["Kontonummer"].str.slice(8, 10)
    df_log["Account"] = df_log["Kontonummer"].str.slice(0, 4)
    df_log["Origin"] = df_log["Kontonummer"].str.slice(10, 12)
    df_log["SalesChannel"] = df_log["Kontonummer"].str.slice(12, 14)
    df_log["CostCarrier"] = df_log["Kontonummer"].str.slice(14, 16)
    # df_log['CumulatedYear'] = df_log['Wert'].str.replace(r'\.', '', regex=True)

    df_export = pd.read_csv(
        base_dir + "export_2021-12.csv", sep=";", encoding="latin-1", converters={i: str for i in range(0, 200)}
    )
    df = df_export.merge(
        df_log, how="left", on=["Marke_HBV", "Site", "Account", "Origin", "SalesChannel", "CostCarrier"]
    )
    df.to_csv(base_dir + "export_error_2021-12.csv", decimal=",", sep=";", encoding="latin-1", index=False)

    df_bookings = pd.read_csv(
        base_dir + "GuV_Bilanz_Salden_Debug.csv",
        decimal=",",
        sep=";",
        encoding="latin-1",
        converters={0: str, 1: str, 6: str, 7: str},
    )
    df = df.merge(df_bookings, how="inner", on=[])


if __name__ == "__main__":
    read_csv()