How to use pandas to connect to mysql database in python

Python how to use pandas to connect to mysql database, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can get something.

Normally, pandas needs to use both pymysql and sqlalchemy libraries to connect to mysql databases, so you need to install these two libraries first.

Python-m pip install sqlalchemy

Python-m pip install pymysql

After installation, connect.

> import pandas as pd

> import numpy as np

> from sqlalchemy import create_engine

Engine tells pandas the database type, user name, password and other information of the connection

It is usually in the following format

MySQL user name, password, IP address, port, database name''

> engine=create_engine ('mysql+pymysql://root:123abc@127.0.0.1:3306/mysql')

> sql='select * from user'

> df = pd.read_sql_query (sql, engine)

> df

Host User... Password_require_current User_attributes

0 localhost mysql.infoschema... None None

1 localhost mysql.session... None None

2 localhost mysql.sys... None None

3 localhost root... None None

[4 rows x 51 columns]

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.