The avatar for @observablehq
Observable
The end-to-end solution for building and hosting better data apps, dashboards, and reports.
Public
Edited
Apr 4, 2023
6 forks
Importers
24 stars
Hands-on Tutorials
Hands-on tutorialsLearn Just Enough JavaScript: IntroductionObservable Quick GuidesBuild your first scatterplot with Observable PlotGet started with the Chart cellBuild your first map with Observable PlotBuild your first choropleth map with Observable PlotPlot from ggplot2Analyzing revenue by category for an online store
Which items are purchased together?
Wrangling data in JavaScript with Arquero: a primer for R users
Observable for Excel Users
(5)
Also listed in…
Which items are purchased together
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db
with purchased_items as (
SELECT * FROM events
JOIN items ON events.item_id = items.id
WHERE type = 'purchase'
)
select
name,
count(*)::INT as count,
sum(price_in_usd)::INT as revenue,
FIRST(category) as category
from purchased_items
group by name, category
order by count desc
Insert cell
Insert cell
data = getFiltered(search, items, links)
Insert cell
data2 = getFiltered([search2], items, links)
Insert cell
function getFiltered(search, items, links) {
const searchedLinks = links.filter(l => search.find(d => d?.name === l.item_a || d?.name === l.item_b))
const searchedItems = items.filter(d => searchedLinks.find(l => d.name === l.item_a || d.name === l.item_b))
return {
nodes: searchedItems,
links: searchedLinks
}
}
Insert cell
dateFormat = d3.utcFormat("%Y-%m-%d")
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
notebooks = [
{
title: "Which items are purchased together?",
path:
"@observablehq/which-items-are-purchased-together",
thumbnail: "b39e834adfbe703df48916786d9a9bfef04dc0100c3b684a44db43878c28b266"
},
{
title: "Part 1: Co-occurrence SQL query",
path:
"@observablehq/arsc-part-1-co-occurrence-sql-query",
thumbnail: "5fb57905caca18de4511d89f9ec6b3dfb8dfa6c6b38f62d2798e7cb7e9b4c4e2"
},
{
title: "Part 2: Interactive filtering",
path:
"@observablehq/arsc-part-2-interactive-filtering",
thumbnail: "7bb7f01497112ba5c08237ffeea20ccc87dbbc03b646afc9ffb32a3e38c024ef"
},
{
title: "Part 3: Matrix visualization",
path:
"@observablehq/arsc-part-3-matrix-visualization",
thumbnail: "6788484f6814389c2ccdab1a2a00f0ddffdb3f88bc5e870a5d6a3194631a2c61"
},
{
title: "Part 4: Force layout visualization",
path:
"@observablehq/arsc-part-4-force-layout-visualization",
thumbnail: "915226635db14cbb92290d78ef53a37c834437861a1e124cbfeb1d6385d8e11b"
},
].map(d => ({...d, collection: collection.path}))
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more