丢弃某条轴上的一个或多个项很简单,只要有一个索引数组或列表即可。由于需要执行一些数据整理和集合逻辑,所以drop方法返回的是一个在指定轴上删除了指定值的新对象:
obj = pd.Series(np.arange(5.),index=['a','b','c','d','e'])
new_obj = obj.drop('c')
print new_obj
结果
a 0.0
b 1.0
d 3.0
e 4.0
dtype: float64
print obj.drop(['d','c'])
结果
a 0.0
b 1.0
e 4.0
dtype: float64
对于DataFrame,可以删除任意轴上的索引值:
data = pd.DataFrame(np.arange(16).reshape(4,4),
index=['Ohio','Colorado','Utah','New York'],
columns=['one','two','three','four'])
print data
print data.drop(['Colorado','Ohio'])
结果
one two three four
Ohio 0 1 2 3
Colorado 4 5 6 7
Utah 8 9 10 11
New York 12 13 14 15
one two three four
Utah 8 9 10 11
New York 12 13 14 15
print data.drop('two',axis=1)
结果
one three four
Ohio 0 2 3
Colorado 4 6 7
Utah 8 10 11
New York 12 14 15
print data.drop(['two','four'],axis=1)
结果
one three
Ohio 0 2
Colorado 4 6
Utah 8 10
New York 12 14