title: load csv and set parameters in jupyter notebook on Azure ML
body: <p>I'm using a Python 3.4 Jupyter notebook to load a dataset in Azure ML which is stored in the cloud as a dataset in the Azure ML project environment. But using the default template created by Azure ML, I can't load the data due to a mixed datatypes error. </p>
  
  <pre><code>from azureml import Workspace
  import pandas as pd
  
  ws = Workspace()
  ds = ws.datasets['rossmann-train.csv']
  df = ds.to_dataframe()
  </code></pre>
  
  <blockquote>
    <p>/home/nbuser/anaconda3_23/lib/python3.4/site-packages/IPython/kernel/<strong>main</strong>.py:6: DtypeWarning: Columns (7) have mixed types. Specify dtype option on import or set low_memory=False.</p>
  </blockquote>
  
  <p>In my local environment I just import the dataset as follows: </p>
  
  <pre><code>df = pd.read_csv('train.csv',low_memory=False)
  </code></pre>
  
  <p>But I'm not sure how to do this in azure using the <code>ds</code> object. </p>
  
  <pre><code>df = pd.read_csv(ds)
  </code></pre>
  
  <p>and</p>
  
  <pre><code>pd.DataFrame.from_csv(ds)
  </code></pre>
  
  <p>raise the error:</p>
  
  <blockquote>
    <p>OSError: Expected file path name or file-like object, got  type</p>
  </blockquote>
  
  <p>*edit: more info on the <code>ds</code> object: </p>
  
  <pre><code>In  [1]: type(ds)
  Out [1]: azureml.SourceDataset
  In  [2]: print (ds)
  Out [2]: rossmann-train.csv
  </code></pre>