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
>>> df.iloc[0, 1] 2
iloc - default indexes (system generated) loc - table indexes or we manually given indexes
>>> type(df.iloc[0]) <class 'pandas.core.series.Series'> >>> df.iloc[0] a 1 b 2 c 3 d 4 Name: 0, dtype: int64
>>> mydict = [{'a': 1, 'b': 2, 'c': 3, 'd': 4}, ... {'a': 100, 'b': 200, 'c': 300, 'd': 400}, ... {'a': 1000, 'b': 2000, 'c': 3000, 'd': 4000 }] >>> df = pd.DataFrame(mydict) >>> df a b c d 0 1 2 3 4 1 100 200 300 400 2 1000 2000 3000 4000