The avatar for @data30
data
Public
Edited
Apr 28
1 fork
1 star
1
Insert cell
Insert cell
Insert cell
landscape.parquet
select *
from landscape
where gh_stars > 0
order by gh_stars desc
Insert cell
Insert cell
landscape.parquet
select category, count(*) as items
from landscape
group by 1
order by 2 desc
Insert cell
Plot.plot({
marginLeft: 200,
x: {
grid: true,
label: "Number of Items"
},
y: {
label: null
},
marks: [
Plot.barX(categories_by_items, {
y: "category",
x: "items",
sort: {y: "-x"},
fill: "steelblue"
})
]
})
Insert cell
landscape
select concat(category, '-', subcategory) as category, count(*) as items
from landscape
group by 1
order by 2 desc
Insert cell
Plot.plot({
marginLeft: 200,
x: {
grid: true,
label: "Number of Items"
},
y: {
label: null
},
marks: [
Plot.barX(subcategories, {
y: "category",
x: "items",
sort: {y: "-x"},
fill: "steelblue"
})
]
})
Insert cell
landscape.parquet
select concat(category, '-', subcategory) as category, count(*) as items
from landscape
where gh_stars > 0
group by 1
order by 2 desc
Insert cell
Insert cell
viewof category = Inputs.text({label: "Category", placeholder: "Choose a category", datalist: categories_by_items.map(d => d.category)})
Insert cell
viewof chosenSubcategory = Inputs.text({label: "Subcategory", placeholder: "Choose a subcategory", datalist: subcategories.map(d => d.category)})
Insert cell
landscape
select name, gh_stars, concat(category, '-', subcategory) as category
from landscape
where concat(category, '-', subcategory) = ${chosenSubcategory.category}
and gh_stars > 0
order by gh_stars desc
Insert cell
landscape.parquet
select distinct category
from landscape
order by 1 asc
Insert cell
function getSubcategoriesForCategory(category) {
return sql`SELECT DISTINCT subcategory FROM landscape WHERE category = ${category} ORDER BY subcategory`;
}
Insert cell
viewof categoryInput = Inputs.text({
label: "Category",
placeholder: "Type to search categories...",
// autocomplete: categories,
datalist: categories.map(d => d.category),
})
Insert cell
getSubcategoriesForCategory(categoryInput.value)
Insert cell
viewof subcategoryInput = Inputs.text({
label: "Subcategory",
placeholder: "Type to subcategories...",
datalist: getSubcategoriesForCategory(categoryInput.value).map(d => d.subcategory)
})
Insert cell
viewof combinedCategoriesInput = Inputs.text({
label: "Subcategory",
placeholder: "Type to subcategories...",
datalist: combinedCategories.map(d => d.combined_value)
})
Insert cell
landscape.parquet
SELECT name, gh_stars, category, subcategory
FROM landscape
WHERE category || ' > ' || subcategory = ${combinedCategoriesInput}
and gh_stars > 0
ORDER BY gh_stars desc
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