title: Import csv Python with Spyder
body: <p>I am trying to import a csv file into Python but it doesn't seem to work unless I use the Import Data icon.</p>
  
  <p>I've never used Python before so apologies is I am doing something obviously wrong.  I use R and I am trying to replicate the same tasks I do in R in Python.</p>
  
  <p>Here is some sample code:</p>
  
  <pre><code>import pandas as pd
  import os as os
  
  Main_Path = "C:/Users/fan0ia/Documents/Python_Files"
  Area = "Pricing"
  Project = "Elasticity"
  Path = os.path.join(R_Files, Business_Area, Project)
  os.chdir(Path)
  
  #Read in the data
  Seasons = pd.read_csv("seasons.csv")
  Dep_Sec_Key = pd.read_csv("DepSecKey.csv")
  </code></pre>
  
  <p>These files import without any issues but when I execute the following:</p>
  
  <pre><code>UOM = pd.read_csv("FINAL_UOM.csv")
  </code></pre>
  
  <p>Nothing shows in the variable explorer panel and I get this in the IPython console:</p>
  
  <pre><code>In [3]: UOM = pd.read_csv("FINAL_UOM.csv")
  </code></pre>
  
  <p>If I use the Import Data icon and use the wizard selecting DataFrame on the preview tab it works fine.
  The same file imports into R with the same kind of command so I don't know what I am doing wrong?  Is there any way to see what code was generated by the wizard so I can compare it to mine?</p>