Python pandas read_excel // Load a specific Excel sheet, skip rows, and more with this tutorial

Learn how to load an Excel file into Python pandas with this quick tutorial. This video from my "Pandas Tips" series walks you through reading an Excel file into pandas from your computer and from a GitHub URL. You'll see how to read from a specific Excel sheet if you have multiple sheets. You will also learn how to skip rows from the top of your Excel file with the skiprows argument or how to use pandas read excel to skip the last rows at the bottom of your Excel sheet with the skipfooter option. Use the thousands keyword argument to make pandas read_excel function use commas as a digit separator and correctly read in numerical values. And finally you will see how to apply true_values and false_values from Python pandas read_excel to treat certain strings as Boolean True or False values. Check this video out to level up your Python pandas skills and make the most out of the pandas read excel function -- it will save you a lot of data cleaning time later!

0:00 Introduction
0:48 Read Excel on Computer
2:15 Set sheet_name
3:34 Read from URL
6:08 Level UP! skiprows
8:00 skipfooter
8:59 thousands
10:40 true_values, false_values
13:23 Conclusion

💻 Github CODE and DATA 💻

🎥 Related VIDEOS 🎥

📖 BOOKS about pandas from my Amazon Storefront 📖

☕ Buy me a COFFEE ☕
If you have enjoyed the content presented in this video and are able, consider buying a virtual cup of coffee to keep my channel going!

#python #pandas #pythonprogramming

[kimh]

Thanks a lot! your video easy to understand how to use pandas in real life.

[hosseinkaragah]

Thanks for the tutorial. It is great! One note, when I used "pd.read_excel" to read the .xlsx file, I encountered an error saying that I needed to install "openpyxl" dependency. I found out that later that pandas can only read .xls files and cannot read new excel version (.xlsx). I was wondering how come you did not get that error. ( my Pandas version 2.1.4) Thank you!