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

Published: 06 December 2023
on channel: Kimberly Fessel

7,712

150

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 💻
https://github.com/kimfetti/Videos/bl...
https://github.com/kimfetti/Videos/bl...

🎥 Related VIDEOS 🎥
• pandas read_csv - • Python pandas read_csv // Load a CSV into ...

📖 BOOKS about pandas from my Amazon Storefront 📖
https://www.amazon.com/shop/kimberlyf...

☕ 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!
https://www.buymeacoffee.com/kimberly...

#python #pandas #pythonprogramming

On this page of the site you can watch the video online Python pandas read_excel // Load a specific Excel sheet, skip rows, and more with this tutorial with a duration of hours minute second in good quality, which was uploaded by the user Kimberly Fessel 06 December 2023, share the link with friends and acquaintances, this video has already been watched 7,712 times on youtube and it was liked by 150 viewers. Enjoy your viewing!

2,457