pandas和mysql数据库连接

pip install mysql-connector-python

import pandas as pd
import mysql.connector

# 创建数据库连接
conn = mysql.connector.connect(
  host="数据库主机名",
  user="用户名",
  passwd="密码",
  database="数据库名"
)

# 创建游标对象
cursor = conn.cursor()

# 执行SQL查询语句
cursor.execute("SELECT * FROM 表名")

# 获取查询结果
result = cursor.fetchall()

# 将查询结果转为DataFrame对象
df = pd.DataFrame(result, columns=['列名1', '列名2', ...])

# 关闭游标对象和数据库连接
cursor.close()
conn.close()