title: Filter and exclude weekends row in DataFrame
body: <p>I have a <code>CSV</code> file with the following data.</p>
  
  <pre><code>Date(IN GMT), Value
  01.01.2017 00:00:00,  1.15430
  01.02.2017 00:00:01,  1.15120
  01.03.2017 00:00:02,  1.12450
  01.04.2017 00:00:03,  1.12330
  01.05.2017 00:00:04,  1.12620
  ....,....
  12.31.2017 23:59:59,  1.14620
  </code></pre>
  
  <p>I want to remove the weekend's date so that I only work with weekday values. The date is in GMT.</p>
  
  <p>I want to exclude the weekend's data point entirely. I just want the weekday values. How can I do it with Pandas?</p>
  
  <p><strong><em>The other replies on the Stackoverflow does not answer it correctly, because:</em></strong></p>
  
  <p>Here's what I did:</p>
  
  <pre><code>df['Date(IN GMT)'] = pd.to_datetime(df['Date(IN GMT)'])
  df[df['Date(IN GMT)'].dt.weekday &lt; 5]
  </code></pre>
  
  <p>and I get:</p>
  
  <pre><code>Date(IN GMT), Value
  2019-05-04 20:57:00,  1.1216 
  2019-05-04 20:58:00,  1.1216 
  2019-05-04 20:59:00,  1.1215 
  2019-07-04 21:00:00,  1.1214 
  2019-07-04 21:01:00,  1.1214 
  2019-07-04 21:02:00,  1.1215 
  2019-07-04 21:03:00,  1.1215 
  </code></pre>
  
  <p>If you look above, after <code>2019-05-04 20:59:00,1.1215</code> there is the value <code>2019-07-04 21:00:00,1.1214</code></p>
  
  <p>It skipped several hours of data and went to the next date(by skipping weekends)... </p>