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!

Пікірлер: 50

  • @mdtareq597
    @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

    @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

    @kevingonzalo9087

    9 ай бұрын

    nice comment

  • @TheMISBlog
    @TheMISBlog7 ай бұрын

    Very useful video, Thanks mo , love your content

  • @jonaslee2539
    @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

    @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!

  • @maricruz3266
    @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

    @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
    @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

    @mo-chen

    Жыл бұрын

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

  • @clarielealmeida6225
    @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

    @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.

  • @pinchopera1
    @pinchopera12 ай бұрын

    Great Content !!!

  • @pasheikhngom
    @pasheikhngom Жыл бұрын

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

  • @mo-chen

    @mo-chen

    Жыл бұрын

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

  • @theFabz
    @theFabz Жыл бұрын

    This is excellent and serves as a nice quick refresher

  • @mo-chen

    @mo-chen

    Жыл бұрын

    Thanks a lot for watching Fabian 😁

  • @gospelmoto2833
    @gospelmoto283310 ай бұрын

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

  • @mo-chen

    @mo-chen

    10 ай бұрын

    Great to have you here on the channel 😃

  • @J_G_Network
    @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

    @mo-chen

    Жыл бұрын

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

  • @maxtukana5986
    @maxtukana5986 Жыл бұрын

    Love your videos ❤ inspires me to be more data savvy

  • @mo-chen

    @mo-chen

    Жыл бұрын

    Hey Max, thanks so much for watching!

  • @umaraziz4767
    @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

    @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
    @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

    @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!

  • @gamonfi
    @gamonfi Жыл бұрын

    Great content, that's the way.

  • @mo-chen

    @mo-chen

    Жыл бұрын

    Thanks a lot Batá!

  • @rahulkothe2821
    @rahulkothe282129 күн бұрын

    Wonderful

  • @ramprasadsomaraju3889
    @ramprasadsomaraju3889 Жыл бұрын

    nice content need more videos on data cleaning also

  • @mo-chen

    @mo-chen

    Жыл бұрын

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

  • @manashjyotiborah530
    @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

    @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 : )

  • @creyes879
    @creyes8799 ай бұрын

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

  • @mo-chen

    @mo-chen

    9 ай бұрын

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

  • @eziola
    @eziola10 ай бұрын

    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

    @mo-chen

    10 ай бұрын

    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
    @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

    @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
    @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

    @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
    @OtiteSpeaks9 ай бұрын

    Where's the link please?

  • @mo-chen

    @mo-chen

    9 ай бұрын

    It's in the description 😁

  • @user-mn3wk6lh9s
    @user-mn3wk6lh9s Жыл бұрын

    i can not download the crime.csv file

  • @mo-chen

    @mo-chen

    Жыл бұрын

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

  • @ramprasadsomaraju3889
    @ramprasadsomaraju3889 Жыл бұрын

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

  • @mo-chen

    @mo-chen

    Жыл бұрын

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

  • @jamesarchieodena4107
    @jamesarchieodena41078 ай бұрын

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

  • @mo-chen

    @mo-chen

    8 ай бұрын

    😊 thank you