Python Excel Automation: read_excel and to_excel

In this video, we will be learning about 2 essential python pandas functions: read_excel and to_excel. They can help automate excel with python!

Timestamps below:

0:28 – Explain read_excel and to_excel
0:59 – Going over the dummy excel data (CompanyData.xlsx - linked below)
1:20 – Import excel data to dataframe
3:00 – Parameter: sheet_name
4:24 – Parameter: header
5:27 – Parameter: nrows
5:44 – Parameter: usecols
6:11 – Parameter: index_col
6:44 – Export dataframe to excel (one sheet) using to_excel
7:35 – Export dataframes to excel (multiple sheets) using to_excel and ExcelWriter

Excel Dummy Data –  https://github.com/LauraMarcela505/Py...
Link to Jupyter Notebook (code follow along) -- https://github.com/LauraMarcela505/Py...
Link to Jupyter Notebook (all code) – https://github.com/LauraMarcela505/Py...

Note: I didn’t put another backslash (2:24), but it still worked. I went back, tested, and learned that you only need to put a backslash after the “C:\” to not get an error 😊

#python  #pandas  #excel

• #education
• #python
• #pandas
• #excel
• #automatewithpython
• #exceltopython