How I'd Learn PYTHON For DATA ANALYSIS | If I Had To Start Over Again

[@original12310]

Finally someone who doesn't say that Python is easy to learn... I'm sick of all those who forgot they had difficulties learning it 😂

[@mo-chen]

Haha it definitely wasn't easy for me. I'm not a tech prodigy who started coding when they were 5 😁

[@original12310]

@@mo-chen Me neither 😅 I learnt SQL, DAX and PowerBI on the go, just because I encountered real business problems that needed those tools.

[@LikeButton4Prez2024]

​@@original12310That's exactly how it went for me too. I had 3-4 false starts in python before I started to make sense of it. I almost had to work backwards from some code I copied and pasted for it to start clicking.

[@SolidSnake59]

No one says it's easy. It's just easier comparing to some older languages. Try C first and then Python you will feel relief.

[@original12310]

@@SolidSnake59 yes, a lot of people have writtent Python is easy. Maybe it's a mistake the way they wrote that. But still, it's written and said.

[@Viper4ever05]

I graduated discovering how essential these programming languages are and I am honestly furious my finance program had absolutely no classes on these subjects or even mentioned how important they would be to our career.

[@mo-chen]

I know... I. was able to do everything in theory but not much in practice 😅

[@Skumtomten1]

Indeed. I graduated with a bachelor in economics and a master in Finance. I learned to use STATA pretty well and the theory, but absolutely no Excel skills or programing. I feel like I don't really know any useful skills, so I desperately try to learn some Python and some Excel right now to complement my education. It is actually a joke that you spend 5 years at uni and don't get to learn any practical skills relevant for your field, almost feels like I wasted 5 years of my life. I have seen a bunch of job applications requiring high levels of python, R or Excel skills but I have never seen STATA yet that was the main tool we used at my uni.

[@original12310]

I used Stata for my master's thesis. Never used it afterwards, never seen it in job ads. I didn't learn Excel, Power BI and other tools only after starting to work and encounter real business problems. The only issue is to get a job where you can flourish and learn these tools. I am quite empty handed to help you there... if you have the time and the energy, learn by yourself with exercises and real life projects that have a meaning to you (either personal or professional).

[@theonlyconformist]

​@@Skumtomten1my background is economics and mathematics, and I work as a SAS programmer in the pharma industry. The math degree got me the interview but didn't require any programming. The econ degree did require a fair bit of R for econometrics. I wouldn't have been hired without that. My university contacted me for feedback a few years into my career and I was very clear that the mathematics department does not prepare its students for the world outside of academia, and students would be well-served to have a programming emphasis

[@gabogainz]

What school did you go to? @@Skumtomten1

[@tyronefrielinghaus3467]

Great video: no fluff, didn't make it seem too easy. Thorough. liked how you didn't downplay the difficulties as some are wont to do...

[@mo-chen]

I'm very glad you liked the video, thanks a lot for watching!

[@DatascienceSiharath]

OMG - You just described how I started learning Python with data analysis. Mainly copy and paste the code since I do not like typing. I need help remembering the code. Now, I have started learning the basics.

[@mo-chen]

Good luck with the Python learning and thanks a lot for watching 😃

[@nikjojo]

Great video. Power Query (in Excel itself) can retroactively add new data placed in a specific folder into your excel file, in-case you don't want to use python.

[@mo-chen]

Great tip 😃 Thanks a lot for watching!

[@nyabutiwalter4955]

Thank you for your encouragement

[@jacobaryee9947]

Great video. I just finished the Google Professional Data Analysis certificate a month ago and I have signed up for their advanced data analysis certification which is mainly based on Python. It has been very helpful but still finding it difficult to write correct codes. I was thinking of giving up but this video has motivated me not to. Thanks Mo.

[@mo-chen]

I'm glad to hear you found this video inspirational! All the best to you 😄

[@bennet5467]

That was really helpful. You explained the very important data analysis basics pretty well! Appreciate your work :)

[@mo-chen]

Thanks a lot for watching 😃

[@markkennedy9767]

This is a very nice overview. If this is primarily what you need for data analysis, it's pretty encouraging. Just know the fundamentals well and know matplotlib, numpy and Pandas!

