2f:[] 2d:{"title":"Canada - One and done","cells":[{"id":0,"value":"md `# Canada - One and done\n\n*for Brian* ❤️\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":"viewof file = Inputs.file({label: \"Data\", required: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":559,"value":"md `### *Market Share*\n\n*Top 20 Competitors*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":517,"value":"vl.markRect()\n .data(clean.filter(d => top_k.includes(d.company)))\n .encode(\n vl.x().fieldT('date')\n .title(null)\n .timeUnit('yearmonthdate')\n .axis({\n orient: 'top',\n }),\n vl.y().fieldN('company')\n .sort(vl.count().order('descending'))\n .axis({\n tickBand: 'extent'\n }),\n vl.color().count()\n .scale({range: ['#fafafa', appcast_color_palette[1]]})\n .legend({\n offset: 50,\n gradientThickness: 7\n })\n )\n .config({\n view: {stroke: null},\n rect: {width: {band: 0.95}, height: {band: 0.9}},\n axis: {grid: null, domain: null},\n axisY: {ticks: false}\n })\n .padding({bottom: 100, top: 50})\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":801,"value":"md `### *Salary*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":586,"value":"vl.hconcat(\n \n vl.markBar({fill: appcast_color_palette[4]})\n .data(clean.filter(d => d.pay_hourly < 40))\n .encode(\n vl.x().fieldQ('pay_hourly').bin(true).title('Hourly Pay')\n .axis({format: '$,.0f'}),\n vl.y().count()\n ),\n\n vl.markText({\n fontSize: 50,\n fontWeight: 200,\n dy: 100\n })\n .title({\n text: 'Median Salary for the Market',\n fontWeight: 200,\n fontSize: 25,\n dy: 75\n })\n .data(clean)\n .encode(\n vl.text({format: '$,.2f'}).median('pay_hourly')\n )\n )\n .spacing(100)\n .config({\n view: {stroke: null},\n axis: {labelOpacity: 0.5, gridOpacity: 0.5},\n axisY: {domain: false},\n axisX: {titlePadding: 10}\n })\n .padding({top: 25, bottom: 100})\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":804,"value":"md `### *Benefits*\n\n*Top 20 Competitors*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":765,"value":"vl.markCircle({size: 200, fill: appcast_color_palette[0]})\n .data(benefits.filter(d => top_k.includes(d.company)))\n .encode(\n vl.x().fieldN('all_benefits')\n .title('Benefit')\n .axis({\n orient: 'top'\n }),\n vl.y().fieldN('company')\n .title('Company')\n )\n .config({\n axis: {labelFontWeight: 200, grid: true, gridOpacity: 0.5, domain: false, titlePadding: 25},\n view: {stroke: null}\n })\n .height(500).width(700)\n .padding({top: 25, bottom: 50})\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":830,"value":"md`

\n## *#wip*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":833,"value":"Plot.lineY(\n playground.filter((d) => d.source != null),\n Plot.binX(\n {\n y: \"count\"\n },\n {\n x: \"date\",\n y: \"sponsored\",\n stroke: \"source\",\n marker: true\n }\n )\n).plot({\n height: 200,\n color: {\n legend: true\n },\n caption: html`post counts by source`\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":848,"value":"Plot.plot({\n caption: html `Frequency of job titles`,\n marginLeft: 400,\n height: 2000,\n x: {\n grid: true\n },\n marks: [\n Plot.barX(\n playground,\n Plot.groupY(\n {\n x: \"count\"\n },\n {\n //x: \"country\",\n y: \"job_title\",\n sort: {y: 'x', reverse: true}\n }\n )\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":88,"value":"
\n
\n
\n

","pinned":false,"hidden":false,"mode":"html"},{"id":20,"value":"md `## Appendix\n\n_Implementation & data stuff_`","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"### *Data*","pinned":false,"hidden":false,"mode":"md"},{"id":676,"value":"//playground\nviewof playground = aq.from(clean)\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":812,"value":"md `### *Main Clean Data*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":674,"value":"Inputs.table(clean)","pinned":true,"hidden":false,"mode":"ojs"},{"id":508,"value":"clean = aq.from(raw_data)\n .derive({\n company: d => op.replace(d.company, 'Fedex Supply Chain', 'FedEx Supply Chain')\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":505,"value":"raw_data = file.csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":815,"value":"md `### *Top K*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":533,"value":"top_k = aq.from(clean)\n .groupby('company')\n .count()\n .orderby(aq.desc('count'))\n .filter( d => op.rank() <= 20 )\n .array('company')","pinned":true,"hidden":false,"mode":"ojs"},{"id":818,"value":"md `### *Benefits*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":637,"value":"benefits = aq.from(clean)\n .select(0,1)\n .reify()\n .derive({\n num_benefits: aq.escape( d => d3.count(d.benefits) )\n })\n .dedupe('company','benefits')\n .filter(d => d.num_benefits > 0)\n .groupby('company')\n .rollup({\n all_benefits: d => op.array_agg(d.benefits)\n })\n .derive({\n all_benefits: d => op.split(d.all_benefits, ',')\n })\n .unroll('all_benefits')\n .derive({\n all_benefits: d => op.replace(d.all_benefits, \"['\", \"\")\n })\n .derive({\n all_benefits: d => op.replace(d.all_benefits, \"']\", \"\")\n })\n .derive({\n all_benefits: d => op.replace(d.all_benefits, \"'\", \"\")\n })\n .derive({\n all_benefits: d => op.replace(d.all_benefits, \"'\", \"\")\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":702,"value":"data_test = [\n {index: 0, my_array: ['one', 'two']},\n {index: 1, my_array: ['one', 'two', 'three']}\n]","pinned":true,"hidden":false,"mode":"ojs"},{"id":704,"value":"aq.from(data_test)\n .unroll('my_array')\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":187,"value":"### *Secondary data sources*","pinned":false,"hidden":false,"mode":"md"},{"id":69,"value":"// all vega data-sets\n\n// to 'extract' a dataset as an array (only for .csv and .json)\n// use this format: football = v_data['football.json']()\n// for some .csv, it's better to use the url format: zipcodes = v_data['zipcodes.csv'].url\n// this is due to the fact that parsing it as an array of objects results in zipcodes of the form \"00313\" turning into \"313\"\n\nv_data = require('vega-datasets@2')","pinned":false,"hidden":false,"mode":"ojs"},{"id":98,"value":"zips = v_data['zipcodes.csv'].url","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"us_holidays_2021 = USholidays.filter(d => op.utcyear(date_parser(d.date)) == 2021)","pinned":false,"hidden":false,"mode":"ojs"},{"id":193,"value":"### *Libraries*","pinned":false,"hidden":false,"mode":"md"},{"id":4,"value":"import {vl} from '@vega/vega-lite-api-v5'","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"import {uniqueValid} from '@uwdata/data-utilities'","pinned":false,"hidden":false,"mode":"ojs"},{"id":59,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs"},{"id":137,"value":"// object containing all of the FiPS us county codes\n\nimport {counties} from \"@d3/choropleth\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":391,"value":"// list of US Holidays\n\nimport {USholidays} from \"@observablehq/microsoft-reactor-hackathon\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":480,"value":"import {Legend, Swatches} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":483,"value":"import {DuckDBClient} from \"@cmudig/duckdb\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":486,"value":"import { palettes } from '@makio135/give-me-colors'","pinned":false,"hidden":false,"mode":"ojs"},{"id":496,"value":"// this is a really cool way of displaying tables. Much more aesthetically pleasing than the defaults of arquero and input.table\n\nimport { formatTable } from \"@saneef/pretty-tables\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":456,"value":"md `### *Functions*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":409,"value":"date_parser = d3.utcParse('%m/%d/%Y')","pinned":true,"hidden":false,"mode":"ojs"},{"id":208,"value":"### *Chart configuration*","pinned":false,"hidden":false,"mode":"md"},{"id":202,"value":"clean_config = ({\n view: { stroke: null },\n axis: {\n gridOpacity: 0.5,\n labelFontWeight: 75,\n domain: false,\n offset: 5,\n titleFontWeight: 350,\n titleFontSize: 10\n },\n axisX: {\n tickCount: 5,\n titlePadding: 10,\n labelPadding: 4\n },\n axisY: {\n ticks: false,\n labelLimit: 300,\n labelFontSize: 7\n },\n title: {\n fontWeight: 300,\n fontSize: 13,\n offset: 25\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":620,"value":"appcast_color_palette = ['#3138BB', '#FF7D6F', '#AF9BFC', '#C7FFE2', '#127FFC', '#FF9B77']","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}