- 论坛徽章:
- 0
|
导出只有只有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')
复制代码
|
|