Reading columns as datetime

pandas_reading04.py

# Reading Multiple Columns As Date Time
import pandas as pd

df = pd.read_excel(
    'Pandas_read_files_tips.xlsx', 
    parse_dates={'Date': ['Month', 'Day', 'Year']}
    )
print(df)

# Returns:
#         Date  Name  Amount
# 0 2023-01-01   Nik     168
# 1 2023-01-02  Jane     178
# 2 2023-01-03  Kate     143
# 3 2023-01-04  Evan     100
# 4 2023-01-05   Nik     156