title: Get Values from other Dataframe into my Loop for the new Dataframe
body: <p>I have one Dataframe (df1) with TimeCategory as index and different dates as columns and values for each TimeCategory during this day which looks like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>TimeCategory</th>
  <th>01.01.2021</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>0-5</td>
  <td>3</td>
  </tr>
  <tr>
  <td>5-7</td>
  <td>0</td>
  </tr>
  <tr>
  <td>7-10</td>
  <td>1</td>
  </tr>
  <tr>
  <td>10-12</td>
  <td>5</td>
  </tr>
  <tr>
  <td>12-14</td>
  <td>5</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>And I have a second dataframe (df2) with the columns Date and TimeCategory.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Dates</th>
  <th>Time</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>01.01.2021</td>
  <td>0-5</td>
  </tr>
  <tr>
  <td>01.01.2021</td>
  <td>07-10</td>
  </tr>
  <tr>
  <td>02.01.2021</td>
  <td>07-10</td>
  </tr>
  <tr>
  <td>02.01.2021</td>
  <td>05-5</td>
  </tr>
  <tr>
  <td>03.01.2021</td>
  <td>12-14</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I added a column to the second dataframe (df2), where I would like to get the values of the first dataframe (df2) based on date and time.</p>
  <p>I made two lists out of the different Dates (Date_List) and the different TimeCategory (TimeCategory_List).</p>
  <p>My If-Else-Condition works how it is supposed to be.</p>
  <p>But I do not know how to get the values (????) from df1 into my loop to write it into my new column [24] of df2.</p>
  <pre><code>for i in range(0,len(df2)):
  
      if df2.loc[:,&quot;Date&quot;].iloc[i,] in Date_List and df2.loc[:,&quot;TimeCategory&quot;].iloc[i,] in TimeCategory_List: 
         
         df2.iat[i,24]= ????
      else: 
          df2.iat[i,24]=0
  </code></pre>