将dataframe 写入excle中

import numpy as np
import pandas as pd

def read_56008():
    df_2=pd.read_csv('56008/Diesel_LFWSRXSJ1K1E56008_2020-04-23_394.csv')
    return df_2


corr_label=(['API_PosnThrFb','AIC_MfCyl','AIC_MfEgr','AIC_MfExh','API_PEgFb','EBP_VAR_W','EGRPR_VAR_FILT_W','EAPP_VAR_FILT_W','EESP_VAR_N_W','TQMOD_VAR_TRQ_ACT_W'])

def dataselect(X):
    X = X[(X['EESP_VAR_N_W'] > 900) &(X['EESP_VAR_N_W'] <=1500)&(X['TQMOD_VAR_TRQ_ACT_W'] >= 500) & (X['TQMOD_VAR_TRQ_ACT_W'] <= 1500)]
    data=[]
    for i in corr_label:
        data.append(X[i])
    data=pd.DataFrame(data)
    data = pd.DataFrame(data.values.T) #data存储了筛选出的变量的所有数值
    data.dropna(axis=0, how='any', inplace=True)
    return data

df_2=read_56008()
data_2=dataselect(df_2)


import xlwt
def data_write(file_path, datas):
    workbook = xlwt.Workbook(encoding='UTF-8')
    worksheet = workbook.add_sheet('My Worksheet')
    i=0
    for data in datas.values:
        print(data)
        for j in range(len(data)):
            worksheet.write(i,j,data[j])
        i+=1
    workbook.save(file_path)

file_path='sheet.xls'
data_write(file_path,data_2)