API Data Extraction and Storage Project

Project Description

This project extracts data from a REST API, transforms and cleans it, and stores it in a PostgreSQL database using Python.

Technologies Used

• Python
• Libraries: requests, pandas, psycopg2
• PostgreSQL
• API: RapidAPI

Challenges and Solutions

• Data Quality: Cleaned data by handling missing values and duplicates.

Future Improvements

• Automate data retrieval and insertion with scheduled tasks.

Acknowledgments

Thanks to RapidAPI for providing the API.