Removing a string in pandas with date indices, python

Question

I am trying to remove the last line in dataframecreated by pandas in python, and it looks like you have problems.

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

I tried the drop method as follows:

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

but he continues to say a label not contained in the axis.

I also tried to fall by index name and it still does not work.

Any advice would be appreciated. Thank!!!

+5

user1504276 Jul 10 '12 at 13:40

2 answers

Linking to the DataFrame directly to retrieve all but the last index worked for me.

df[:-1]

+11

modpy Apr 18 '16 at 2:04

eumiro · Accepted Answer · 2012-07-10T13:51:12+0000

df.ix[:-1]

returns the original DataFrame with the last row removed.