raw = (await FileAttachment("songs_normalize.csv").csv({typed: true})).map(d => ({
...d,
song: String(d.song)
}))
prep = t.tidy(
raw,
// define for all-caps or all-lowercase
t.mutate({song2: d => d.song.replace(/-.*$/g, "")}),
t.mutate({song2: d => d.song2.replace(/\(.*\)/g, "")}),
t.mutate({allOne: d => d.song2.match(/^[ a-z,/']+$|^[A-Z,/']+$/)})
)
Inputs.table(prep)
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.
