cancel
Showing results for 
Search instead for 
Did you mean: 

Reading an AI Catalog .csv file from within a Notebook

Reading an AI Catalog .csv file from within a Notebook

I am trying (unsuccessfully) to load data from a csv file (that only has one column, namely a full address field: address | city | state | zip) from the AI Catalog with the following syntax:

 

addresses = pd.read_csv("https://app.datarobot.com/usecases/6467ed0c26e748....dc4df6fc/prepare/6467e45f7f....0f934df6b2")

If I do an addresses.head(6) command, it looks like the table's metadata, not the first few rows of the csv as I was expecting. 

 

Does anyone have guidance on referencing files already loaded into the AI Catalog? It seems I'm not using the correct hash references. 

 

PS> I am using information from this page https://docs.datarobot.com/en/docs/dr-notebooks/dr-notebook-ref.html which says:

"How can I access datasets in my Use Case that I have not yet loaded into my notebook?"

Access the dataset you want to include in the notebook from the Use Case dashboard. The ID is included in the dataset URL (after /prepare/); it is the same ID stored for the dataset in the AI Catalog.

Labels (2)
0 Kudos
10 Replies

I was searching all over the internet and DataRobot's documentation. I finally found a way to convert a dataset into a dataframe. Thank you!