Hey everyone. Hope you all had a great weekend! I will be traveling to Vancouver this week to visit a Quantum Computing company and learn more about the work they're doing, so I'm not sure when the next Pandas video will be ready for release. I will be working on it while I'm there, but I likely won't have it recorded and released until midway through next week. Let me know if anyone has any questions they would like me to ask them about Quantum Computing!
Hey, Corey. Thankyou for everything. I am not from Computer Science background, Out of curiosity I started learning to code and here I am now, has done more than 20 datascience project. Your videos are literally best, I have taken some courses for high price and I can un-undoubtedly say that your way of teaching is way more interactive, complete and easy to grab. I just want to know how you plan for any course, like in 1st or 2nd video You said that I will cover this topic in later videos. So do you make whole content, practice it? deepdive in it and make your own order and then start teaching? It would be very helpful for me if you share about how you prepare for any topic. Thank you very much Love from INDIA
I have many times seen while using dataframe that column names are not at same level and this creates an issue during extraction of values. Do you have any idea about it?
i understand your pandas tutorials very clearly. this is helping me a lot. thank you so much corey. i wish to see your tutorials on machine learning using python.
You really care about making a video addressing many scenarios and possible issues … that’s phenomenal !! … I really appreciate it … thank you so much!!
I had to say, thank you!! I think you guys are really helping to fill the unequal educational resources between the rich and the poor. Great job and I hope you now that what you are doing is really meaningful
much appreciated! could you please have more video like that? cleaning data and see the diffrent errors come with it! it would really helpful for juniors.
@Corey Schafer Something told me that I'hd better watch this video. Just when I thought that I'd sanitized a large data set, I realize now that there could potentially be some data (or missing data) that could crash my application. Great video. Thank you Sir!
Boss, it is requested to kindly make videos on comprehensive data analysis series, covering all aspects in much detail, and covering all possible areas for data analysis. Your channel and vdos are awesome. Great work indeed...... 👍
instead of replacing separately you can just pass the list of strings that you want replace E.g : df['YearsCode'].replace(['Less than 1 year','More than 50 years'],[0,51],inplace=True)
Thanks Corey, i have no words to say. As an inspiring data scientist, your pandas videos were really cool. I don't know if you will ever read this but this has helped and has put a smile on my 'confused about pandas' face. i have subscribed and will watch your videos for becoming a self taught data scientist. God Bless You
Hi Corey thank you so much for posting these videos. Your tutorials have helped me transition the concepts I know into actual useful code. I would like to test my progress and would really appreciate if you can put out a link with some data analysis projects (i.e. a database to download, questions to answer using data analysis, and the code that was written to answer those questions). Thank you so much and keep the videos coming you're an amazing teacher!!
In 27:28 of the video. For a one liner code. df['YearsCode'].replace(['Less than 1 year','More than 50 years'],[0,51]), inplace=True). Correct me if I'm wrong I'm new to Python. But great video again Corey! Hats off!
this does not work anymore as Corey was mentioning, rather like this>> df.replace({'YearsCode': {'Less than 1 year':0, 'More than 50 years':51} },inplace= True)
for the last part of the video, you can actually create two lists and use these lists in replace method to change all values at once. It is slightly easier especially if the df has multiple values to replace
useing this func ( df.fillna("Unfilled", inplace = True) ) to replace the missing values is good practice I belive, for me it's easier than replace and more dynamic
Another way to change the dtype of df["YearsCode"]. def change_to_float(string): try: result = float(string) except: result = np.nan finally: return result df['YearsCode'] = df['YearsCode'].apply(change_to_float) df['YearsCode'].mean()
I love this series man, more than you could expect. If I may ask, what state and country are you from? Because I saw snow on your 2nd channel and now I'm confused about whether you live in the USA or in a European country. Thanks again for this series
Hi Corey, your videos are "the great". I am beginner can you please tell me how to get "cheet sheet" or ".py scripts" of your video playlist "Python Tutorials" "1 to 136", to speedup learning as i am slow in typing. Thank you.
Hi Corey, Thanks for the awesome series. While I have not yet finished the series, I would like to know, how we can deal with duplicates. If you have a column let's say with duplicate apps and the apps have reviews, size, installations and you want to let's say get a mean for the reviews, take the first size and sum of the installations and merge the rest of the columns for those apps as they were, like Ratings. How would one do that?
Great series, but I must say I find R much easier to understand since there are not as many exceptions as there are in python. Everything is a function and there is no concept of method (at least that I'm aware of)
hello corey, in your video the first df.dropna() drops rows 4 and 5; according to your explanation because the "How" function is set to any , whereas row 6 also contains a string of 'missing', 'anonumous' is also a string, why doesn't row 6 drop?, what differentiates the two strings. Thank you, Awesome lessons
![Balls on a Wooden Circuit [9] #shorts #marblerun #animation #asmr](http://i.ytimg.com/vi/bOKKOHtDAYs/mqdefault.jpg)
Hey everyone. Hope you all had a great weekend! I will be traveling to Vancouver this week to visit a Quantum Computing company and learn more about the work they're doing, so I'm not sure when the next Pandas video will be ready for release. I will be working on it while I'm there, but I likely won't have it recorded and released until midway through next week. Let me know if anyone has any questions they would like me to ask them about Quantum Computing!
Hey, Corey. Thankyou for everything. I am not from Computer Science background, Out of curiosity I started learning to code and here I am now, has done more than 20 datascience project. Your videos are literally best, I have taken some courses for high price and I can un-undoubtedly say that your way of teaching is way more interactive, complete and easy to grab.
I just want to know how you plan for any course, like in 1st or 2nd video You said that I will cover this topic in later videos. So do you make whole content, practice it? deepdive in it and make your own order and then start teaching?
It would be very helpful for me if you share about how you prepare for any topic.
Thank you very much
Love from INDIA
I have many times seen while using dataframe that column names are not at same level and this creates an issue during extraction of values.
Do you have any idea about it?
How do I download dataset after cleaning my data using Jupyter notebook online? Plzz ans..
I like this series in pandas. thank you so much Corey.
Please make a playlist on numpy after pandas.
Yeah please do that
this series on pandas is the most complete and informative series ive found till date...!!!
Good teaching is an art... This playlist is so helpful ! Thank you for your work !
Corey you're teaching is awesome!!! Much appreciated!!!
Expecting series on Machine Learning/Deep Learning in the near future...
This is the most amazing series on Pandas ever. I just finished watching number 9th. Sir thank you so much providing such great content. 🧡🤍💚
Thank you Corey for this. My parents urged me to join your community. They are saying you are doing wonderful job. Thank you Corey for enabling us
You never disappoint!! And I never have to speed you up because you keep a great pace with no BS! Thank you!!
Best series on Python Pandas . Thank you so much Mate. Love from India
Thanks for this Corey - your tutorials are always great! I've been using pandas for almost 2 years and still learned stuff 👍
Now thats a lovely explaination, i like how u showed the function can be used in different scenarios!
can't wait for your numpy series , this channel is gold , Thank you Corey
You're a great teacher, Corey!
i understand your pandas tutorials very clearly. this is helping me a lot. thank you so much corey. i wish to see your tutorials on machine learning using python.
As usual Corey best of the best!!!
You really care about making a video addressing many scenarios and possible issues … that’s phenomenal !! … I really appreciate it … thank you so much!!
Great stuff Corey!!! Keep up the good work!
11:36 we can use df.replace(['NA', 'Missing'], np.nan, inplace=True) instead
could've used in other df.replace(...) line too. But I think he is trying to keep it simple for us to understand it easily.
Hi @ Corey Schafer
I am very with your teachings, these are great building blocks towards data science, i hope one day we arrive there.
wow, this is the best playlist for python pandas. thankyou so much!
Corey, you are teaching the best!
This video was so smooth! Right in the point! Thanks!!!
Thanks man for such valuable series of videos, please add more video on new features on pandas !!!
Brilliant tutorials on Pandas!
Very much looking forward to the time series lessons.
Thank you so much for creating these videos!! They're really valuable for self-learners like me.
Learnt a lot so far. Thanks so much Corey,.
Great content - great style of speaking and explaining - thank you!
Simple and clear explanations. Great job.
love you coreyyyyy best channel
I had to say, thank you!! I think you guys are really helping to fill the unequal educational resources between the rich and the poor. Great job and I hope you now that what you are doing is really meaningful
The series is very helpful to me. Thank you sir.
Very helpful series with nice explanations !!!
Many thanks for sharing excellent tutorials Corey.
Great lesson!
We love you Corey Schafer!!!! Lots of love from India🥰
Thank you, learning so much :)
much appreciated! could you please have more video like that? cleaning data and see the diffrent errors come with it!
it would really helpful for juniors.
Man, i love you! Thanks a lot from Argentina!
@Corey Schafer
Something told me that I'hd better watch this video. Just when I thought that I'd sanitized a large data set, I realize now that there could potentially be some data (or missing data) that could crash my application. Great video. Thank you Sir!
Boss, it is requested to kindly make videos on comprehensive data analysis series, covering all aspects in much detail, and covering all possible areas for data analysis. Your channel and vdos are awesome. Great work indeed...... 👍
such a great work done by you , hope you all the best man
instead of replacing separately you can just pass the list of strings that you want replace
E.g : df['YearsCode'].replace(['Less than 1 year','More than 50 years'],[0,51],inplace=True)
It's very useful .You are great at articulating . Thank you so much .
Thanks Corey, i have no words to say. As an inspiring data scientist, your pandas videos were really cool.
I don't know if you will ever read this but this has helped and has put a smile on my 'confused about pandas' face.
i have subscribed and will watch your videos for becoming a self taught data scientist.
God Bless You
Hey , truly glad for your all series . If possible , please do make a course video on Pyspark .
Love the way u teach. thanks a lot... Love from India
Corey you are great.❤️
Love from India ❤️
Hi Corey thank you so much for posting these videos. Your tutorials have helped me transition the concepts I know into actual useful code. I would like to test my progress and would really appreciate if you can put out a link with some data analysis projects (i.e. a database to download, questions to answer using data analysis, and the code that was written to answer those questions).
Thank you so much and keep the videos coming you're an amazing teacher!!
That was such a good video- thank you for sharing
In 27:28 of the video. For a one liner code. df['YearsCode'].replace(['Less than 1 year','More than 50 years'],[0,51]), inplace=True). Correct me if I'm wrong I'm new to Python. But great video again Corey! Hats off!
this does not work anymore as Corey was mentioning, rather like this>> df.replace({'YearsCode': {'Less than 1 year':0, 'More than 50 years':51} },inplace= True)
This is gold.
Excellent teaching. Thank you.
thanks a ton for this series..helped a lot in clearing concepts!!
You're a legend, my guy.
Thank you so much, i have learnt a lot and able to automize my daily Excel routine work
Please do a video about your visit to the Quantum Computing trip in Vancouver!
Thank you Corey again. My resume is getting more interesting everyday. Viva
I love your tutorials. Could you also make tutorials for scipy and scikit learn?
Great vid, pls do one on multiple indexes!
These are awesome! Thanks a million!
hey bro always I fond the solutions in your videos thanks man
Thanks again for such a helpful video.
Thanks Corey
Amazing video...solved my problems ☺️☺️🙏🏻
for the last part of the video, you can actually create two lists and use these lists in replace method to change all values at once. It is slightly easier especially if the df has multiple values to replace
Great video! How about a video in spitting data and passing the split into a function? That would be great!
great series, thanks!
Amazing tutorial 😍👌
Thank you , excellent tutorial as always :)
Thank you so much!! You are the best
good video again..!! thanks a lot
Good pandas video. Thank you
useing this func ( df.fillna("Unfilled", inplace = True) ) to replace the missing values is good practice I belive, for me it's easier than replace and more dynamic
Your content is awsome....!
How do replace nan values with other values only in a particular column?
Please Help
Thank You
Hi Corey, please post a video on python sys module
This also work if we want to drop a column if 0 and 1 index have NaN
df.dropna(axis='columns', how='any', subset=[0, 1])
amazing series - hi Corey, how many PARTS u think will end up in this playlist? Thank you for helping the community :)
Another way to change the dtype of df["YearsCode"].
def change_to_float(string):
try:
result = float(string)
except:
result = np.nan
finally:
return result
df['YearsCode'] = df['YearsCode'].apply(change_to_float)
df['YearsCode'].mean()
Thanks man! Was stuck on this... really appreciated!!
Great video - I wonder if you can do a few on the business side like freelancing and how to get clients as python developers?
Thank you
can you make video explaining:
primitive data types vs data types vs adt vs data structure
is brilliant give certificates after completion of course?
Hii corey, can u plz make a video on how to bypass captcha while scrapping a web site
Can you use join() or merge() to do multiple replacements?
I love this series man, more than you could expect.
If I may ask, what state and country are you from? Because I saw snow on your 2nd channel and now I'm confused about whether you live in the USA or in a European country.
Thanks again for this series
Hey there. I currently live in Greenville SC in the United States. The snow videos were likely from Boulder Colorado where I lived for several years.
Hi Corey, your videos are "the great". I am beginner can you please tell me how to get "cheet sheet" or ".py scripts" of your video playlist "Python Tutorials" "1 to 136", to speedup learning as i am slow in typing. Thank you.
@Corey Schafer - Please do a video series on PySpark.
That is BRILLIANT
Thank you!
Please continue the series sir
Hi Corey,
Thanks for the awesome series. While I have not yet finished the series, I would like to know, how we can deal with duplicates.
If you have a column let's say with duplicate apps and the apps have reviews, size, installations and you want to let's say get a mean for the reviews, take the first size and sum of the installations and merge the rest of the columns for those apps as they were, like Ratings. How would one do that?
Great series, but I must say I find R much easier to understand since there are not as many exceptions as there are in python. Everything is a function and there is no concept of method (at least that I'm aware of)
Thanx a lot
hello corey,
in your video the first
df.dropna() drops rows 4 and 5; according to your explanation because the "How" function is set to any , whereas row 6 also contains a string of 'missing', 'anonumous' is also a string, why doesn't row 6 drop?, what differentiates the two strings.
Thank you, Awesome lessons
great job brow
excellent!
@Corey Schafer Can you make video on getting started on Open Source Contribution?
Corey, do you happen to know what Linux distro's ship with python 3 currently?
thank you sir .