title: Python Pandas (Excel) datasheet code issue
body: <p>I have imported an excel (.xlsx) spreadsheet into my python code (using Pandas) and want to extract data from it and the spreadsheet contains the following;</p>
  <pre><code>DATE:        Lecture1:   Lecture2:
  16/07/2020   09:30       11:00
  17/07/2020   09:45       11:30
  18/07/2020   09:45       11:00
  19/07/2020   10:00       14:30
  20/07/2020   09:30       14:45
  </code></pre>
  <p>How can I create the part of the code so that if &quot;now = date.today()&quot;, then &quot;print&quot; the row of my lectures for that day...</p>
  <p>I have the following;</p>
  <pre><code>import pandas as pd
  
  data = pd.read_excel(r'/home/timetable1.xlsx')
  data[&quot;Date&quot;] = pd.to_datetime(data[&quot;Date&quot;]).dt.strftime(&quot;%d-%m-%Y&quot;)
  df = pd.DataFrame(data)
  print (df)
  </code></pre>
  <p>This prints out the whole timetable as shown below (note the format changes slightly);</p>
  <pre><code>         Date  Lecture1  Lecture2
  0  16-07-2020  09:30:00  11:00:00
  1  17-07-2020  09:45:00  11:30:00
  2  18-07-2020  09:45:00  11:00:00
  3  19-07-2020  10:00:00  14:30:00
  4  20-07-2020  09:30:00  14:45:00
  </code></pre>
  <p>So I am not sure what the part of the code will be to determine 'todays' date and show only 'todays' lecture times for example something like this maybe;</p>
  <pre><code>now = date.today()
  now.strftime(&quot;%d-%m-%y&quot;)
  if [&quot;Date&quot; == now]:
      print ('timetable1.xlsx' index_col=now)
  </code></pre>
  <p>I am new to coding so not very good at it. The above code is wrong I know I can't think of a way to display the info.</p>
  <p>So my desired output that I want;</p>
  <pre><code>      Date  Lecture1  Lecture2
  18-07-2020  09:45:00  11:00:00
  </code></pre>
  <p>Your input would be much appreciated.</p>