pandas读写Excel&Csv

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)