2d:null 2e:["$","title",null,{"children":"1111D3 com Crossfilter e DC.js | LailsonAzevedo | Observable"}] 33:T410,variacoes = { let view = md`${container('chart2', 'Variacoes dos Valores das acões do Google e do Facebook')}` let compositeChart = dc.compositeChart(view.querySelector("#chart2")) let xScale = d3.scaleTime() .domain([dateDim.bottom(1)[0].date, dateDim.top(1)[0].date]) compositeChart.width(800) .height(400) .margins({top: 50, right: 50, bottom: 25, left: 40}) .dimension(dateDim) .x(xScale) .xUnits(d3.timeDays) .renderHorizontalGridLines(true) .legend(dc.legend().x(700).y(5).itemHeight(13).gap(5)) .brushOn(false) .compose([ dc.lineChart(compositeChart) .group(acoesGoogleByDayGroup, 'Google') .ordinalColors(['steelblue']), dc.lineChart(compositeChart) .group(acoesFbByDayGroup, 'Facebook') .ordinalColors(['darkorange'])]) dc.renderAll() return view }34:T1428,html`Esta célula inclui o css do dc. `35:[] 31:{"id":"e20203f6f026d7ba","slug":"1111d3-com-crossfilter-e-dc-js","title":"1111D3 com Crossfilter e DC.js","thumbnail":"86abdc1e6ee16f96bd6bb1473f41a3d9ac816bc32660e98a76d251af4590fc09","access_level":"public","create_time":"$D2019-09-29T17:39:55.821Z","update_time":"$D2019-09-30T20:49:31.642Z","view_time":null,"first_public_time":"$D2019-09-29T20:28:14.833Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"36fbc8f6f5c00a43","login":"lailson93","name":"LailsonAzevedo","avatar_url":"https://avatars-next.observableusercontent.com/8397361199475564bd8b8467c8ee423769557a5b87acf0492efafc33c8656c23","tier":"starter_2024"},"version":217,"publish_version":217,"role":null,"authored":false,"authors":[{"type":"individual","id":"394bd7ee6c15f136","login":"lailson93","name":"LailsonAzevedo","avatar_url":"https://avatars-next.observableusercontent.com/8397361199475564bd8b8467c8ee423769557a5b87acf0492efafc33c8656c23","tier":null}],"members":[{"type":"individual","id":"394bd7ee6c15f136","login":"lailson93","name":"LailsonAzevedo","avatar_url":"https://avatars-next.observableusercontent.com/8397361199475564bd8b8467c8ee423769557a5b87acf0492efafc33c8656c23","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"1111D3 com Crossfilter e DC.js","cells":[{"id":0,"value":"md`# 1111D3 com Crossfilter e DC.js`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"dataset = d3.csv(\"https://gist.githubusercontent.com/emanueles/d8df8d875edda71aa2e2365fae2ce225/raw/1e949d3da02ed6caa21fe3a7a12a4e5a611a4bab/stocks.csv\").then(function(data){\n // formatando nossos dados\n let parseDate = d3.timeParse(\"%Y/%m/%d\")\n data.forEach(function(d,i){\n d.date = parseDate(d.date)\n d.google = +d.google // +: converte para numerico\n d.facebook = +d.facebook\n })\n return data\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"facts = crossfilter(dataset)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"dateDim = facts.dimension( d => d.date)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"googleDim = facts.dimension( d => d.google)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"topTenGoogle = googleDim.top(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"bottomTenGoogle = googleDim.bottom(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"googleByDayGroup = dateDim.group().reduceSum(d => d.google)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"fbByDayGroup = dateDim.group().reduceSum(d => d.facebook)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"function container(id, title) { \n return `\n

${title}

`\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"buildvis = {\n let view = md`${container('chart','Valores das ações do Google')}` //container\n let lineChart = dc.lineChart(view.querySelector(\"#chart\"))\n let xScale = d3.scaleTime()\n .domain([dateDim.bottom(1)[0].date, dateDim.top(1)[0].date])\n lineChart.width(800)\n .height(400)\n .dimension(dateDim)\n .margins({top: 30, right: 50, bottom: 25, left: 40})\n .renderArea(false)\n .x(xScale)\n .xUnits(d3.timeDays)\n .renderHorizontalGridLines(true)\n .legend(dc.legend().x(680).y(10).itemHeight(13).gap(5))\n .brushOn(false)\n .group(googleByDayGroup, 'Google')\n dc.renderAll()\n return view \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"buildcomposite = {\n let view = md`${container('chart2', 'Valores das ações do Google e do Facebook')}`\n let compositeChart = dc.compositeChart(view.querySelector(\"#chart2\"))\n let xScale = d3.scaleTime()\n .domain([dateDim.bottom(1)[0].date, dateDim.top(1)[0].date])\n compositeChart.width(800)\n .height(400)\n .margins({top: 50, right: 50, bottom: 25, left: 40})\n .dimension(dateDim)\n .x(xScale)\n .xUnits(d3.timeDays)\n .renderHorizontalGridLines(true)\n .legend(dc.legend().x(700).y(5).itemHeight(13).gap(5))\n .brushOn(false) \n .compose([\n dc.lineChart(compositeChart)\n .group(googleByDayGroup, 'Google')\n .ordinalColors(['steelblue']),\n dc.lineChart(compositeChart)\n .group(fbByDayGroup, 'Facebook')\n .ordinalColors(['darkorange'])])\n dc.renderAll()\n return view \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"md`# Exercicios`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"md`# Exercicios (1/3)`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"valorDia1Fb = dataset[0].facebook","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"valorDia1Google = dataset[0].google","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"testGroup = dateDim.group().reduceSum(d=>d.google);\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"testGroup.all()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"testGroup1 = googleDim.group().reduceSum(d => ((d.google*100)/valorDia1Google) - 100 );","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"testGroup1.all()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"acoesGoogleByDayGroup = dateDim.group().reduceSum(d => ((d.google*100)/valorDia1Google) - 100 );","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"acoesGoogleByDayGroup.all()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"acoesFbByDayGroup = dateDim.group().reduceSum(d => ((d.facebook*100)/valorDia1Fb) - 100 );","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"acoesFbByDayGroup.all()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":109,"value":"md`# Exercicios (2/3)`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"dataset2 =\n d3.json(\"https://raw.githubusercontent.com/emanueles/datavis-course/master/assets/files/observable/movies.json\").then(function(data){\n // formatacao de dados\n data.forEach(function(d,i){\n d.Film = d.Film\n d.Year = +d.Year\n d.Genre = d.Genre\n d.Worldwide_Gross_M = +d.Worldwide_Gross_M\n d.Budget_M = +d.Budget_M\n })\n return data\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"facts2 = crossfilter(dataset2) // fact representa o objeto crossfilter","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"yearDim = facts2.dimension(d => d.Year)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"teste22222 = yearDim.bottom(1)[0].Year","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"yearTop = yearDim.top(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"totalBrutoByYear = yearDim.group().reduceSum(d => d.Worldwide_Gross_M);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"totalBrutoByYear.all()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"genreDim = facts2.dimension(d => d.Genre)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"totalBrutoByGenre = genreDim.group().reduceSum(d => d.Worldwide_Gross_M);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":211,"value":"totalBrutoByGenre.all()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"function container1(id, title) { \n return `\n

${title}

`\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"by_year = {\n let view = md`${container1('barchart','Total Arrecadado nas Bilheterias por ano em Milhoes de Dólares')}` //container\n let chart1 = dc.barChart(view.querySelector(\"#barchart\"))\n// let xScale = d3.scaleLinear()\n// .domain([yearDim.bottom(1)[0].Year, yearDim.top(1)[0].Year+1])\n \n // var yearlyDimension = ndx.dimension(function (d) {\n // return d3.timeYear(d.Year).getFullYear();\n // });\n chart1.width(800)\n .height(400)\n .margins({top: 30, right: 50, bottom: 25, left: 40})\n .x(d3.scaleBand()) //https://github.com/d3/d3-scale\n .barPadding(0.3)\n .xUnits(dc.units.ordinal)\n .renderHorizontalGridLines(true)\n .brushOn(false)\n .dimension(yearDim)\n .group(totalBrutoByYear)\n chart1.render();\n return view \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"//FALTA ORDENAR\nby_genre = {\n let view = md`${container1('barchart','Total Arrecadado nas Bilheterias por Gênero de 2007 e 2011 (em Milhoes de Dólares)')}` //container\n let chart1 = dc.barChart(view.querySelector(\"#barchart\"))\n \n chart1.width(800)\n .height(400)\n .margins({top: 30, right: 50, bottom: 25, left: 40})\n .x(d3.scaleBand()) //https://github.com/d3/d3-scale\n .barPadding(0.3)\n .xUnits(dc.units.ordinal)\n .renderHorizontalGridLines(true)\n .brushOn(false)\n .dimension(yearDim)\n .group(totalBrutoByGenre)\n chart1.render();\n return view \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"dc = require(\"dc\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"crossfilter = require(\"crossfilter2\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"d3 = require(\"d3\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 32:"$31:body"