Quick start tutorial
Overview
Use this guide to learn the basics of Datalore.
Datalore brings together:
Powerful coding assistance for Python, SQL, R, Scala, and Kotlin in Jupyter notebooks
Data integrations for SQL databases and cloud storage systems
Modern business intelligence and interactive data apps
Real-time collaboration on code and in team workspaces
For a quick overview of Datalore, check out the Getting Started with Datalore video.
First steps
Use this quick guide to learn some of the basic operations of Datalore: connecting a data source, reading your data, and quick automatic plotting. Conclude this simple by sharing your results.
Open a new notebook in the editor
On the Home page, click the New notebook. You are now redirected to the New notebook page.
(Optional) Enter your text in the Title field.
Press Enter to finish creating your notebook and open it in the editor.
At the moment, your notebook document contains only one cell. By default, it is an empty code cell.
Edit your notebook
In the first cell, enter the following code.
# Try it now import datetime now_moment = datetime.datetime.now() print('– What is the right time to start?') print('– Now!\n')To run the code of the currently active cell, press Alt+Shift+Enter.
Add a Markdown cell by hovering over the middle of the bottom border of the cell and clicking Add markdown cell.
Enter a text in your Markdown cell.
To run the code of your entire notebook, select
from the main menu.
Work with your data
Follow the procedure below to attach a .csv file and perform basic analytics on its data. For this, you will need a .cvs file with a table in it.
Prepare your dataset
Attach your .csv file to your notebook simply by dragging it into the editor.
Make sure the downloaded file is attached to the notebook. Click the Attached data icon on the left-hand sidebar. You should find your attached file on the Files tab.
View your data as a table
Use pandas, a popular library for Python, to view your dataset.
By convention, import pandas as pd:
import pandas as pdEnter the code below to access the content of your dataset and display it as a table. Make sure you specify the name of your attached .csv file in the quotation marks instead of libraries_by_python_version.csv.
libraries = pd.read_csv('libraries_by_python_version.csv') libraries
After you run your code cell, you should have a table like this:
Visualize your data set
Now, you can build a chart based on the generated table. There is no need to write any code for it. Use the interface of the cell with the generated table.
In the cell with the generated table, switch to the Visualization tab.
Customize your visualization:
For the chart type, expand the Plot type list and select one of the options :
Point(default)
Line
Bar
Area
Correlation
To set up a color palette, expand Color list and select a column.
By default, the graph represents the data from the first two columns of your DataFrame. To plot other data, expand the list for axis X or Y and select a column.
As you perform the steps above, the chart will be generated dynamically. The result should be similar to the image below.
Share your work
Now that you have done some work on your notebook, you can share it with your collaborators. In this procedure, you will grant view or edit access to every user who will have the link to the notebook.
Share your notebook by creating a link
On the editor page, click the Share button in the upper right corner of the editor to open the Share [notebook_title] dialog shown in the picture below.
Under Share notebook, expand the list and select the access type you want to grant using the link.
Click the icons next to the notebook link to open it in a new browser tab or copy the link.
(Optional) To disable the link, repeat steps 1 and 2, and select No access link.
Keywords
getting started, first notebook, demonstration, demo notebook, how to begin, quickstart