Data Cleaning Tutorial | Cleaning Data With Python and Pandas

[anmol_seth_xx]

First of all thanks to you,
I learned ffill, bfill and interpolate functions from here.
But it's recommended from many professionals that missing values should be imputed with mean, median & mode.

[kaustubhjain]

the chill moment when he codes and sips up coffee, cool man great work !!!

[kurosaki]

Could you make a tutorial on Big Data as well, for situations with e.g. 500k rows and 200 columns where you don't see all of your data and don't know what kinds of Nan values to expect and therefore can't name them textually? Big thanks in advance :)

[YOGIT_Singh]

Bro, you are Doing such great work..
The way you are explaining things is excellent and easy to understand.
Kudos to you .

[ravitejapavuluri]

You said everything but but missed the one I am waiting for is filling NaN with mean or media values.

[sheetalurankar]

Explain the more concepts like standardizing, matching, consolidation so we get all idea about data cleaning.

[alishalbayev]

I just started watching but I see that you are really good man, thanks

[sifar]

Great tutorial! No need to hesitate on referring to the code snippets btw… I don’t think any sane person watching this has the expectation for you to memorise a to z what you want to articulate…

[sammy]

Nice way of explaining. One request, do make one video on Outlier removal.

Thanks.

[thewhiskybottle]

Take the ads off please, thanks, great tutorial by the way.

[poojakumarirollno]

Great job sir . Thank you so much for great explaining . Can u make more videos on data analytics

[shyamkumar-fhfh]

Can u tell about yourself... The company u are working and can u give some tips to get a job in data science field as a fresher

[RavikaUniverse.]

awesome, good and precise data cleaning
please load some more stuff related to pandas

[Young-Prof]

This is amazing. I learned a lot. I want to come to India to study Data Analytics

[ganeshkumarpatel]

Please explain to fiilna or replace zero with mean value by groupby... Means you have 3 groups in data frame and you want to fillna with respective to group mean

[sayantikabiswas]

thanks for teaching ffill, bfill, interpolate and fillna ...it was a great session

[rommelnb]

Thanks Mr. Shah--- I used these commands to prepare a cheat sheet for data cleaning--- regards

[slayergaming]

This video really helped me a lot, but I still got more to understand. I've zero basic knowledge on this. I'm working on a thesis which needs some coding to complete. I've few questions to what you've explained in this video;
1. What if there are lot of dataset and how do you define the missing value for each?
2. What was that in the missing value you defined "np.nan" ?
As I said earlier, I'm working on a project which is about human-in-the-loop code. Initially I'll be given the dataset and have to figure out a code to include human for feedback from system (Reinforcement Learning). I would like get your response, and if possible any helpful idea or suggestions on the project mentioned above.

Thank you

[gideonopoku-gyamfi]

So please which do you think is more efficient to be used without changing the accuracy of the data

[littlecreator]

Hi, very nice explanation. I am totally new to python. Can you pls make a tutorial on how to install jupyter and all the other required libraries to perform forecasting.