[@mo-chen]

It is not rocket science, that's for sure!

[@thegamerboneless2864]

I been writing it out in a note book, yes hand written 😂 I do over and over then I do with pc. It has been helping me alot

[@mo-chen]

Great method! We’re all different, key is to find something that works for you. Thanks a lot for watching 😃

[@oommggdude]

I subscribed immediately after realizing how humble and real you are

[@mo-chen]

Thanks so much 😃

[@iskandarinperson]

I like your honesty in describing the nature of data science with python. It also relates to those who struggles with learning the data science especially those who just started in the industry.

[@DREAMS_OF_SUCCESS]

A must watch for everyone before start off with python. I better prepared now to start learning from scratch . Thanks very much

[@arwakalavadwala834]

problem is not "learning python"....its the thought process you need to code something..

[@econhelp583]

Excellent advice packed into a short amount of time. The perfect combo!

[@mo-chen]

I'm glad you liked the video, thank you for watching!

[@benjaayasan156]

Great way to put it Mo Chen. very clean and clear explanation. Thank you.

[@andre-SJP-PR]

The tip about learning the basics and then learning the tools for the area you want to delve into is very good and important.

[@theonlyconformist]

Love the video. My background is economics and mathematics and I've been doing statistical programming and data analytics in SAS for five years. I'm trying to learn Python and work in data analytics for finance. This is exactly the video I was looking for. Thank you for making it

[@mo-chen]

I'm glad you liked the video! Great to have you here on the channel 😁

[@regs_j]

Cheers Mo, I feel motivated to pick up python again and stick with it!

[@mo-chen]

That's great to hear, good luck 😁

[@Fabi-n1x]

@@mo-chen kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@sandydsa]

Insightfull. Useful tips. My mistake was going to hackerrank when I really wanted to focus on data anslysis. After several weeks, I realized that it focused on Developer skills using python, very different from python skills you need for Data Analysis 🙂

[@buffrunner1384]

Thanks Mo, great video. Do you have a video, or could you make one going through & showing how you created the OrdersDataWrangling function from the intro of this video (0:20 in to this video)? Taking multiple excel workbooks and collating into a single table is a huge use case for automation w/ Python, so this would be very useful to hear your though process and how the code chunk works!

[@pandeynikhilone]

I love your voice, and way of expressing thoughts.

[@mo-chen]

Thanks so much for the kind words, great to have you here!

[@rayusaki88]

Thanks Mo! Amazing video 👏🏻👏🏻

[@mo-chen]

Thanks so much for watching, I’m glad you liked it 😃

[@pietraderdetective8953]

Great video! Looping is something I always constantly remind my students to avoid though...especially in Python.

[@mo-chen]

If there’s a more efficient way than looping, use that of course 😃 Thanks a lot for watching!

[@ameerdraidi2181]

Thank you ❤ I'm now on my way in the data analysis journey and I hope I will be a great one in the near future.

[@mo-chen]

Best of luck!

[@happycamper4483]

Very well done!. I am surprised you have fewer views for this presentation.

[@mo-chen]

I’m glad you liked the video, thanks a lot for watching 😃

[@AkporHari]

Really good video, Mo. Just what I was looking for.

[@mo-chen]

I'm glad to hear, thanks so much for watching 😁

[@BillyT83]

Great tips Mo ... Thank you for sharing your journey!

[@mo-chen]

I'm glad you liked the video, thank you for watching 😁

[@leoCarCampos]

Your videos is so objective Mo, congrats 👏🏻

[@mo-chen]

Thanks a lot for watching and for your kind words!

[@TheMISBlog]

Totally Agree with you Mo, Thanks for the video

[@mo-chen]

Glad to see you again on the channel, thanks so much for watching 😃

[@Alexshisler]

Awesome video! Looking forward to applying all of this.

[@mo-chen]

I'm very glad you found the content useful! Thanks a lot for watching 😁

[@Fabi-n1x]

kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@kousei4999]

Thanks for all this valuable information Mo, looking forward to more tips and tutorials!

[@mo-chen]

I'm very glad you liked the content, thanks so much for watching!

