mysql 将txt数据导入到数据库中

import csv

# 假设TXT文件是CSV格式
with open('data.txt', 'r') as infile:
    reader = csv.reader(infile)
    data = [row for row in reader]

# 数据清洗和转换
cleaned_data = []
for row in data:
    # 进行数据清洗和转换
    cleaned_row = [convert_data(item) for item in row]
    cleaned_data.append(cleaned_row)

# 将清洗后的数据导入到MySQL数据库
import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="database")
cursor = db.cursor()

for row in cleaned_data:
    sql = "INSERT INTO table_name (column1, column2, column3) VALUES (%s, %s, %s)"
    cursor.execute(sql, row)

db.commit()
cursor.close()
db.close()

LOAD DATA INFILE 'data.txt' INTO TABLE table_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

import codecs

with codecs.open('data.txt', 'r', encoding='utf-8') as infile:
    data = infile.readlines()

# 进行数据导入