How I use Python as a Data Analyst
HTML-код
- Опубликовано: 22 май 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!
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 🙌🏼
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.
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
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?
Love you luke! You are a Great Mentor for newbies in Data Science like me....Always Grateful to you.
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!
This is such high quality content! Thank you for taking the time!!
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!
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!
Luke, best content and best editing skills I've seen, you rock!
Much appreciation for the lessons delivery mechanism - creative and fun!
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.
HEy Luke, Really nice Video !! The Application and Editing of this very video is really GOOD ‼
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
incredible work Luke !
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!❤🔥
Great Job Luke, Liked that more technical content!
This is BRILLIANT!! Can't wait to dig into it. Thanks!!
Love the video! Thanks a lot for posting and for the job you've put in to create it. :)
The editing style of this video is amazing and engaging. Also, the video's content is top notch!
This is so cool, I love nerding about automations like this! Python + SQL is always a nice combo
Thanks Mateo!
Absolutely loved this video. Great work! I'm subscribing.
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 an amazing video - great editing and application to real-world data. Thank you!!
Luke, really impressive - not only high py skills but also an interesting topic, thank you for this high quality content
Thanks a lot for this! Everything is so well explained, I really enjoyed seeing the entire process! 🥳🥳🥳
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!
First video i have seen that shows me the WHY of what I need to learn. Thank you so much.
Wow. Thank you Luke, soo much information here.
Wow Luke!! You channel is amazing truly. Thanks so much :')
Crazy amount of value in this video, thanks Luke.
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.
🙌🏼🙌🏼🙌🏼
thanks for this, def brought some much-needed clarity for me!
You really are a data nerd, Luke. Thanks for these well-edited videos, keep up the good work!
Another super nice video of yours! THanks for sharing!
Holy molly! You are so good at this. New sub here!❤❤
Amazing video Luke!! Thanks for this type of 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.
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! 🙌🏼
Great overview, thanks Luke
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!
Man great video! You give us so much motivation to move on!
First video I've seen of yours, but I love it. Immediately liked and subscribed.
🙌🏼
Amazing content! Thank you! Also, thanks for providing links.
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 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🇮🇳
What amazing job!!! I loved it!!!
Impressive! Thanks for all the time and work to make this short packed video happen.
Glad you enjoyed it, Ariel!
loved it , am going to watch all your vids xD
You’re great dude, thanks for your videos!
That is a huge amount of work you have done to make this video. Thank you for this.
Thank you for noticing! 🙌🏼
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!
Thanks Man this is extremely useful! Huge fan
The video was extremely helpful for filling in some gaps for me. Value is off the charts 🌟
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!
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!
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!
Love your videos!! 💙
You are a Genius Luke !!! God bless you !!!
Thanks for the video Luke it's really helpful, can you mention how you clean description column or make a video about it
Wow. The amount of helpful information in this video is staggering. More pleeease!
More to come!
Nice video man gj!
Really cool video!!!!!!!!!!! Keep up the excellent effort
Luke is one of the person in youtube who encourage me to learn Data analytics in coursera ...
Great Video!! Thanks for this type of content ♥
You're so welcome Thilina!
Congratulations, this is undoubtedly one of the best videos on "How I use Python as a Data Analyst"
This my first time to comment but am your great follower. Thanks for everything.
Great video as usual!!! Go further LUKE
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 🙌🏼
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?
Good stuff luke
here before this video blow up, this amount of work is amazing
Amazing video! Keep it up
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!
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.
Love your work bro
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)
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 😢
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!
Thanks Luke for this outstanding informations .
Great video. Thanks!
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?
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!! 🙌🏼
You are that RUclipsr everyone needs for their field. I was “wow”ing on ur content.
Aw thank you! 🙌🏼
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
Awesome video!
Sir, I feel like subscribing to your channel is the proudest subscription of my entire existence in RUclips.
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!
I neither know the meaning of this song nor any word from the language. Yet I might have listed to it more that 2 dozen times now since y’day. Very catchy tune and grater rendering 👏👏👍👌
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!
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.
The most practical analysis i've seen yet
That was a good video. I liked and subscribed 🙂
Heck yeah!
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 😜
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!
Wow amazing Video! I just wanted to learn smth about scraping for class tmrw and ended up in here :D Youre videos are priceless for work - just perfectly explained for everybody! Do you have a Video about youre VS Code Setup?
Yeah! I have a video and a playlist!
@@LukeBarousse Thank you for youre quick response!
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!!