[@nitinkayyath6117]

Loved the content Mo. Very informative

[@mo-chen]

I’m glad you liked it, thanks so much for watching!

[@jihoonhong2334]

This is amazing! Thank you so much for this amazing video!!!

[@mo-chen]

Thanks a lot for watching!

[@danielagarcia8481]

Great video! Now, I know where to begin 😁 Thank you

[@anthonymoore3246]

Beautifully made video mate

[@AnalyticsWithAlex]

Great video, Mo!

[@mo-chen]

Thanks a lot for watching 😁

[@marionsabandal1419]

As a python user. These is a very informative vlog

[@mo-chen]

I'm glad you liked the video, thanks a lot for watching 😃

[@guillermocelisprada]

Great video mate, thanks!

[@mo-chen]

I'm glad you liked it, thanks for watching 😄

[@nuinui7510]

Thanks bro! Really useful ❤

[@mo-chen]

Glad to hear that!

[@Jguthro]

I learned java first, so python was easy to get use to and let me learn the art of leverage all if the libraries that are available.

[@mariumbegum7325]

Amazing explanation! Keep up the great content

[@mo-chen]

Thanks so much, I’m glad you liked the video!

[@interest2006]

Is it possible to make a great detailed video of you interacting with stakeholders and what are the steps you take before the stakeholders meeting, analyse, notes, advice to stakeholders and how you ask if you need more information for better outcome And how you interact during stakeholders meeting and what you do after the meeting. How you implement and what problems and difficulties you face with a real/fake 😅 example. Please!

[@mo-chen]

Great idea! I certainly took a note of it 😃 Thanks a lot for the detailed feedback and for watching!

[@Sebastien-bb4oc]

Thank you so much for this video. Good job!!!

[@mo-chen]

Glad it was helpful!

[@Huckfinn2020]

Great video, quite helpful. Thank you! One small question - could you please make a video that helps understand when/where to use python for data analysis compared to self-serve BI tools such as Tableau/power BI/looker? What sort of problems can we solve better with python rather than these BI tools? Thank you in advance!

[@Fabi-n1x]

kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@samueloni2027]

You are so good. so much value in this channel

[@mo-chen]

Thank you for watching and for the kind words!

[@JohnPCleary]

Mo, I looked at your LinkedIn and saw that you are absolutely stacked with credentials and went to some of the best schools and places to work at. With that being said, I have a bachelors in marketing from an online degree mill and was wondering if this career path is even plausible for people with weaker credentials. If you legit where in my shoes, what type of job path would you take to eventually become a DA?

[@mo-chen]

I'm not saying it'll be easy but if you try hard enough and for long enough, you significantly increase your chances of succeeding. I've applied to hundreds of jobs in my life - but obviously only got the actual role a fraction of the times. If it was easy to be a data analyst then everyone would be and companies wouldn't pay you such high salaries. I made a video on how to become a data analyst, you should check that out. I also put together a data analyst roadmap at datawithmo.com/. These should help a lot! Thank you so much for watching 😁

[@colivart]

I’m late but you can look at using your experience to your advantage by becoming a marketing analyst. I’m currently in sales and am being short listed for a promotion to sales analyst.

[@chiranyadissapananda]

Really makes sense! thanks a lot!!!!!

[@mo-chen]

Thanks so much for watching, great to have you here on the channel!

[@master1982]

Well done, Mo

[@mo-chen]

Thanks!

[@DigiGasStation]

Great video. Thanks for sharing.

[@mo-chen]

I'm glad you liked it, thanks a lot for watching!

[@questsarkari]

Good one mo chen

[@kasperjensen3113]

Great content! Some very important aspect to learn Python is to focus on the "field" Data Analysis and not to how to create and app or some other things that is off topic 👍 So great that you pointed that out to others 😊 You can easily take some tutorials with different projects for different purpose and be a master off copying those. But not be really good to data analysis 🙌 So I would also say that find some great dataset from example Kaggle and use the basics functions of pandas, numpy and So on 🎉

[@mo-chen]

Thanks so much for the kind words and for the detailed feedback. Really appreciate it 😃 Thanks so much for watching!

