读取csv文件
import pandas as pd
data = pd.read_csv(r"D:123123.csv", parse_dates=["成交时间"],encoding="gbk)
#parse_dates 指定转换时间格式的列,encoding编码设置,默认utf-8
将结果导出到本地csv文件
data.to_csv(r"D:123report.csv",encoding="utf-8-sig")
import pandas as pd
data = pd.read_csv(r"D:123123.csv", parse_dates=["成交时间"],encoding="gbk)
#parse_dates 指定转换时间格式的列,encoding编码设置,默认utf-8
data.to_csv(r"D:123report.csv",encoding="utf-8-sig")