Data Loading

Data Loading

Introduction

This page is the starting point for data loading. The General Overview section below contains all the required steps to get you started.

If you're interested in getting a quick overview of the changes you will need to make to your existing data files, please check the Data Loading: What You Need To Change page.

General Overview

Getting your study data into cBioPortal requires four steps:

1. Setting up the validator
2. Preparing your study data
3. Validating your study data
4. Loading your study data

Setting up the validator

Installation

If you have a git clone of cBioPortal, the relevant scripts can be found in the folder: <your_cbioportal_dir>/core/src/main/scripts/importer

Dependencies

The scripts run in python 2. If you want the scripts to be able to generate html reports (recommended way for reading the validation errors, if any), then you will also need to install jinja2. You can use this command:

$ sudo pip2 install jinja2

Preparing Study Data

A study to be loaded in cBioPortal can basically consist of a directory where all the data files are located. Each data file needs a meta file that refers to it and both files need to comply to the format required for the specific data type. The format and fields expected for each file are documented in the [File Formats page](File Formats). Below is an example of the files in such a directory.

dir
|-meta_study.txt
|-meta_cancer_type.txt -> cancer_type.txt
|-meta_clinical.txt -> data_clinical.txt
|-meta_[expression|mutations|CNA|etc] -> data_[expression|mutations|CNA|etc]

Rules

There are just a few rules to follow:

• meta_study, meta_clinical and respective clinical data file are the only mandatory files.
• cancer type files can be mandatory if the study is referring to a cancer type that does not yet exist in the DB.
• meta files can be named anything, as long as it starts or ends with name 'meta'. E.g. meta_test, meta.test, test.meta are all fine; metal_test and metastudy are wrong.
• data files can be named anything and are referenced by a property data_filename set in the meta file.

Validating the study

Once all files are in place and follow the proper format, you can validate your files using the dataset validator script.

The validation can be run standalone, but it is also integrated into the metaImport script, which validates the data and then loads it if validation succeeds.

Loading Data

To load the data into cBioPortal, the metaImport script has to be used. This script first validates the data and, if validation succeeds, loads the data.

Removing a Study

To remove a study, the cbioportalImporter script can be used.

Example study

Examples for the different types of data are available on the data examples page for use as reference when creating data files.