[@priyapriya-nu5vp]

Hii MO thank for video It's very useful and I like the way explain 🙂

[@mo-chen]

Thank you for the kind words, I'm very glad you liked the video 😃

[@Fabi-n1x]

kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@technicalsuranii]

Good to know about your journey usinf Python in Finance Industry

[@mansoorzia9155]

What would you recommend as resources with a roadmap to learn Python for Data Analysis to Data Scientists. What would you term as basics of Python/Programming? I have a background of Excel, SQL, BI Tools (SiSense, PowerBi, Tableau).

[@AbdullaHernandez]

Mo, can you create a video on your thoughts about ChatGPT code interpreter, and what kind of effect it might have on the industry for those of us who are thinking of pivoting into data analysis?

[@mo-chen]

Great video idea, it's something that will be an upcoming video on my channel for sure 😁 My general thoughts and opinion are that I welcome AI onboard. Being a data analyst is not just about writing code which AI is very good at. I'm more than happy for AI to do all of my boring, repetitive tasks such as data cleaning and transformation. You need to understand the business problems, engage with your stakeholders to come up with solutions, dashboards, processes that suit their needs. AI will certainly change the job tasks of data analysts, in a good way I believe - as rather than spending time doing monotonous tasks, I can spend more time doing value-add tasks.

[@AbdullaHernandez]

@@mo-chen thank you for taking the time to answer me Mo, I appreciate that. I'm looking forward to the video, and also thank you for the helpful and professional content you produce, it's very helpful for me as I switch careers from medicine into Data Analytics. Hopefully in a few months I'll be ready to apply for my first entry jobs. 👍

[@RoopmathiGunnaubcmba]

Thanks for posting yet another Lessons Learned video Mo. I liked this video's smooth structure, from describing your situation, how you first learned Python, how you recommend new learners hack it, and finally with the overview of the crucial Python libraries. I see knowledge of Numpy, Matplotlib, or Seaborn libraries being asked in many job descriptions. One tip I would like to add to improve this video is if you could summarize the key points in the last 1 minute of your video.

[@mo-chen]

Thanks for the detailed feedback! Summarizing at the end is useful and is definitely something I'll take into consideration. Thanks a lot for watching 😁

[@decoy7936]

Hi Mo, thank you for your amazing content I learn a lot 😊 A quick question if you can help me: I currently work as financial accountant and want to transition into data analytics, there is a chance to do that within my current employer. They use google sheets to store their data and they do not use SQL (even tho they have a lot a data). For that reason, should I first learn python (I chose the course you recommend with the basics and libraries) and then SQL? Thank you so much for helping us and giving us valuable information and lessons!!

[@mo-chen]

Though I would pretty much always recommend learning SQL first, if you can't apply your skills on a daily basis at all, learning Python first is a good option. Thanks so much for watching 😁

[@c0s1m4]

Hey Mo, thanks for the video! Do you think that Datacamp is useful?

[@mo-chen]

Yes, I do quite like DataCamp. Used it myself as well 😁

[@mjcubelo]

Question, if you know Matplotlib and Seaborn, do you still need to learn Tableau or MS Power BI?

[@nateechandrakasem2339]

Very informative video on building a strong foundation for beginner data analyzers.. but the real question is, where can I get that black oversize tee shirt in all your videos? I need one! 😂

[@mo-chen]

Haha you’re not the first one who asked about the t shirt. It’s from Uniqlo. Very affordable 😃

[@toancdu]

Thank you so much for your shares.

[@nttrn]

Thanks for python recap and the essential library for data analyst!

[@mo-chen]

I'm glad you liked the video! Thanks so much for supporting the channel I really appreciate it!

[@DanielleBaylor]

Still in the beginning phases of SQL but thought I'd see what you have to say about Python 🙃

[@mo-chen]

Thanks for watching, great to have you here on the channel 😁

[@AttackOnTyler]

Not having any technical skills, going straight to python is kinda brutal. Like you don't really know what the solved state should be before implementing code to make it

[@kousei4999]

Also, thanks for explaining things on a easy to understand manner, you make it feel achievable after explaining your own struggles.

