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

Veröffentlicht am: 06 Dezember 2023
auf dem Kanal: 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

Auf dieser Seite können Sie das Online-Video Python pandas read_excel // Load a specific Excel sheet, skip rows, and more with this tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Kimberly Fessel 06 Dezember 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 7,712 Mal angesehen und es wurde von 150 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

283,391

945