How I use Python as a Data Analyst
ฝัง
- เผยแพร่เมื่อ 16 พ.ค. 2024
- 📲 Job Data App 👉🏼 datanerd.tech/
🐍 Python For Everybody 👉🏼 lukeb.co/PythonForEverybody
📊 Python for Data Science 👉🏼 lukeb.co/PythonDataScience
Python App Resources:
==================================
♾️ EDA Python Notebook 👉🏼 www.kaggle.com/code/lukebarou...
📈 Kaggle Dataset 👉🏼 www.kaggle.com/datasets/lukeb...
👽 GitHub Repo 👉🏼 github.com/lukebarousse/Data_...
☁️ SerpAPI to BigQuery Python Code 👉🏼 gist.github.com/lukebarousse/...
🔷 SerpAPI 👉🏼 serpapi.com/ (💥20% OFF💥 If you tell them Luke sent you)
👾 r/DataNerd Subreddit 👉🏼 / datanerd
* NOTE: The Streamit app I built in this video keeps crashing due to heavy traffic 😔 which is a good thing! 🎉 And so I built a new one: datanerd.tech/
Courses for Data Nerds
==================================
📜 Google Data Analytics Certificate (START HERE) 👉🏼 lukeb.co/GoogleCert
☁️ Google Cloud Fundamentals 👉🏼 lukeb.co/GoogleCloud
💿 SQL for Data Science 👉🏼 lukeb.co/SQLdataScience
🧾 Excel Skills for Business 👉🏼 lukeb.co/ExcelBusinessAnalyst
🐍 Python for Everybody 👉🏼 lukeb.co/PythonForEverybody
📊 Data Visualization with Tableau 👉🏼 lukeb.co/Tableau_UCDavis
🏴☠️ Data Science: Foundations using R 👉🏼 lukeb.co/RforDataScienceJH
➕ Coursera Plus Subscription (7-day free trial) 👉🏼 lukeb.co/CourseraPlus
👨🏼🏫 All courses 👉🏼 kit.co/lukebarousse/data-anal...
Build a Portfolio
==================================
👩🏻💻Build portfolio here 👉🏼 hostinger.com/luke
Rebate Code: "LUKE"
My Portfolio 👉🏼 lukebarousse.tech/
Books for Data Nerds
==================================
📚 Books I’ve read 👉🏼 kit.co/lukebarousse/book-reco...
📗 Data Analyst Must Read 👉🏼 geni.us/StorytellingWithData
📙 Tableau 👉🏼 geni.us/tableau
📘 Power BI👉🏼 geni.us/powerbi
📕 Python 👉🏼 geni.us/pythontricks
Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 kit.co/lukebarousse/computer-...
🪟Windows on a Mac (Parallels VM) 👉🏼 lukeb.co/ParallelsFreeTrial
👨🏼💻 M1 Macbook Air (Mac of choice) 👉🏼 geni.us/M1macAir8GB
💻 Dell XPS 13 (PC of choice) 👉🏼 geni.us/DellNewXPS13
💻 Asus Vivo Book (Lowest Cost PC) 👉🏼 geni.us/AsusVivoBook15
💻Lenovo IdeaPad (Best Value PC)👉🏼 geni.us/LenovoIdeaPad15
Social Media / Contact Me
======================
👾 r/DataNerd 👉🏼 / datanerd
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
🙋🏼♂️Newsletter: www.lukebarousse.com/
00:00 Intro
01:31 How to collect data
02:33 APIs
03:19 Getting the Goods
04:58 What is a Database?
07:32 Cleaning the Goods
08:56 EDA of the Goods
09:31 Salary Analysis
10:01 Keyword Analysis
11:55 App Build... for the Goods
13:14 I NEED YOUR HELP!!!
As a member of the Amazon, Coursera, Hostinger, and Parallels 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 - วิทยาศาสตร์และเทคโนโลยี
Data Nerds, I'm curious on your feedback on this Python app! Check it out here 📲 jobdata.streamlit.app/
Love your passion for data, Luke! The app looks clean and easy to understand, my only note is that on Skill section, there's a small typo on the title question you might want to update. Also thanks for the great video as always.
Thank you!!
And oh my goodness... the spelling!! 🤦🏼♂️ ... Add this to things Python is NOT good at... spell check
Hey great work. Can you please make a end to end tutorial for entire automating pipeline so it would help us a lot.
This was amazing to see from beginning to end, its awesome to see some of my daily operations in view of the piblic
@@LukeBaroussepython seems a program language you cab do anything build Aby program you want?
That was an incredibly interesting video. An end-to-end data science project fully deployed presented in terms of apples and oranges. Amazing teaching style and very useful app. Forking your repo.
Thanks Sebastien!
Wow the editing on this is excellent
🙌🏼 Thanks... I'm blaming this on why it took me so long to upload this one 🤦🏼♂️
Thank you Luke. I'm just starting out with data science! It's incredible how you showcased what Python can do and connected the dots along the way for beginners such as myself. You're awesome.
Wow.. amazing video Luke! Watching your videos just boosts the passion I already have for Data Science. Thank you.
This is an absolutely unreal video and project you undertook! The fact that you also gave all the code and the csv file along with it is so cool! I just graduated with a degree in Physics, and am starting a data science career, and videos like this are priceless. Your videos have helped me a lot so far and looking forward to more in the future! Keep rocking
My dude, thanks so much for noticing this about the small details! Stoked that this helps with your learning. 🙌🏼
P.s. Also, nobody was supposed to see the emoji on the R bin, I thought I cut it fast enough in the edit... guess not 🤣😜🤣
did you get a job?
really nice work. You clearly show the strength and power of python. I'm not surprised SQL is the top skill. many jobs are listed as data analyst but all the company is really looking for is someone to use SQL and get the data from different source systems and then use some kind of BI tool like tableau, power BI, SSRS etc.... to build a report. Python would be used more in a data science role which def have less people than a job requiring you to write sql code and build basic reports
Two of my favourite things I learned from this video are
1) Importance of learning python
2) storytelling ( Presentation skill)
Thank you so much Luke!!
You got my message!! I appreciate this 🙌🏼
What an incredible video and project concept! for the first time I've truly understood what all we can do by learning data analysis. I'm currently learning all of this and sometimes it feels dry and I feel like giving up, but you with your passion have motivated me to work harder! thank you!
So glad that this video could motivate; I know the struggle all too well with understanding how to apply these things, so just trying to give back!
That was freakin awesome, I know NOTHING about what you taught but had to watch all the way through to follow the story. GREAT job man!
Love you luke! You are a Great Mentor for newbies in Data Science like me....Always Grateful to you.
As someone who recently started learning about Data Analytics, I can say I'm (finally) starting to understand concepts from a broader perspective and listening to this video got me excited (even though I may not YET understand the granular detail. Well done Luke, this is AWESOME!
Heck yeah! Keep up the studies Sifiso, it does get easier!
Hello, i started too. I use programix On which plattform do you learn python?
This was honestly one of the best coding videos I've seen on YT. So much information shared in such little time. I was thinking about Data Analyst as a route to take from Systems Integrator (what I'm currently doing), and I'm doing a bit of what you shared here. Awesome job man!
Glad it was helpful, Kamron!
This is such high quality content! Thank you for taking the time!!
This is so cool, I love nerding about automations like this! Python + SQL is always a nice combo
Thanks Mateo!
This is beautiful and keeps me motivated to stay on my journey to become a data analyst. Awesome video, tons of information and what a great project!❤🔥
Luke, really impressive - not only high py skills but also an interesting topic, thank you for this high quality content
Great video, thank you so much! I've been learning Python during the last 3 months, just scratching the surface so this video helped me scope things out and see Python's true capabilities.
This was an amazing video - great editing and application to real-world data. Thank you!!
Thanks a lot for this! Everything is so well explained, I really enjoyed seeing the entire process! 🥳🥳🥳
Love the video! Thanks a lot for posting and for the job you've put in to create it. :)
Luke, best content and best editing skills I've seen, you rock!
Thanks for the video Luke it's really helpful, can you mention how you clean description column or make a video about it
Much appreciation for the lessons delivery mechanism - creative and fun!
Your channel has some of the best produced content. I thoroughly enjoy watching each and every episode. The amount of detail and effort that you put into them really shows!
Aw thanks for noticing the effort Edward!
Wonderful video that showed the power of Python and what a great tool to have to get and analyze so much data in so little time.
I hope to see a walkthrough of this project in particular in one of your future videos
The editing style of this video is amazing and engaging. Also, the video's content is top notch!
thanks for this, def brought some much-needed clarity for me!
Great video Luke! Summarized the whole pipeline neatly. Now, my mind is on fire, thinking about analysing data with Different APIs.
Thanks buddy for creating such good content.
🙌🏼🙌🏼🙌🏼
such a cool video. I did the Google Data Analytics course but wasn't sure I wanted to become a Data Analyst. What really excites me with Data is what you did in this video - automation, efficient workflows and just a tone of time saving wizardry. Some really useful info here too and noticing your editing skills are taking on a Vox like sytle which definitely work. Big thumbs up!
Hi Dan, I've just started module 2 of the Google Analytics course. How valuable did you find it at your actual job of data analysis? Did it teach you what you need to actually start on day 1 at a job, is there anything more you suggest I learn?
@@GarthVader78 Sorry if i gave the wrong impression, in the end I decided that Data Analytics wasn't for me - so didn't apply for any data analytics jobs. I really enjoyed the course and enjoy learning about data, but most of the jobs I looked at were emphasising Excel skills and I just didn't fancy sitting in front of a spreadsheet all day analysing sales of lipstick or bed springs. We are going through a really exiciting time right now though with AI and it will be interesting to see the impact of that on a typical Data Analysit role. If you are doing the original course, and not the advanced course, one recommendation I'd make is when you learn R - find out how you do that in Python too. And I'm sure they mention it, but get started with your project's portfolio asap. I wish I had done more with that.
Absolutely loved this video. Great work! I'm subscribing.
This is BRILLIANT!! Can't wait to dig into it. Thanks!!
Wow Luke!! You channel is amazing truly. Thanks so much :')
HEy Luke, Really nice Video !! The Application and Editing of this very video is really GOOD ‼
Wow - impressive work, Luke! That’s about 10 hours worth of content boiled down to the essential 14 minutes. I love how you made the code AND data available. Phenomenal.
I’ll just say that anyone as Python-savvy as you will get wayyyy more value by upgrading to a Python-based calculator app like PyCalc than sticking with old school calculators.
Looking forward to more high quality content.
I need to check out this PyCalc, thanks for recommending this!
Great Job Luke, Liked that more technical content!
First video i have seen that shows me the WHY of what I need to learn. Thank you so much.
Holy molly! You are so good at this. New sub here!❤❤
This is exactly what I needed to make sense of all the skills and app names and terms I hear flying around assuming I know them!
Amazing content! Thank you! Also, thanks for providing links.
You really are a data nerd, Luke. Thanks for these well-edited videos, keep up the good work!
Crazy amount of value in this video, thanks Luke.
Amazing video Luke!! Thanks for this type of content
🙌🏼
That is a huge amount of work you have done to make this video. Thank you for this.
Thank you for noticing! 🙌🏼
incredible work Luke !
Man great video! You give us so much motivation to move on!
Wow. Thank you Luke, soo much information here.
Congratulations, this is undoubtedly one of the best videos on "How I use Python as a Data Analyst"
Luke is one of the person in youtube who encourage me to learn Data analytics in coursera ...
Another super nice video of yours! THanks for sharing!
loved it , am going to watch all your vids xD
This is so Cool!!! Superb explanation and really get us through everything. your content really does answer my struggle in showcasing online project. Thanks Luke
No probs!! Thank you!
Wow. The amount of helpful information in this video is staggering. More pleeease!
More to come!
Wow! Great video I’m glad I found your channel. Instant sub.
This may seem strange to say, but your video helped give me a wake up call and realign some priorities.
It was also a huge “truth bomb” in that it really showed me that I don’t have a snowball’s chance in hell of ever arriving at this level of knowledge and skill.
I’m 50 and looking to change careers. I’m all over the place learning from several different sources-I’m embarrassed to say how many. But, the bottom line remains: It would take years-years I simply don’t have anymore- to be as versed a data-badass as what you displayed here; I’ll be eaten alive.
Awesome work, man!
First video I've seen of yours, but I love it. Immediately liked and subscribed.
🙌🏼
Wow just wow! I jumped here from your insta account to explore more knowledge! About Data Analytics... N i would like to appreciate you bcoz, you are giving practical knowledge to people like me... I am from a Non IT background n its really hard to switch in DA DS and you are doing a wonderful job! With ease! Love from Indian🇮🇳
The video was extremely helpful for filling in some gaps for me. Value is off the charts 🌟
Thanks Man this is extremely useful! Huge fan
Love your video Luke. One of the best ones with the bike analysis you did. So much effort put there! Thank you very much! You are almost convicing me to move towards Python away from R. Especially because of the data engineering part and how much Python seems to be better integrated into cloud ecosystems. Need to make up my mind quickly.
Nothing wrong with some R, but I do have a soft spot for Python and it's compatibility with so many other tools! Thanks for the comment Bouseux!
Impressive! Thanks for all the time and work to make this short packed video happen.
Glad you enjoyed it, Ariel!
I honestly did not believe i would like the video, but You Made me understand more in 14 minutes than in the last 3 months I have been learning Data science, thank You, subscribed 👍
Heck yeah this is awesome to hear! Data science can be a tough one to learn so just trying to make it easier. Thanks for the kind words 🙌🏼
Great analysis Luke and love the app!
Thanks Data Professor, If it wasn't for you I probably wouldn't have even considered StreamLit, so thanks! 🙌🏼
You are a Genius Luke !!! God bless you !!!
The skills displayed in this video baffle me. Theres so much one can do with these tools. As long as you know how. This guy Luke seems like a pretty sharp guy.
It's absolutely a mind-blowing project, Luke! 🤩🙌🏽 Python is so powerful Love how you uncovered the process of creating this project, thank you for sharing it! Ugh the jokes can't be more real, I feel that pain of literally pulling my hair out and saying WTF to my computer 🤦🏻♀
😜 Oh my goodness, I had so many freakouts during this project, Thu! 🤣 And thank you for all your feedback on this project along the way, super appreciative of ya!
@@LukeBarousse Hahaha I can imagine it's a whole roller coaster! You did great 😜
Wow... This is insane!!!!... Have been looking for how to do a powerbi project using live data and API and I've been struggling with finding direction... This video came from the heavens... 😂😂😂
Thanks luke
Good luck with your Power BI project! And glad this could help
Wow, incredible! You could easily release a paid tutorial/course explaining all these details. If you eventually release it, please let us know, I'm very interested in learning your workflow
Interesting! Maybe at some point! And def will do!
The most practical analysis i've seen yet
Hey Luke, just found your videos.
I'm a data analyst but my company's (non profit) definition of data analysis is sadly behind the times, and I am trying to broaden my skills and tools so that I can further my team's ability to handle our data as the company grows. I have been studying python, SQL, R, and Tableau (trying to keep it all free because my company aint sponsoring this), but the lessons are so scattered because these tools are used for so many different roles and tasks, especially python which I like the most.
When you are demonstrating how you use Python I see you doing things like data cleanup, importing data, seeing tables, etc. Can you put together a slowed down, and more detailed version of these steps, or point me/us in a direction on where to learn these specific tools/modules (Free or cheap)
You’re great dude, thanks for your videos!
Great overview, thanks Luke
here before this video blow up, this amount of work is amazing
This is an AMAZING video that gave me so much insight as to how API's work as well as added to my list of topics I need to learn sooner then later.
I WISH YOU HAD A TUTORIAL SHOWING HOW TO COMPLETE A PROJECT SUCH AS THIS. I WOULD WATCH IT AND I KNOW MANY OTHERS WHO WOULD AS WELL!!!
Thank you so much for your video and I really hope to see a tutorial of this project in the coming months!
Thinking about doing this, stay tuned!
What amazing job!!! I loved it!!!
You are that TH-camr everyone needs for their field. I was “wow”ing on ur content.
Aw thank you! 🙌🏼
Hey @LukeBarousse! I am just learning Python myself now (about 25% of the way thru it) from udemy and it's been great. It's a great class, but I am curious about something. I am struggling to figure out how and when to use those concepts currently. For example, I know how to use while loops or I know how to create classes with attributes and methods, but what I'm struggling with is how to know when to use those for projects. Does this just come with time and practice or does that fact I don't know that mean I have yet to completely absorb the lesson? I guess a simpler way to say that is my questions aren't about the code itself and how it works, it's the application of it. When practicing I am struggling with looking at it and going "Oh yes, of course, I need to use this and that, and put one of these in here". Does that make sense? I am hoping that will just come with more and more practice and real world application, but I don't know.
Hey Luke, big fan of the channel and has me interested in changing my career to data analytics. I was curious if you could do a video talking about the data analytics degree from WGU, and possible resources to help accelerate through the degree?
Thanks man! I have been waiting for this since last LinkedIn scrape you did. Good vibes too!!!!
I took way too long for you then! But thank you for waiting Johnbelle!
Great video. Seems like a great project for me to replicate and add my flare to! ❤️
Wow this video an eye opener, from this video i realized that i have been doing data analyst job for this past few tears without me knowingly 😢
Great video as usual!!! Go further LUKE
This video was a good reminder that I need to break out of my procrastination. I had a Coursera crisis of confidence and have been avoiding the Data Analysis capstone project for a few months now.
Thank you for a great video with a both excellent educational and entertainment content! Thank you for sharing the dataset with the community for free ❤
Heck yeah! Thanks for helping us DataNerds out with your API!! 🙌🏼
I have to say as a BI analyst, this video is pretty damn accurate of how we use Python. Well done Luke!
Thank you!
Wow! I really didn’t know what should I expect before click, but you did an amazing job doing this video! For real made my mind blow up
Thank you!
Great Video!! Thanks for this type of content ♥
You're so welcome Thilina!
Love your videos!! 💙
Fantastic Job Luke, I actually went over your kaggle profile few days ago over this same project, I used the results for the 2022 Kaggle Survey Data Analytics competition (you got the credits!), I was wondering if it was really you or not tho, Thanks a lot for the resource :)
Oh heck yeah! This is awesome to hear you are getting use out of the data for something! And thanks for the credits!!
Thanks for the video, it will be great if you add how to setup serpapi also can you give us link of the website that you extract data
Love your work bro
Thank you very much. May god bless you
This my first time to comment but am your great follower. Thanks for everything.
Really cool video!!!!!!!!!!! Keep up the excellent effort
This video is really useful. I really appreciate your example. It helps me solving my two biggest problem recently. Skill and how to collect job info.
Glad it helped Hugh!
"If you got value out of this video...", after storming us with so much value in 14 minutes. It felt like a movie....jeeeez! Thanks so much for this end-to-end explanation. I'm definitely coming back to this video for future reference.
Heck yeah! Glad it provided value! 🙌🏼
This guy is the best data related content creator there is
Hey, could you make any video on the topic- My workstation tour. Showcasing what setup do you use for your work.
Sir, I feel like subscribing to your channel is the proudest subscription of my entire existence in TH-cam.
I’m actually a L&D professional from Morocco and I’m trying to steer my career to data & business analytics and really need guidance.
Thanks for the very cool story though!
This is an amazing illustration of the power of Python Luke!
Thank you my dude!!
@@LukeBarousse you're very welcome!
Can you recommend my channel to your followers as well?
Nice video man gj!