import pandas as pd
import numpy as np
def readExcel(path, sheet):
"""
# 读Excel文件,返回2维list
:param path:
:param sheet:
:return:
"""
data = pd.read_excel(path, sheet_name=sheet, header=None)
return data.values.tolist()
def writeExcel(data, savePath, sheet):
"""
写Excel文件,传入2维list
:param data:
:param savePath:
:param sheet:
:return:
"""
data = np.array(data)
writer = pd.ExcelWriter(savePath)
pd.DataFrame(data).to_excel(writer, sheet_name=sheet, index=False, header=None)
writer.save()
import pandas as pd
import numpy as np
def readCsv(path):
"""
读csv文件,返回2维list
:param path: 路径
:return: 数据 2维list
"""
data = pd.read_csv(path, header=None)
return data.values.tolist()
def writeCsv(data, savePath):
"""
写csv文件,传入2维list
:param data: 数据 2维list
:param savePath: 保存路径
:return:
"""
data = np.array(data)
pd.DataFrame(data).to_csv(savePath, index=False, header=None)