Python Forum

Full Version: How to read specified columns
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,


import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
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)
import matplotlib.pylab as plt
from sklearn.cross_validation import train_test_split
from sklearn.cross_validation import cross_val_score
from sklearn.preprocessing import StandardScaler
import pandas as pd
import numpy as np
 
labels=datapara
x=dataRaw[labels]
y=dataRaw['classVariable']
labels are becoming dataFrame type, can not read data of column (specified in labels)