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




[ad_1]

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 —
⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. https://www.kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=derricksherrill&utm_content=description-only

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:
https://github.com/Derrick-Sherrill/DerrickSherrill.com/blob/master/clean_excel_example.py

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:
https://github.com/Derrick-Sherrill/DerrickSherrill.com

Check out my website:
https://www.derricksherrill.com/

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

Useful Links
—————————————————————————————————————–
Python Download:
https://www.python.org/downloads/
(Remember Python 3 is the future!)

I use Atom Text Editor for all my tutorials
Atom Text Editor:
https://atom.io/

Packages I often use in Python tutorials:
-Pandas
https://pandas.pydata.org/pandas-docs/stable/
-Numpy
https://www.numpy.org/
-xlrd
https://xlrd.readthedocs.io/en/latest/
-TensorFlow
https://www.tensorflow.org/api_docs/python
-Matplotlib
https://matplotlib.org/
-Django Framework
https://www.djangoproject.com/
-Beautiful Soup
https://www.crummy.com/software/BeautifulSoup/
(Install through Terminal $pip3 install ….)

Other Useful Services sometimes featured:
-Amazon Web Services (AWS)
https://aws.amazon.com/
-Microsoft Azure
https://azure.microsoft.com/en-us/
-Google Cloud
https://cloud.google.com/
-Juypter Notebooks
https://jupyter.org/

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

Source


[ad_2]

Comment List

  • Derrick Sherrill
    January 10, 2021

    Excel sheet se data kase nikalte hai

  • Derrick Sherrill
    January 10, 2021

    My very big problem

  • Derrick Sherrill
    January 10, 2021

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

  • Derrick Sherrill
    January 10, 2021

    How can i preprocessing in text mining using excel file? I am a beginner .

  • Derrick Sherrill
    January 10, 2021

    @Derrick – I have a little problem. Whenever I export that to Excel, is not working. Is exporting in the same state with First Name and Last name into one cell. In Terminal is working fine with split between two but when I do export to xlsx format this functions is not working anymore. I use to export df.to_excel("Clean data.xlsx") —- Anyone from here could help me with that problem? Many thanks all!

  • Derrick Sherrill
    January 10, 2021

    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!

  • Derrick Sherrill
    January 10, 2021

    hie how do i sum up excel dataframe ($320), $350

  • Derrick Sherrill
    January 10, 2021

    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.

  • Derrick Sherrill
    January 10, 2021

    Contanct me , i want to work on a project with you

  • Derrick Sherrill
    January 10, 2021

    How do you export a finished clean data to an existing sheet?

  • Derrick Sherrill
    January 10, 2021

    Derrick, I am curious why you don't install "scripts" package in atom? It seems troublesome to run the script with the command "python3 xxx".

  • Derrick Sherrill
    January 10, 2021

    Please Derick can i get your mail, need to send you a file

  • Derrick Sherrill
    January 10, 2021

    I'm trying to do the command prompt in your video but when I enter what you wrote it doesn't do anything. I'm on windows, is there another step?

  • Derrick Sherrill
    January 10, 2021

    Love it!!

  • Derrick Sherrill
    January 10, 2021

    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!

  • Derrick Sherrill
    January 10, 2021

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

  • Derrick Sherrill
    January 10, 2021

    Huge fan bother keep it up!!! Thanks

  • Derrick Sherrill
    January 10, 2021

    what a legend! Love your tutorials 🙂

  • Derrick Sherrill
    January 10, 2021

    Is it possible to remove time stamps and change date formats (both US and Europe date formats in same column) of my excel data within python?

  • Derrick Sherrill
    January 10, 2021

    How to split below Column value
    Column
    058-10-1312 The Little Rascals

    Split as
    Column1 – 058-10-1312
    Column2 – The Little Rascals

  • Derrick Sherrill
    January 10, 2021

    questions is that if i want to spilt the file data into by ',' for eg '1234567890, FOOD, 10/UNIT, QTY 300', i want to spilt by '1234567890' , 'FOOD', ' 10/UNIT', 'QTY 300' , how can we do this ?

  • Derrick Sherrill
    January 10, 2021

Write a comment