To add a Pandas DataFrame to a MySQL database in Python, you can use the to_sql
method of the Pandas DataFrame.
The following steps are required:
to_sql
method, passing the table name and connection object, to add data to the MySQL databaseHere's the sample code for adding a Pandas DataFrame to a MySQL database:
main.py848 chars22 lines
In the above code, replace the MySQL database credentials with your own. The if_exists
parameter in to_sql
method specifies what action should be taken if the table already exists in the database. If set to replace
, it will overwrite the existing table, otherwise, it will append the data to the table.
gistlibby LogSnag