title: checking if a value in a data frame column exists in a list, and creating a new column acording to the checking result
body: <p><strong>an example how i tried to solve it</strong></p>
  <pre><code>```
  df = pd.DataFrame({'vals': [1, 2, 3, 4, 5], 'ids': ['a', 'b', 'f', 'n','k'], 'ids2':['a','n','c', 'n','z'],'mylove': ['i', 'l', 'o', 'v','x'],'mysweet': ['e', 'n', 'a', 's','p'] })```
  
       vals    ids  ids2    mylove    mysweet
  0     1       a    a        i          e
  1     2       b    n        l          n
  2     3       f    c        o          a
  3     4       n    n        v          s
  4     5       k    z        x          p
  </code></pre>
  <p><strong>will check each lists bellow</strong></p>
  <pre><code>``
  AIMO,BIMO,CIMO,DIMO  = ['i'],['l'],['o'],['v','x']
  aimo = df['mylove'].isin(AIMO)   #check if the value in the list is available in the column &quot;mylove&quot;
  aimo1 = df[aimo]   #&quot;because the above just gave me a boolean i created a new data frame&quot; i dont know what to do&quot;
  aimo1.loc[:,'CATAGORY'] = 'CANDY'  # #&quot;assigned this value to the new column called &quot;CATAGORY&quot;&quot;#mind this CATAGORY is a new column just created in this stage. ``
  </code></pre>
  <p><strong>then i repeated the above procedure</strong></p>
  <pre><code>``
  bimo = df['mylove'].isin(BIMO)
  bimo1 = df[bimo]
  bimo1.loc[:,'CATAGORY'] = 'Goods'
  
  cimo = df['mylove'].isin(CIMO)
  cimo1 = df[cimo]
  cimo1.loc[:,'CATAGORY'] = 'SERVICE'
  
  dimo = df['mylove'].isin(DIMO)
  dimo1 = df[dimo]
  dimo1.loc[:,'CATAGORY'] = 'action'``
  </code></pre>
  <p>#<strong>now i concatenate the columns and created a new dataframe</strong></p>
  <pre><code>```new_df = pd.concat([aimo1,bimo1,cimo1,dimo1])```
  </code></pre>
  <p>the result gate <strong>new_df</strong></p>
  <pre><code>            vals    ids  ids2   mylove  mysweet CATAGORY
         0      1      a     a       i    e        CANDY
         1      2      b     n       l    n        Goods
         2      3      f     c       o    a        SERVICE
         3      4      n     n       v    s        action
         4      5      k     z       x    p        action
  </code></pre>
  <p><strong>i tried this one. but it tooks too long to get the result my original data. my original data has many rows. i am a new bee</strong></p>