In this course the students will get to know how to scrape data from the API of a website (if available). We start with the fundamentals and the beginner level project. After that, two different projects will be covered, followed by the advanced project. After scraping data of each project, the results will be stored inside an Excel file. Within the advanced level project we will create two different datasets with 5000 results each. The goal is to merge both Dataframes (total: 10000 results), save it in Excel and output the data in the PostgreSQL database and run SQL commands on our own data.
🎯 Project & Part #1 - Beginner Level
🎯 Project & Part #2 - Intermediate Level
🎯 Project & Part #3 - Infinite Scroll Website (Intermediate Level)
🎯 Project & Part #4 - Advanced Level
_______________________________________________________________________________________________
⏰ TIME STAMPS ⏰
00:00 Intro + Course Overview
04:15 Package Installations
09:15 Fundamentals of API Scraping and Beginner Level Project
14:48 Overview of the available Data
22:00 Create JSON-Object
29:08 Extract necessary Data (Title, Subtitle, Year,...)
46:42 Output Data in Pandas Dataframe
51:23 Store results in Excel
_______________________________________________________________________________________________
✖️ E-Mail✖️
✔️ schlee-alexander@gmx.net
✖️ Linked In✖️
✖️ INSTAGRAM ✖️
✖️ UDEMY COURSES ✖️
✖️ GITHUB ✖️