Move data to a Database with Python

Data and code examples to accompany tutorial series on moving data to a database with Python.

This repository contains 3 different ways to take data from an external source, a CSV file, and put its contents into a database using Python:

• Move data to a Database with Python: Pure Python
• Move data to a Database with Python: SQLAlchemy
• Move data to a Database with Python: Pandas

The data used in this repository comes from the New York City Airbnb Open Data from Kaggle's public dataset repository.

Usage:

Clone or download the repository using git:

git clone https://github.com/andrewvillazon/move-data-to-a-db-python.git

(Optional but recommended) create a virtual environment and use pip to install the libraries in requirements.txt

pip install -r requirements.txt

Run each script as required:

python <filename>.py