title: How do I merge multiple dataframes in Python
body: <p>I have 3 dataFrames and all 3 have different columns. How do I make 1 big dataFrame of it?</p>
  <p>Example of df1:</p>
  <pre><code>   type - country 
  0  001  - US      
  1  002  - DE      
  2  003  - ES     
  3  004  - FR  
  </code></pre>
  <p>Example of df2:</p>
  <pre><code>   Model
  0  Clio
  1  Q5  
  2  RS6
  3  AMG
  </code></pre>
  <p>Example of df3:</p>
  <pre><code>   Name
  0  Richard
  1  Paul
  2  Juan
  3  Del Castillo
  </code></pre>
  <p>This is the code I'm using:</p>
  <pre><code>df123 = pd.concat([df1, df2, df3])
  </code></pre>
  <p>The output is:</p>
  <pre><code>   type - country - Model - Name
  0  001  - US      - NaN   - NaN
  1  002  - DE      - NaN   - NaN
  2  003  - ES      - NaN   - NaN 
  3  004  - FR      - NaN   - NaN
  </code></pre>
  <p>Expected output:</p>
  <pre><code>   type - country- Model - Name
  0  001  - US     - Clio  - Richard
  1  002  - DE     - Q5    - Paul
  2  003  - ES     - RS6   - Juan
  3  004  - FR     - AMG   - Del Castillo
  </code></pre>