导出只有只有list(n3)里面的内容,求助!
import pandas as pd
import os
pwd=os.getcwd()
workpath='C:\\Users\\CIB\\Desktop'
os.chdir(workpath)
condi_vn = [(40000,80000),(20000,40000),(7500,15000),(2500,5000)]
condi_worth = [(20000000,40000000),(10000000,20000000),(4000000,8000000),(1500000,3000000)]
condi_scale = ['大型','中型','小型','微型']
data=pd.read_excel('2019年4月核心客户档案库(3000户月报模版)结果数.XLSX',header=0,
sheet_name='201904',encoding='gbk')
final=pd.DataFrame()
for scale,vn,worth in zip(condi_scale,condi_vn,condi_worth):
n1 = data[(vn[0] < data['4月月均VN']) & (data['4月月均VN']<= vn[1])
& (worth[0] < data['4月财富业务年日均']) & (data['4月财富业务年日均']<= worth[1])]['单位名称']
n2 = data[(vn[0] < data['4月月均VN']) & (data['4月月均VN'] <= vn[1])
& (data['4月财富业务年日均'] <= worth[0])]['单位名称']
n3 = data[(data['4月月均VN'] <= vn[0])
& (worth[0] < data['4月财富业务年日均']) & (data['4月财富业务年日均'] <= worth[1])]['单位名称']
temp = list(n1)+list(n2)+list(n3)
cus = pd.DataFrame(temp)
final=cus
final.to_excel('output.xls')
导出只有只有list(n3)里面的内容,求助!