title: Merging Columns from Differerent Sheets into single sheet in python
body: <p>Actually, I am having Four CSV files which consists of one column in each file.Now I have to merge these four columns from four different files(columns of varying Size) into One single sheet.</p>
  
  <p>I tried many things,but they are merging in a single column itself.... But I want to merge those four different columns separately in one sheet.</p>
  
  <p>File1:Sheet1</p>
  
  <ul>
  <li><strong><em>Column1</em></strong></li>
  <li>data1</li>
  <li>data2</li>
  <li>data3</li>
  </ul>
  
  <p>File 2:Sheet1</p>
  
  <p><strong><em>Column1</em></strong></p>
  
  <ul>
  <li>data1</li>
  <li>data2</li>
  </ul>
  
  <p>File 3:Sheet1</p>
  
  <p><strong><em>Column1</em></strong></p>
  
  <ul>
  <li>data1</li>
  <li>data2</li>
  <li>data3</li>
  </ul>
  
  <p>File 4 :Sheet1 :</p>
  
  <p><strong><em>Column1</em></strong></p>
  
  <ul>
  <li>data1</li>
  <li>data2</li>
  </ul>
  
  <p>Now I want to merge these four columns from these 4 sheets into a single sheet having four columns like this</p>
  
  <p>New File--->Sheet1(only sheet)</p>
  
  <ul>
  <li><strong><em>column1   |    column1(of sheet1 of file2)  |     column1(of sheet1 of file3)   |      column1(of sheet1 of file4)</em></strong> </li>
  </ul>