Read .DAT data files

This example show show how Canari read raw .DAT datasets using the Pandas external library and stores it into a dataframe.

import pandas as pd

data_file = .DAT
df_raw = pd.read_csv(data_file,
                    sep=";",  # Semicolon as delimiter
                    quotechar='"',
                    engine="python",
                    na_values=[""],  # Treat empty strings as NaN
                    skipinitialspace=True,
                    encoding="ISO-8859-1",
                    )