This project demonstrates the extraction, transformation, and loading (ETL) process of data using Python and MySQL. The data is extracted from the ncbi website.
Extraction: Data is scraped from the ncbi website using the pandas library. Transformation: The data is cleaned and transformed, including lowering column names and handling missing values. Loading: The cleaned data is loaded into a MySQL database.