丢弃值
drop方法可以丢弃某条轴上一个或多个项,返回的是删除指定值的新对象。
Series
obj = Series(np.arange(5.), index=['a', 'b', 'c', 'd', 'e'])
new_obj = obj.drop('c')
new_obj
a 0.0
b 1.0
d 3.0
e 4.0
dtype: float64
drop可以同时指定多个值
obj.drop(['d', 'c'])
a 0.0
b 1.0
e 4.0
dtype: float64
DataFrame
drop可以删除DataFrame任意轴上的索引值
data = DataFrame(np.arange(16).reshape((4, 4)),
index=['Ohio', 'Colorado', 'Utah', 'New York'],
columns=['one', 'two', 'three', 'four'])
data.drop(['Colorado', 'Ohio'])
one two three four
Utah 8 9 10 11
New York 12 13 14 15
指定列(axis=1)
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
指定多列
data.drop(['two', 'four'], axis=1)