A seasoned FileMaker developer, making his way into a wide open world of the future…
coronaConfirmedRawDataAttempt1 = d3.csv("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv")
coronaConfirmedRawData = d3.csv("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv",d3.autoType)
coronaConfirmedValues = Object.keys(coronaConfirmedRawData).map( k => coronaConfirmedRawData[k] )
md`# Let's just get ONE record, and see if we can transform it....`
{Lat, Long, ...rest} = coronaConfirmedRawData1
(({Lat, Long}) => ({Lat, Long}))(coronaConfirmedRawData1)
(({Province/State,Lat, Long}) => ({Province/State,Lat, Long}))(coronaConfirmedRawData1)
(({"Province/State",Lat, Long}) => ({"Province/State",Lat, Long}))(coronaConfirmedRawData1)
md`I guess you can't do destructuring on non-variable-name-compliant keys.`
Object.keys(coronaConfirmedRawData1).slice(4)
Object.keys(coronaConfirmedRawData1).slice(4).map(d => ({
key: d,
date: d.replace(/(\d+)\/(\d+)\/(\d+)/,"20$3-$1-$2")
}))
Object.keys(coronaConfirmedRawData1).slice(4).map(d => d.replace(/(\d+)\/(\d+)\/(\d+)/,"20$3-$1-$2"))
md`# Use new Date(d)`
Object.keys(coronaConfirmedRawData1).slice(4).map(d => new Date(d))
{
let result = [];
const ProvinceOrState = coronaConfirmedRawData1["Province/State"];
const CountryOrRegion = coronaConfirmedRawData1["Country/Region"];
const Lat = coronaConfirmedRawData1.Lat;
const Long = coronaConfirmedRawData1.Long
for(let k in coronaConfirmedRawData1) {
if(k.match(/\d+\/\d+\/\d+/)) {
result.push(
({
ProvinceOrState:ProvinceOrState,
CountryOrRegion:CountryOrRegion,
Lat:Lat,
Long:Long,
Occurence:coronaConfirmedRawData1[k],
Date:new Date(k)
})
)
}
}
return result
}
dataToTable = d => {
let result = [];
const ProvinceOrState = d["Province/State"];
const CountryOrRegion = d["Country/Region"];
const Lat = d.Lat;
const Long = d.Long
return Object.keys(d).slice(4).map(k => ({
ProvinceOrState:ProvinceOrState,
CountryOrRegion:CountryOrRegion,
Lat:Lat,
Long:Long,
Occurence:d[k],
Date:new Date(k)
})
)
}
coronaConfirmedTable = coronaConfirmedRawData.reduce( (r,d) => r.concat( dataToTable( d ) ) , [] )
d3 = require("d3@5", "d3-sankey@0.12")
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.
