如何将mysql查询转换为dataframe

pip install pandas
pip install pymysql

import pandas as pd
import pymysql

connection = pymysql.connect(host='localhost', user='username', password='password', db='database_name')

query = "SELECT * FROM table_name"
cursor = connection.cursor()
cursor.execute(query)

result = cursor.fetchall()

df = pd.DataFrame(result)

cursor.close()
connection.close()

import pandas as pd
import pymysql

# 连接到MySQL数据库
connection = pymysql.connect(host='localhost', user='username', password='password', db='database_name')

# 执行查询语句
query = "SELECT * FROM table_name"
cursor = connection.cursor()
cursor.execute(query)

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

# 将结果转换为DataFrame
df = pd.DataFrame(result)

# 关闭连接
cursor.close()
connection.close()

# 打印DataFrame
print(df)