Web Scraping APIs for Data Science 2021 | PostgreSQL+Excel
From Beginner to Advanced | 4 Hands-On Projects
Updated on Sep, 2023
Language - English
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 wach project, the results will be stored inside an Excel file. Within the advanced level project we will create two dofferent 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.
The requirement for this course is basic knowledge of Python Programming. Since we will not cover very difficult Python topics you do not have to be a professional. The most important characteristic is that you are curious about Web Scraping and Data Mining. You should be ready to invest time in gaining the knowledge which is taught in this course.
After this course you will have the knowledge and the experience to scrape your own data and create your own dataset. With the help of the course resources you will always have documents you can refer to. If you have a question or if a concept just does not make sense to you, you can ask your questions anytime inside the Q&A - Forum. Either the instructor or other students will answer your question. Thanks to the community you will never have the feeling to learn alone by yourself.
Disclaimer : I teach web scraping as a tutor for educational purposes. That's it.
The first rule of scraping the web is: do not harm a certain website. The second rule of web crawling is: do NOT harm a certain website.
What will you learn in this course:
create your own dataset
output data in Excel
output your dataframe in PostgreSQL
run SQL commands on your dataframe
What are the prerequisites for this course?
basic understanding of Python programming
Check out the detailed breakdown of what’s inside the course
- Course Overview & Introduction 06:00 06:00
Fundamentals & Project # 1 - Beginner Level
Project # 2 - Intermediate Level
Project # 3 - BONUS SECTION -Infinite Scroll Website - Intermediate Level
Project #4 - Advanced Level Project + PostgreSQL
Hi Everyone, my name is Alex and I know that a lot of Programming-Topics can be very confusing and overwhelming. My Goal is to share my knowledge in a very simple way. I'm focussing on Python, Selenium and the whole Web Scraping Process. Especially for my own Data Science and Machine Learning Projects, I need to understand the concepts behind Web Scraping and I want to share it with my students.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now