cleaned_up_sheet = {
const raw_sheet = raw_data.sheet("Other high priority openings", {headers: true});
return raw_sheet.map((d) => {
const each_city = d.Location.split("\n");
const BU = d['BU '];
const job_title = d['Job Title '];
const other_titles = d['Other titles'];
return {BU, job_title, other_titles, each_city};
});
}
viewof clean = aq.from(cleaned_up_sheet)
.unroll('each_city')
.view()
Inputs.table(clean)
//raw_sheet = raw_data.sheet("Other high priority openings", {headers: true})
raw_data = file.xlsx()
// this is a really cool way of displaying tables. Much more aesthetically pleasing than the defaults of arquero and input.table
import { formatTable } from "@saneef/pretty-tables"
import {toc} from "@nebrius/indented-toc"
date_parser = d3.utcParse('%m/%d/%Y')
// sample of how to place html blocks in a grid
// html `<div style="display: grid; grid-template-columns: 1fr 1fr 1fr; column-gap: 0px; row-gap: 5px;">
// ${viewof spend}
// ${viewof cpl}
// ${viewof cpc}
// </div>`
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.
