API ETL Pipeline

• Fetch data from public APIs
• Handle missing values
• Normalize nested JSON
• Generate summary statistics
• Export the processed CSV for any other analytics projects

Follow these steps in order. Each one builds on the previous.

1. Step 1

   Install required modules via pip

2. Step 2

   Find a public API key for this project

3. Step 3

   Fetch the data from the API using requests

4. Step 4

   Validate the response you just fetched from the API

5. Step 5

   Normalize the nested JSON data by flattening it

6. Step 6

   Use the fetched data to build a pandas dataframe

7. Step 7

   Handle missing values or duplicate values

8. Step 8

   Export the cleaned dataset to CSV format

9. Step 9

   Generate a summary for the newly created CSV dataset

10. Step 10

    Test the file with at least two different public APIs

• pandas docs
• requests docs
• JSON handling in Python
• REST API tutorial
• Real Python API guide