Learn PYTHON to be a DATA ANALYST?!? (or is R enough...)
Рет қаралды 252,608
Күн бұрынGoogle Data Analytics Certificate 👉🏼 lukeb.co/GoogleCert
🐍 Python For Everybody 👉🏼 lukeb.co/PythonForEverybody
📊 Python for Data Science 👉🏼 lukeb.co/PythonDataScience
Follow Al Bellamy on LinkedIn 👉🏼 / bellamy-al
GitHub Repo on this 👉🏼 github.com/lukebarousse/Job_A...
In this video, I share my findings on whether you should learn Python to become a data analyst. For this, I used Python to scrape LinkedIn job postings for data analysts to analyze what skills are being requested of entry-level data analysts. Surprisingly enough, it is neither Python nor R as the most requested skill!?!
Certificates & Courses
==================================
DataCamp:
Intro to Python Course 👉🏼 lukeb.co/PythonBasicsDataCamp
Python Data Analyst 👉🏼 lukeb.co/PythonAnalystDataCamp
Power BI 👉🏼 lukeb.co/PowerBIDataCamp
Tableau 👉🏼 lukeb.co/TableauDataCamp
R 👉🏼 lukeb.co/RDataCamp
DataCamp Subscription (25% off ) 👉🏼 lukeb.co/datacamp_discount
Coursera:
Google Data Analytics Certificate (BEGINNERS START HERE) 👉🏼 lukeb.co/GoogleCert
Python for Everybody 👉🏼 lukeb.co/PythonForEverybody
SQL 👉🏼 lukeb.co/PostgresSQLUofM
Coursera Plus Subscription (Monthly $59USD) 👉🏼 lukeb.co/CourseraMonthly
Coursera Plus Subscription (Annual $399USD) 👉🏼 lukeb.co/CourseraYearly
Build a Portfolio Website
==================================
Create your website here 👉🏼 hostinger.com/luke
Rebate Code: "LUKE" (Save up to 91% on annual plans at checkout)
My Portfolio 👉🏼 lukebarousse.tech/
Recommended Books
==================================
📚 All Book Recommendations 👉🏼 kit.co/lukebarousse/book-reco...
📗 Data Science Must Read 👉🏼 geni.us/StorytellingWithData
📙 Tableau 👉🏼 geni.us/tableau
📘 Power BI👉🏼 geni.us/powerbi
📕 Python 👉🏼 geni.us/pythontricks
Tech for Data Science
==================================
💻 Dell New XPS 13 (PC of choice) 👉🏼 geni.us/DellNewXPS13
💻 Dell New XPS 15 👉🏼 geni.us/DellNewXPS15
👨🏼💻 M1 Macbook Air 8GB (Mac of choice) 👉🏼 geni.us/M1macAir8GB
👨🏼💻 M1 Macbook Pro 8GB 👉🏼 geni.us/M1macPro8GB
🔌 Must-have Mac dock 👉🏼 geni.us/CalDigitTS3
🖥 M1 Multiple monitor adapter 👉🏼 geni.us/DisplayLinkAdapter
⌨️ Mac Keyboard 👉🏼 geni.us/MacMagicKeyboard
🖱 Mac Mouse 👉🏼 geni.us/MacMagicMouse
💾 Small (1TB) External HD 👉🏼 geni.us/WDelements1TB
💾 Large (14TB) External HD 👉🏼 geni.us/WDelements14TB
🏢 Standing Desk 👉🏼 geni.us/StandingDeskFezibo
📸 Camera of Choice 👉🏼 geni.us/SonyA6600body
For computers, I recommend checking the manufacturer's website (i.e., dell.com) for deals/rebates
Social Media / Contact Me
======================
🙋🏼♂️Newsletter: www.lukebarousse.com/
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
📥 Business Inquiries: luke@lukebarousse.com
00:00 Intro
01:05 Overview
01:43 What is Python?
02:35 Analysis of Python Use
03:40 What is R?
04:07 Python vs R
04:36 Why Google chose R!
05:43 OTHER tools to learn
09:24 Recommendation to learn Python
11:38 Conclusion
As a member of the Amazon, Coursera, Hostinger, and Data Camp Affiliate Programs, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.
#datanerd #dataanalyst #datascience
@SunDevilThor 2 жыл бұрын
I would absolutely love an in-depth tutorial from beginning to end on how you put your web-scraping script together.
@LukeBarousse 2 жыл бұрын
If this comments gets some more likes, I'm definitely down for this!!!
@Major_Data 2 жыл бұрын
+1
@priyankgupta 2 жыл бұрын
@@LukeBarousse Please do this.....
@ronytakchi7199 2 жыл бұрын
Subscribing so I don't miss this vid!
@briangolembiesky6402 2 жыл бұрын
@@LukeBarousse I was about 5 minutes into your video and had the same thought. I would absolutely love a tutorial on creating a web-scraping tool specifically to look at new job positions on Indeed or Linked In. Probably going to send you an email asking if I could pay to have you put together a tutorial. It would be invaluable.
@sicelovilane5391 2 жыл бұрын
I have often noticed people focus on the seemingly cool stuff like coding too much without the basic understanding. I have an IT background and currently a BI Developer. My preferred list would be the following: 1. Get enough knowledge of Statistics 2. Use one simple statistics tool with a Graphical User Interface e.g SPSS, Stata, etc 3. Sharpen your MS Excel skills 4. Learn SQL for data analysis 5. BI tool or Visialization tool e.g. Power BI, Tableau 5. Learn a Data Science programming language e.g python, SAS, R 6. Build projects I'm sure you'll be the complete package. Thank me later 😊😊
@Fnartprod 2 жыл бұрын
I work with both R and python on a daily basis, from a statistical tool stand point the R ecosystem is better, more statistical tests are available, with more statistics (like confidence intervals) and under the hood the implementation tends to be more accurate, also for a beginner with a stat background R api is closer to the theory so it's faster to pickup. Python is way better as a general purpose programming language hands down. I'm working on porting some of R's statistical tools to python
@LukeBarousse 2 жыл бұрын
Very much agree with this my dude! Thanks for sharing this!
@stonecat676 2 жыл бұрын
the R api being closer to theory and math terminology is spot on, that's why it's preferred for data science positions that utilize math more
@GohanSSJII 2 жыл бұрын
وين تعلمت خويا هذا المجال ؟ من ڨوڨل سارتيفيكايت ؟ راني حاب نبدا هذا المجال اذا عندك roadmap نكون مشكور ليك الله يحفظك
@seekerj1643 2 жыл бұрын
Agreed. I think they both have their purposes and as a statistical tool R is the way to go. Python has a bit of catching up to do but it will for sure.
@vivekjoshi3769 2 жыл бұрын
Did you learn R first or Python for data analytics? I started with Python in the beginning for basics & then moved to R. I didn't learn Python libraries but I have learned some R libraries. Now I feel these libraries are pretty overwhelming. I am thinking to go back to python.
@joemoe1739 2 жыл бұрын
I made some research on this topic at our University. Statistically, many IT students, prefer Phyton over R and it was no surprise because many of them think that Phyton is more dynamic and easy to understand, where as r needs to type complex syntax to perform operations. But I prefer R for doing statistical analysis and other stuff. With R, I think you'll be able to to to the deeper insights into a statistics. Glory to those R diehards.
@LukeBarousse 2 жыл бұрын
Ha! I can appreciate me some R!
@emilyau8023 Жыл бұрын
My first programming language was Java. If you understand most programming languages including R, you can pick up how to use Python. These people who are complaining act like it's a war crime. They need to chill.
@theraven.4 Жыл бұрын
It is pretty common for python to thrown into people's faces.
@DJ_Osiris Жыл бұрын
Start with Excel. It's indispensable . I learned R before I learned SQL. Once you learn the dyplr package of R, SQL will be a breeze. SQL is not that hard once you understand the principles of data manipulation and R is a great way to learn that.
@Moon-ob7lb 2 жыл бұрын
Excellent video! I especially appreciate you opening up the scope and sharing the other tools that are important!
@LukeBarousse 2 жыл бұрын
Thanks for this Moon!!
@CS-si8kl 2 жыл бұрын
People should learn from you how to take criticism in the most positive way before learning anything that is to do with data analytics. Great video. And savage response by giving a shoutout to the same person. 😂
@LukeBarousse 2 жыл бұрын
ha! I try to be savage! Thanks for watching!!
@InglesConConfianza Жыл бұрын
That was a perfect response to criticism.
@kwamsahortor 2 жыл бұрын
"...so when I understood that R was barbaric, I switched over and learnt Python." Luke you're a savage and the R community will be coming for you. 😀😀😂😂 I'm living for this R vs Python "debate".
@LukeBarousse 2 жыл бұрын
I got my shields ready... I'm ready to take on the R nerds... hahahaha Thanks Michael!!
@faustin289 2 жыл бұрын
Why is R considered 'barbaric' though? If anything, I find it a clean and simple language that doesn't try too hard to do everything like python. It only lives for data analysis and it does the job excellently. If only I could wrap my head around its love affair with lists and the ***apply family of functions!
@Major_Data 2 жыл бұрын
Funny thing is, while R may be barbaric, the R user community is pretty polite and equitable. Notice I didn't say anything negative about Python itself in that video, just the vast army of Python Fanboys. 😉
@LukeBarousse 2 жыл бұрын
@@Major_Data There are no rules in Python Fanboy land!! We take no prisoners!! 😂
@LukeBarousse 2 жыл бұрын
@@faustin289 I was saying "Barbaric" as a joke! R is a very decent tool IMO for a data analyst! I'm just Python Fanboy, so I'm obliged to say rude things like that 🤣
@user-ul2lv7qs7r Жыл бұрын
Enlightened. Thanks Luke!!!
@wilsonaguilar6117 2 жыл бұрын
Ty for the advices! I started with R and now I am using python because I like working in other programming stuffs such as automatization and webscrapping
@LukeBarousse 2 жыл бұрын
Heck yeah, thanks for sharing this Wilson, such a good reason to switch over to Python!
@advrohitowhal9794 2 жыл бұрын
Luke every video is EYE opener. BIG THANKS!!!!!
@LukeBarousse 2 жыл бұрын
Thank you!
@extraincomesuz Жыл бұрын
Luke, I'm on the final module of the Google Data Analyst Certificate, learning R. I too wondered why I was learning R since job posts more often asked for Python. I learned Intermediate JavaScript so understood foundational programming before this course. I like using Sheets & SQL but feel I need to dive deeper into Excel. I love this journey and wish I could plug my brain into learning multiple languages at once -- Python, advanced SQL and advanced Excel functions. This video pushed me to subscribe, thank you for the analysis!
@LukeBarousse Жыл бұрын
Heck yeah, good luck with finishing up the certificate!
@marcocerrato9014 2 жыл бұрын
Hi Luke, like always great video. I completely agree with your analysis. I am a python fanboy, but you are right. Python is not a requirement for a lot of cases. Having said that, I do believe that having Python under your skill belt is a plus. Same goes with knowing R. Oh I also use datacamp.
@LukeBarousse 2 жыл бұрын
Heck yeah thanks for sharing this Marco! Glad to have you as a fellow "Python Fanboy"!! Very much agree with your assessment of Python and R.
@allahjoseph Жыл бұрын
Bullllseye on the analysis & presentation! My guy doesn’t miss. Great stuff dude
@imdeepu7855 2 жыл бұрын
Thank You Luke for putting effort and given us a brilliant idea about the same topic.
@viceroyop6385 2 жыл бұрын
Very helpful insight going into my last year of uni. Thanks.
@LukeBarousse 2 жыл бұрын
Heck yeah, glad I could help!!
@vivekjoshi3769 2 жыл бұрын
Hey Luke! Amazing video. This video speaks exactly my thoughts. I have been thinking why people are not focusing on skills like Excel & SQL and straightaway diving into Python libraries. Phew! I realized this early & started working on Excel & SQL.
@LukeBarousse 2 жыл бұрын
You're on the right track Vivek! To often (including myself) we get lured into learning Python before learning other important skills
@BoxerDogs 2 жыл бұрын
This was another very helpful video. Thank you for posting.
@diegodelsol1309 2 жыл бұрын
Great response, Luke! Positive and professional. Keep up the good work.
@LukeBarousse 2 жыл бұрын
Aww thanks so much Diego!!
@nodaswardenaar 2 жыл бұрын
"I myself started with r on my journey, and realized when r became barbaric I switched" -Luke. Dude starting on projects not long ago with r, I really feel this one. I came from a biomedical science background and learning r for my minor bioinformatics. I didn't had any expectations whatsoever and had no idea about programming at all. Coming from no background, r has been really challenging and fun experience to learn. The learning process of r had really much similarities between my background and the syntax. Didn't thought that statistical analysis was really fun to work with, since I had only used excel for statistics before.
@LukeBarousse 2 жыл бұрын
😂 I really didn’t think many people were going to catch me saying that… hahaha Awesome to hear about the projects with R, it can be tough at time but totally worth it. So much better then dealing with spreadsheets alone for analysis.
@MrCeroSombra 2 жыл бұрын
I actually genuinely love using R. It's really the first programming language (I don't count SQL as it's not really the same thing as I see it) that I've tackled after studying C++ for years and studying basic Linux kernel scripting and it is honestly fun. I've never felt so confident with optimizing my code before. Also, it is ridiculously easy for me to grasp most new concepts. I won't lie, I haven't looked much into python, with only a couple hours of it under my belt, but I think I will always be attached to R. Also, sidenote Rstudio is a fantastic IDE for all the above languages. Imho. Thanks for the video, I watched it before starting the Google Certificate and again now.
@LukeBarousse 2 жыл бұрын
Can completely agree with this for R, it's def a great option to use. Thanks for sharing Clyde!
@crisolivares7847 2 жыл бұрын
Hey Luke, I am currently taking 3 courses 2 hrs a day 2 days a week for 10 weeks. Data Analysis with R & RStudio, Data Analysis with Python Anaconda and Python basic Machine learning. That's how I came across with your channel. 4 months ago I took a 60 hrs course in Python 3 which was based in the Cisco PCPA. These courses are free in my city because of a Microsoft techspark project they did with the Mexican government. My dream is to get an Entry level job in Data science I just have my High School Degree but if I get a job with the salary they have for entry level positions in my city I will be able to pay my college right now I have 2 daughters and my wife is pregnant and making 100dlls a week! I know it sounds crazy but the economy in Mexico is very different. I just wanted to say thank you for all the quality content and give you some context on the audience you reach and might not have an idea you are helping a lot of people. Honestly Thank you.
@LukeBarousse 2 жыл бұрын
Thanks for sharing this Cris, Good luck with your journey in data science. I admire your hard work and perseverance. You got this my dude!!
@S.R.Yejan28 2 жыл бұрын
Hey, Luke! Thank you so much for this informative video. I think that maybe I am living my life backwards, but I am halfway through learning R with DataCamp, and was planning to flow directly into learning SQL > XL > PowerBI. I know that this might be against your recommendations, but it is really helping me understand the world of data analysis better and it teaches me how to think in those terms. This as I come from a completely different background as an ESL teacher. But anyway, I love R and your channel both jajaja!
@LukeBarousse 2 жыл бұрын
Hey Samuel, the recommendation I provided here was a generalization focused on those that want to enter the world of data analytics and get a job quick. There is no "perfect" path. The fact that you are motivated enough to continue your studies with R while also learning data analysis is good enough in my book!! Keep up the hard work and studies!!
@johnsonnnaji6510 Жыл бұрын
Love your sincerity in your viewpoints. Always Top Top quality from you Luke
@bouseuxlatache4140 2 жыл бұрын
Luke you should be supervising masters students. You just did a hypothesis testing supported by a mixed qualitative and quantitative analysis. Brilliant! No kiding. You should be supervising those kids. You'd be a super lecturer. Thanks for the video and take care.
@LukeBarousse 2 жыл бұрын
Aww Bouseaux, thanks for the kind words my friend!! And ha, I wouldn't mind teaching a class one day, but glad you noticed the motive behind my video! 🙌🏼 May need to do more videos like this!
@michaellee4303 2 жыл бұрын
Hey Luke, I love your videos so much I've found myself binge-watching them lately. You compare a lot about the certificates, but I'm curious as to what data science boot camp program you would recommend to a friend. I think it would be a good idea for a video as the boot camps most often build on top of the certificates.
@LukeBarousse 2 жыл бұрын
Hey Michael, I've never taken a boot camp program, per se. I'd have to investigate thsi further to find out more. Most of my learnings have been through e-learning platforms like Coursera and DataCamp as they were lower cost options for me
@gsabella4 2 жыл бұрын
In the Google DA Cert, about to start the R section of the course (almost to the finish line) Looking forward to learning!
@geenahspace5391 Жыл бұрын
Your videos❤😩😩 I just can’t stop watching, been binging all night and I can’t get enough. Thank you so much Luke, I’m a newbie to Data Analysis, I’m about to start out even though I haven’t even gotten a Laptop yet. I’m hopeful to start out as soon as I have saved enough for a HP or Dell Laptop. I’m glad I have a background on excel from computer lessons my mum enrolled me at after junior highschool here in Nigeria. Studied Nutrition in the university and becoming a Data analyst on Food, diet and the medical sector sounds really nice🥺. I am definitely doing this, might take sometime but surely it would happen. Once again, thank you Mr. Luke, you inspire me alot and your contents are so wholesome. It’s liberating, it gives me a feel that this is achievable because of how well and easy you’ve broken it down. I’ll sleep now, sadly I can’t get even 4 hours sleep from now (it’s 4:16 am in Nigeria) because I have to work this morning but it’s been so worth it😅.
@LukeBarousse Жыл бұрын
Glad you have been enjoying the videos!! Good luck on your learning journey you got this! 🙌🏼
@JASA_87 2 жыл бұрын
Thank sooooo much for this vid.... I want to break in into the tech world and I wanted to be a data analyst but did not know the path I should go to achieve such goals... thank you for providing all the 8nfo I need to start on my journey
@LukeBarousse 2 жыл бұрын
Aw thanks for this Julio! Keep up the positive vibes my dude, you got this!
@amythequeenzhang 2 жыл бұрын
Thank you Luke for all the good stuff.
@LukeBarousse 2 жыл бұрын
Glad you like it!
@hugoestrada194 2 жыл бұрын
Great video and analysis there, hi Luke, I'm a Software Engineer from Guatemala and currently I'm working as a Data Analyst. Personally, there are a couple of points that I'd like to mention that I strongly believe are worthy, in order to have a healthy discussion. I use Spark, Python and SQL almost every day on my job, like each language to me has its own pros and cons. I used to work as a DBA, so I have a couple of second thoughts regarding SQL haha. I do agree that Excel, R and SQL are good foundational languages to start in this field, and I'm not a Python fan, or better said, I'm not advocating for any language, to me, the tool, or language of choice, will depend on the needs of your project, and the community you have. Like, why would you use SQL or Python or R or any language, when you can actually combine them. My advice, would be, don't marry any language or tool, because that's all what they are: TOOLS.
@LukeBarousse 2 жыл бұрын
Boom! Love this knowledge bomb Hugo! Thanks for sharing this. Very much agree with your perspective. You need multiple tools in order to succeed as a data analyst!
@YazminAbat 2 жыл бұрын
Very wise!! sometimes the tools are more googleable for certain tasks :) vba + python + sql work wonders
@oseikwamejones9019 Жыл бұрын
I love this.
@vladi1475S 2 жыл бұрын
This is also a good project to add to your own experience as a data analyst. Thanks for the video!
@muffinhydra Жыл бұрын
Also I would argue due to the popularity of python its easier to get resources about it in order to get decent / above average with it . Within the course, to go with R, is to make sure that there is a definitive base skill level for it; while with python you can learnt that anywhere to a decent degree.
@sergeymelkumov5940 2 жыл бұрын
I just finished my certificate and very happy about it. I think R does everything I need it to do and beyond. There are packages for web scrapping and building production ready web apps (not with Shiny, i know it has performance issues, with dashR).
@LukeBarousse 2 жыл бұрын
Thanks for sharing this Sergey! I agree with what you are saying about R
@ShivekMaharaj 2 жыл бұрын
Your videos are enlightening Luke. Nice work. 👌
@LukeBarousse 2 жыл бұрын
Thanks for the kind words, I try to make them easy to follow!!
@ramyasengupta6531 2 жыл бұрын
Thankyou for the guidance. I was looking for this from months. Everyone out there know alot but you put it in the bestway. Mastering Excel SQL visualization/programming skills. Its a path for beginners. God bless
@ckpratibha9956 2 жыл бұрын
Great content, was looking for an answer to this!
@LukeBarousse 2 жыл бұрын
Thanks for coming on over to my channel CK!! Glad I was able to help!!
@Qzbub 2 жыл бұрын
This is such a good eagle eye view on what skills to master and why
@LukeBarousse 2 жыл бұрын
Thanks Anvesh!
@wartem 2 жыл бұрын
In Sweden, Power Bi is about 5 times more likely to be in postings than Tableau.
@GTV_367 Жыл бұрын
Good vid good info💯
@structormodeling7728 2 жыл бұрын
Thanks for the great content bro!
@LukeBarousse 2 жыл бұрын
And thank you for watching!
@explorer_yogesh 2 жыл бұрын
Wow, you are great. This video helped me a lot.
@LukeBarousse 2 жыл бұрын
Aw thank you, glad it helped!
@rakohasan 2 жыл бұрын
Take love Luke. You are amazing. Your analysis is much mind blowing. No one talk me that I should be master of Excel.All of them said, start with python. Most of the article and videos give important on python first.Your recommendation is blessing of new comer. Thank you. Actually I was looking such as video.You have given all answer of my query. ❤️😇
@LukeBarousse 2 жыл бұрын
Heck yeah! This is so awesome to hear Rako! Good luck in your learning journey!!
@navjotsingh2251 2 жыл бұрын
I use R, google sheets and Java for all analysis. Never had to touch python at all. But it depends on where you work and what their tech stack is.
@LukeBarousse 2 жыл бұрын
Thanks for sharing this tech stack, I agree depends on where you work!
@alyan9247 Жыл бұрын
Sir your advice is helping me as a entry level Data Analyst so i'm really Thankful to you with tons of Love 💓
@Eyalgazit 2 жыл бұрын
Thank you Luke, Have a great day! Personally I finished the Google Analytics certification and started to learn Python in my own pace.
@LukeBarousse 2 жыл бұрын
This is awesome to hear Eyal! Good luck with your Python studies, you won't regret it
@krn-in2tv 2 жыл бұрын
I love your content!! thank you very much!!!!
@LukeBarousse 2 жыл бұрын
Aw thank you so much for this!! 🙌🏼
@davidmiller-td1sl 2 жыл бұрын
You R starting quite a battle with this one! Great video! DataNerds can use a lot of tools!
@LukeBarousse 2 жыл бұрын
Thank you to my top subscriber! You are gonna crush this race this weekend!!
@OnlyFps09 2 жыл бұрын
Wow your video are clear, informative straight forward on details. Thank you for your helpful informations Sir.
@LukeBarousse 2 жыл бұрын
Aww thanks so much for noticing this! I try to keep them clear as possible!!
@stopthink9000 2 жыл бұрын
This was GREAT!! I liked the R portion most of all from the Google DA Cert course. I was wondering the differences between the two and if I was missing out on anything with Python. You definitely hear a ton more about Python than R. The thing I like about R is it's quick and dirty capabilities. You can go from CSV to visualizations within a minute or two on a large dataset. You definitely can get to know quite a bit about a dataset in a short time w/ R. I would like to learn more Python soon, but it's not as urgent as I thought it might be. Thanks man!
@LukeBarousse 2 жыл бұрын
Yep, def not as urgent!! If R is getting your job done then it is good enough and stick with it to master it!! Thanks for sharing this Philip!
@bouseuxlatache4140 2 жыл бұрын
I like this little R vs Python fight. for sure each community will strive to develop further modules and packages and refine them. we will all benefit from that. personally I want to love both of them. I use a lot microsoft solution and have the impression python is used a lot with azure to transform and load the data. and R is used to support machine learning solutions like machine learning studio. I wonder if google is going that route? thanks for the video Luke!
@LukeBarousse 2 жыл бұрын
Thanks for watching!
@Tejaswi_ss 2 жыл бұрын
Thank you so much for suggesting datacamp i have tried learning from different channels and coursera too but datacamp is the best🙌
@LukeBarousse 2 жыл бұрын
Thanks for sharing this Tejaswi!!
@TheMISBlog 2 жыл бұрын
Great video luke
@LukeBarousse 2 жыл бұрын
Thanks!
@turnabol 2 жыл бұрын
Hi Luke, thank you for sharing this video. I believe I'm not the only DA noob that got stuck in the weeds of R vs Python. You did a great job with explaining that there is so much to be learned before this question makes any sense for beginners. Could you please recommend any Excel learning resources? Or do you remain firmly with GDAPC being the one-stop-shop for beginners?
@LukeBarousse 2 жыл бұрын
Hey Marko, I think the GDAPC is a good introduction... but def not the final resource for mastering excel. I personally used this book (along with a course I took in college) to better master Excel. amzn.to/2Xj14qe
@husseinhadliye2992 Жыл бұрын
Thanks for the video it's really helpful for beginners like me but I really love if you make a tutorial on web scraping in python
@pakipower 2 жыл бұрын
Great insights Luke. Any comments on Power Query and Python comparison?
@LukeBarousse 2 жыл бұрын
Python is obviously a superpoerful language, but if you work with excel alone then I think you HAVE to use power query to load and transform your data. Very powerful tool (even when compared to Python) IMHO.
@elghark 2 жыл бұрын
My personal experience was pretty much the same as that you pictured: -started with excel + some vba code -SQL fundamentals -Matlab for university -R as my very first data analysis/science environment -python for everything If I were good at, I'd probably keep on working with both R and Python. Even if Python it's the one I prefer, I have to admit that R is much easier as starting point. Many less libraries mean much less confusion and let u focus on few crucial ones. I miss its outstanding libraries for statistic tests and the way u can insert inputs according your needs.
@LukeBarousse 2 жыл бұрын
Thanks for sharing this perspective. Very much agree about the ease of learning R as well and it still being a powerful language!!
@catvyhuynh7359 2 жыл бұрын
Thanks for your analysis and comparison between Python and R. Personally, I think both programming languages are useful for data analysis, but these tools are not enough for data analysts since we also need to master other tools like SQL, Tableau, Power BI, and speadsheets. By the way, I really like the way you use Python to collect relevant job information from LinkedIn to make analysis. Since I'm doing the Google DA certificate, I'll have to learn R first. After finishing, I've planned to do the track Data Analyst with Python from datacamp because I think I can learn the most of Python for data analysis here. Your learning journey of Python really encourages me to follow my learning pathway. So thanks again and I'm looking forward to your new videos!
@LukeBarousse 2 жыл бұрын
Aw thanks for the kind words!! I think you have a great learning plan established for data analysis and python, so keep it up!
@minlingg91 2 жыл бұрын
i started with python first as I started learning data science through a government subsidized diploma which teaches Python/Tableau by default. It was the most cost efficient way for me.However, I am looking to pickup R as it is the preferred language that the analytics department at my company uses. im currently in a non-analytics role but i still find python useful in automating some tasks, manipulating data with pandas etc. that would take me hours on excel.
@LukeBarousse 2 жыл бұрын
Yeah I think they are both great. It’s awesome to hear how you are applying both!!
@daviuni5489 2 жыл бұрын
Wow that's so so interesting, thanks
@LukeBarousse 2 жыл бұрын
Thanks for tuning in!
@charafreggui2053 2 жыл бұрын
Luke you are one of the best data analytics youtubers that I'm a big fun of.I'm a computer science student in my last year andhaving both skills and interests in both data analytics and IOT fields , however wondering which one holds the most demand for entry job . What do you think ?
@LukeBarousse 2 жыл бұрын
Hey Charaf, thanks for the kind words my dude!! I'm not too familiar with the job demand in IOT, but for data analytics I feel like it's staying positive. Plus is can be applied in so many different industries that I really feel it's promising... Good luck in your studies!
@solamente30 2 жыл бұрын
Great objective video!
@LukeBarousse 2 жыл бұрын
Thank you!
@SC-bi6my 2 жыл бұрын
I have learn Python a little bit and now i just start Google cert. with R. I think R is more easily in term of picking up the basic in data analysis. Actually I think both R and Python are good at data field.
@LukeBarousse 2 жыл бұрын
Hey thanks for sharing this, awesome perspective to hear!
@NP_Omar 2 жыл бұрын
I appreciate your content
@LukeBarousse 2 жыл бұрын
Aww thanks Omar
@Major_Data 2 жыл бұрын
Dude, I haven't laughed that hard in forever. Brilliant!
@LukeBarousse 2 жыл бұрын
I'm not gonna lie... I was a little nervous for your reaction to this 😳 Glad you got a laugh out of it!!
@Major_Data 2 жыл бұрын
@@LukeBarousse I'm honored! Seriously, I should do a tutorial on how to start beefs between KZfaqrs... 🤣
@everythingnerd7168 Жыл бұрын
When you were looking through the job postings, was it just looking for any job with python or r listed, or was part of the criteria that it was a data job? That could definitely change the results since python has so many different uses
@willianferreira6613 2 жыл бұрын
That information is quite good for me. I already work with excel VBA, power query and power Pivot. My role is to automatize projects and reports. I already developed a project using python as well. Unfortunately I can't share because it contains company's information. But I guess I am almost ready to transition.
@LukeBarousse 2 жыл бұрын
Yeah I think your start with excel is foundational. Keep up with the learning new tools!
@nikbohm 2 жыл бұрын
I'm not a data scientist. Just interested in the field as an amateur. @Luke, we need more people like you, in any field and not just tech, who calmly and objectively try to understand how to improve their area of work, rather than denigrating people like this Al person did. Great video. Keep up the good work and the attitude.
@LukeBarousse 2 жыл бұрын
Thanks for the kind words!!! Oh BTW Al is a great dude!! He was only saying the things he did as a joke. I in NO WAY was trying to make Al seem like he was abad dude, I really enjoyed his humor on this subject so I wanted to share it!
@lordespax 2 жыл бұрын
Hey Luke, I’ve just come across your channel today and I can not be more grateful about your content. Your easy-to-follow guides to data analytics and how to entry these kind of jobs are excellent! I have a question though, I’m finishing a computer science degree right now, where I’ve learnt quite a bit of everything (R, Python, C, Java, sql, etc) but nothing in full detail (apart from Python which I learnt myself at job). What would you recommend me going for after finishing the degree and the Google Certificate? Mastering Excel/SQL? Thank you in advance and have a nice 2022!!
@LukeBarousse 2 жыл бұрын
No problem at all! Glad you are enjoying the content!! And yeah I would recommend Excel/SQL (that is if you are interested in becoming a data analyst). I made a new video on this recently, not sure if you saw it yet: kzfaq.info/get/bejne/l9eCq72E17CwdZc.html
@lordespax 2 жыл бұрын
@@LukeBarousse Yeah! In fact that's the one which brought me to you :) Thank you again for the advice and keep up the amazing content!!!
@LukeBarousse 2 жыл бұрын
@@lordespax Aww thanks my dude! Sorry about the same vid recommendation 😂🤦🏼♂ Good luck with your studies!
@arvind_purushotham 2 жыл бұрын
In my opinion..lets not have roadblock on what tech to master..Its basically on the usecase we handle..If its about deployment, deeplearning , nlp, oops, scraping -- python is my choice..If its about statistical test, market basket analysis, other eda analysis -- R is my choice..It depends on community interest on a specific algorithm..
@LukeBarousse 2 жыл бұрын
BoOOm!! Very much agree with this Arvind!!!
@wartem 2 жыл бұрын
I know Python and SQL pretty well. Should I learn Excel, R, (Tableau or Power Bi) now? Or maybe theory like statistics and further knowledge in pandas, numpy and matplotlib?
@dataArtists 2 жыл бұрын
Another great analysis and entirely helpful for me! Broke my heart to learn R = baRbaric through ;-)
@LukeBarousse 2 жыл бұрын
Thanks Robert!! I may have exaggerated a bit about it being "BaRbaric"
@arthurbaz2 2 жыл бұрын
As an economist, I use R for econometric/spatial/general data analysis and now I'm also getting into shiny dashboards, which allow me to present results nicely. I've very limited knowledge of Python, but my goal with it is learning web scraping and other stuff that R can't do as well... Same with SQL, which I'm using to query huge databases.
@LukeBarousse 2 жыл бұрын
Heck yeah, these are great goals to have with Python. I think you've picked a great reason to start learning it! good luck!
@arthurbaz2 2 жыл бұрын
@@LukeBarousse thanks! Your content is being really useful
@fernando_dominguez Жыл бұрын
Luke, you are the man, loved how you approached this without ego. I rarely write comments but you got me pumped up. Without knowing it, you described my career path: Excel ✓ Power Bi ✓ SQL ✓ (funny thing here, I thought I knew R but with your explanation I don't lol) Python - Just started a few weeks ago and very pumped! I will probably end with R but I feel I have a long way to go with Python. Thanks for your content it's great!
@LukeBarousse Жыл бұрын
Thanks Fernando! Good luck with the Python studies! 🙌🏼
@syhusada1130 2 жыл бұрын
Hi Luke, in the Capstone project phase of Google Data Analytics. And I seem to be able to use merely just R to cover the entire phase from Ask, Prepare, Process, Analyze, Share, to Act. I wonder, when is it that I will be required to use Excel/SQL by necessity to analyze data?
@LukeBarousse 2 жыл бұрын
In the course? I'm not too sure but I feel it covers the basics of Excel and SQL during the course. As demonstrated in this video Excel and SQL are highly valuable skills for data analysis and you'll be requested to use these skills as a data analysts. Although you may not use Excel and SQL in your capstone, that doens't mean a data analyst doesn't use it in their real job
@Rawi888 2 жыл бұрын
Stellar Vid. I got a lot of anxiety thinking " Oh crap, I've wasted so much time doing nothing, now look at this mountain of work I need to tackle. AND I"M STILL GONNA PROCRASTINATE" but you know.... I'm kind of... sick and tired of being sick and tired man. I GOTTA BE ABOVE IT !
@LukeBarousse 2 жыл бұрын
Love this attitude my dude!!
@caiotheodore9751 6 ай бұрын
cool video, my only problem with this analysis is scraping ALL job postings. Outs of those 150k, a lot might be skecthy or simply undesirable jobs. As a statistician who recently spent a lot of time looking for my first job, I haven't seen a job offering talking about Tableau even once
@GamingRobioto 2 жыл бұрын
Really interesting having just discovered your videos, I'm an experienced Data Analyst in the Education sector (6 years and a further 4 in Emergency Services) and my main tools have been Excel and to a greater extent R (with a sprinkling of SQL). For the type of analysis I do, I've found R much more useful than Python. I have however, felt I need to learn Python due to many advertised Data Analyst roles asking for it, when thinking of the next step of my career. But as I don't use it everyday at the moment, it is hard to retain that information so I'm looking for ways to incorporate Python into some of my regular work. Food for thought... as I feel I've stagnated a bit and stayed safe with Excel and R.
@LukeBarousse 2 жыл бұрын
Thanks for sharing this, and glad you found my channel! Both Excel and R (more specifically) can be such powerful tools as you've shown here. Thanks for sharing your perspective on Python and R!
@GamingRobioto 2 жыл бұрын
@@LukeBarousse Thanks Luke, it's inspired me to get back to learning Python again, so I'm going to pick that up again this week at work. So thank you for inadvertently doing that 🙂👍. Subbed and I will be watching with interest from now on. Rob
@LukeBarousse 2 жыл бұрын
@@GamingRobioto heck yeah! Glad to have another sub! Good luck with the python studies, Rob 🙌🏼
@carl-christianmalm863 Жыл бұрын
Thanks for all the content!!! Much appreciated and highly enjoyable :) I have a question though. Being in mid-career, wanting to add some skills I'm currently taking the Google Analytics cert, however I wanted to add Phyton as well. Being a newbie, and needing to do the grunt work is the Coursera Crash course or Udemy's Phyton BootCamp recommended for this or any other course to consider instead?
@LukeBarousse Жыл бұрын
I'm not too sure on Udemy, as I haven't looked into their offerings as much as Coursera's
@carl-christianmalm863 Жыл бұрын
@@LukeBarousse ok thanks. I'll stick to Coursera and ure vids then ;)
@chinmothy 2 жыл бұрын
i love the fact you did some self evaluation before starting the video
@LukeBarousse 2 жыл бұрын
I try ... sometimes my mouth gets me in trouble 😳
@TVP_Akshay Жыл бұрын
Excellent
@akin242002 2 жыл бұрын
As a Python fan, Python is just fun and nice to read. However, I like how you address the issue. Self reflection isn't easy.
@LukeBarousse 2 жыл бұрын
It's never easy but must be done! Thanks for sharing this!!
@christianpedigo5213 2 жыл бұрын
I got my certification through the Google courses. I honestly think that R is far more difficult to learn than Python. I'm teaching myself the latter and i'm finding it's easier to learn (without much guidance) than R (with the courses guidance). So, with that said, I'm not sure whether or not R is inherently more difficult than Python, or if the course's teaching style simply didn't match my learning style. But yeah, I've really enjoyed Python and mostly resented R.
@christianpedigo5213 2 жыл бұрын
And then following this, I absolutely love SQL and would be 1000% happy if my entire day was spent in it.
@LukeBarousse 2 жыл бұрын
Everybody has their own learning style, so I agree with you that its hard to say... is it the learning method or is it the language? Either way, you are proceeding forward with learning a language which is A+ is my book! Keep up the hard work Christian!!!
@vectoralphaSec Жыл бұрын
If i want to work as a machine learning engineer or data scientist one day which entry level job role should i start applying to get my foot in the door in the industry?? I dont mind starting from the bottom and working my way up.
@skwerel Жыл бұрын
I would be curious to see if this held if the dataset included business analysts. The two positions are pretty similar, and many companies use the two interchangeably
@mohamedelhosary2988 2 жыл бұрын
I don't comment a lot in KZfaq but can't this time.. you're awesome!!
@LukeBarousse 2 жыл бұрын
Aww Mohamed, thanks for this one! I appreciate it my dude!
@TylerHillery 2 жыл бұрын
Dang Luke your channel is blowing up! Almost at 100k. Question, when doing your data analysis you looked at the frequency of Python or R each time it showed up in the job description. Do you think the frequency matters or just the fact it showed up at least once?
@LukeBarousse 2 жыл бұрын
For the analysis, if a word appears in the job description at least once then I count it. I didn't analyze it any further if it appears more than once as my assumption was that because it was mentioned once, then they must be requesting it for the job. Maybe for a more in-depth analysis I may look into frequency within a job description, but i'll save that for a later time.
@TylerHillery 2 жыл бұрын
@@LukeBarousse I think the way you did it makes more sense. I just wanted clarification to make sure I understood it correctly. Keep up the great content!
@LukeBarousse 2 жыл бұрын
@@TylerHillery No thanks for asking! I didn't feel like I explained it completely clear in the video. Appreciate the motivation as well, stay tuned for more for this project!
@hemantaphurailatpam3956 2 жыл бұрын
if you are learing python as a data analyst, better learn cython too. If ur code is running in a few minutes, then its fine. But if it takes hours, or days to run, then better implement cython. That being said, most of the code optimization can be done in the structure of the code (less nested for loop and if-else statement). Numpy array operation is a way to achieve this. In my case I am comfortable with both python and C. So, whenever I need speed I wrote a piece in C and link to my python code.
@LukeBarousse 2 жыл бұрын
Thanks for sharing this hemanta, def agree on using this for speed efficiency. I typically stick with Python as my code runs fast enough for me
@BrunoInterlandi 2 жыл бұрын
Anyway, nice video! Many concepts on it
@LukeBarousse 2 жыл бұрын
Thanks Bruno!
@carlosm9114 2 жыл бұрын
it could be very much interesting to see a video about the best SQL editors, i´m just starting and the one that google offers does not seems right for me. Thank you so much for the videos and the info you provide, i love it :)
@LukeBarousse 2 жыл бұрын
I’m a VS CODE fan but I haven’t checked it much for sql yet. I also use pgadmin for Postgres.
@justluke8730 2 жыл бұрын
So I am getting my bachelor's this summer and learnd the basics of both r and python. I can confidently say, that the most common limitation with either of the two is your own knowledge. That said, i prefer to work with R simply because it comes more naturally to me and usually my intuition gets me to where i want to be more often than not. Programming in Python often feels like a fight...
@LukeBarousse 2 жыл бұрын
Thanks for sharing this Luke! Yeah like youve come to realized I think the most limiting thing is your knowledge and application of the tool!
@dylanoharvey4298 2 жыл бұрын
Very good
@TheGridMedia 2 жыл бұрын
Great video Luke, as a business analyst looking to move more into the science side and leans some new skills, this one knocks it out of the park for me. I finished the google course and now I'm moving into python :) PS: maybe a year after M1 or when the new MacBooks are announced, I would love a, one year later, on M1 mac for DAs, or if PCs are still king without all the software workarounds. Been a ThinkPad user for years, but the M1s are sexy.
@LukeBarousse 2 жыл бұрын
Hey my dude! Thank you so much for this, glad it could be of help! I'd def like to do a video on this topic. Also hoping to do a review of the M2 (or whatever they call it) when it comes out, so stay tuned!!
@daniilg586 2 жыл бұрын
Used to use R to implement statistics models into my analysis on risk. However, the vast majority of dudes in my team work with python so do not see any difference in it, R is just a bit easier for me in terms of syntaxis 😀
@LukeBarousse 2 жыл бұрын
Thanks for sharing this Daniil!! Very much agree with your assessment here!
@shilpakarra7059 2 жыл бұрын
I just started the Module in the Google Data Analytics Certification on Coursera where they start with R programming. I feel, because I am from a completely non technical background, it is both high and low for me now. The high being that since I am not aware about any programming language at all, I just have to start with something, which is R, currently. And the low being too many reviews from experts about how one is better than the other are giving me a scare. But like you mentioned, I am just at the beginning level of Data Analytics, switching careers after a 15 year run into HR. So, I'd rather focus on R, probably practice more of Tableau and SQL before I think about going with a specific programming language.
@LukeBarousse 2 жыл бұрын
Very much agree with this Shilpa! Don't be intimidated by R, it's perfect for learning a programming language! Good luck!!
@tgfmg007 2 жыл бұрын
I'm also on the Google Data Analytics Certification. Been in music education for ten years (teaching). I'm enjoying it! I do plan to take other courses on Python soon. Can't wait to see where it takes me.
@drmanny39 2 жыл бұрын
So I decided to start google professional certificate next month, do you recommend that I do the Excel course first , I saw the IBM has it as their second module in the course
@LukeBarousse 2 жыл бұрын
No I would just stick with the google to start
@CPA1535 2 жыл бұрын
as an accountant who is learning this stuff the reason why excel is so popular is because us finance folks live in excel. you have to think about the end user when you do your data analytics and using excel as a canvas for your final product will make non data analyst folks feel more comfortable.
@LukeBarousse 2 жыл бұрын
Very much agree with this, thanks for sharing this. Excel is very user friendly to a lot of people
@KASANITEJ 2 жыл бұрын
Can you build a model with apriori to see which progrmming languages or s/w tools are combinedly required for a job title.
@LukeBarousse 2 жыл бұрын
I'm not familiar with apriori
@swastikgh9110 2 жыл бұрын
the video gave good insight s
@LukeBarousse 2 жыл бұрын
Thanks for this!!
@223mauricio Жыл бұрын
Analysis of Python use , I had to rewind like ten times … my brain just exploded with this “simple” script 😂 I think now I will call you the God of data analysis… ✅ number 1
Симбочка Пимпочка
Рет қаралды 2,5 МЛН
Learn with Lukas
Рет қаралды 43 М.
Data Nash
Рет қаралды 39 М.
One More German
Рет қаралды 1,7 МЛН