title: Delete values from dataframe in the fastest possible manner
body: <p>I have a dataframe with over 5M+ rows. I also have a list of values which I want to delete from the the dataframe. Let's say that my list name is <code>a</code> and my dataframe name is <code>df</code>. Below is the code I use to check if item in <code>a</code> is present in <code>df</code>, and then delete it from <code>df</code>:</p>
  
  <pre><code> if len(a) &gt; 0:
         for i in tqdm(a):
               indexName = df[ df['id'] == i ].index
               df.drop(indexName , inplace=True)
  </code></pre>
  
  <p>The above code takes 5 minutes. Although it works, I am pretty sure there is a much more efficient method. Please share if you have any ideas!</p>