Dec. 11, 2023, 10:25 a.m. | Kaushik Varanasi

DEV Community dev.to




Load the Pokemon data


Let's load the Pokemon data from the open-source db. We'll need a small standalone Python project for that.


Create a folder called pokemon-python and a file named load_pokemon.py:



import pandas as pd
from sqlalchemy import create_engine
engine = create_engine('postgresql://postgres:password@xxxxx.xxxxx.us-east-2.rds.amazonaws.com:5432/postgres')
df=pd.read_csv('https://raw.githubusercontent.com/veekun/pokedex/master/pokedex/data/csv/pokemon.csv')
df.to_sql('pokemon', engine)



cd pokemon-python



# create a venv
pip install virtualenv
python3 -m …

data east import install pandas password pip pokemon postgres postgresql project python python3 rds small sqlalchemy venv

Software Engineer for AI Training Data (School Specific)

@ G2i Inc | Remote

Software Engineer for AI Training Data (Python)

@ G2i Inc | Remote

Software Engineer for AI Training Data (Tier 2)

@ G2i Inc | Remote

Data Engineer

@ Lemon.io | Remote: Europe, LATAM, Canada, UK, Asia, Oceania

Artificial Intelligence – Bioinformatic Expert

@ University of Texas Medical Branch | Galveston, TX

Lead Developer (AI)

@ Cere Network | San Francisco, US