title: How to create a new dataframe/CSV file from reading contents of files from various folders in python
body: <p>I have multiple folders which contains CSV files with values. I need to create a new dataframe/CSV file where contents of each column from each file and each folder is placed in this new dataframe</p>
  <p>Folder-1</p>
  <p>A1.CSV</p>
  <pre><code>       A       B      C       D
         aa      bb     cc      dd
  </code></pre>
  <p>Folder-2</p>
  <p>B1.CSV</p>
  <pre><code>        E      F       G       H
          ee     ff      gg      hh
  </code></pre>
  <p>Folder-3</p>
  <p>C1.CSV</p>
  <pre><code>         I      J       K       L
           ii     jj      kk      ll
  </code></pre>
  <p>D1.CSV</p>
  <pre><code>          M       N       O       P
            mm      nn      oo      pp
  </code></pre>
  <p>New-Dataframe should be</p>
  <pre><code>           A       B        C       D     E     F      H      I   O     P
             aa      bb       cc      dd    ee    ff     hh     ii  oo    pp 
  </code></pre>