from sqlalchemy import create_engine
import pandas as pd
from pandas import DataFrame, Series
engine = create_engine(“mysql+pymysql://root:password@ip:3306/tables”,
encoding=‘utf8’, echo=True)
解析csv文件中, name这一列,就数据中的\d+.替换
def excel_to_mysql():
excel = pd.read_csv("tea.csv")
mm_list = []
for m in excel['name'].dropna():
mm = re.sub(r"\d+.","" ,m)
mm_list.append(mm)
excel['name'] = pd.Series(mm_list)
print(excel)
excel.to_csv('a.csv')
# excel.to_sql(name='tabalename',con=engine, if_exists='append',index=False)
同样功能优化如下
def excel_to_mysql():
excel = pd.read_csv("tea.csv")
excel['name'] = excel.name.apply(lambda ele: re.sub(r"\d+.", "", ele))
print(excel)
excel.to_csv('a.csv')