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
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

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

[nick-oixf]

I really enjoy your style of teaching. Thank you!😊

[jinit]

Thank you a thousand times for such easy to follow content and instructions. I’m learning to code and my old brain needs simple instructions. Your video helped me easily import data. Looking forward to seeing more videos/content from your channel. Worth the subscription 😊

[work-routine]

Great explanation style, thanks for your work!

[macrefinerymartinez]

How do you read values from a spreadsheet that has formulas using read_excel?

[yesyogi]

Hi.. Are you planning to upload more tutorials on this topic here on youtube or on any blog ?

[enricomendiola]

Hello, I have a question. When exporting datafrom to excel . You did not specify the path on the filename. How did you know that it is under the Onedrive subdirectory?

[FaizanScribe]

How can I get in touch with you ? I have a question thats too long to post here.

[marioorozco]

Sorry Laura, I forgot to ask if you’re on IG or would this be the best method to ask you for help or follow questions. Many thanks