I have a df dataset with two columns with dates, called data1 and data2.
When trying to import the data with the code below, an error response appears:
filepath=("bd.csv")
df=pd.read_csv(filepath, sep=';', encoding='latin-1', decimal=".", index_col='data2', parse_dates=True)
error message: "ValueError: 'DATA FINAL' is not in list"
note: The date format is:
| date1 | date2 | |
|---|---|---|
| 08-jan-08 06:30:00 | 08-jan-08 18:30:00 |