user1504276 user1504276 - 1 year ago 128
Python Question

dropping a row in pandas with dates indexes, python

I'm trying to drop the last row in a dataframe created by pandas in python and seem to be having trouble.

index = DateRange('1/1/2000', periods=8)
df = DataFrame(randn(8, 3), index=index, columns=['A', 'B', 'C'])

I tried the drop method like this:

df.drop([shape(df)[0]-1], axis = 0)

but it keeps saying label not contained in the axis.

I also tried to drop by index name and it still doesn't seem to be working.

Any advice would be appreciated. Thanks!!!

Answer Source

returns the original DataFrame with the last row removed.