add dataframe to a mysql database in python

main.py
# import required libraries
import pandas as pd
from sqlalchemy import create_engine

# create a Pandas DataFrame
data = {'name': ['John', 'Mike', 'Sara', 'Steve'],
        'age': ['25', '30', '28', '32'],
        'gender': ['Male', 'Male', 'Female', 'Male']}
df = pd.DataFrame(data)

# create a database connection using SQLAlchemy
engine = create_engine('mysql://user:password@host:port/database')

# create a table in the database using pandas DataFrame
df.to_sql('table_name', con=engine, if_exists='replace', index=False, 
               dtype={'name': sqlalchemy.types.VARCHAR(length=100), 
                      'age': sqlalchemy.types.Integer(), 
                      'gender': sqlalchemy.types.VARCHAR(length=10)})

# add data to the MySQL database using to_sql method
df.to_sql('table_name', con=engine, if_exists='append', index=False)
848 chars
22 lines