title: Loading a CVS file where the data is all in one column
body: <p>I am importing a CSV file that contains data which is all in a single column (the TXT file has the data separated by ";"</p>
  
  <p>Is there anyway to get the data to load into Anaconda (using Panda) so that it is in separate columns, or can it be manipulated afterwards into columns?</p>
  
  <p>The data can be found at the following web-address (this is data about sunspots):</p>
  
  <p><a href="http://www.sidc.be/silso/INFO/snmtotcsv.php" rel="nofollow noreferrer">http://www.sidc.be/silso/INFO/snmtotcsv.php</a></p>
  
  <p>From this website <a href="http://www.sidc.be/silso/datafiles" rel="nofollow noreferrer">http://www.sidc.be/silso/datafiles</a></p>
  
  <p>I have managed to do this so far:</p>
  
  <h1>Start code by loading the Panda command set</h1>
  
  <p>from pandas import *</p>
  
  <pre><code>#Initial setup commands
  import warnings
  warnings.simplefilter('ignore', FutureWarning)
  import matplotlib
  matplotlib.rcParams['axes.grid'] = True # show gridlines by default
  %matplotlib inline
  from scipy.stats import spearmanr
  
  #load data from CSV file
  startdata = read_csv('SN_m_tot_V2.0.csv',header=None)
  startdata = startdata.reset_index()
  </code></pre>