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!
Great point! Yes, pandas read_excel does utilize openpyxl as its engine for new Excel files after .xls. You will need to install openpyxl to work with .xlsx files. I already had this package installed, which is why you didn't see an error for me. Thanks for mentioning this!
excellent video, thanks!
Thanks! Glad you liked it. 😊
Thanks a lot! your video easy to understand how to use pandas in real life.
Most welcome! Glad to hear you liked it. Yes, I plan to show many of the pandas tricks I’ve learned through daily use of it in this video series. 😁
Very powerful course. ❤
Thanks! Glad you liked it.
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!
Great point! Yes, pandas read_excel does utilize openpyxl as its engine for new Excel files after .xls. You will need to install openpyxl to work with .xlsx files. I already had this package installed, which is why you didn't see an error for me. Thanks for mentioning this!
💯