pandas连接mysql数据库

# pandas连接mysql数据库 # 1.安装依赖  “UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other # DBAPI2 objects are not tested. Please consider using SQLAlchemy.” conda install sqlalchemy pymysql   # 2.导入类库 from sqlalchemy import create_engine import pandas as pd

# 3.创建数据库连接字符串 user = 'root' password = '123456' host = '127.0.0.1' port = '3306' database = 'lrcore_cloud_xxx' db_url = f'mysql+pymysql://{user}:{password}@{host}:{port}/{database}'

# 4.创建 SQLAlchemy 引擎 engine = create_engine(db_url)

# 5.使用 Pandas 读取数据 df = pd.read_sql_table('user', engine)

print(df)

''' 输出结果    id  name 0   1  jack 1   2  boom 2   3  lucy 3   4  jack 4   5  boom 5   6  lucy

'''