May-09-2018, 04:02 PM
Hi,
I have below data:
Y type column names are A, E, F, and its data in Rawdata,
I have below data:
import pandas as pd import numpy as np from scipy import stats dataFileName='RFInput.xlsx' sheetName='Rawdata' sheetNamePara='paraList' dataRaw=pd.read_excel(dataFileName, sheetname = sheetName) datapara=pd.read_excel(dataFileName, sheetname = sheetNamePara) noData=len(dataRaw) labels = datapara x = dataRaw[labels] Rawdata: A B C D E F 0 1.2 1.6 3.2 3.2 1.6 1 1.2 1.6 3.2 3.2 1.6 2 2.6 1.9 6.5 6.5 1.9 0 1.2 1.6 3.2 3.2 1.6 1 2.6 1.9 6.5 6.5 1.9 4 1.2 1.6 3.2 3.2 1.6 paraList: A C E F Y N Y YI want to find column index of Y and N in paralist, and corresponding column names:
Y type column names are A, E, F, and its data in Rawdata,
data_Y: A E F 0 3.2 1.6 1 3.2 1.6 2 6.5 1.9 0 3.2 1.6 1 6.5 1.9 4 3.2 1.6 data_N: C 1.6 1.6 1.9 1.6 1.9 1.6