title: Mathematica - Import CSV and process columns?
body: <p>I have a CSV file that is formatted like:</p>
  
  <pre><code>0.0023709,8.5752e-007,4.847e-008
  </code></pre>
  
  <p>and I would like to import it into  Mathematica and then have each column separated into a list so I can do some math on the selected column.</p>
  
  <p>I know I can import the data with:</p>
  
  <pre><code>Import["data.csv"]
  </code></pre>
  
  <p>then I can separate the columns with this:</p>
  
  <pre><code>StringSplit[data[[1, 1]], ","]
  </code></pre>
  
  <p>which gives:</p>
  
  <pre><code>{"0.0023709", "8.5752e-007", "4.847e-008"}
  </code></pre>
  
  <p>The problem now is that I don't know how to get the data into individual lists and also Mathematica does not accept scientific notation in the form 8.5e-007.</p>
  
  <p>Any help in how to break the data into columns and format the scientific notation would be great.</p>
  
  <p>Thanks in advance.</p>