Data Collection and Integration
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Data Collection and Integration
This course is part of Data Wrangling with Python Specialization
Included with
Ask Coursera
16 reviews
Recommended experience
16 reviews
Recommended experience
What you'll learn
How to utilize Python and Python packages to collect data from various sources
How to integrate data collected from various sources to a unified dataset for further processing and analysis
Skills you'll gain
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 6 modules in this course
The "Data Collection and Integration" course provides students with comprehensive techniques for gathering data from diverse sources, including files, relational databases, web pages, and APIs. Participants will gain practical experience in collecting and integrating data for further processing and analysis. The course emphasizes the utilization of appropriate tools and packages, such as Pandas, Beautiful Soup, and SQL, to effectively handle real-life datasets and address data integration challenges.
The "Collect Data from Files" week focuses on equipping you with the necessary skills to handle various file formats, such as txt, csv, json, xml, html, and more, for effective data collection. You will learn how to read, parse, and extract relevant data from different file types, enabling you to gather valuable information from diverse sources.
What's included
2 videos4 readings1 assignment1 discussion prompt
2 videos•Total 16 minutes
- Course Overview•2 minutes
- Collect Data From Files•14 minutes
4 readings•Total 101 minutes
- Course Updates and Accessibility Support•1 minute
- Assessment Strategy•30 minutes
- Activity Strategy•10 minutes
- Collect Data From Files Demo•60 minutes
1 assignment•Total 30 minutes
- Collect Data From Files Quiz•30 minutes
1 discussion prompt•Total 120 minutes
- Collect Data from Files Exploration Exercise•120 minutes
The "Collect Data from Web" week focuses on empowering you with the skills to extract data from various webpage formats using Python libraries like requests and Beautiful Soup. You will learn how to access web pages, retrieve HTML content, and parse the data to collect relevant information effectively.
What's included
1 video2 readings1 assignment1 discussion prompt
1 video•Total 13 minutes
- Collect Data From Web•13 minutes
2 readings•Total 180 minutes
- Collect Data From Web Demo•60 minutes
- Collect Data From Web Case Study•120 minutes
1 assignment•Total 30 minutes
- Collect Data From Web Quiz•30 minutes
1 discussion prompt•Total 120 minutes
- Collect Data from Web Exploration Exercise•120 minutes
The "Collect Data from Database" week focuses on equipping you with the skills to interact with various SQL-like databases using Python packages. You will learn how to connect to databases, execute queries, and retrieve data from different database systems, enabling you to collect and utilize data efficiently.
What's included
1 video2 readings1 assignment1 discussion prompt
1 video•Total 8 minutes
- Collect Data From Database•8 minutes
2 readings•Total 180 minutes
- Collect Data From Database Demo•60 minutes
- Collect Data From Databases Case Study•120 minutes
1 assignment•Total 30 minutes
- Collect Data From Database Quiz•30 minutes
1 discussion prompt•Total 120 minutes
- Collect Data from Databases Exploration Exercise•120 minutes
The "Collect Data from APIs" week focuses on enabling you to interact with various websites that provide Application Programming Interfaces (APIs). You will learn how to access APIs, retrieve data in structured formats (e.g., JSON or XML), and utilize Python to process and extract valuable information from API responses.
What's included
1 video1 reading1 assignment1 discussion prompt
1 video•Total 6 minutes
- Collect Data From APIs•6 minutes
1 reading•Total 60 minutes
- Collect Data From APIs Demo•60 minutes
1 assignment•Total 30 minutes
- Collect Data From APIs Quiz•30 minutes
1 discussion prompt•Total 120 minutes
- Collect Data from APIs Exploration Exercise•120 minutes
The "Data Integration" week focuses on the techniques and methodologies for integrating data collected from various sources. You will learn how to combine and merge datasets, handle data inconsistencies, and create a unified dataset for further analysis and decision-making.
What's included
1 video2 readings1 assignment1 discussion prompt
1 video•Total 15 minutes
- Data Integration•15 minutes
2 readings•Total 180 minutes
- Data Integration Demo•60 minutes
- Data Integration Case Study•120 minutes
1 assignment•Total 30 minutes
- Data Integration Quiz•30 minutes
1 discussion prompt•Total 120 minutes
- Data Integration Exploration Exercise•120 minutes
The "Case Study" week offers you the opportunity to apply the knowledge you have learned throughout the course in a practical and comprehensive case study. You will engage in data collection from various sources, including files, SQL-like databases, and web APIs, and then integrate the collected data into a unified dataset for further analysis. This week serves as a culminating activity, allowing you to demonstrate your skills in data collection, integration, and preparation for analysis.
What's included
1 reading1 assignment
1 reading•Total 120 minutes
- Case Study Assignment•120 minutes
1 assignment•Total 60 minutes
- Self Reflection•60 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Explore more from Data Analysis
Course
- Status: Free Trial
Course
- Status: Free TrialU
University of Michigan
Course
- Status: PreviewN
Northeastern University
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
82.35%
- 4 stars
0%
- 3 stars
11.76%
- 2 stars
0%
- 1 star
5.88%
Showing 3 of 16
Reviewed on Dec 6, 2023
Great course, and easy to follow along to learn the material. Great exercises and practice.
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,