使用python去除mysql数据中的重复值
import pymysql
import pandas as pd
from sqlalchemy import create_engine
conn = connect = pymysql.connect(host="localhost",
port=3306,
user="root",
password="root123",
database="mydb",
charset="utf8mb4")
cursor = conn.cursor()
conn1 = create_engine('mysql+pymysql://root:root123@localhost:3306/mydb?charset=utf8')
sql = """
select * from abc;
"""
read_abc_mysql = pd.read_sql(sql=sql, con=conn)
read_abc_mysql.to_csv(path_or_buf="abc.csv", index=False)
read_abc_csv = pd.read_csv("abc.csv", encoding='utf-8', usecols=["a", "b", "c"])
dis_data = read_abc_csv.drop_duplicates(keep='first')
dis_data.to_csv(path_or_buf="abc1.csv", index=False)
read_dis_csv = pd.read_csv("abc1.csv", encoding='utf-8', usecols=["a", "b", "c"])
sql1 = """
truncate table abc;
"""
cursor.execute(query=sql1)
csv_to_sql = pd.DataFrame(read_dis_csv)
csv_to_sql.to_sql(name='abc', con=conn1, if_exists='append', index=False)
sql2 = """
select * from abc;
"""
read_abc_mysql = pd.read_sql(sql=sql2, con=conn)
print(read_abc_mysql)