How to read_excel with a dayfirst condition?

Question

I'm trying to read_excel through pandas. I have a date column in the format DD/MM/YYYY. Pandas will automatically read this as month first and as far as I've been able to tell there is no dayfirst function like there is with read_csv. Is there a way to do read_excel while specifying date format? ``` xlxs_data = pd.DataFrame() df = pd.read_excel('new.xlsx') xlsx_data = xlxs_data.append(df, ignore_index=True, dayfirst=True) TypeError: append() got an unexpected keyword argument 'dayfirst' ```

Accepted Answer

You can pass `dayfirst=True` as a param to `read_excel`, although the docs don't state this is a param it recognises, it accepts kwargs and will resolve your problem:

```
df = pd.read_excel('new.xlsx', dayfirst=True) 
```

How to read_excel with a dayfirst condition?

Solution

Problem