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