[@mo-chen]

The key is to not give up and work hard 😃 I wish you all the best with your own journey!

[@shrike1861]

Where do u learn the basic of python? Until u r ready for essential libraries such as numpy and pandas?

[@delwarhossain4501]

Thank you very much Mr. Mo

[@mo-chen]

You are very welcome. Thanks for watching!

[@Fabi-n1x]

kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@fredericostephan]

I really liked your explanation. Do you recommend any course to really master python foundations? Thanks

[@elisahgildaredonga6535]

Great video, Do more!

[@mo-chen]

Thanks so much for watching, I will!

[@marialaura9493]

Hi Mo! First of all thanks a lot for your videos, they've been of huge impact in my current learning path and also thanks for taking the time to go through comments

[@mo-chen]

Of course I'm reading all of this, one of the things I love about this channel the most is the ability it gave me to connect with others 😃 I made a video recently on how to build an awesome data analyst portfolio. Check it out here kzbin.info/www/bejne/rYDFh5KerNplh68&ab_channel=DataWithMo. This should help!

[@Fabi-n1x]

kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@welcometomathy]

Never had the need to know python in my day to day as a data analyst. All I have to Know Excel SAP Business Objects/ Azure Databricks (SQL) Power BI (DAX)

[@mo-chen]

DA jobs will vary widely in terms of roles and responsibilities. SQL, Excel and Power BI is a great combination of skills! Thanks a lot for watching 😁

[@kittykatganda2042]

I can resonate with you!

[@jessicapierceart]

Nice b-roll. 🤣😂 Love the marathon video.

[@mo-chen]

Thanks a lot for watching!

[@BelleMorue]

I think my maths are weak a little bit for data analysis. I am learning machine learning and this is relatively easier to me because I did a bachelor degree in computer science with specialization in compilator's design and network programming. Also, I did 20 years before an expert system in clisp and some game solvers with sicstus. I considered someone able to solve a logic game is not a real software developer if this person doesn't write the code to solve the mystery word puzzle in the news paper. Don't disrespect yourself with only a pen with word puzzle please, this is not fun. My mathematical notions are limited to some books.(Actuarial Mathematics Bower, Life Insurance Mathematics, Theory of Interest Killison , stochastic Ross, some book of first statistic course where we teach how to use a moment-generating function , Calculus Spivak, Real Analysis for students in mathematics, Discrete math for CS, Numerical analysis, math for cryptanalysis, algorithm, linear algebras, and math for aircraft technicians. )

[@Austin1510g]

Really great video. But the intro that said "run this one line of python code" without saying that that one line is saying to run a python file that has a hell of a lot more lines than just one lmao

[@bloodyred633]

Great Video 🎉😊

[@mo-chen]

Thanks a lot for watching 😁

[@zacharysng2626]

this video is 👌, big fan

[@mo-chen]

Thanks so much for watching 😁

[@frankiexpentaxangeli]

i thumb up for mentioning dad who is watching it

[@Ikee76]

Hey Mo! I recently finished the Google Data Analytics Course. I’m beginning to do more of a deep dive into SQL and R but was wondering if I should substitute R for Python since it seems to be the more popular language. What do you recommend?

[@samueloni2027]

Python is more popular and is in demand. Learn Python first

[@mo-chen]

I can only code in Python and not in R, and I'd say Python is more popular so go with that! Thanks a lot for watching 😃

[@applepeel1662]

Python definitely R is mostly used in academic research

[@sheikhraihan8550]

Such a great video

[@mo-chen]

I'm glad you liked it, thanks a lot for watching!

[@hareemkhalil5108]

How much math or calculus does one need to know to learn python for data analysis? i have an undergrad degree in economics and no background in coding. How much time do i need to invest in building a data analysis skillset?

[@andrewhting]

you da man!

[@mo-chen]

Thank you!

[@marvin1659]

great brother

[@mo-chen]

I’m glad you liked it 😃

[@homeoffice3524]

So interesting how different paths can end up in the same place. I never finished anything after primary school. UK is not my country to. And in the end I learned sql, php, and python in my bedroom. I refuse to learn and use any OOP and ai craps or mainstream forced shit. And here I am. With salary 55k per year + side projects making small games. I'm working completely remote and next year I'm going back home where this salary is astronomical 😂

