df=pd.read_csv('yourcsv.csv') X=df.iloc[:,:-1].values y=df.iloc[:,1].values
Purely integer-location based indexing for selection by position. .iloc[] is primarily integer position based (from 0 to length-1 of the axis), but may also be used with a boolean array.
>>> df.iloc[[0, 1]] a b c d 0 1 2 3 4 1 100 200 300 400