Pandas 将csv文件写入数据库,并将数据简单清洗
# 导入包
import pandas as pd
import pymysql
from sqlalchemy import create_engine
#一、 数据库配置
host = 'host'
user = 'user'
passwd = 'pw'
db = 'db'
port=3306
charset = 'utf8'
# pymysql
conn = pymysql.connect(host = host,user = user,passwd = passwd,db = db,port=33
原创
2020-08-13 17:47:29 ·
1500 阅读 ·
0 评论