title: Read.CSV not working as expected in R
body: <p>I am stumped.  Normally, <code>read.csv</code> works as expected, but I have come across an issue where the behavior is unexpected.  It most likely is user error on my part, but any help will be appreciated.</p>
  
  <p>Here is the URL for the file</p>
  
  <pre><code>http://nces.ed.gov/ipeds/datacenter/data/SFA0910.zip
  </code></pre>
  
  <p>Here is my code to get the file, unzip, and read it in:</p>
  
  <pre><code> URL &lt;- "http://nces.ed.gov/ipeds/datacenter/data/SFA0910.zip"
   download.file(URL, destfile="temp.zip")
   unzip("temp.zip")
   tmp &lt;- read.table("sfa0910.csv", 
                     header=T, stringsAsFactors=F, sep=",", row.names=NULL)
  </code></pre>
  
  <p>Here is my problem.  When I open the data csv data in Excel, the data look as expected.  When I read the data into R, the first column is actually named row.names.  R is reading in one extra row of data, but I can't figure out where the "error" occurs that is causing row.names to be a column.  Simply, it looks like the data shifted over.  </p>
  
  <p>However, what is strange is that the last column in R does appear to contain the proper data.</p>
  
  <p>Here are a few rows from the first few columns:</p>
  
  <pre><code>tmp[1:5,1:7]
    row.names UNITID XSCUGRAD SCUGRAD XSCUGFFN SCUGFFN XSCUGFFP
  1    100654      R     4496       R     1044       R       23
  2    100663      R    10646       R     1496       R       14
  3    100690      R      380       R        5       R        1
  4    100706      R     6119       R      774       R       13
  5    100724      R     4638       R     1209       R       26
  </code></pre>
  
  <p>Any thoughts on what I could be doing wrong?</p>