Exploratory Data Analysis with Python | PANDAS

GET YOUR DATA JOB ➡ mochen.info/
ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-por...
PATREON: Even more detailed data analysis content ➡ / mo_chen
1:1 MENTORSHIP: I put my heart and soul into this program. I'm here to help you succeed ➡ mochen.info/1-1-mentorship-lp/
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ coursecareers.com/a/mochen?co...
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ • Portfolio Projects
┋Community & Socials┋
/ discord ⬅ Join our Discord Data Community
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ coursecareers.com/a/mochen
DataCamp Courses & Certifications ➡ datacamp.pxf.io/c/4216860/111...
Google Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Intro and thank you
01:21 Import libraries, read in the csv file and drop duplicates
03:48 Explore the data
09:15 Answering some questions
18:06 Outro
┋Files┋
Link to the github repository ➡︎ github.com/mochen862/explore-...
Link to Jupyter install ➡︎ jupyter.org/install
Link to Anaconda install (this contains Jupyter and is what I use) ➡︎ www.anaconda.com/products/dis...
Thanks so much for taking a little time out of your day to watch this!

[@mdtareq597]

Hey man, I've been watching your videos for a bit now. I gotta say, the way you explained everything in this one was super helpful, especially for someone like me who's just starting out. I'd love to see your entire Python data analytics course in the near future. Thanks for the awesome projects, and please keep 'em coming!

[@mo-chen]

Hi and Tareq, I’m so glad you get value from my videos!! I’d love to release my own python course one day haha. I will absolutely keep the videos coming. Thanks a lot for watching : )

[@kevingonzalo9087]

nice comment

[@jonaslee2539]

Hello Mo! I started following your channel about few weeks ago and I must say that this is by far one of my favorite videos in your channel. Very clear and concise explanations especially on the technical parts and the methodologies you used to analyze the dataset. Hoping that you could continue to produce more contents like this, especially on using Python to explore different kinds of dataset or maybe dive a little bit into Machine Learning would be amazing!!

[@mo-chen]

Hey Jonas, thanks so much for highlighting the specifics you liked about the video! I'm so glad it added value to you 😁I certainly have more Python videos in the pipeline!

[@TheMISBlog]

Very useful video, Thanks mo , love your content

[@maricruz3266]

I wanted to stop in and say thank you for making this video. It was nice to have to answer the questions on my own and that really helped me retain the information. I liked the length of the video as well, it was straight to the point with great explanations of everything. This was awesome! 😊

[@mo-chen]

I'm so glad you liked the video and I'm even more glad that you did the exercises. Learning by doing is surely the best way😁 Well done!

[@BKSDA1]

I love you Mo Chen I have started my path in data analytics this year and got really stuck with python courses and tutorials. This is a perfect video that helps understanding the tools you can use with the libraries in python, and examples of questions you would have to answer to in a real scenario. Learning the code this way makes much more sense than going through tutorials of each and every single function code you can use for analysis. I truly appreciate the time you put into doing this videos! All the best mate.

[@mo-chen]

Thanks so much for the kind words! I'm very glad you found the content useful 😁

[@clarielealmeida6225]

OMG!! That's what i really need. Your channel is so helpful to me. I would like more videos like this in your channel because interpreting the information and presenting it is even more important than making the code. Pls make more videos like this. Thank you soooo much!!

[@mo-chen]

Hey clariele 👋 I’m glad to see you again on the channel! Thanks so much for watching 😃 I will certainly try my best to make more videos like this.

[@pasheikhngom]

Wow you are my new favorite KZbinr! New subscriber here you have been super helpful. You are truly changing my life 🙏🏿

[@mo-chen]

Hi pa sheikh ngom, I’m glad you like the content! Thanks so much for watching and subscribing: )

[@gospelmoto2833]

Great vid Mo! You just got a new sub here!

[@mo-chen]

Great to have you here on the channel 😃

[@theFabz]

This is excellent and serves as a nice quick refresher

[@mo-chen]

Thanks a lot for watching Fabian 😁

[@maxtukana5986]

Love your videos ❤ inspires me to be more data savvy

[@mo-chen]

Hey Max, thanks so much for watching!

[@pinchopera1]

Great Content !!!

[@umaraziz4767]

Great work, they way you explain everything is amazing and so understandable. I also want to acknowledge that the previous video of yours "Data Analyst Portfolio Project" was top notch. Please create more videos like that on advance data analysis project. I also want to request you to create and advance level data analysis project in SQL and Python. Thanks again. Best wishes. 🙏

