Clean Excel Data with Python and Pandas - 5 Minute Python Scripts - Full Code Along Walkthrough

In this video we'll cover the basics of how to clean your excel data using python.
We'll cover how we can load in excel files, change or modify their current cells to meet your requirements, and then rewrite back to a new excel file.

Kite helps fund the channel, thanks for checking them out and supporting me --

Thanks so much for all the support!! You all are far too good to me. 330+ Subscribers!!! Thank you all so much.

Here's the GitHub link:

If you have any suggestions for the next video please let me know!

Until next time!

*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:

Check out my website:

If you liked the video - please hit the like button. It means more than you know. Thanks for watching!!

Useful Links
-----------------------------------------------------------------------------------------------------------------
Python Download:
(Remember Python 3 is the future!)

I use Atom Text Editor for all my tutorials
Atom Text Editor:

Packages I often use in Python tutorials:
-Pandas
-Numpy
-xlrd
-TensorFlow
-Matplotlib
-Django Framework
-Beautiful Soup
(Install through Terminal $pip3 install ....)

Other Useful Services sometimes featured:
-Amazon Web Services (AWS)
-Microsoft Azure
-Google Cloud
-Juypter Notebooks

Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

[davestark]

Such a huge fan of the 'bitesize' format of these videos. Clear instructions, excellent explanations. Keep it up!!

[dlutherc]

It's so much easier to learn the content when the important information is not separated by a lot of talk. These videos have helped tremendously, you do a great job!

[josephtran]

sheet1['First Name'] = sheet1['First Name, Last Name].map(lambda x: x.split(', ')[0]
sheet1['Last Name'] = sheet1['First Name, Last Name].map(lambda x: x.split(' ')[1]



pandas is built on top of numpy which supports vectorized operations. No need to write the for loop. You can just call the column and .map() with a lambda expression inside

[koontzrob]

Really Awesome Video! It would be pretty cool if you did like a part 2 where you clean excel data (data with way more errors, random empty rows, wrong data types, misspellings etc) with python.

[anthonyrojas]

This is my new mentor man, the simplicity and clear explanation is on point.

[rverm]

Cool taking machine learning now . This really helps

[AcceptableBread]

These tutorials are some of the best I have ever seen! Your ability to clearly and concisely explain the concepts is exceptional. Looking forward to seeing more.

[nethsz]

Thanks, I am beginer, it's really usefull, just need to install -xlrd and -xlsxwriter at first.

[mimichui]

Stumble to your channel and found these 5-min tutorials. Almost watched every single one. Thank you so much! Looking forward to watching more 5-min videos.

[vilw]

Thanks so much for this, this might seem simple but can trouble you while dealing with huge datset.I was stuck for few days now after watching the video got an idea of what to do and what was i doing wrong!!

[keagankemp]

Wow starting my python journey and came across your channel, needless to say all this is a good find.

[AshokKumar-eudd]

Hi Sherrill,
i wanted to learn python course. while searching videos in YouTube, i found ur channel and feels this right channel for beginner. i am basically excel user and not aware about python and any programmer . could you please advise me how to start my carrier in python and also request you to post basic videos from scratch in excel user. it would be appreciate if you can help me

[josephtortolano]

Hey nice video I am working a lot with VBA at work and I was wondering why would you do this into python if you could easily do it in VBA ? Is it faster or more reliable with python ? Also can you show cases where python might awser problems that can't be done in VBA. That would be a very nice video in order to see differences and limits in both languages. Keep the good work 👏

[createyourlifestylenow]

great, they way you explain it is very easy to follow for beginners

[TeverRus]

My man, you are a genuis! Thank you so much! I'm going to use it at work on Monday :) Cheers!

[alessandroformiconi]

Hi Derrick thank you, very good work and ALL IN 7 MINUTES, that's great for learning ... i have programmed in Java for years, but Python is so funny!

[vincenzo]

Great tutorial, thanks. Can use this at work. Like the Milan entry - definitely go to Italy.

[big_cheese]

Thanks very much for all the great content, has been fantastic both for my work & coding in my spare time. Keep it up!

[stephang]

Great video, on spot and no 'superivised typing' for us. At the moment I'm fighting with date-Time-fields. You could add a column 'Birth date' with dates in different formats ('200-12-30', '1998-11-28 05:25:59', '01.01.1985' (European)) and clean it up in a way that I can apply conditions on it (for e.g. find the over 18 year old). Just if you need ideas :-)

[xujerry]

it is good lessons of your video, It makes me learn more about python. nice to keep in touch with you.