title: Pandas-Export to CSV as a string (not date format)
body: <p>Pandas DataFrames - how do I export list 'X' to a CSV so it appears as a string? The problem is when I open the CSV using Excel it appears in date format.</p>
  <pre><code>X=['1-4', '1-5', '2-3', '4-8']
  </code></pre>
  <p>ie. when list 'X' is exported to a CSV and opened with Excel it appears as a date:</p>
  <p><a href="https://i.stack.imgur.com/v2dBw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v2dBw.png" alt="enter image description here" /></a></p>
  <p>I would like list 'X' to appear in Excel as is - that is, not converted it to date format.
  Desired output for Excel is:</p>
  <p><a href="https://i.stack.imgur.com/vmIur.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vmIur.png" alt="enter image description here" /></a></p>
  <p>I have tried the following code - but it throws an error:</p>
  <pre><code>import pandas as pd
  
  X=['1-4', '1-5', '2-3', '4-8']
  Y=[1,4,3,5]
  
  df=pd.DataFrame(list(zip(X,Y)))
  
  column_names=['A','B']
  df.columns=[column_names]
  
  df.A.to_string()
  
  df.to_csv('yyy.csv', mode='a', header=True)
  </code></pre>
  <p>Thankyou</p>