The avatar for @dis-2024-spring
DIS-2024-SPRING
Public
Edited
Apr 5, 2024
Fork of Exploratory data analysis
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// Describe the tables in the database
db.describe()
Insert cell
Insert cell
db
select * from items
limit 5
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db
-- type your SQL code here
select * from events where type = 'purchase'
Insert cell
db
select DISTINCT type from events
Insert cell
Insert cell
Insert cell
Insert cell
db
select * from events
join items on events.item_id = items.id
where type = 'purchase'
LIMIT 5
Insert cell
Insert cell
db
select name, category, brand,
count(*)::int as count,
sum(price_in_usd)::int as revenue
from events
join items on events.item_id = items.id
where type = 'purchase'
group by name, category, brand
order by revenue desc
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
viewof table = Inputs.table(items,{})
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
SummaryTable(items)
Insert cell
Insert cell
Insert cell
Insert cell
search
Insert cell
// type your code here
Inputs.table(search)
Insert cell
SummaryTable(search)
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Plot.plot({
marginLeft: 100,
marks: [
Plot.dot(items, {x: "count", y: "revenue"})
]
})
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
// type your code here
Plot.plot({
marginLeft: 100,
marks: [
Plot.text(items, {
x: "count",
y: "revenue",
text: "name",
textAnchor: "end",
dx: -5,
fill: "category",
fontSize: (d) => d.count / 15,
//filter: d=> d.category != "Apparel"
filter: d=> d.revenue>limit //removes text if it makes less than limit
}),
Plot.dot(items, { x: "count", y: "revenue", fill: "category",filter: d=> d.category != "Apparel"})
],
color: {
legend: true,
columns: "100px" // aligns the legend
}
})
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here
Plot.plot({
marginLeft: 100,
marks: [
Plot.ruleY([limit]),
Plot.text(items, {
x: "count",
y: "revenue",
text: "name",
textAnchor: "end",
dx: -5,
fill: "category",
fontSize: (d) => d.count / 15,
//filter: d=> d.category != "Apparel"
filter: d=> d.revenue>limit //removes text if it makes less than limit
}),
Plot.dot(items, { x: "count", y: "revenue", fill: "category"})
],
color: {
legend: true,
columns: "100px" // aligns the legend
}
})
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
viewof numItems = Inputs.range([10,100], {step: 1})
Insert cell
Plot.plot({
marginLeft: 250,
marks: [
Plot.barX(items, {
x: "revenue",
y: "name",
sort: { y: "x", reverse: true, limit: numItems }
})
]
})
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Plot.plot({
marginLeft:250,
marks: [
Plot.barX(items, {
x: "revenue",
y: "name",
fillOpacity: d => d.name.includes(highlight) ? 1 : .4,
fill: "brand",
sort: { y: "x", reverse: true, limit: numItems }
})
],
color: {
legend: true,
columns: "100px" // aligns the legend
}
})
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
viewof highlight = Inputs.text({label: "Search in chart"})
Insert cell
// type your code here
Plot.plot({
marginLeft:250,
marks: [
Plot.barX(items, {
x: "revenue",
y: "category",
order: "brand",
fillOpacity: d => d.name.includes(highlight) ? 1 : .4,
fill: "brand",
sort: { y: "x", reverse: true, limit: numItems }
})
],
color: {
legend: true,
columns: "100px" // aligns the legend
}
})
Insert cell
Insert cell
Insert cell
// Get the unique list of brands in the dataset for the checkboxes below
brandOptions = new Set(items.map(d => d.brand))
Insert cell
Insert cell
// type your code here
Plot.plot({
marginLeft:250,
marks: [
Plot.barX(items, {
x: "revenue",
filter: d => brands.includes(d.brand),
y: "category",
order: "brand",
fillOpacity: d => d.name.includes(highlight) ? 1 : .4,
fill: "brand",
sort: { y: "x", reverse: true, limit: numItems }
})
],
color: {
legend: true,
columns: "100px" // aligns the legend
}
})
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here
// Draw vertical bars
Plot.barY(
items,
// Group data into categories along the x axis
Plot.groupX(
{ y: "mean" }, // compute + display the count of observations in each group
{ x: "brand", y: "revenue" } // group observations by the `brand`
)
).plot()
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
viewof reducer = Inputs.radio(["mean", "min", "max", "deviation", "sum"], {
value: "mean",
label: "Summary statistic (reducer):"
})
Insert cell
// type your code here
// Draw vertical bars
Plot.barY(
items,
// Group data into categories along the x axis
Plot.groupX(
{ y: reducer }, // compute + display the count of observations in each group
{ x: "brand", y: "revenue" } // group observations by the `brand`
)
).plot()
Insert cell
Insert cell
Insert cell
Insert cell
db
select brand, date_trunc('day', date) as day, SUM(price_in_usd)::INT as revenue from events
left join items on events.item_id = items.id
where type = 'purchase'
group by brand, day
Insert cell
Insert cell
viewof windowSize = Inputs.range([0, 20], {value:7, step: 1})
Insert cell
// type your code here
Plot.plot({
marks: [
Plot.line(
byDay,
Plot.windowY(
{ y: "mean", k: windowSize },
{ x: "day", y: "revenue", stroke: "brand" }
)
),
Plot.dot(
byDay,
Plot.windowY(
{ y: "mean", k: windowSize },
{ x: "day", y: "revenue", stroke: "brand" }
)
),
Plot.text(
byDay,
Plot.selectMaxY(
Plot.windowY(
{ y: "mean", k: 7 },
{
x: "day",
y: "revenue",
fill: "brand",
text: (d) => d3.utcFormat("%a, %b %d") (d.day), dy:-10
}
)
)
)
],
color: {
legend: true
}
})
Insert cell
Insert cell
Insert cell
Insert cell
viewof k = Inputs.range([1, 30], {
label: "Number of days for moving average (K)",
value: 7,
step: 1
})
Insert cell
// type your code here
Insert cell
Insert cell
Insert cell
Insert cell
import { Treemap } from "@d3/treemap"
Insert cell
tree = Treemap(items, {
path: (d) => d.category + "/" + d.name,
value: (d) => d?.revenue, // size of each node
group: (d) => d.category, // for color
label: (d, n) => d.name + "\n" + numformat(d.revenue) + "\n " + d.category,
width: width,
height: 700
})
Insert cell
numformat = d3.format(",d")
Insert cell
Insert cell
import {showMe} from "@observablehq/show-me"
Insert cell
import {toc} from "@nebrius/indented-toc"
Insert cell
sampleData = d3.range(100).map(d => ({x: Math.random(), y: Math.random()}))
Insert cell
Insert cell
getSnippet = () => svg`<svg width="16" height="20" viewBox="0 -4 16 16" fill="none"><path d="M13 3H3C2.44772 3 2 3.44772 2 4V12C2 12.5523 2.44772 13 3 13H13C13.5523 13 14 12.5523 14 12V4C14 3.44772 13.5523 3 13 3Z" stroke="currentColor" stroke-width="2"></path><rect x="4" y="9" width="2" height="2" rx="0.5" fill="currentColor"></rect><rect x="7" y="5.5" width="2" height="5.5" rx="0.5" fill="currentColor"></rect><rect x="10" y="7" width="2" height="4" rx="0.5" fill="currentColor"></rect></svg>`
Insert cell
getTop10 = () => svg`<svg width="30" height="20" viewBox="0 0 60 25" fill="none" class="jsx-98319bc75a420d73 mr2 ba b--light-gray moon-gray snippet-thumbnail" style="border-radius: 5px;"><rect width="60" height="40" rx="4" fill="#F5F5F5"></rect><rect x="8.5" y="8.5" width="43" height="23" rx="1.5" fill="white" stroke="currentColor"></rect><rect x="10" y="10" width="33" height="6" rx="1" fill="currentColor"></rect><rect x="10" y="17" width="16" height="6" rx="1" fill="currentColor"></rect><rect x="10" y="24" width="10" height="6" rx="1" fill="currentColor"></rect></svg>`
Insert cell
getScatter = () => svg`<svg width="30" height="20" viewBox="0 0 60 40" fill="none" class="jsx-285534909 mr2 ba b--light-gray moon-gray snippet-thumbnail" style="border-radius: 5px;"><rect width="60" height="40" rx="4" fill="#F5F5F5"></rect><rect x="8.5" y="8.5" width="43" height="23" rx="1.5" fill="white" stroke="#C4C4C4"></rect><circle cx="15.5" cy="25.5" r="2" stroke="currentColor"></circle><circle cx="19.5" cy="20.5" r="2" stroke="currentColor"></circle><circle cx="21.5" cy="21.5" r="2" stroke="currentColor"></circle><circle cx="33.5" cy="19.5" r="2" stroke="currentColor"></circle><circle cx="39.5" cy="18.5" r="2" stroke="currentColor"></circle><circle cx="41.5" cy="17.5" r="2" stroke="currentColor"></circle><circle cx="28.5" cy="23.5" r="2" stroke="currentColor"></circle><circle cx="25.5" cy="17.5" r="2" stroke="currentColor"></circle><circle cx="45.5" cy="13.5" r="2" stroke="currentColor"></circle></svg>`
Insert cell
getRange = () =>
svg`<svg width="40" height="20" viewBox="0 0 60 30" fill="none" class="jsx-285534909 mr2 ba b--light-gray moon-gray snippet-thumbnail" style="border-radius: 5px;"><rect width="60" height="40" rx="4" ></rect><rect x="7.5" y="17.5" width="47" height="5" rx="2.5" fill="white" stroke="currentColor"></rect><rect x="7" y="17" width="33" height="6" rx="3" fill="currentColor"></rect><circle cx="38" cy="20" r="5.5" fill="white" stroke="currentColor"></circle></svg>`
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.
Learn more