UPDATE: The Python script I wrote for this project can be found here: github.com/sdw-online/top_uk_youtubers_2024/blob/main/assets/scripts/python/extract_data_from_youtube_api.py
Thank you boss, please can we get the extracted csv file from the python script because i don't know anything about python hence i don't know what to do with the script. So please the extracted csv file would be appreciated so that i can be on the same page with you on the SQL cleaning
Thank you for this video! Most youtubers just tell you what to do, but you highlight each step of the thought process! Would love to see more videos like this! Learned a lot from this!
I would like to thank you and tell you how grateful I am for your diligent and detailed work. We're all looking forward to an another end-to-end project … With a PYTHON tutorial
Wow, I watched this video when it was 2days old with my main channel. Now i came back to start practicalizing it. the growth was great. This is great. I will be here until i grasp it. maybe me alone will give this 100views lol
i finished the Google Data Analytics course 1 month ago, unfortunately stuck on the projects and how to make them from zero, this video bring most of what I've learned together, i hope to see more like this, keep going we are looking for your advices and more projects, Thanks A lot
I guess, I am the only one who didn't come here from TikTok. So my friend TH-cam algorithm has started doing its magic. But, just make some changes to your video banner to get more attention. And all the best.🤜
Wow, this course is so great and i have learned a lot from it as a beginner aspiring data analysis. This is my first time commenting on any TH-cam channel but i did here because am so excited with your steps of this project its exceptional.
Thanks! Here's the Python script I wrote for this: github.com/sdw-online/top_uk_youtubers_2024/blob/main/assets/scripts/python/extract_data_from_youtube_api.py
Thanks a lot Stephen. You're my life saver, been scrolling the videos that teach everything step by step. here we go!! the great Stephen video is here. Thanks
Thanks a lot Stephen. You're my life saver, been scrolling the videos that teach everything step by step. here we go!! the great Stephen video is here. Thanks
Doing the Lord's work fr. Many tutorials don't really demonstrate how the portfolio should be structured and how to implement the analysis and results in the right format. Great video
Hey Steve!!!! I totally loved how you took your time to breakdown step by step the whole project. All I can say is at last I've found a mentor to start my career in data.
You you explained what my instructor was teaching me for 3 months in one day. Dude! keep up the good work. We need more people like you to take us in not show us how to get in. I am glad to be a subscriber. Please do more exercises. Like if you can create a zoom link or Skype link where we all can be there live and shadow each other. Also, do a brush up on what interview question that will be asked when applying for a Data analyst jobThat will be awesome 👌 😊
Thank you for your kind words! And don't worry, I'm coming up with everything you've mentioned behind the scenes, - I'll be announcing something you will find interesting very soon, so stay tuned ✅
@@sdw-online Thank you. Please can yo do this dataset or any dataset with Excel - postgreSQL- PowerBi. just like how you did this one. I just completed an data course with my instructor and I am a little shaky with postgreSQL. Thanks. one of these day I visit London to shake your hand lol
oh my god, first project video that explains well and shows indepth work, appreciate it and great work, keep uploading like this and also if you can touch more part like data modelling, analysing python and presenting it , would be great help. thank you so much.
Is this why TH-cam doesn't want me to download this video. The pauses the video from their own end and I can't download it to watch for later. Meanwhile I can download any other video but this
Found on TikTok and subscribed to your TH-cam channel. Thank you for sharing. I followed along and created the Power BI dashboard. I especially appreciated the data cleaning and validation on SQL and learned so much. The analysis you did on Excel was amazing!! Thank you. I hope to see more of your contents and learn more!
Thank you sincerely for putting so much effort into this excellent project! I was looking for a way to use Power BI in the context of an end-to-end project with SQL. This is perfect! :)
Hi Stephen I just wanted you to know that I am grateful for this video. Though I wish I could download to watch later. So I have to manage learning directly.
You have no idea how I appreciate this. Thank you very much. DO you mind creating a video for the RESTAPI to SQLServer or MySQL. I know you did it but as text. I would really appreciate a similiar video. You are so good in explaining complex concept in an easier manner. Also consider Udemy courses, I wouldnt mind subscribing for such content.
I know, so many people were badgering me for weeks for it, had to deliver - hope you like it! Let me know if you need any resources to help you land a data analyst role too!
Such a gentleman and a humble introduction 👏 kudos to you man , ty for the valuable content and knowledge sharing ( it pushed me to open the video to just hit the like button for such a genuine introduction in the start ) Love from INDIA 🙏🏽
Hi Steven you have done well for pip like us who are new to the data field, i have been searching for videos like this and i must thank you for this awsome video. i ave been on your video for weeks trying to understand every details. thank you once again and stay blessed.
Hi Stephen, thanks for this great job, I have been looking for videos like this as a beginner in this field, please i have got a question on how to load our excel data into Mysql workbench after creating the TH-cam table. thanks for your time
22:10 how do you connect servers so effortlessly? i got stuck here for the longest time and ive scoured all over youtube and the rest of the internet just to find a solution. it appears yall have your server names autofilled and/or autodetected by the SQL Server but not in my case. it's just blank for me. i tried manually inputting it by tracing the name of my pc but it still doesnt work. I NEED HELP :(((
Thanks Stephen. Trying to follow along but I can't seem to find the dataset using the Python script you menbntioned. Dataset from kaggle doesn't have some required column.
Hi, I'm a bit confused around the 27:09 mark where you are cleaning the data and selecting the columns total_subscribers etc, I don't seem to have that in my data set, is this something you added yourself? Mine is only showing 9 columns whereas yours is showing 13.
The data set that I downloaded from Kaggle is not complete, there is no “total_video” column. Please how do I deal with this challenge because right now I am stuck and can’t continue working on the project. Thanks
@@victorwilliam6480 the dataset with the total_video column is the one I created using Python - Check the assets/dataset directory of the GitHub repository I saved everything to for that
Thank you for the video, can you share where to get unguided projects dataset, and some dataset website to practice for power BI. Thanks in advance :).
I was wondering about Data Analyst vs Data Scientist... I started learning SQL and then I heard about Exploratory Data Analysis, I have jumped to it. Then I realized that this part of Data Science.
Great Video!! Is there any other tools or software you have used where you can follow step by step into analysing data, I currently have extracted data from Yahoo Finance and was wondering about creating a portfolio to show future employers.
Thanks! I'm going to create more step-by-step analysis videos like this one using different tools and software that will help you build your portfolio, so stay tuned for that!
hey great video with good highlights thanks alot.✌ please keep up with the projects content. Also i was wondering can i get your help or guidence on to building a inventory database management that i trying to do. CAN YOU PLEASE HELP OUT WITH THE PYTHON STRIP YOU USED TO EXTRACT THE DATA. ALL THE BEST MAN 🤜
UPDATE:
The Python script I wrote for this project can be found here:
github.com/sdw-online/top_uk_youtubers_2024/blob/main/assets/scripts/python/extract_data_from_youtube_api.py
Thank you boss, please can we get the extracted csv file from the python script because i don't know anything about python hence i don't know what to do with the script.
So please the extracted csv file would be appreciated so that i can be on the same page with you on the SQL cleaning
Thanks, bro
how do I extract this data without knowing python? please help
thank you very much but how do i use this script?
How did you save the dashboard as a pmg image
Thank you for this video! Most youtubers just tell you what to do, but you highlight each step of the thought process! Would love to see more videos like this! Learned a lot from this!
Thanks!
And no problem, more projects like this coming your way!
This is one of the organized videos ever out of all data project videos on youtube
I would like to thank you and tell you how grateful I am for your diligent and detailed work.
We're all looking forward to an another end-to-end project …
With a PYTHON tutorial
Thanks! And no problem - stay tuned for more projects like this!
Wow, I watched this video when it was 2days old with my main channel. Now i came back to start practicalizing it. the growth was great. This is great. I will be here until i grasp it. maybe me alone will give this 100views lol
love that - appreciate you!
i finished the Google Data Analytics course 1 month ago, unfortunately stuck on the projects and how to make them from zero, this video bring most of what I've learned together, i hope to see more like this, keep going we are looking for your advices and more projects, Thanks A lot
I guess, I am the only one who didn't come here from TikTok. So my friend TH-cam algorithm has started doing its magic. But, just make some changes to your video banner to get more attention. And all the best.🤜
great to hear - and appreciate the feedback!
Hahaha. I did too
Hehehehehehr, same here
From TikTok ❤
Same here
Wow, this course is so great and i have learned a lot from it as a beginner aspiring data analysis.
This is my first time commenting on any TH-cam channel but i did here because am so excited with your steps of this project its exceptional.
AWESOME DUDE! Please add the Python script to your GitHub repo where everyone is screaming about, please.
Thanks! Here's the Python script I wrote for this:
github.com/sdw-online/top_uk_youtubers_2024/blob/main/assets/scripts/python/extract_data_from_youtube_api.py
Thanks a lot Stephen. You're my life saver, been scrolling the videos that teach everything step by step. here we go!! the great Stephen video is here. Thanks
Thanks a lot Stephen. You're my life saver, been scrolling the videos that teach everything step by step. here we go!! the great Stephen video is here. Thanks
Stephen, may i know when to use the Star schema etc.
@@HakimMatnang thanks for the kind words Hakim! And I'm going to create videos that answer this in depth, so watch out for it!
@@sdw-online Nice one!. Can't wait for it =)
Doing the Lord's work fr. Many tutorials don't really demonstrate how the portfolio should be structured and how to implement the analysis and results in the right format. Great video
Thank you!
Hey Steve!!!! I totally loved how you took your time to breakdown step by step the whole project. All I can say is at last I've found a mentor to start my career in data.
a good mentor
I Must confess Stephen this is an embedded encyclopaedia .....that was great man
appreciate your kind words! ✨
Came from tiktoks. Thanks for this!
Same here 👍 so much love for him
Awesome, hope you enjoy it!
You you explained what my instructor was teaching me for 3 months in one day. Dude! keep up the good work. We need more people like you to take us in not show us how to get in. I am glad to be a subscriber. Please do more exercises. Like if you can create a zoom link or Skype link where we all can be there live and shadow each other. Also, do a brush up on what interview question that will be asked when applying for a Data analyst jobThat will be awesome 👌 😊
Thank you for your kind words!
And don't worry, I'm coming up with everything you've mentioned behind the scenes, -
I'll be announcing something you will find interesting very soon, so stay tuned ✅
@@sdw-online Thank you. Please can yo do this dataset or any dataset with Excel - postgreSQL- PowerBi. just like how you did this one. I just completed an data course with my instructor and I am a little shaky with postgreSQL. Thanks. one of these day I visit London to shake your hand lol
I sent you a message on tiktok only to see this directions to this video. I just want to say thank you. You are amazing! This is more than enough!❤
Thank you Funmi!
oh my god, first project video that explains well and shows indepth work, appreciate it and great work, keep uploading like this and also if you can touch more part like data modelling, analysing python and presenting it , would be great help. thank you so much.
Is this why TH-cam doesn't want me to download this video. The pauses the video from their own end and I can't download it to watch for later. Meanwhile I can download any other video but this
Found on TikTok and subscribed to your TH-cam channel. Thank you for sharing. I followed along and created the Power BI dashboard. I especially appreciated the data cleaning and validation on SQL and learned so much. The analysis you did on Excel was amazing!! Thank you. I hope to see more of your contents and learn more!
Appreciate your comment!
I'm going to drop more in this format, so hopefully you like them too!
You're a natural teacher.
Thank you!
This was the first tutorial I managed to complete without getting stuck. Thank you for this amazing video
Thank you for the video, came here from Tiktok too. The Python tutorial to fetch the data from You tube would be really nice .
You're welcome, here you go:
github.com/sdw-online/top_uk_youtubers_2024/blob/main/assets/scripts/python/extract_data_from_youtube_api.py
Thank you sincerely for putting so much effort into this excellent project! I was looking for a way to use Power BI in the context of an end-to-end project with SQL. This is perfect! :)
Well-done SDW. I can imagine the efforts put in this
Appreciate it Idris!
Yeah it definitely took a while to make it, but hopefully you enjoy it!
Hi Stephen I just wanted you to know that I am grateful for this video. Though I wish I could download to watch later. So I have to manage learning directly.
Done and dusted !Thanks @stephen remain Blessed
Where have you been all my life?
Well done Stephen!
Thanks! And I'm here to stay now!
You have no idea how I appreciate this. Thank you very much. DO you mind creating a video for the RESTAPI to SQLServer or MySQL. I know you did it but as text. I would really appreciate a similiar video. You are so good in explaining complex concept in an easier manner. Also consider Udemy courses, I wouldnt mind subscribing for such content.
thank!
And sure, I'll create a video just for you on this and post it on here ✅-
What courses would you like to see from me?
hello Stephen, was waiting for this video to drop. Currently trying to land a role as Data Analyst. Great job with the video!
I know, so many people were badgering me for weeks for it, had to deliver - hope you like it!
Let me know if you need any resources to help you land a data analyst role too!
more guided projects like this please! 🙏
No problem ✅
Such a gentleman and a humble introduction 👏 kudos to you man , ty for the valuable content and knowledge sharing ( it pushed me to open the video to just hit the like button for such a genuine introduction in the start )
Love from INDIA 🙏🏽
From Tiktok....thnx
You're welcome
Pls we need more such project videos it's very beneficial for data engineers❤. Pls keep uploading more such useful projects😀
Strolled in from TikTok. Thanks Stephen.
You're welcome 🙏🏾
Amazing! Your contents are trustworthy.
Appreciate it!
Really enjoyed this video! Broke down every step and that is helpful since I am working to become a data analyst
Glad you liked it!
Thank you for the content of this video, nice and straightforward, and the knowledge drawn and delivery was top-notch.
Thank you!
Thank you for this resource Stephen. Very detailed and easy to understand. Looking forward to seeing/learning more
Thank you man, I’d gladly pay if you release a course of say 3-5 end to end projects
Thanks!
Stay tuned, I'll release some resources you'd find exciting not so far from now, so stay tuned ✅
Coming off from Ticktock,glad to have discovered your Chanel videos.
Thank you.
You really helped me grasp the process of analytics man… thanks for your amazing work
Please do the Python way aswell, on cleaning the data, creating visuals within Python and doing stats, will really be helpful
Agreed!
No problem, will do ✅
@@sdw-online yes please do it
Hi Stephen, Great video....Need more end to end projects..
Thank you, I when from what an I looking at to knocking out a project in a few hours. Awesome video.
this is helping with my IT.
thanks for sharing.
Really cool i came to check out the video from tiktok.
Hi Steven you have done well for pip like us who are new to the data field, i have been searching for videos like this and i must thank you for this awsome video. i ave been on your video for weeks trying to understand every details. thank you once again and stay blessed.
Thanks for amazing project
From Tiktok. Thanks for sharing
you're welcome✨
From Tiktok thanks
You're welcome
Great video, python tutorial for this script will be very helpful !
Thanks! Here it is:
github.com/sdw-online/top_uk_youtubers_2024/blob/main/assets/scripts/python/extract_data_from_youtube_api.py
Started learning from today hope i will boost my knowledge.
hopefully you learn something new from this video!
From TikTok. Thank you
you're welcome
From tiktok. Thanks Stephen.
You're welcome Mohamed!
Love from India ❤ thank you sir.......for this video please do some more this kind of educational videos. Its help us a lot 😊
Thanks - and no problem ✅
This is exactly what i have been looking for...Thank you so much for this great deal...I really appreciate
you're welcome!
Thanks 🙏🏼 came from TikTok ☺️
you're welcome✨
You are very professional and your advices are the best ones. Thank's Bro
Thanks Stephen!
It was very informative.
Need more of these!!!
More coming your way ✅
We are here 😊
This is so cool. Thanks so much for sharing. Building some projects for my portfolio... I will definitely connect 👍❤
Excellent, and share your project with me when you're done Wilfred ✅
@@sdw-online Will definitely do.
Really love this. Well detailed
Appreciate it Ifeoma
oh wow, this is amazing! thank you!
Well done sir, you inspired me to take on a project of mine
You're welcome - and that's great to hear!
Phenomenal, thank you so much!
This is amazing. well done bru
Appreciate it !
This is superb bro. Thank you
Excited for this pal
super!
One of your big fan from TikTok 😊
super, hope you learn something from this video Andrew!
Thank you, sir, I came from tick-tock to TH-cam.
This is so cool !! So appropriate 🎉❤
hope you enjoy it!!
Thanks STEV for this great video. I'll need the python script used to extract the cleaned data use need for the table. Thanks again
Thanks David! Here it is:
github.com/sdw-online/top_uk_youtubers_2024/blob/main/assets/scripts/python/extract_data_from_youtube_api.py
Amazing job.
Thank you
Thank you so much. This is superb
Thank u for sharing this great insight on data. I am unable to get the link to the dataset so as to practice alongside as I follow the tutorial.
Bravo
from tiktok here
🫡
Hi Stephen, thanks for this great job, I have been looking for videos like this as a beginner in this field, please i have got a question on how to load our excel data into Mysql workbench after creating the TH-cam table. thanks for your time
Appreciate the compliment!
And try this guide: blog.n8n.io/import-csv-into-mysql/
22:10 how do you connect servers so effortlessly?
i got stuck here for the longest time and ive scoured all over youtube and the rest of the internet just to find a solution. it appears yall have your server names autofilled and/or autodetected by the SQL Server but not in my case. it's just blank for me. i tried manually inputting it by tracing the name of my pc but it still doesnt work.
I NEED HELP :(((
Thanks Stephen. Trying to follow along but I can't seem to find the dataset using the Python script you menbntioned. Dataset from kaggle doesn't have some required column.
You're welcome!
Have a look at the GitHub repository here: github.com/sdw-online/top_uk_youtubers_2024/tree/main/assets/datasets
@@sdw-online thanks a lot.
Hi, I'm a bit confused around the 27:09 mark where you are cleaning the data and selecting the columns total_subscribers etc, I don't seem to have that in my data set, is this something you added yourself? Mine is only showing 9 columns whereas yours is showing 13.
At the beginning of the video he added more data that he got himself
Came from tiktok😂
Thanks a lot man
thanks a lot !!! good job
Appreciate it!
i really wish i could get a one on one tutorials with you
Thank you !
You're welcome!
Thank you
You're welcome
Thank you very much. Can you make a video with collect api data
sure, I'll work on it for you
Thanks for this insightful project ❤, can you please make the python script available.
You're welcome, and sure will do
The data set that I downloaded from Kaggle is not complete, there is no “total_video” column. Please how do I deal with this challenge because right now I am stuck and can’t continue working on the project. Thanks
@@victorwilliam6480 the dataset with the total_video column is the one I created using Python -
Check the assets/dataset directory of the GitHub repository I saved everything to for that
Is it possible you can show us how to do that with python too ….. just asking for a favour 😊. Thank you for all your good work .
please commence with the python tutorial, especially for the TH-cam API, that will be very helpful.
Thank you for the video, can you share where to get unguided projects dataset, and some dataset website to practice for power BI. Thanks in advance :).
I was wondering about Data Analyst vs Data Scientist...
I started learning SQL and then I heard about Exploratory Data Analysis, I have jumped to it. Then I realized that this part of Data Science.
That's right!
Hello!
Thank you for the video. Is there any way you could make a more in depth video about the python script?
Hey, awesome video! I’m a finance student going into third year. Do you have any tutorials on any finance projects?
Please share the python tutorial to pull the data using the youtube API
I'll create a Python tutorial on this soon
Great Video!! Is there any other tools or software you have used where you can follow step by step into analysing data, I currently have extracted data from Yahoo Finance and was wondering about creating a portfolio to show future employers.
Thanks!
I'm going to create more step-by-step analysis videos like this one using different tools and software that will help you build your portfolio, so stay tuned for that!
Stéphane please put the updated version of this data Excel, because we don't know how we can run the python script... Please bro ?!
hey great video with good highlights thanks alot.✌ please keep up with the projects content. Also i was wondering can i get your help or guidence on to building a inventory database management that i trying to do. CAN YOU PLEASE HELP OUT WITH THE PYTHON STRIP YOU USED TO EXTRACT THE DATA. ALL THE BEST MAN
🤜
great vid, but i still believe that you should have showed us the part of how you extracted the data from the API