Data with Dylan
Data with Dylan
  • 95
  • 29 444
Analyzing My YT Stats Using APIs in Python
This video will show you my CZcams analytics through the use of APIs in Python!
👀 Want to learn more technical data science skills and impress your colleagues? Click here: www.youtube.com/@data_with_dylan?sub_confirmation=1
⏰ TIMESTAMPS:
0:00 - Intro
0:06 - What are APIs
0:35 - Showing the Documentation
1:56 - Importing the Libraries
2:24 - Getting the API Key and Channel ID
3:42 - Building the Search URL
10:29 - Looping Through the Search URL
12:57 - Building the Video URL
15:53 - Building the Full Dataframe
23:49 - Outro
❓GET YOUR CZcams API KEY: blog.hubspot.com/website/how-to-get-youtube-api-key
📄 CZcams API DOCUMENTATION: developers.google.com/youtube/v3/docs
đŸ“± SOCIALS:
📖 Medium Data Science Blog: medium.com/@dylanhgs
đŸ’Œ LinkedIn: www.linkedin.com/in/dylan-song/
đŸŽ” TikTok: www.tiktok.com/@dylan_s0ng
#datascience #webscraping #python
zhlédnutí: 70

Video

3 things I wish I knew before I learned how to code
zhlĂ©dnutĂ­ 49Pƙed měsĂ­cem
This video will show you 3 important things to keep in mind as you start your coding journey! 👀 Want to learn more technical data science skills and impress your colleagues? Click here: www.youtube.com/@data_with_dylan?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 0:09 - Don't only rely on consuming 0:58 - Learn through projects 3:18 - Ad break 3:41 - You can't be a complete master 4:55 - Outro...
Web Scraping Brawl Stars Data + Building a Dashboard [Full Project]
zhlĂ©dnutĂ­ 109Pƙed měsĂ­cem
This video is a full project walkthrough where I'll first web scrape data from Brawl Stars using Python and then move on to Power BI to build a dashboard! 👀 Want to learn more technical data science skills and impress your colleagues? Click here: www.youtube.com/@data_with_dylan?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 0:26 - Brawl Planet 1:07 - Retrieving the Two Tables 7:41 - Creating th...
I failed an easy Leetcode problem... [Vlog #1]
zhlĂ©dnutĂ­ 47Pƙed 2 měsĂ­ci
This is my first vlog where I eat lunch and study at the Suzzalo library at UW! 👀 Want to learn more technical data science skills and impress your colleagues? Click here: www.youtube.com/@data_with_dylan?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 0:21 - Ride to Seattle 0:39 - Seattle Arrival 0:47 - Walk to Lunch 0:57 - Lunch 1:40 - Walk to Suzzalo 1:59 - Suzzalo Library Arrival 2:32 - Chang...
How I got into UW Seattle [Essay Timeline + Data Sci Activities]
zhlĂ©dnutĂ­ 471Pƙed 2 měsĂ­ci
This is the first video in my UW playlist and I'll show you the essay timeline and data science activities that I've done to get into UW! 👀 Want to learn more technical data science skills and impress your colleagues? Click here: www.youtube.com/@data_with_dylan?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 1:11 - General Essay Timeline 5:09 - College App Resources 6:44 - Start of Second Half 7...
Top 5 Most Useful Excel Tools for Analysts
zhlĂ©dnutĂ­ 117Pƙed 3 měsĂ­ci
This video will give you my top 5 useful Excel tools that will make the data analysis process much more efficient! 👀 Want to learn more Excel tricks and impress your colleagues? Click here: www.youtube.com/@data_with_dylan?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 0:11 - Flash Fill 0:57 - Function Arguments 3:20 - Data Analysis 5:20 - Quick Analysis 6:02 - Bookmarks 7:20 - Outro đŸ“± SOCIALS: ...
Top 3 Functions in Pandas Every Data Scientist Must Know [Python]
zhlĂ©dnutĂ­ 188Pƙed 4 měsĂ­ci
This video will give you the 3 functions in Pandas that are crucial for analyzing data in Python! 👀 Want to learn more Python tricks and impress your colleagues? Click here: www.youtube.com/@data_with_dylan?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 0:10 - Pandas Function 1 1:28 - Pandas Function 2 2:11 - Pandas Function 3 4:02 - Outro đŸŒ Pandas Installation Guide: pandas.pydata.org/docs/gett...
5 Keyboard Shortcuts Every Python Programmer Should Know
zhlĂ©dnutĂ­ 238Pƙed 5 měsĂ­ci
This video will give you 5 keyboard shortcuts that are very useful in Python Jupyter Notebook, along with a full list of shortcuts at the end! 👀 Want to learn more Python tricks and impress your colleagues? Click here: www.youtube.com/@data_with_dylan?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 0:12 - Creating a New Cell 1:18 - Deleting a Cell 1:49 - Running the Cell 2:20 - Markdown 4:18 - Py...
Do you know these 3 HIDDEN features in Excel?
zhlĂ©dnutĂ­ 168Pƙed 6 měsĂ­ci
This video will show you 3 features in Excel that maybe you never heard about! 👀 Want to learn more Excel tips? Click here: www.youtube.com/@dylan_song?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 0:13 - FEATURE NUMBER 1 2:29 - FEATURE NUMBER 2 4:02 - FEATURE NUMBER 3 5:27 - Outro đŸ“ș INDIVIDUAL VIDEO LINKS for Each Feature: Feature 1 - czcams.com/video/e2xmdrU0jT0/video.html Feature 2 - czcams....
Convert Data from Excel into ADDRESS LABELS in Word
zhlĂ©dnutĂ­ 84Pƙed 6 měsĂ­ci
This video will show you how to produce Avery Address Labels in Word using data from Excel! 👀 Want to learn more? Click here: www.youtube.com/@dylan_song?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 0:26 - Reading the Question 0:59 - Showing the Sample Data in Excel 1:06 - Opening the Blank Word Document 1:10 - Choosing the Avery Label 1:56 - Step by Step Mail Merge Wizard 3:45 - Printing the ...
Selenium Clicker Automation Project [for Beginners!]
zhlĂ©dnutĂ­ 119Pƙed 6 měsĂ­ci
This is a beginner-friendly project walkthrough that will show you how to build an autoclicker using Selenium in Python! 👀 Want to learn more Python tricks and impress your colleagues? Click here: www.youtube.com/@dylan_song?sub_confirmation=1 ⏰ TIMESTAMPS: 0:00 - Intro 0:11 - Importing the Libraries 0:50 - Setting up the Driver 3:07 - Coding the Autoclicker 8:28 - Comparing Your CPS to the Wor...
Build Excel DROPDOWN Lists [Efficient Data Entry]
zhlĂ©dnutĂ­ 145Pƙed 7 měsĂ­ci
Build Excel DROPDOWN Lists [Efficient Data Entry]
Web Scrape ANY SITE in Python [BeautifulSoup Project]
zhlĂ©dnutĂ­ 408Pƙed 8 měsĂ­ci
Web Scrape ANY SITE in Python [BeautifulSoup Project]
Build Simple Bar Charts in Excel from Scratch!
zhlĂ©dnutĂ­ 201Pƙed 8 měsĂ­ci
Build Simple Bar Charts in Excel from Scratch!
Create a TIMELINE SLICER for your Excel Dashboard!
zhlĂ©dnutĂ­ 386Pƙed 9 měsĂ­ci
Create a TIMELINE SLICER for your Excel Dashboard!
Visualize Data with DYNAMIC Maps in Excel [5 Mins]
zhlĂ©dnutĂ­ 221Pƙed 9 měsĂ­ci
Visualize Data with DYNAMIC Maps in Excel [5 Mins]
How to COMBINE Excel Datasets [No VBA Required!]
zhlĂ©dnutĂ­ 164Pƙed 9 měsĂ­ci
How to COMBINE Excel Datasets [No VBA Required!]
How to MERGE Datasets with Python Pandas [4 Types]
zhlĂ©dnutĂ­ 159Pƙed 9 měsĂ­ci
How to MERGE Datasets with Python Pandas [4 Types]
EXPORT Data in Python with ONE LINE of Code [2 Mins!]
zhlĂ©dnutĂ­ 303Pƙed 10 měsĂ­ci
EXPORT Data in Python with ONE LINE of Code [2 Mins!]
Find the Most COMMON Words with Python WordCloud
zhlĂ©dnutĂ­ 281Pƙed 10 měsĂ­ci
Find the Most COMMON Words with Python WordCloud
OPTIMIZE Business Decisions with Excel GOAL SEEK
zhlĂ©dnutĂ­ 104Pƙed 10 měsĂ­ci
OPTIMIZE Business Decisions with Excel GOAL SEEK
AUTOMATE Data Cleaning with Excel Power Query
zhlĂ©dnutĂ­ 1KPƙed 10 měsĂ­ci
AUTOMATE Data Cleaning with Excel Power Query
Import Data from ANY WEBSITE into Excel [3 Mins]
zhlĂ©dnutĂ­ 230Pƙed 10 měsĂ­ci
Import Data from ANY WEBSITE into Excel [3 Mins]
Web Scraping WIKIPEDIA Data Using Pandas [3 Steps]
zhlĂ©dnutĂ­ 2,1KPƙed 11 měsĂ­ci
Web Scraping WIKIPEDIA Data Using Pandas [3 Steps]
Transform BLAND Data Visuals with Plotly [3 Types]
zhlĂ©dnutĂ­ 66Pƙed 11 měsĂ­ci
Transform BLAND Data Visuals with Plotly [3 Types]
Learn Machine Learning with Sklearn: MULTIPLE REGRESSION in Python
zhlĂ©dnutĂ­ 140Pƙed 11 měsĂ­ci
Learn Machine Learning with Sklearn: MULTIPLE REGRESSION in Python
Step-by-Step Guide on Building a DYNAMIC Dashboard Card in Excel
zhlĂ©dnutĂ­ 159Pƙed 11 měsĂ­ci
Step-by-Step Guide on Building a DYNAMIC Dashboard Card in Excel
Data Visualization Taken to a NEXT LEVEL: Dynamic Data Bars in Excel
zhlĂ©dnutĂ­ 96Pƙed rokem
Data Visualization Taken to a NEXT LEVEL: Dynamic Data Bars in Excel
FASTEST Way to Show DESCRIPTIVE STATS in Excel
zhlĂ©dnutĂ­ 256Pƙed rokem
FASTEST Way to Show DESCRIPTIVE STATS in Excel
3 Simple Steps to Perform LINEAR REGRESSION in Excel
zhlĂ©dnutĂ­ 666Pƙed rokem
3 Simple Steps to Perform LINEAR REGRESSION in Excel