[@mo-chen]

Hi Umar, I'm very happy that you find my videos easy to understand! I definitely have more project videos coming, keep an eye out for them. Thanks a lot for watching : )

[@dwiwahyuarifuddiinnajib3912]

Hello mo, I really enjoy your videos bro. Especially when you start to explain the technical part. You define the technical aspect as easy to catch, especially for me as a person who still learns English. I hope I can see more of your videos about personal projects-related material. cause, to be honest, your videos really help me to improve my skill. Thanks bro.. Best wish for you

[@mo-chen]

Hi there, I’m glad you’re able to easily follow along. I certainly have more project related videos coming, so keep an eye out. Thanks a lot for watching and all the best to you too!

[@J_G_Network]

Nice, I like the law enforcement take on working with this type of data, I am new to all this stuff but I was able to follow along and understand most everything that you were doing there.

[@mo-chen]

Hi Jesus, I'm very glad you found the content easy to follow! Thanks a lot for watching : )

[@gamonfi]

Great content, that's the way.

[@mo-chen]

Thanks a lot Batá!

[@rahulkothe2821]

Wonderful

[@ramprasadsomaraju3889]

nice content need more videos on data cleaning also

[@mo-chen]

Thank you 😁 I'll try my best to create videos on data cleaning!

[@creyes879]

Great content. By any chance do you have a video on how you setup your VSCode for data analysis? Tips?

[@mo-chen]

I don’t unfortunately. I use VSC with my Linux subsystem on my windows. That could be a tip 😃

[@manashjyotiborah530]

Hey Mo, your videos are great! I have a request if you could complete...I am a fresher trying to get into the data field. However, I am finding it hard to get calls for interviews. It would be nice if you could help us by telling about the ways we can apply for jobs on platforms like LinkedIn. What is the correct way to cold email, how should our portfolio look as a fresher to get shortlisted for interview calls etc. Hope this comment gets noticed! Thanks again for your helpful videos 😀

[@mo-chen]

Hi Manash, your comment absolutely gets noticed here, thanks a lot for watching! I'm not entirely sure when I'll make a video like the one you suggested, so I'll quickly answer your question for now if that's okay. CV-wise, if you have any relevant experience, start with that first. Then obvisouly include your education and any certifications that you may have, along with links to your data portfolio (Github, Tableau dashboards, etc). Make sure you don't just include what you did on the CV, but why you did what you did, and what the resulting outcome was. You've got nothing to lose by reachnig out to the recruiters / hiring managers, so just go ahead and do it : )

[@eziola]

Great video! I'm subscribing for more Python analytics videos! Do you have any suggestions on your favorite textbook resource for Data Analytics in Python?

[@mo-chen]

My favourite Python resources are on the data roadmap at datawithmo.com/. Feel free to check it out. Thanks so much for watching 😃

[@valorant-pedia1005]

Great content! Can you please make a video on how can someone search for jobs after learning data analytics? Currently I am learning excel data analytics before jumping into python and all that coding stuff. But i really wonder how to search for jobs.

[@mo-chen]

Hi VALORANT-pedia, great video idea, I'll put it on my list of videos that I'd like to make in the future! Linkedin is a great place to look for jobs : ) Thanks a lot for watching!

[@Richard4red]

I think I found problem in one of your steps, when you rearranged the days for week_and_hour dataframe you didn't switched the order of the columns you just assigned the values of the columns to the header meaning the values are not reliable anymore because they don't reflect what happended in that day anymore

[@mo-chen]

Fantastic spot Alexey, thank you! The code should be of course "week_and_hour = week_and_hour[['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday']]" to re-arrange the order of the columns. Thank you so much for the help 😁 I have now corrected the code that's in the github repository (link in description).

[@OtiteSpeaks]

Where's the link please?

[@mo-chen]

It's in the description 😁

[@user-mn3wk6lh9s]

i can not download the crime.csv file

[@mo-chen]

Please try downloading the entire repo az a zip file. That should help!

[@jamesarchieodena4107]

You are so smart and cute as well..❤❤❤

[@mo-chen]

😊 thank you

[@ramprasadsomaraju3889]

How to contact you? I had a paid work to do hope it is perfect for you🙂🙂🙂

[@mo-chen]

Hello! Please send all the busniess queries to my email. You can find it on the About page 😄