从多索引数据中删除单行

Question

>假设我有以下数据帧：

0         1         2         3
bar one -0.424972  0.567020  0.276232 -1.087401
two -0.673690  0.113648 -1.478427  0.524988
baz one  0.404705  0.577046 -1.715002 -1.039268
two -0.370647 -1.157892 -1.344312  0.844885
foo one  1.075770 -0.109050  1.643563 -1.469388
two  0.357021 -0.674600 -1.776904 -0.968914
qux one -1.294524  0.413738  0.276662 -0.472035
two -0.013960 -0.362543 -0.006154 -0.923061

而且我只想删除按["foo", "two"]索引的行.有没有简单的方法可以做到这一点？

使用drop我可以删除级别 0 的foo下索引的记录，或级别 1 的two索引的所有记录。但我只想放弃那个。

Answer 1

你可以用tuple

df.drop(('foo','two'))
Out[381]: 
0         1         2         3
bar one -0.424972  0.567020  0.276232 -1.087401
two -0.673690  0.113648 -1.478427  0.524988
baz one  0.404705  0.577046 -1.715002 -1.039268
two -0.370647 -1.157892 -1.344312  0.844885
foo one  1.075770 -0.109050  1.643563 -1.469388
qux one -1.294524  0.413738  0.276662 -0.472035
two -0.013960 -0.362543 -0.006154 -0.923061