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]
Excel sheet se data kase nikalte hai
My very big problem
Thanks, I am beginer, it's really usefull, just need to install -xlrd and -xlsxwriter at first.
How can i preprocessing in text mining using excel file? I am a beginner .
@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!
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!
hie how do i sum up excel dataframe ($320), $350
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.
Contanct me , i want to work on a project with you
How do you export a finished clean data to an existing sheet?
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".
Please Derick can i get your mail, need to send you a file
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?
Love it!!
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!
Thanks very much for all the great content, has been fantastic both for my work & coding in my spare time. Keep it up!
Huge fan bother keep it up!!! Thanks
what a legend! Love your tutorials 🙂
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?
How to split below Column value
Column
058-10-1312 The Little Rascals
Split as
Column1 – 058-10-1312
Column2 – The Little Rascals
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 ?
https://github.com/Dangieboy/CSV-Data-Cleaner