This tutorial will walk you through how to use Scroll for data analysis and visualization, from basic concepts to advanced techniques.

Let's dive in!

---

Scroll comes with several sample datasets. Let's start with the famous iris dataset:

iris printTable

sepal_length	sepal_width	petal_length	petal_width	species
6.1	3	4.9	1.8	virginica
5.6	2.7	4.2	1.3	versicolor
5.6	2.8	4.9	2	virginica
6.2	2.8	4.8	1.8	virginica
7.7	3.8	6.7	2.2	virginica
5.3	3.7	1.5	0.2	setosa
6.2	3.4	5.4	2.3	virginica
4.9	2.5	4.5	1.7	virginica
5.1	3.5	1.4	0.2	setosa
5	3.4	1.5	0.2	setosa

You can also load datasets from Vega's collection:

sampleData zipcodes.csv limit 0 5 printTable

Let's explore some basic operations on the iris dataset:

iris summarize printTable

name	type	incompleteCount	uniqueCount	count	sum	median	mean	min	max	mode
sepal_length	number	0	8	10	57.699999999999996	5.6	5.77	4.9	7.7	5.6
sepal_width	number	0	8	10	31.599999999999998	3.2	3.1599999999999997	2.5	3.8	2.8
petal_length	number	0	8	10	39.8	4.65	3.9799999999999995	1.4	6.7	4.9
petal_width	number	0	7	10	13.699999999999996	1.75	1.3699999999999997	0.2	2.3	0.2
species	string	0	3	10						virginica

This gives us summary statistics for each column.

Let's look at filtering:

iris where species = setosa printTable where species oneOf setosa virginica printTable

sepal_length	sepal_width	petal_length	petal_width	species
5.3	3.7	1.5	0.2	setosa
5.1	3.5	1.4	0.2	setosa
5	3.4	1.5	0.2	setosa

sepal_length	sepal_width	petal_length	petal_width	species
6.1	3	4.9	1.8	virginica
5.6	2.8	4.9	2	virginica
6.2	2.8	4.8	1.8	virginica
7.7	3.8	6.7	2.2	virginica
5.3	3.7	1.5	0.2	setosa
6.2	3.4	5.4	2.3	virginica
4.9	2.5	4.5	1.7	virginica
5.1	3.5	1.4	0.2	setosa
5	3.4	1.5	0.2	setosa

---

Let's start with a simple scatterplot of the iris data:

iris scatterplot x sepal_width y sepal_length title Sepal Length vs Width fill species

Let's look at some time series data:

sampleData seattle-weather.csv parseDate date linechart x date y temp_max title Maximum Temperature in Seattle stroke steelblue

Let's create a bar chart showing precipitation:

sampleData seattle-weather.csv groupBy weather reduce precipitation mean precip_avg barchart x weather y precip_avg fill teal title Average Precipitation by Weather Type

---

Let's look at some more complex transformations:

sampleData weather.csv groupBy weather reduce temp_max mean avg_max_temp reduce temp_min mean avg_min_temp orderBy -avg_max_temp printTable

count	avg_max_temp	avg_min_temp

Let's add some computed columns:

iris compute ratio {sepal_length}/{sepal_width} where ratio > 2 printTable

sepal_length	sepal_width	petal_length	petal_width	species	ratio
6.1	3	4.9	1.8	virginica	2.033333333333333
5.6	2.7	4.2	1.3	versicolor	2.074074074074074
6.2	2.8	4.8	1.8	virginica	2.2142857142857144
7.7	3.8	6.7	2.2	virginica	2.0263157894736845

---

Let's create a heatmap of annual precipitation values:

sampleData seattle-weather.csv splitYear groupBy year reduce precipitation mean precipitation_mean select year precipitation_mean transpose heatrix

You can create multiple visualizations:

iris scatterplot x sepal_length y sepal_width fill species barchart x species y sepal_length fill teal title Sepal Length by Species

---

This tutorial covered the basics of data science with Scroll. Some key takeaways:

• Scroll makes it easy to load and manipulate data
• Visualizations are simple to create and customize
• Complex transformations can be done with simple commands
• Everything is readable and version-controllable

Built with Scroll v178.3.0