Table of contents

Access data from local files

You can upload and load local data assets such as CSV files into your Data Science Experience project. When you add a local data asset to a project, any collaborator in that project can load data from it.

Important: CSV files are assumed to have headers and use a comma as a field separator. When a CSV file is read, an attempt is made to infer the types of the columns. This process is not perfect, and in some cases the inferred type might be wrong; for example, a column of time stamps might be inferred to be a column of strings instead. Malformed csv files cannot be previewed.

To upload the local data asset:

  1. In your project, go to your Assets page and click add data set.

  2. Drag or browse to your local file system to the palette. The file is now added to the project.

For DSX Desktop, the data assets are stored in:

  • Mac: /Users/<em>username</em>/Library/Application Support/ibm-dsx-desktop/Notebooks/mynotebooks/assets

  • Windows: %APPDATA%\ibm-dsx-desktop\Notebooks\mynotebooks\assets

  • Linux: ~/.config/ibm-dsx-desktop/Notebooks/myNotebooks/assets/ or $XDG_CONFIG_HOME/ibm-dsx-desktop/Notebooks/myNotebooks/assets/

RStudio only: In the Files view, you can find the uploaded data files by going to ../datasets from Home.

Load data from a local data asset

To automatically load data from a local data asset into a data frame in a notebook:

  1. Open the notebook and click the Find and Add Data icon (Shows the Find and Add Data icon) in the toolbar. Only CSV files can be inserted into notebooks, and the first data row is always be read as the header row.

  2. Select the CSV file to insert.