Mid_Project_Egyptian_youtube-channels-DeepAnalysis

ABOUT PROJECT & INTRO

it’s Mid Project for Epsilon AI Diploma i Make a Deep Analysis Project to Scrape YouTube data using YouTube Data API. ,
I extract the data and then load this data into a Python Pandas DataFrame and then Analyze this data.
Finally, we build simple visualization from this data using the Python Seaborn and ploty library.

Introduction

Hello ! My name is Mohamed Eisa just call me (0xnrous), this is my second public notebook Deep Analysis

I'm planning to go through feature (question) by feature and take closer look those features.
So it's gonna take a while to finish this notebook with all features involved.
I'm planning to update it regulary whenever I have free time.
I'll answer each important question first and give a summary in the Final section.

English is not my native language, so sorry for gramatical errors or similar.

This Data is Genterated from YouTube API in[ 06/08/2023 ]so every video will added to channels we show new result

Questions

Before performing EDA, we should have a clear objective. So we can make the right questions and the right visualizations.

• [Q1: What is Title of Video that have highst Views ?]
• [Q2: What is Title of Video that have lowest View ?]
• [Q3: What is Top videos for number of Comments, Likes and Views for Each Feature ?]
• [Q4: What is Lowest videos for number of Comments, Likes and Views for Each Feature ?]
• [Q5: What are Comparison between channel's growth metrics ?]
• [Q6: Which Year of (channel_name) is Viwed Most ? ]
• [Q7: Which Year of (channel_name) is Liked Most ? ]
• [Q8: Which Year of (channel_name) is Comments Most ? ]
• [Q9: Which Montha in 2023 of (channel_name) is Viwed Most ? ]
• [Q10: Which Montha in 2023 of (channel_name) is Liked Most ? ]
• [Q11: Which Montha in 2023 of (channel_name) is Comments Most ? ]
• [Q12: calculate the estimated income per Views video ?]
• [Q13: calculate the estimated income per Views video ?]
• [Q14: What is minumim avgerage revegue of (Channel_name)?]
• [Q15: What is Maximun avgerage revegue of (Channel_name)?]
• [Q16: There are any relationship between Anual Income, Years ? ]

Link I used in Generating API and in Scraping :

Link to create YouTube API Key: https://console.cloud.google.com/
Link to Google YouTube Data API documentation: https://developers.google.com/youtube/v3
Link to json Formater to beautifying the JSON data so that it is easy to read : https://jsonformatter.curiousconcept.com/#

Link I for Streamlit: https://egyptian-youtube-channels-deepanalysiswith-api-scrapping-mmjmk.streamlit.app/
To open link in new tab just do a CTRL+click (on Windows and Linux) or CMD+click (on MacOS) on the link and with open streamlit

CONCLUSION FOR DROOS ONLINE CHANNEL 📕 (Insights):

How to Increase video CTR ، Interaction and Subscription Ratio :

- Use more action verbs.

- Best CTR titles used in the channel are “تعلم ”, "وصايا”, “مذاكرة ، “نصائح ” , “ اسهل” ,“شرح”, “ فقط” , “ اقل ” ، “كيف ” related to most of top 10 videos of views , likes and Comments

- Some Words to avoid to used in Channel are “التحميل” ، “ ادوات” “مشكلة”

- Try to make a clean thumbnail with text color light (white,yellow,skyblue) over bloded colors because it get good clicked on

- Avoid low CTR titles that are about: lives and Q&A

- Avoid color red in text over dark.

- Don’t put multiple objects that saturate the thumbnail.

- Don’t making Videos about tut for Windows Programm like IDM or any thing related

Using emojis is almost scarce. One or two can be more attractive that only plain text.

> the most advice i will tell to Ahmed Abozeid from this Analysis is to making Learning videos with pop learning and Trending learning Methods For study Techniques and also English Tut to attracting People to get more views and Subscribes