28:null 29:["$","title",null,{"children":"Data Loading | odunayo12 | Observable"}] 2e:[{"id":"9412dd022d4f39ee97056a5040bd7f17224d35ccbf5389b881ec286bd7a653d6dba34aa61eaa8a8866dc109db2ca86ee5124edb082772971c9677c1333cdbc1a","href":"https://static.observableusercontent.com/files/9412dd022d4f39ee97056a5040bd7f17224d35ccbf5389b881ec286bd7a653d6dba34aa61eaa8a8866dc109db2ca86ee5124edb082772971c9677c1333cdbc1a","name":"NatPopQuery@2.csv","type":"text/csv","lastModified":1592509520734.862,"size":21144},{"id":"e0cbbfebb269c83b6ebb47489e8682270d7431a4e4b666dd8d8ef23b7ee8e103140da206558c23b0cbea4e1dfafae6c0ec07461cb9cb099ec7439cca2eb5ab62","href":"https://static.observableusercontent.com/files/e0cbbfebb269c83b6ebb47489e8682270d7431a4e4b666dd8d8ef23b7ee8e103140da206558c23b0cbea4e1dfafae6c0ec07461cb9cb099ec7439cca2eb5ab62","name":"matches.csv","type":"text/csv","lastModified":1603465480471.36,"size":140113},{"id":"77bd5fc13d10652161d1158ef4cb5c2340ff43400fd261144b06bc3e289ed6bda3881e823f4198e61a3ab0491f4f342c46ba76573cbe982e6b741fc59613d0a9","href":"https://static.observableusercontent.com/files/77bd5fc13d10652161d1158ef4cb5c2340ff43400fd261144b06bc3e289ed6bda3881e823f4198e61a3ab0491f4f342c46ba76573cbe982e6b741fc59613d0a9","name":"mda_by_year@1.csv","type":"text/csv","lastModified":1603372328998.042,"size":175444}] 2c:{"id":"296ef513188f366f","slug":"data-loading","title":"Data Loading","thumbnail":"e6f3535e4ea15aa0e9d609bd97d59b028b5c9212ccdd4940afa14a14bdc0b132","access_level":"public","create_time":"$D2020-06-18T19:24:01.645Z","update_time":"$D2020-12-03T20:07:21.428Z","view_time":null,"first_public_time":"$D2020-10-09T09:33:27.613Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"871fd20b3a566363","login":"odunayo12","name":"","avatar_url":"https://avatars-next.observableusercontent.com/445356530fc62927e5cc436f44a9a13ca00019b40ee7654ebf650e93f3d0f3b9","tier":"starter_2024"},"version":803,"publish_version":803,"role":null,"authored":false,"authors":[{"type":"individual","id":"97b947fcd501b1c3","login":"odunayo12","name":"","avatar_url":"https://avatars-next.observableusercontent.com/445356530fc62927e5cc436f44a9a13ca00019b40ee7654ebf650e93f3d0f3b9","tier":null}],"members":[{"type":"individual","id":"97b947fcd501b1c3","login":"odunayo12","name":"","avatar_url":"https://avatars-next.observableusercontent.com/445356530fc62927e5cc436f44a9a13ca00019b40ee7654ebf650e93f3d0f3b9","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Data Loading","cells":[{"id":0,"value":"md`# Data Loading`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"md `\"autoType\" coverts to string or numerics where necessary`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"indian_cricket =d3.csvParse(await FileAttachment(\"matches.csv\").text(), d3.autoType)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":618,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"table(indian_cricket.filter((d,i)=>{ return i<5 }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"d3.csvParse(await FileAttachment(\"NatPopQuery@2.csv\").text(), d3.autoType)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"// colNo= d3.nest()\n// .rollup(function(leaves) { return leaves.length; })\n// .entries(indian_cricket);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":383,"value":"md`### Dimension \n\narray.lenght is an array method that returns the no of elements in a given array; while d3.keys(object) returns an array containing the property names of the specified object. Combinong both, we have:`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":364,"value":"dataDimension = data => [data.length, d3.keys(data[0]).length]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":376,"value":"dataDimension(indian_cricket)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":410,"value":"md`To get the keys of our .lenght our object which is an equivalent of column names in a datafarame we use d3.keys(object) without the array.length method `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":347,"value":"d3.keys(indian_cricket[0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"objectsWithoutNull = indian_cricket.reduce(function (r, a) {\n return r + +( Object.values(a).indexOf(null) == -1);\n }, 0); ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":435,"value":"nullable = indian_cricket.filter(obj=>Object.values(obj).includes(null))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":440,"value":"notNullable = indian_cricket.filter(obj=>!Object.values(obj).includes(null))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":449,"value":"weg = D3.count(indian_cricket, d => d.umpire3)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":483,"value":"Array.from(D3.rollup(indian_cricket, d => d.length, d => d.umpire3, d => d.season))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"Array.from(D3.rollup(indian_cricket, d => d.length, d => d.result))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":515,"value":"indian_cricket.filter(o => o[0] !==null)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":518,"value":"keys = Object.keys(indian_cricket[0]);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":540,"value":"// https://stackoverflow.com/a/53720094/13119339\nop = indian_cricket.reduce((output,current)=>{\n for(let key in current){\n if( output[key]){\n if( current[key]||current[key] ==0) output[key]+=1;\n } else {\n if( current[key] ||current[key] ==0){\n output[key] = 1;\n } else{\n output[key] = 0;\n }\n }\n }\n return output;\n}, [])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":671,"value":"Array.from(D3.rollup(indian_cricket, v => v.length, d => d.season, e => e.city))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"md`To drop a key (subset a dataframe equivalent in python), we use delete Object.key but first we duplicate the data as indian_cricket_obj `","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"indian_cricket_obj = indian_cricket","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":649,"value":"indian_cricket_obj.forEach(d => {delete d.umpire3})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":660,"value":"D3.rollup(indian_cricket_obj, v => v.length,d => d.season)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":561,"value":"table(op)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":543,"value":"html`\n \n \n \n ${Array.from(op, ([key, values]) => html`\n \n \n \n `)}\n

Sport	Athletes
${key}	${values.map(d => d).join(\", \")}

`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"md `Renaming the data the manual way.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"countryData = {\nconst data = await FileAttachment(\"NatPopQuery@2.csv\").text();\n //const parseYear = d3.utcYear(\"%Y\")\n return d3.csvParse(data, ({Year, Population, State, MalePop, FemalePop, Longitude, Latitude, Iso1}) => ({\n year: +Year, \n population: +Population, \n state: State, \n malePopulation: +MalePop, \n femalePopulation: +FemalePop, \n longitude: +Longitude, \n latitude: +Latitude, \n Abbreviation: Iso1}))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"d3.extent(countryData, d => d.year) //shows the range of data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"d3.extent(countryData, d => d.state)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"// Get the first (zero-ith) element\ncountryData[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"// Access the malePopulation key of the first element\ncountryData[0].malePopulation","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"countryData.length","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"// Get a list of features in our dataset from the first observation\nObject.keys(countryData[0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"// Get a list of the unique values of the `year` feature\nyears_content = _.uniqBy(countryData, d => d.year)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"// Get a list of the unique values of the `year` feature (only returning the string values of interest)\nyears_content_list = _.uniqBy(countryData, d => d.year).map(d => d.year)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"d3.range(countryData, d => d.year)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"countryData.map(d => d.year)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"md`Let's work with already mad histogram by importing it.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"malePopulation = countryData.map(d => d.malePopulation) //returns an array of the malepopulation column ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"import {chart as malePopulationHistogram} with {malePopulation as data, height} from \"@d3/histogram\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"import {chart as femalePopulationHistogram} with {malePopulation as data, height} from \"@d3/histogram\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":109,"value":"femalePopulationHistogram","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"malePopulationHistogram","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":128,"value":"md`# Scales`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"fruits = [\n {name: \"🍊\", count: 21},\n {name: \"🍇\", count: 13},\n {name: \"🍏\", count: 8},\n {name: \"🍌\", count: 5},\n {name: \"🍐\", count: 3},\n {name: \"🍋\", count: 2},\n {name: \"🍎\", count: 1},\n {name: \"🍉\", count: 1}\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"fruits.map(d => d.count) // the count dimension (quantitative)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"fruits.map(d => d.name) // the count dimension (quantitative)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"md`## Nesting Data\nsee; http://learnjsdata.com/group_data.html`\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":204,"value":"// deaths = {\n// const {data} = await d3.json(\"https://github.com/odunayo12/New_NGN_BUDGET_DATA/blob/add_year/Budget_Data/summary/mda_by_year.csv\");\n// return data;\n// }\n\nmda_data =d3.csvParse(await FileAttachment(\"mda_by_year@1.csv\").text(), d3.autoType)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":210,"value":"//https://stackoverflow.com/a/23369299/13119339\nmda_data_2 = d3.nest().key(d => { return d.Year; }).key(d => { return d.costCenter_Code_MDA; }).key(d => { return d.table_identifier_MDA; }).entries(mda_data) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"mda_data_3 ={\n const mda_data_3 = {name:\"BUDGET\",\n children: mda_data_2.filter(d => d.key == \"2018\").map(d => {\n \n return {\n name: d.key, \n children: d.values.map(d => {\n \n return {\n name: d.key,\n children: d.values.map(d => {\n \n return{\n name: d.key\n }\n })\n }\n })\n }\n })\n }\n \n return mda_data_3\n }\n ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":799,"value":"viewof radioFormB ={\n const options = [\n {name: \"d3.treemapBinary\", value: d3.treemapBinary},\n {name: \"d3.treemapDice\", value: d3.treemapDice},\n {name: \"d3.treemapSlice\", value: d3.treemapSlice},\n {name: \"d3.treemapSliceDice\", value: d3.treemapSliceDice},\n {name: \"d3.treemapSquarify\", value: d3.treemapSquarify, checked: true}\n ];\n const form = `

${options.map(o => Object.assign(`