title: Pandas - Append data to specific columns
body: <p>I need to append data from a list to a specific column. 
  I have 4 lists:</p>
  
  <pre><code>orderNumber = ['123456789']
  countryOfOrigin = ['United Kingdom']
  sizeList = ['2', '4']
  quantityList = ['10', '12']
  </code></pre>
  
  <p>I also have a CSV file with following headers:</p>
  
  <pre><code>OrderNumber   COO   Size   QTY
  </code></pre>
  
  <p>I need these lists appended to this CSV in their correct columns. And if list only has one item in the data is simply dublicated to fill all rows</p>
  
  <pre><code>OrderNumber        COO         Size   QTY
  123456789     United Kingdom    2     10
  123456789     United Kingdom    4     20
  </code></pre>
  
  <p>This is what I tried. But all it does it adds everything one under another in the same column</p>
  
  <pre><code>orderNumber = ['123456789']
  countryOfOrigin = ['United Kingdom']
  sizeList = ['2', '4']
  quantityList = ['10', '12']
  
  header = ["OrderNumber", "COO", "Size", "QTY"]
  order = pd.DataFrame(orderNumber)
  order.to_csv('C:/Users/user/Desktop/Pandas-Example2.csv', mode='a', index=False)
  size = pd.DataFrame(sizeList, columns=["Size"])
  size.to_csv('C:/Users/user/Desktop/Pandas-Example2.csv', mode='a', index=False)
  </code></pre>
  
  <p>Any idea how this could be fixed?</p>