Accessing data and files in DataLab

Introduction to DataLab

Jason Mak

Product Lead

Datalab workbooks vs notebooks

Notebooks

• Contain cells
• Used to reproduce and run analysis

DataLab workbooks

• Container for notebooks
• Container for files and outputs
• House data connections

Creating a new workbook

Data sources in DataLab

Adding an Explore cell

Viewing data using an Explore cell

Turning an Explore cell into a query

Turning an Explore cell into a query

Turning an Explore cell into a query

Connecting to a Google Spreadsheet

Adding and accessing files

Querying a local file

     

Using a SQL cell

SELECT * 
FROM 'our_file.csv'

     

Using a code cell (Python)

import pandas as pd
df = pd.read_csv('our_file.csv')

Let's practice!

Introduction to DataLab