[@mo-chen]

Sounds like you're in a happy place! Well done for everything you've achieved 😁

[@Fabi-n1x]

kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@MarkEm]

This is THE MOST typical journey

[@MarkEm]

He doesn't realise that non-programmers don't have a clue what tabular data is😅

[@danawhiteisagenius8654]

Coming from Sys Ops and DevOps, Python came easy to me. If you can script BASH you’ll be ok with Python.

[@ee_li]

Thanks 😊

[@mo-chen]

I’m glad you liked it 😄

[@adelakunadebayo]

Hi Mo thank you. this is your 2nd video i am watching and i just stumbled on your page (less than an hour ago) while doing a search for the path to being a data analyst. Well done mate. I am an electrical engineer (renewables actually) and i really just want to be a data analyst in the power industry. Do you have or know anyone that one can follow on that path already? Not a spring chicken here (i am over 50 years old) just want to add more skills to my portfolio so i do not have to do much heavy lifting in a couple of years down the line. thank you so much for your videos. They actually are encouraging for people like me who are so swamped with all the information out there. Road map is really needed for guidance. Thank you again mate!

[@mo-chen]

HI there 👋 I don't know anyone in the power industry unfortunately. Not sure if you checked out the roadmap on my website at datawithmo.com/. If not, feel free to have a look! Thanks a lot for watching 😃

[@M1Fortunes]

Just get to it friend, Pick up your data analytical skills along with some Python coding and apply to the companies that inspire your interest. There is definitely a place for you.

[@Fabi-n1x]

kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@jinluwang5671]

We only had one week of 3 classes for python basics. Moving to pandas next week 😢

[@ricardofacts2287]

Great video

[@mo-chen]

Thank you 😄

[@retrogaminghd3300]

Can you give me a timelime to keep track of my progress? Is 3 months enough? Or maybe 6? . I am an econ major. And second question, how much math do u know and how much is used daily in your role ? Thank you mo !

[@mo-chen]

Everyone's timeline is different. I've been coding in Python for about 3 years now. You can probably get to a decent level in 6-12 months if your focus is data analytics solely. Thanks a lot for watching 😃

[@TheShabooka]

thank you!

[@mo-chen]

Thanks so much for watching!

[@IsmaelKinoti]

Me feeling like "hey you just hid under the table"😅😅 Great advice though. Thank you

[@Fabi-n1x]

kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@okongee007]

thank you mo

[@mo-chen]

Thanks a lot for watching 😁

[@NormieDead]

omg that was sic.. din't knew when video ended. btw i came for data-science

[@Nathan-f4d]

Thanks Big Bro Mo

[@mo-chen]

Haha thanks for watching!

[@confusedmark]

Hi Mo, I am very confused with the industry I am going to take. I am currently under BS Economics program. I am confused between Data Analysis and Web Development and Design. I am also have a background in SEO and copywriting. I would love to hear your advice which one to focus for a long term-career. Thank you in advance.

[@mo-chen]

Choose the one that you think will enjoy the more in the future. Unfortunately I can't really comment on web dev and design, given I've never had any experience working in a role like that. Why not try do some projects for both and see which projects you enjoy more? Maybe that'll help 😄

[@Mathematics_Discuss]

If you already enjoying economics, the best and logical road to take next is data analytics. Web design is a career very deviated from Economics which you are already into.

[@Fabi-n1x]

kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@elvinmustafov7313]

nice video dude keep it in same way .

[@mo-chen]

Thanks, will do!

[@Fabi-n1x]

@@mo-chen kzbin.info/www/bejne/l3Ldd4lpmpKMfNk

[@M_le-n4r]

Can you make a video on how to automate the excel sheet data you had in the beginning of the video ? :)

[@mo-chen]

Not sure when I'll get to make the video, but for now you could check out the excel related functions in the pandas library (e.g. pd.read_excel, pd.to_excel, etc). Thanks a lot for watching 😁

[@ng2791]

Great video, wish I know half of what you’re talking about lol