Python pandas: Why does df.iloc[:, :-1].values for my training data select till only the second last column?
I think you have only two columns in df
, because if there is more columns, iloc
select all columns without last:
df = pd.DataFrame({'A':[1,2,3],
'B':[4,5,6],
'C':[7,8,9],
'D':[1,3,5],
'E':[5,3,6],
'F':[7,4,3]})
print (df)
A B C D E F
0 1 4 7 1 5 7
1 2 5 8 3 3 4
2 3 6 9 5 6 3
print(df.iloc[:, :-1])
A B C D E
0 1 4 7 1 5
1 2 5 8 3 3
2 3 6 9 5 6
X = df.iloc[:, :-1].values
print (X)
[[1 4 7 1 5]
[2 5 8 3 3]
[3 6 9 5 6]]
print (X.shape)
(3, 5)
Just for clarity
With respect to python syntax, this question has been answered here.
Python list slicing syntax states that for a:b
it will get a
and everything upto but not including b
. a:
will get a
and everything after it. :b
will get everything before b
but not b
. The list index of -1
refers to the last element. :-1
adheres to the same standards as above in that this gets everything before the last element but not the last element. If you want the last element included use :
.