Skip to content

Data about statistics of more then 300 videos get from Youtube API, saved as a pandas dataframe, visualized and then loaded to AWS PostgreSQL database

Notifications You must be signed in to change notification settings

NataliiaMatsiuk/Grabbing-data-from-youtube-API-putting-it-in-the-pandas-dataframe-loading-in-the-AWS-database

Repository files navigation

Grabbing data from youtube API, putting it in the pandas dataframe, loading in the AWS database

  1. Working with Youtube's API to collect video statistics from a channel
  2. Saving video statistics as a pandas dataframe
  3. Add dummies-variables
  4. Visualizing data with matplotlib.pyplot and seaborn
  5. Saving data in csv-file
  6. Connection with AWS PostgreSQL database
  7. Checking if video exists. If it exists, upload data, if not, insert a new video into the databse

Inspired by https://www.youtube.com/watch?v=c4Af2FcgamA&t=13s&ab_channel=StrataScratch

About

Data about statistics of more then 300 videos get from Youtube API, saved as a pandas dataframe, visualized and then loaded to AWS PostgreSQL database

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published