Clean Excel Data With Python Pandas - Removing Unwanted Characters

Hey Everyone, in this one we're looking at the replace method in pandas to remove characters from your spreadsheet columns.

Be sure to post what you want to see next!

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

Support the Channel on Patreon --
Join The Socials --
*****************************************************************
Full code from the video:

import pandas as pd

Packages (& Versions) used in this video:
Python 3.8
Pandas 0.25
Atom 1.41

*****************************************************************
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 and thank you for all your support!!

--- Channel FAQ --

What text editor do you use?

What Equipment do you use to film videos?

What computer do you use/desk setup?

What editing software do you use?
Premiere Pro for video editing
Photoshop for images
After Effects for animations

Do I have any courses available?
Yes & always working on more!

Where do I get my music?
I get all my music from the copyright free Youtube audio library

Let me know if there's anything else you want answered!

-------------------------

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

[CodeWithDerrick]

Thanks for being here! What do you want to see next?

[aatsw]

I've binge-watched quite a lot of your videos in the last two days. Amazing contents, and you always managed to keep it concise yet very clearly explained. Thank you. Please keep updating.

[aduck]

This was what I needed and you made it so clear to understand. Thank you 😊

[subzeroLV]

Thank you Derrick! That was exactly what I was looking for! I have no doubt I can apply this to my situation. I really appreciate you taking the time to make this video!

[vanakornsirijongprasert]

I like how you went back explaining each methods and what they would do.

[sahilkhan]

clear, easy and straight to the point. A real man

[shawnpetersen]

Great video, keep up the good work. I just started my Data Analytics journey and using "R" but self-teaching myself on Python.

[petterstensland]

Derrick, super thank you for these videos. Invaluable!

[jesusbvasquezq]

Excellent video, straight to the point and clearly explained. It helped me a lot. Thanks a million for this.

[samr]

This was what I needed and you made it so clear to understand. Thank you

[sudiptomitra]

Very simple, yet so effective & precise !

[JohnsonKongor]

Thanks, Derrick. I love this cause I work with many spreadsheets.

[torque]

Another great video! You are very good at explaining things.

[amritamishra]

I Was stuck here since 2 hours..your code did help..!!Thanks...

[brendafosmire]

Thanks. Very useful for me since I’m learning Pandas.

[aqiltank]

Love from Malaysia, I like your videos. Keep it up 😇

[hasibulhasan]

Thanks man! This was very helpful also to remove unnecessary character from csv data.

[mohamed]

Thank you Derrrick great video. I'm new to python and was a bit sceptical to use with excel. I'm quite proficient in excel, but this seems faster than text to columns functionality of excel. I'll give a bash and see.

[monihareddy]

You are a life savior for me. Thank you so much for this.

[luismoreyra]

wow! i'm really amazed with this vid! you saved me a lot of headaches dude!! thanks a lot!!!