Delete rows pandas Dataframe bas

2019-01-12  本文已影响2人  榴莲气象

Delete rows pandas Dataframe based on index (multiple criteria) (Python 3.5.1)

Call drop and pass a list on level='county to drop row labels with those values on that index level:

In [284]:
df.drop(['D','G',np.NaN], level='county')

Out[284]:
              population
state county            
NJ    A              100
      B              200
CA    E              500
      F              600

You could try using the inverse operator (~) on boolean indexing. For example,

import numpy as np
df[~(df.index.get_level_values('county').isin(['A', 'B', np.nan]))]
this line of code says "select from df where county is NOT in some list"

上一篇 下一篇

猜你喜欢

热点阅读