title: Combining pandas dataframes, different number of lines
body: <p><strong>Two data frames of different lengths:</strong></p>
  <pre><code>df1:                               df2:
  Column1  Column2  Column3          Column1  Column2
  Url      Name      Description     Type 1   Duration 1
                                     Type 2   Duration 2
                                     Type 3   Duration 3
                                     Type 4   Duration 4
  </code></pre>
  <p><strong>How to get such a table?</strong></p>
  <pre><code>Column1  Column2  Column3          Column4  Column5
  
  Url1      Name1     Description1   Type *   Duration 1
                                     Type 2   Duration 2
                                     Type 3   Duration 3
                                     Type 4   Duration 4
  </code></pre>
  <p>I want to write data to Excel table.
  <a href="https://i.stack.imgur.com/fm1WO.png" rel="nofollow noreferrer">An example of the required table</a></p>
  <p><strong>Tried:</strong></p>
  <pre><code>df1.merge (df2, left_index = True, right_index = True)
  df2.join (df2)
  </code></pre>
  <p><strong>As a result, only one line from df2 is written</strong></p>