Platform
Resources
Pricing
Sign in
Get started
Columbia Data Club
The Data Club, brought to you by Research Data Services
Workspace
Fork
Public
By
Moacir P. de Sá Pereira
Edited
Dec 5
1 fork
5
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
data.csv
Filter
2
Columns
Sort
Slice
Save
Type Table, then Shift-Enter. Ctrl-space for more options.
Insert cell
data
Clear All
Swap X/Y
Customize
X
pickup_datetime
Y
—
tip_percentage
Color
—
Size
—
Facet X
—
Facet Y
—
Mark
Auto
Type Chart, then Shift-Enter. Ctrl-space for more options.
Insert cell
Insert cell
aqDf
.
view
(
)
Insert cell
Insert cell
Insert cell
Insert cell
aqDfByHour
=
aqDf
.
groupby
(
"hour"
)
.
rollup
(
{
trips
:
(
d
)
=>
op
.
mean
(
d
.
trip_count
)
}
)
Insert cell
Plot
.
plot
(
{
marginLeft
:
50
,
x
:
{
interval
:
1
,
label
:
"Hour number"
}
,
marks
:
[
Plot
.
barY
(
aqDf
.
groupby
(
"hour"
)
.
rollup
(
{
trips
:
(
d
)
=>
op
.
mean
(
d
.
trip_count
)
}
)
,
{
y
:
"trips"
,
x
:
"hour"
,
fill
:
"blue"
,
fillOpacity
:
0.2
}
)
,
Plot
.
ruleY
(
[
0
]
)
]
}
)
Insert cell
Insert cell
Plot
.
plot
(
{
marginLeft
:
50
,
x
:
{
interval
:
1
,
label
:
"Hour number"
}
,
y
:
{
label
:
"Average Temperature (°C)"
}
,
marks
:
[
Plot
.
barY
(
aqDf
.
groupby
(
"hour"
)
.
rollup
(
{
temperature
:
(
d
)
=>
op
.
mean
(
d
.
temperature
)
}
)
,
{
y
:
"temperature"
,
x
:
"hour"
,
fill
:
"blue"
,
fillOpacity
:
0.2
}
)
,
Plot
.
ruleY
(
[
0
]
)
]
}
)
Insert cell
Insert cell
aqDfTemp
=
aqDf
.
groupby
(
"date"
)
.
rollup
(
{
minTemp
:
(
d
)
=>
op
.
min
(
d
.
temperature
)
,
maxTemp
:
(
d
)
=>
op
.
max
(
d
.
temperature
)
}
)
Insert cell
Plot
.
plot
(
{
marginLeft
:
50
,
x
:
{
interval
:
1
,
label
:
"Day"
}
,
y
:
{
label
:
"Temperature (°C)"
}
,
marks
:
[
Plot
.
lineY
(
aqDfTemp
,
{
y
:
"maxTemp"
,
x
:
"date"
}
)
,
Plot
.
lineY
(
aqDfTemp
,
{
y
:
"minTemp"
,
x
:
"date"
}
)
,
Plot
.
ruleY
(
[
0
]
)
]
}
)
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
data
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
File attachments
complete_weather_and_taxi_data.parquet
Parquet
lululemon_x_25000.parquet
Parquet
sampled-1m-2024-yellowcab-trips.parquet
Parquet
GHCNh_USW00094728_2024.parquet
Parquet
data.csv
CSV
Databases
Filter
pickup_datetime
Operator
tip_percentage
Operator
Column
Operator
Columns
Sort
Column
Direction
Descending
Ascending
Slice
From
Start
To
End
Add comment
Select
Duplicate
Copy link
Embed
Delete
Cells
data
File attachments
data.csv
CSV
Customize
Clear
Title
Subtitle
Caption
Height
Width
Auto
Full
Margin
Top
Right
Bottom
Left
Inset
Legend
Auto
None
X label
X scale
Auto
Scale
Auto
linear
log
sqrt
symlog
point
band
X options
Grid
Reverse
Y label
Y scale
Auto
Scale
Auto
linear
log
sqrt
symlog
point
band
Y options
Grid
Reverse
Color scheme
Auto
Color scheme
Auto
Default color schemes
Sequential
Diverging
Cyclical
Categorical
Sequential color schemes
Blues
Greens
Greys
Oranges
Purples
Reds
Turbo
Viridis
Inferno
Magma
Plasma
Cividis
Warm
Cool
BuGn
BuPu
GnBu
OrRd
PuBuGn
PuBu
PuRd
RdPu
YlGnBu
YlGn
YlOrBr
YlOrRd
Diverging color schemes
BrBG
PRGn
PiYG
PuOr
RdBu
RdGy
RdYlBu
RdYlGn
Spectral
Cyclical color schemes
Sinebow
Turbo
Categorical color schemes
Category10
Accent
Dark2
Paired
Pastel1
Pastel2
Set1
Set2
Set3
Tableau10
Color scale
Auto
Scale
Auto
linear
log
sqrt
symlog
categorical
ordinal
Color options
Reverse
Reducer
—
Auto
—
count
distinct
sum
min
max
mean
median
mode
Field
—
Reducer
—
Auto
count
distinct
sum
min
max
mean
median
mode
Field
—
Reducer
—
Auto
—
count
distinct
sum
min
max
mean
median
mode
Field
—
Reducer
—
Auto
—
count
distinct
sum
min
max
mean
median
mode
Field
—
Field
—
Field
—
Mark
Auto
—
bar
dot
line
area
rule
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
aqDfByHour
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
aqDfTemp
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
arrow
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
readParquet
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
arrowTable
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
complete_weather_and_taxi_data
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
aqDf
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
turtles
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML