Python Forum
How to read specified columns
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to read specified columns
#1
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)

Attached Files

.xlsx   RFInput.xlsx (Size: 9.71 KB / Downloads: 28)
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020