title: Pandas, Filter not None values and against list multiple values
body: <p>I have the following DataFrame:</p>
  
  <pre><code>            Item  Weight  Bags    Must  quantity  must quantity  bags column  length assigned bag
  0     planes bag    8.50  planes   v       1              1          6                None
  1  Full Bandolera   3.76  planes   v       3              2          6                None
  2  tail             0.30  planes  &lt;NA&gt;     3              2          6                None
  3  central wing     1.08  planes  &lt;NA&gt;     3              2          6                None
  4  engine           0.44  planes  &lt;NA&gt;     3              2          6                None
  5  height steer     0.12  planes  &lt;NA&gt;     3              2          6                None
  6  dihedral         0.40  planes  &lt;NA&gt;     3              2          6                None   
  7  pods bag         8.72  pods     v       1              1          4                None
  8  Pod              1.74  pods     v       3              2          4                None
  9  optic            0.86  pods     v       2              2          4                None
  10 thermal          1.20  pods     v       3              2          4                None
  11 Encryption Cable 0.20  Ground  &lt;NA&gt;    1              0          25                None
                            System,
                            planes, 
                            pods, 
                            low bag  
  </code></pre>
  
  <p>I'm trying to assign the value of the Bags column to length assigned bag under the following condition:
  if Must column value is not null and the length of the bags column matches one of the items in the following list:</p>
  
  <pre><code>[6,4,13]
  </code></pre>
  
  <p>This is my try:</p>
  
  <pre class="lang-py prettyprint-override"><code>class AssignBagMusts:
      df = ITEMS_DF
      _bags: dict = BAGS
  
      @classmethod
      def create_bag_df(cls):
          """
          Add len of string in Bags column to a column named beg_len.
          """
          cls.df['bags column length'] = cls.df['Bags'].map(len)
          cls.df['assigned bag'] = None
          return cls.df
  
      @classmethod
      def assign_to_bag(cls):
          bags_lens = list(cls._bags.values())
          df = cls.df[pd.notnull(cls.df[cls.df['Must']]) &amp;
                      cls.df[cls.df['bags column length']] == any(bags_lens)]
          print(df)
  if __name__ == '__main__':
      AssignBagMusts.create_bag_df()
      AssignBagMusts.assign_to_bag()
  </code></pre>
  
  <p>And I got this error:</p>
  
  <pre><code>raise KeyError(f"None of [{key}] are in the [{axis_name}]")
  KeyError: "None of [Index([ 'v',  'v', &lt;NA&gt;, &lt;NA&gt;, &lt;NA&gt;, &lt;NA&gt;, &lt;NA&gt;,  'v',  'v',  'v',  'v',  'v',\n        'v',  'v',  'v',  'v',  'v',  'v', &lt;NA&gt;,  'v', &lt;NA&gt;,  'v',  'v',  'v',\n        'v',  'v',  'v', &lt;NA&gt;, &lt;NA&gt;,  'v', &lt;NA&gt;,  'v', &lt;NA&gt;, &lt;NA&gt;, &lt;NA&gt;, &lt;NA&gt;,\n        'v', &lt;NA&gt;, &lt;NA&gt;,  'v',  'v',  'v',  'v',  'v'],\n      dtype='object')] are in the [columns]"
  </code></pre>