Data Analysis with Python for Excel User Part 1 Read and Write Excel File using Pandas

Data Analysis with Python for Excel User Part 1 Read and Write Excel File using Pandas

In this video we are going to learn how to read excel file using pandas

Python is a widely used high-level, general-purpose, interpreted, dynamic programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than possible in languages such as C++ or Java. The language provides constructs intended to enable writing clear programs on both a small and large scale.

Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles.It also supports modules and packages, which encourages program modularity and code reuse. The Python interpreter and the extensive standard library are available in source or binary form without charge for all major platforms, and can be freely distributed.

[Locke]

Thanks for the tutorial. Also, I like how you pronounce the word "sheet."

[MarceloUchoas]

Thank you!
You will be rewarded for making this wonderful video!

[narayanamt]

excellent. no nonsense type of explanation. Thank you very much.

[cristianscript]

How can I insert instead of a column instead of a row at the bottom of the last column thanks

[kitopatterson]

Great job! Do you think you can create another video to show how to use the other arguments in pd.read_excel?

[dorianpersaud]

Can someone kindly explain why, when using pd.ExcelFile, we must have the letter r written before specifying the file location? I see that it works in persona;l use, but I just want to understand its purpose. Thanks!

[manusiaaneh]

thanks for your lesson, btw would you bring me data in tutorial?

[zeussaurabh]

how are you able to use pd.excelfile when you have not imported pandas as pd ?

[andreidodu]

And how I read an xls file cuz when i try to open it i receive XLRDError unsupported error or corrupt file Expected BOF record 'found Module\tO'

[waqarmughal]

i love u boy <3 you cleared my problem.. <3

[itskumarshiv]

Hi !
if in my sheet there are no any name in column then how we print any column ??

[khisrowseadeqi]

You do not show us how to write back. Appreciate if you can write how the data can be save back to the file

[josephnolan]

I get the following message after following for 5 mins:

NameError Traceback (most recent call last)
in <module>()
----> 1 read_sheets_name =
2 read_sheet_name

NameError: name 'wb' is not defined. Please can anyone help?