31:T837,make_map = (data, title) => { return d => { d.append('text') .attr('font-size', 14) .attr('fill', '#fff') .attr('text-anchor', 'end') .attr("transform", d => `translate(180,20)`) .text(title); d.append('text') .attr('font-size', 12) .attr('fill', '#ddd') .attr('text-anchor', 'end') .attr("transform", d => `translate(180,35)`) .text(d3.format(',')(d3.sum(Object.values(data)))); d.selectAll('path.state_shape_base') .data(states_map) .enter() .append('path') .classed('state_shape_base', true) .attr("d", path) .attr("fill", d => { return "#ffffff"; }); d.selectAll('path.state_shape') .data(states_map) .enter() .append('path') .classed('state_shape', true) .attr("fill", d => { var st = d.properties.ST_NM; var match = get_closest_state(st); return `rgba(255,88,89,${color(data[match]) || 0})`; }) .attr("stroke", "#7d7d7d") .attr("stroke-width", 0.1) .attr("stroke-linejoin", "round") .attr("d", path); d.selectAll("circle") .data(states_map) .enter() .append("circle") .attr("transform", d => `translate(${path.centroid(d)})`) .attr("stroke", "#004382") .attr("stroke-width", 0.1) .attr("fill", "#FEE969") .attr("r", d => { var st = d.properties.ST_NM; var match = get_closest_state(st); return radius(data[match]); }); d.selectAll("text.state") .data(states_map) .enter() .append("text") .attr('class', 'state') .attr("transform", d => `translate(${path.centroid(d)})`) .attr("fill", "#222") .attr("stroke", "rgba(255,255,255,0.5)") .attr("font-size", 7.5) .attr("text-anchor", "middle") .attr("alignment-baseline", "middle") .attr("paint-order", "stroke") .text(d => { var st = d.properties.ST_NM; var match = get_closest_state(st); if (data[match]) return d3.format(",")(data[match]); }); }; }32:T1e3c,FuzzySet = function(arr, useLevenshtein, gramSizeLower, gramSizeUpper) { var fuzzyset = {}; // default options arr = arr || []; fuzzyset.gramSizeLower = gramSizeLower || 2; fuzzyset.gramSizeUpper = gramSizeUpper || 3; fuzzyset.useLevenshtein = typeof useLevenshtein !== 'boolean' ? true : useLevenshtein; // define all the object functions and attributes fuzzyset.exactSet = {}; fuzzyset.matchDict = {}; fuzzyset.items = {}; // helper functions var levenshtein = function(str1, str2) { var current = [], prev, value; for (var i = 0; i <= str2.length; i++) for (var j = 0; j <= str1.length; j++) { if (i && j) if (str1.charAt(j - 1) === str2.charAt(i - 1)) value = prev; else value = Math.min(current[j], current[j - 1], prev) + 1; else value = i + j; prev = current[j]; current[j] = value; } return current.pop(); }; // return an edit distance from 0 to 1 var _distance = function(str1, str2) { if (str1 === null && str2 === null) throw 'Trying to compare two null values'; if (str1 === null || str2 === null) return 0; str1 = String(str1); str2 = String(str2); var distance = levenshtein(str1, str2); if (str1.length > str2.length) { return 1 - distance / str1.length; } else { return 1 - distance / str2.length; } }; var _nonWordRe = /[^a-zA-Z0-9\u00C0-\u00FF, ]+/g; var _iterateGrams = function(value, gramSize) { gramSize = gramSize || 2; var simplified = '-' + value.toLowerCase().replace(_nonWordRe, '') + '-', lenDiff = gramSize - simplified.length, results = []; if (lenDiff > 0) { for (var i = 0; i < lenDiff; ++i) { simplified += '-'; } } for (var i = 0; i < simplified.length - gramSize + 1; ++i) { results.push(simplified.slice(i, i + gramSize)); } return results; }; var _gramCounter = function(value, gramSize) { // return an object where key=gram, value=number of occurrences gramSize = gramSize || 2; var result = {}, grams = _iterateGrams(value, gramSize), i = 0; for (i; i < grams.length; ++i) { if (grams[i] in result) { result[grams[i]] += 1; } else { result[grams[i]] = 1; } } return result; }; // the main functions fuzzyset.get = function(value, defaultValue, minMatchScore) { // check for value in set, returning defaultValue or null if none found if (minMatchScore === undefined) { minMatchScore = .33; } var result = this._get(value, minMatchScore); if (!result && typeof defaultValue !== 'undefined') { return defaultValue; } return result; }; fuzzyset._get = function(value, minMatchScore) { var results = []; // start with high gram size and if there are no results, go to lower gram sizes for ( var gramSize = this.gramSizeUpper; gramSize >= this.gramSizeLower; --gramSize ) { results = this.__get(value, gramSize, minMatchScore); if (results && results.length > 0) { return results; } } return null; }; fuzzyset.__get = function(value, gramSize, minMatchScore) { var normalizedValue = this._normalizeStr(value), matches = {}, gramCounts = _gramCounter(normalizedValue, gramSize), items = this.items[gramSize], sumOfSquareGramCounts = 0, gram, gramCount, i, index, otherGramCount; for (gram in gramCounts) { gramCount = gramCounts[gram]; sumOfSquareGramCounts += Math.pow(gramCount, 2); if (gram in this.matchDict) { for (i = 0; i < this.matchDict[gram].length; ++i) { index = this.matchDict[gram][i][0]; otherGramCount = this.matchDict[gram][i][1]; if (index in matches) { matches[index] += gramCount * otherGramCount; } else { matches[index] = gramCount * otherGramCount; } } } } function isEmptyObject(obj) { for (var prop in obj) { if (obj.hasOwnProperty(prop)) return false; } return true; } if (isEmptyObject(matches)) { return null; } var vectorNormal = Math.sqrt(sumOfSquareGramCounts), results = [], matchScore; // build a results list of [score, str] for (var matchIndex in matches) { matchScore = matches[matchIndex]; results.push([ matchScore / (vectorNormal * items[matchIndex][0]), items[matchIndex][1] ]); } var sortDescending = function(a, b) { if (a[0] < b[0]) { return 1; } else if (a[0] > b[0]) { return -1; } else { return 0; } }; results.sort(sortDescending); if (this.useLevenshtein) { var newResults = [], endIndex = Math.min(50, results.length); // truncate somewhat arbitrarily to 50 for (var i = 0; i < endIndex; ++i) { newResults.push([ _distance(results[i][1], normalizedValue), results[i][1] ]); } results = newResults; results.sort(sortDescending); } newResults = []; results.forEach( function(scoreWordPair) { if (scoreWordPair[0] >= minMatchScore) { newResults.push([scoreWordPair[0], this.exactSet[scoreWordPair[1]]]); } }.bind(this) ); return newResults; }; fuzzyset.add = function(value) { var normalizedValue = this._normalizeStr(value); if (normalizedValue in this.exactSet) { return false; } var i = this.gramSizeLower; for (i; i < this.gramSizeUpper + 1; ++i) { this._add(value, i); } }; fuzzyset._add = function(value, gramSize) { var normalizedValue = this._normalizeStr(value), items = this.items[gramSize] || [], index = items.length; items.push(0); var gramCounts = _gramCounter(normalizedValue, gramSize), sumOfSquareGramCounts = 0, gram, gramCount; for (gram in gramCounts) { gramCount = gramCounts[gram]; sumOfSquareGramCounts += Math.pow(gramCount, 2); if (gram in this.matchDict) { this.matchDict[gram].push([index, gramCount]); } else { this.matchDict[gram] = [[index, gramCount]]; } } var vectorNormal = Math.sqrt(sumOfSquareGramCounts); items[index] = [vectorNormal, normalizedValue]; this.items[gramSize] = items; this.exactSet[normalizedValue] = value; }; fuzzyset._normalizeStr = function(str) { if (Object.prototype.toString.call(str) !== '[object String]') throw 'Must use a string as argument to FuzzySet functions'; return str.toLowerCase(); }; // return length of items in set fuzzyset.length = function() { var count = 0, prop; for (prop in this.exactSet) { if (this.exactSet.hasOwnProperty(prop)) { count += 1; } } return count; }; // return is set is empty fuzzyset.isEmpty = function() { for (var prop in this.exactSet) { if (this.exactSet.hasOwnProperty(prop)) { return false; } } return true; }; // return list of values loaded into set fuzzyset.values = function() { var values = [], prop; for (prop in this.exactSet) { if (this.exactSet.hasOwnProperty(prop)) { values.push(this.exactSet[prop]); } } return values; }; // initialization var i = fuzzyset.gramSizeLower; for (i; i < fuzzyset.gramSizeUpper + 1; ++i) { fuzzyset.items[i] = []; } // add all the items to the set for (i = 0; i < arr.length; ++i) { fuzzyset.add(arr[i]); } return fuzzyset; }33:[{"id":"cf44bb5e6255a3c1cc73eb657a1744cd4b527333d18dece17e124c01325b4679209d3b181a0cadc5303204bbc0d7c134b9d854b3db6fad9ebccb07ef4fc96710","href":"https://static.observableusercontent.com/files/cf44bb5e6255a3c1cc73eb657a1744cd4b527333d18dece17e124c01325b4679209d3b181a0cadc5303204bbc0d7c134b9d854b3db6fad9ebccb07ef4fc96710","name":"State-Confirmed_Full_Data_data@1.csv","type":"text/csv","lastModified":1591435908597.828,"size":45678},{"id":"baf2f5aed62d2aa0a43c417f3806d80dabb3d47966027d143bf631dce0fad1a2fe8f92cda97fccfd36d49bc5342ab5515c232a533e57c6a8e5fb1cd02d0d8fbb","href":"https://static.observableusercontent.com/files/baf2f5aed62d2aa0a43c417f3806d80dabb3d47966027d143bf631dce0fad1a2fe8f92cda97fccfd36d49bc5342ab5515c232a533e57c6a8e5fb1cd02d0d8fbb","name":"india_state_topo.json","type":"application/json","lastModified":1591532439775.62,"size":233938}] 2f:{"title":"Active Corona Cases by End of Each Month in India","cells":[{"id":0,"value":"md`# Active Corona Cases by End of Each Month in India`","pinned":false,"hidden":false,"mode":"ojs"},{"id":379,"value":"chart = {\n const svg = d3\n .create(\"svg\")\n .attr(\"viewBox\", [0, 0, 600, 220])\n .style('font-family', 'Arvo')\n .style('background', '#4196B4');\n\n svg\n .append(\"g\")\n .attr('transform', 'translate(5,15)')\n .call(make_map(statewise_feb, \"February\"));\n svg\n .append(\"g\")\n .attr('transform', 'translate(205,15)')\n .call(make_map(statewise_mar, \"March\"));\n svg\n .append(\"g\")\n .attr('transform', 'translate(405,15)')\n .call(make_map(statewise_apr, \"April\"));\n\n svg\n .append('rect')\n .attr('transform', 'translate(195,40)')\n .attr('fill', '#dedede')\n .attr('fill-opacity', 0.2)\n .attr('width', 0.5)\n .attr('height', 160);\n svg\n .append('rect')\n .attr('transform', 'translate(395,40)')\n .attr('fill', '#dedede')\n .attr('fill-opacity', 0.2)\n .attr('width', 0.5)\n .attr('height', 160);\n\n return svg.node();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":649,"value":"md`### Chart Implementation`","pinned":false,"hidden":false,"mode":"ojs"},{"id":553,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":376,"value":"path = d3.geoPath(\n d3\n .geoMercator()\n .fitWidth(170, topojson.feature(topo, topo.objects.india_state))\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":377,"value":"radius = d3\n .scaleSqrt()\n .domain([0, 12000])\n .range([0, 10])","pinned":false,"hidden":false,"mode":"ojs"},{"id":481,"value":"color = d3.scaleSqrt().domain([0, 12000])","pinned":false,"hidden":false,"mode":"ojs"},{"id":673,"value":"font = md``","pinned":false,"hidden":false,"mode":"ojs"},{"id":456,"value":"md`### Summarize`","pinned":false,"hidden":false,"mode":"ojs"},{"id":461,"value":"statewise = {\n var nest = d3\n .nest()\n .key(d => d[\"Name of State / UT\"])\n .rollup(leaves => {\n return d3.max(leaves, k => k.cases);\n })\n .entries(data);\n var tmp = {};\n nest.map(d => {\n tmp[d.key] = d.value;\n });\n return tmp;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":527,"value":"statewise_feb = {\n var nest = d3\n .nest()\n .key(d => d[\"Name of State / UT\"])\n .rollup(leaves => {\n return d3.max(leaves, k => k.cases);\n })\n .entries(\n data.filter(\n d =>\n d.date >= d3.timeParse(\"%B %e, %Y\")(\"February 01, 2020\") &&\n d.date < d3.timeParse(\"%B %e, %Y\")(\"March 01, 2020\")\n )\n );\n var tmp = {};\n nest.map(d => {\n tmp[d.key] = d.value;\n });\n return tmp;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":544,"value":"statewise_mar = {\n var nest = d3\n .nest()\n .key(d => d[\"Name of State / UT\"])\n .rollup(leaves => {\n return d3.max(leaves, k => k.cases);\n })\n .entries(\n data.filter(\n d =>\n d.date >= d3.timeParse(\"%B %e, %Y\")(\"March 01, 2020\") &&\n d.date < d3.timeParse(\"%B %e, %Y\")(\"April 01, 2020\")\n )\n );\n var tmp = {};\n nest.map(d => {\n tmp[d.key] = d.value;\n });\n return tmp;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":547,"value":"statewise_apr = {\n var nest = d3\n .nest()\n .key(d => d[\"Name of State / UT\"])\n .rollup(leaves => {\n return d3.max(leaves, k => k.cases);\n })\n .entries(\n data.filter(\n d =>\n d.date >= d3.timeParse(\"%B %e, %Y\")(\"April 01, 2020\") &&\n d.date < d3.timeParse(\"%B %e, %Y\")(\"May 01, 2020\")\n )\n );\n var tmp = {};\n nest.map(d => {\n tmp[d.key] = d.value;\n });\n return tmp;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":446,"value":"md`### Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"data = FileAttachment(\"State-Confirmed_Full_Data_data@1.csv\")\n .text()\n .then(d =>\n d3.tsvParse(d).map(d => {\n d.date = d3.timeParse(\"%B %e, %Y\")(d[\"Day of Date\"]);\n d.cases = +(d[\"Total Confirmed cases\"].replace(/,/g, '') || 0);\n return d;\n })\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":406,"value":"topo = FileAttachment('india_state_topo.json').json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":505,"value":"states_map = topojson\n .feature(topo, topo.objects.india_state)\n .features.filter(d => {\n var st = d.properties.ST_NM;\n if (st == \"Daman & Diu\" || st == \"Lakshadweep\" || st == \"Sikkim\") {\n return false;\n } else {\n return true;\n }\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":84,"value":"dates = d3.extent(data, d => d.date)","pinned":false,"hidden":false,"mode":"ojs"},{"id":63,"value":"states = d3\n .nest()\n .key(d => d[\"Name of State / UT\"])\n .entries(data)\n .map(d => d.key)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"md`### References\n\n- https://public.tableau.com/profile/manish.khatre#!/vizhome/Covid19_India_2_15884436966190/Analysis`","pinned":false,"hidden":false,"mode":"ojs"},{"id":233,"value":"md`### Fuzzy state names`","pinned":false,"hidden":false,"mode":"ojs"},{"id":230,"value":"example = [\"Andhra\", get_closest_state('Andhra')]","pinned":false,"hidden":false,"mode":"ojs"},{"id":227,"value":"get_closest_state = d => {\n if (state_matcher.get(d) && state_matcher.get(d).length) {\n return state_matcher.get(d)[0][1];\n } else {\n return \"NA\";\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":225,"value":"state_matcher = FuzzySet(states)","pinned":false,"hidden":false,"mode":"ojs"},{"id":218,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"md`### Dependencies`","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"d3 = require(\"d3@v5\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":408,"value":"topojson = require(\"topojson-client@3\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}