Python: How to Import Microsoft Excel Files!

In this tutorial we will be looking at IMPORTING EXCEL FILES into Python. This is one of many great python tutorials that should get you well on your way to programming some amazing stuff!!

I have more videos available on Arduinos and Excel ready for viewing!!

Subscribe for more amazing stuff!

This channel is about learning to code and analyse data in small bitesize amounts. As a result, larger projects come as a series which I put as a playlist. A link to some of my playlists can be found below.

Create PowerPoint Presentations Only Using Python

Build a Music Player using Python

Learn Regression Modelling from scratch

Basic graphing with Python

Building Network Graphs using Python

PATREON:
If you liked the tutorial then please feel free to make a donation on Patreon.
Just copy and paste the link below to go directly to my page.

[ScholarStream_]

I thank God I came to this channel 🙌🙏🙏

[mitchellfolbe]

In pycharm 3.7 I got a unicode error. It is corrected by putting an 'r' before the name of the file, e.g. (r"C:\users...). Alternatively, you could change the backslash '\' to a forwardslash '/'. Also I got an error for sheetname as unexpected argument.

[hi]

Thank you so much. Can you make a video about plotting?

[tinyengineer]

I'm having a problem with this program dropping values before zero on the x-axis, or rather the negative values aren't appearing in the plot. Does anyone know how to fix this?

[MrYamrajji]

its not working in pycharm and it is showing that ModuleNotFoundError: No module named 'pandas'

[raaghavkapoor]

pls tell what to do i got error:
TypeError: read_excel() got an unexpected keyword argument 'sheetname'

[Dopeboyz]

Where do i get syder or pandas from. I been trying to use python but i cant find it

[titi]

Hi, please help, I get this error, FileNotFoundError: [Errno 2] No such file or directory: 'C:\\PythonFiles MBI_dataset.xlsx'

[ajayalexalex]

What your talking I am not able to understand anything

[theforbiddenfruit]

with panda are you able to import a singular feild from the spreadsheet in excel? or are you only able to import the whole table and not reference a singular bit of data? Also, does the spreadsheet have to be closed for this to run?

[mukeshkund]

Can we work on excel without using Pandas ?? i need to work on the formulas on excel but the challenge is no use of pandas .

[eBuddha]

How can we import multiple excel files ?