Pands的用法

【1】读取excel数据

def readx(path):
    l = []
    data = pd.ExcelFile(path)
    sheet_names = data.sheet_names
    for sheet in sheet_names:
        if sheet == 'sheet1':
            df = pd.read_excel(path, sheet_name=sheet).fillna('')
            for v in df.values:
                l.append(v)
    return l

【2】添加多个sheet的数据
 

def createData(t, save):
    writer = pd.ExcelWriter(save)
    for i in word:
        lens1 = []
        lens1.append(["", "", "", "", "AM", "", "", "DM", ""])
        lens1.append(["", "", "目标", "-5C", "25C", "60C", "-5C", "25C", "60C"])
        for v in t[i]:
            lens1.append(v)
        df1 = pd.DataFrame(lens1)
        df1.to_excel(writer, sheet_name=i, index=False, header=False)
    writer.save()
    writer.close()

【3】去除表头和列前索引

df1.to_excel(writer, sheet_name=i, index=False, header=False)

【4】获取文件夹下所有文件

def filename(file_dir):   
    for root, dirs, files in os.walk(file_dir):
        l = files
    t = []
    for i in l:
        t.append({"p":file_dir+i,"n":i[:-5]})
    return t

【5】numpy（pandas的数据为numpy类型）转list

np.tolist()