Public
Edited
Mar 3, 2023
Insert cell
import {SimpleData} from "@nshiab/importing-data-simple-data-analysis"
Insert cell
Insert cell
Insert cell
Insert cell
citiesInfoRaw = new SimpleData().loadDataFromUrl({
url: "https://raw.githubusercontent.com/nshiab/cities-temperature-example/main/output/cities-for-observable/cities-info.csv"
})
Insert cell
citiesInfoRaw.clone().checkValues().showTable()
Insert cell
citiesInfoRaw.showTable()
Insert cell
citiesDataRaw = new SimpleData().loadDataFromUrl({
autoType: true,
url: [
"https://raw.githubusercontent.com/nshiab/cities-temperature-example/main/output/cities-for-observable/1.csv",
"https://raw.githubusercontent.com/nshiab/cities-temperature-example/main/output/cities-for-observable/3.csv"
]
})
Insert cell
citiesDataRaw.showTable()
Insert cell
Insert cell
citiesDataCleaned = citiesDataRaw.clone().keepNumbers({ key: "tmax" })
Insert cell
citiesDataCleaned
.clone()
.checkValues({ nbItemsToCheck: 25000, randomize: true })
.showTable()
Insert cell
Insert cell
citiesDataRestructured = citiesDataCleaned.clone().mergeItems({
dataToBeMerged: citiesInfoRaw,
commonkey:"id"
})
.addkey({
key:"year",
itemGenerator: (item) => item.date.getFullYear() }) // itemGenerator is a function that will be applied to each item.
.addKey({
key: "decade",
itemGenerator: (item) => Math.floor(item.year / 10) * 10
})
Insert cell
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