BUG: duplicate columns and drop buggy · Issue #6240 · pandas-dev/pandas (original) (raw)

In [21]: df = DataFrame({'A' : np.random.randn(5),
 'B' : np.random.randn(5),'C' : np.random.randn(5), 
  'D':['a','b','c','d','e'] })

In [22]: df
Out[22]: 
          A         B         C  D
0 -0.941264  0.272726 -0.547948  a
1  0.069432  1.398414  0.039093  b
2 -0.073638 -1.264676 -1.339994  c
3  1.520017 -0.562979 -0.739326  d
4 -0.395157  0.542807  0.766582  e

[5 rows x 4 columns]

In [23]: df.take([2,0,1,2,3], axis=1).drop('C',axis=1)
Out[23]: 
          A         B  D
0 -0.941264  0.272726  a
1  0.069432  1.398414  b
2 -0.073638 -1.264676  c
3  1.520017 -0.562979  d
4 -0.395157  0.542807  e

[5 rows x 3 columns]

In [24]: df.take([2,0,1,2,1], axis=1).drop('C',axis=1)
IndexError: index 3 is out of bounds for axis 0 with size 3