31:T499,gems = rawGems.map((g) => { const match = /^(?\d+)(?:\/(?\d+))?(?c)?$/.exec( g.variant ).groups; const baseName = g.name === "Vaal Domination" ? "Dominating Blow" : g.name === "Vaal Breach" ? "Portal" : gemNameBases.find((name) => g.name.toLowerCase().includes(name.toLowerCase()) ); const name = g.name, value = g.value, level = +match.level, quality = match.quality ? +match.quality : 0, corrupted = !!match.corrupted, support = g.name.endsWith("Support"), vaal = g.name.startsWith("Vaal"), awakened = g.name.startsWith("Awakened"), exceptional = /(?:Enhance|Enlighten|Empower) Support/.test(g.name), variant = g.variant[0], transfigured = !vaal && !awakened && name != baseName, maxLevel = name === "Brand Recall" ? 6 : name === "Vaal Breach" ? 1 : exceptional ? 3 + awakened : awakened ? 5 : 20; return { name, baseName, value, level, quality, corrupted, support, vaal, awakened, exceptional, transfigured, maxLevel }; })32:T9af,_(gems) .groupBy("baseName") .mapValues((group, baseName) => group .flatMap( (a) => group .map((b) => (_.isEqual(a, b) ? undefined : [a, b])) .filter((x) => x) // remove undefined ) .map(([a, b]) => { const ac = a.corrupted, bc = b.corrupted; // No going back! if (ac && !bc) return; if (a.transfigured && !(a.name === b.name)) return; // Normal upgrades const leveled = a.level < a.maxLevel && b.level === b.maxLevel; const quality = a.quality === 0 && b.quality === 20; // Labyrinth outcomes const awakening = !a.awakened && b.awakened; const transfig = !a.transfigured && b.transfigured; // Vaal Orb outcomes const vaalOrb = !ac && bc; const vaalified = !a.vaal && b.vaal; const overleveled = a.level === a.maxLevel && b.level > a.level; const overquality = a.quality === 20 && b.quality == 23; const atoken = tokenize( _.pick(a, ["vaal", "awakened", "transfigured"]) ); // Can only do one thing at a time if (+vaalOrb + awakening + transfig + leveled * quality !== 1) return; // Can only affect level and quality of a corrupted gem if (ac && bc && !(leveled || quality)) return; const flags = (gem) => 1 * gem.awakened + 2 * gem.vaal + 4 * gem.transfigured; const af = flags(a), bf = flags(b); // Mutually exclusive if ( af > 0 && // a is something af !== bf // then b must match ) return; // else a is plain or they match if (b.corrupted) { if (!a.corrupted) { // Reject invalid Vaal Orb transitions if ( (a.quality === 0 && b.quality !== 0) || (a.quality === 20 && b.quality === 0) ) return; const diff = b.level - a.level; if (diff !== 0 && diff !== 1) return; } else { } } else { // !b.corrupted if (a.quality > b.quality || a.level > b.level) return; } const changes = "" + (b.corrupted ? "c" : "") + (b.vaal ? "v" : "") + (b.level > b.maxLevel ? "l" : "") + (b.quality == 23 ? "q" : ""); return changes; }) .filter((x) => x !== undefined) ) .value()33:T40b,Plot.plot({ grid: true, width: width, height: 500, y: {label: "Value (Log)"}, facet: "super", marks: [ Plot.ruleY([0], { strokeOpacity: 0.6 }), Plot.areaX(densities, { x: (d) => d.x, x1: 0, fx: (d) => d.i, z: "i", y: "y", fillOpacity: 0.2, }), // Plot.dot(densities, { // x: (d) => d.x, // fx: (d) => d.i, // y: "y", // z: "i", // strokeOpacity: 1 // }), Plot.lineX(densities, { x: (d) => d.x, fx: (d) => d.i, z: "i", y: "y" }), Plot.areaX(densities, { x: (d) => -d.x, x1: 0, fx: (d) => d.i, y: "y", z: "i", fillOpacity: 0.2 }), Plot.lineX(densities, { x: (d) => -d.x, fx: (d) => d.i, z: "i", y: "y", }), Plot.dot( densities, Plot.selectFirst({ y: (d) => d.m, stroke: "#000", fx: (d) => d.i, z: "i", symbol: "circle", fill: "red", r: 4 }) ) ] })34:[] 2f:{"title":"Path of Exile Economy","cells":[{"id":0,"value":"# Path of Exile Economy\n## Analysis Experiments using poe.ninja data\nGoals:\n- Use visualization tools to analyze and isolate factors that determine value\n- Condense those factors into an item filter\n\nRelevant resources:\n- https://www.pathofexile.com/trade **(requires login ☹)** - the official player trading website, and source of economy data\n- https://poe.ninja/ - An economy analysis website, providing live and historical prices; no official public 3rd party API for live data but still usable\n- https://www.filterblade.xyz/ - the (probably) most popular and comprehensive in-game item filter (which limits and highlight items dropped by slain monsters); uses live economy data, related repo: https://github.com/NeverSinkDev/Filter-ItemEconomyAspects\n- https://www.poewiki.net/ - Official community wiki; can be queried for data (select format=json): https://www.poewiki.net/wiki/Special:CargoQuery","pinned":false,"hidden":false,"mode":"md"},{"id":189,"value":"Here's data from poe.ninja's `denseoverviews` endpoint which gives a concise, categorized snapshot of the PoE market.","pinned":false,"hidden":false,"mode":"md"},{"id":3,"value":"async function getData(url) {\n const r = await fetch(\"https://corsproxy.io/?\" + encodeURIComponent(url));\n return r.ok\n ? r.json()\n : md`## 🛑 ${r.status} ${r.statusText}\\n~~~\\n${[...r.headers]\n .map(([name, value]) => `${name}: ${value}`)\n .join(\"\\n\")}\\n\\n${await r.text()}\\n~~~`;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":624,"value":"data = await getData(\n \"https://poe.ninja/api/data/denseoverviews?league=Affliction\"\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":193,"value":"flatData = _.concat(data.currencyOverviews, data.itemOverviews).flatMap((cat) =>\n cat.lines.map((line) => ({\n name: line.name,\n type: cat.type,\n variant: line.variant?.split(\", \") ?? [],\n // \"chaos\" is the Chaos Orb item used as the de facto standard currency for trading, in addition to Divine Orbs for larger sums\n value: line.chaos\n }))\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":192,"value":"flatData","pinned":true,"hidden":false,"mode":"ojs"},{"id":205,"value":"Divine Orbs are currently worth **${_.find(flatData, _.matchesProperty(\"name\", \"Divine Orb\")).value}** Chaos Orbs","pinned":false,"hidden":false,"mode":"md"},{"id":1039,"value":"Types: ${_(flatData).map(\"type\").uniq().join(\", \")}","pinned":false,"hidden":false,"mode":"md"},{"id":334,"value":"\n

${k}: ${v.sort().map((v) => htl.html`${v} `)}

","pinned":true,"hidden":false,"mode":"html"},{"id":219,"value":"## Gems\nRead more here: https://www.poewiki.net/wiki/Gem","pinned":false,"hidden":false,"mode":"md"},{"id":1060,"value":"rawGems = _.filter(flatData, [\"type\", \"SkillGem\"])","pinned":true,"hidden":false,"mode":"ojs"},{"id":1065,"value":"gemNames = _(rawGems).map(\"name\").uniq().value()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1082,"value":"gemNameBases = gemNames\n .filter(\n (it) =>\n !it.startsWith(\"Vaal\") &&\n !it.startsWith(\"Awakened\") &&\n gemNames.every((that) => !it.includes(that + \" of \"))\n )\n .sort((a, b) => b.length - a.length) // Longest names first","pinned":true,"hidden":false,"mode":"ojs"},{"id":1106,"value":"gemNameBases","pinned":true,"hidden":false,"mode":"ojs"},{"id":1094,"value":"// Manual sanity check that there are no transfigurd gems left\ngemNameBases.filter((it) => it.includes(\" of \"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":28,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":227,"value":"gems","pinned":true,"hidden":false,"mode":"ojs"},{"id":53,"value":"function parseGemVariant(v) {\n const g = /^(?\\d+)(?:\\/(?\\d+))?(?c)?$/.exec(\n v\n ).groups;\n return {\n level: +g.level,\n quality: g.quality ? +g.quality : 0,\n corrupted: !!g.corrupted\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":86,"value":"gemMaxValue = _(gems)\n .groupBy(\"name\")\n .mapValues((v) => _.maxBy(v, \"value\").value)\n .value()","pinned":true,"hidden":false,"mode":"ojs"},{"id":255,"value":"gemsByName\n= _.groupBy(gems, \"name\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":182,"value":"gemLevels = _.mapValues(gemsByName, (gs) =>\n _(gs).map(\"level\").uniq().sortBy().value()\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":537,"value":"gemsByLevel = _.groupBy(gems, \"level\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":1184,"value":"gemsByLevelUncorrupted = _(gems)\n .filter((it) => !it.corrupted)\n .groupBy(\"variant\")\n .value()","pinned":true,"hidden":false,"mode":"ojs"},{"id":503,"value":"gems20 = new Set(_(gemsByLevel[20]).concat(gemsByLevel[21]).map(\"name\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":241,"value":"gemQualities = _.groupBy(gems, \"quality\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":547,"value":"Plot.plot({\n x: { type: \"log\" },\n y: { type: \"point\" },\n marks: [\n Plot.frame(),\n Plot.dot(\n _(gems)\n // .filter((g) => g.variant == \"21/23c\")\n // .sortBy(\"value\")\n .value(),\n {\n // fy: (g) => (gems20.has(g.name) ? \"regular\" : \"low\"),\n fx: (g) => (g.exceptional ? \"Exceptional\" : \"Normal\"),\n fy: (g) => (g.awakened ? \"Awakened\" : \"Normal\"),\n // fill: \"baseName\",\n // y: (g) => `${g.quality}/${g.level}`,\n x: \"value\",\n y: \"variant\",\n // y: \"baseName\",\n // fill: \"quality\",\n // fill: (g) => g.quality,\n // stroke: (g) => (g.corrupted ? \"red\" : \"black\"),\n // fill: \"vaal\"\n // symbol: \"awakened\"\n symbol: (g) => +g.vaal + g.awakened * 2\n }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":465,"value":"gemPlot = (gs) =>\n Plot.plot({\n x: { type: \"point\" },\n y: { type: \"log\" },\n marks: [\n Plot.frame(),\n Plot.dot(gs, {\n // fy: (g) => (gems20.has(g.name) ? \"regular\" : \"low\"),\n // fy: \"quality\",\n x: \"level\",\n // x: (g) => `${g.quality}/${g.level}`,\n y: \"value\",\n fill: \"quality\",\n // fill: (g) => g.quality,\n stroke: (g) => (g.corrupted ? \"red\" : \"black\"),\n // fill: \"vaal\"\n // symbol: \"awakened\"\n symbol: (g) => +g.vaal + g.awakened * 2\n })\n ]\n })","pinned":true,"hidden":false,"mode":"ojs"},{"id":516,"value":"gemPlot(_(gems).filter(_.flow([_.property(\"name\"), (g) => gems20.has(g)])))","pinned":true,"hidden":false,"mode":"ojs"},{"id":522,"value":"gemPlot(_(gems).filter(_.flow([_.property(\"name\"), (g) => !gems20.has(g)])))","pinned":true,"hidden":false,"mode":"ojs"},{"id":751,"value":"Plot.plot({\n // x: { axis: null },\n y: { type: \"log\" },\n color: { scheme: \"Plasma\" },\n marks: [\n Plot.frame(),\n Plot.dot(\n gems.filter((g) => g.level > 1),\n {\n x: \"baseName\",\n y: \"value\",\n r: (g) => (g.quality == 0 ? 1 : g.quality - 17),\n stroke: (g) => (g.corrupted ? \"red\" : \"black\"),\n // x: \"level\",\n // fx: \"quality\",\n x: (g) => `${g.level}/${g.quality}`,\n // x: (g) => `${g.quality}/${g.level}`,\n // fy: \"awakened\",\n fy: (g) =>\n g.exceptional ? \"ex\" : g.awakened ? \"aw\" : g.vaal ? \"vaal\" : \"\"\n // sort: { x: \"y\", reduce: \"proportion\" }\n }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":468,"value":"await getData(\n \"https://www.poewiki.net/index.php?title=Special:CargoExport&tables=skill%2C+items%2C&join+on=items._pageId%3Dskill._pageId&fields=items.name%2C+skill.max_level%2C&where=items.class_id+IN+%28%22Active+Skill+Gem%22%2C+%22Support+Skill+Gem%22%29&order+by=&limit=1000&format=csv\"\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":633,"value":"_.mapValues(gemsByName, (gs) =>\n _(gs)\n .filter(_.negate(_.property(\"corrupted\")))\n .groupBy(\"quality\")\n .value()\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1051,"value":"### Gem Transformations","pinned":false,"hidden":false,"mode":"md"},{"id":1203,"value":"md`${_.keys(gems[0]).join(\" | \")}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1211,"value":"// Sanity check: Mutually exclusive properties\nnew Set(\n gems.map(\n (g) =>\n (g.transfigured ? \"t\" : \"\") +\n (g.vaal ? \"v\" : \"\") +\n (g.awakened ? \"a\" : \"\")\n )\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1419,"value":"tokenize = _.flow(_.pickBy, _.keys, _.join);\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1456,"value":"tokenize({ a: false, b: true, c: false, d: true })","pinned":true,"hidden":false,"mode":"ojs"},{"id":1053,"value":"$32","pinned":true,"hidden":false,"mode":"ojs"},{"id":267,"value":"## BaseTypes\nEquipment like armor and jewelry have a base item type that define certain characteristics and possible affixes. They also have an item level, where certain affixes and affix tiers require a certain ilvl of the item (the highest requirement is ilvl 86, so it doesn't matter if an item has higher ilvl than that), and may also have one or two \"influences\" which enable further exclusive affixes.","pinned":false,"hidden":false,"mode":"md"},{"id":269,"value":"baseTypes = _.filter(flatData, [\"type\", \"BaseType\"]).map((g) => ({\n name: g.name,\n value: g.value,\n ...parseBaseTypeVariant(g.variant)\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":278,"value":"function parseBaseTypeVariant(v) {\n const influenceArray = v[1]?.split(\"/\").sort() ?? [];\n return {\n level: v[0],\n influence: influenceArray,\n influenceCount: influenceArray.length,\n influenceTag:\n influenceArray.length === 0\n ? \"0\"\n : influenceArray.length > 2\n ? \"All\"\n : influenceArray.length + influenceArray.map((i) => i[0]).join(\"\"),\n ..._([\"Hunter\", \"Warlord\", \"Redeemer\", \"Crusader\", \"Shaper\", \"Elder\"])\n .map((it) => [it.toLowerCase(), influenceArray.includes(it)])\n .fromPairs()\n .value()\n };\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":812,"value":"baseTypes","pinned":true,"hidden":false,"mode":"ojs"},{"id":294,"value":"Interestingly, it might be more valuable for an item to have a lower ilvl because there are fewer possible affixes available, which makes it more likely or easier to improve the chance to roll a desired affix. For example, here are the prices for the very rare Prismatic Jewel base type:\n\n${baseTypesByName[\"Prismatic Jewel\"].map(it=>`- ilvl ${it.level}: **${it.value}c**`).join(\"\\n\")}","pinned":false,"hidden":false,"mode":"md"},{"id":289,"value":"baseTypesByName = _.groupBy(baseTypes, \"name\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":285,"value":"baseTypeLevels = _.groupBy(baseTypes, \"level\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":649,"value":"baseTypeInfluences = new Set(_.flatMap(baseTypes, \"influence\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":896,"value":"groupedNormalizedBaseTypes = _(baseTypes)\n .groupBy(\"influenceTag\")\n .mapValues((items) => {\n const groupCount = _(items)\n .groupBy((it) => Math.round(Math.log(it.value)))\n .mapValues(\"length\")\n .toPairs()\n .value();\n const maxCount = _.maxBy(groupCount, 1)[1];\n return groupCount.map((it) => [it[0], it[1] / maxCount]);\n })\n .toPairs()\n .flatMap((group) =>\n group[1].map((it) => ({ tag: group[0], logValue: +it[0], count: it[1] }))\n )\n .value()","pinned":true,"hidden":false,"mode":"ojs"},{"id":654,"value":"Plot.plot({\n color: {\n scheme: \"Magma\"\n },\n\n marks: [\n Plot.frame(),\n Plot.cell(groupedNormalizedBaseTypes, {\n x: \"tag\",\n y: \"logValue\",\n fill: \"count\",\n sort: { x: \"data\", reduce: (it) => _.maxBy(it, \"count\").logValue }\n })\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":835,"value":"Plot.plot({\n y: { type: \"log\" },\n marks: [\n Plot.frame(),\n Plot.boxY(baseTypes, {\n x: \"influenceTag\",\n y: \"value\",\n channels: { name: \"name\", level: \"level\" },\n tip: true\n })\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":665,"value":"Plot.plot({\n y: { type: \"log\" },\n marks: [\n Plot.frame(),\n Plot.dot(baseTypes, {\n r: (it) => +it.level.substring(0, 2) - 80,\n y: \"value\",\n x: \"influenceTag\",\n stroke: \"name\",\n sort: { x: \"y\", reduce: \"max\" },\n channels: { name: \"name\", level: \"level\" },\n tip: true\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":959,"value":"Plot.plot({\n color: {\n scheme: \"Magma\"\n },\n\n marks: [\n Plot.cell(\n baseTypes,\n Plot.group(\n { fill: \"p99\" },\n {\n x: (it) => it.influence[0] ?? \"X\",\n y: (it) => it.influence[1] ?? \"X\",\n // fy: \"level\",\n // fill: \"value\"\n fill: (it) => Math.log(it.value)\n }\n )\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1002,"value":"Plot.plot({\n width: 1000,\n color: {\n scheme: \"Magma\"\n },\n marks: [\n Plot.cell(\n baseTypes,\n Plot.groupX(\n { fill: \"p99\" },\n {\n filter: (it) => it.influenceCount <= 2,\n fx: (it) => it.influence[0] ?? \"X\",\n fy: (it) => it.influence[1] ?? \"X\",\n x: \"level\",\n // fill: \"value\"\n fill: (it) => Math.log(it.value)\n }\n )\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1045,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":1270,"value":"viewof useManualBw = Toggle({ label: 'Use bandwidth slider', value: true })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1268,"value":"viewof manualBandwidth = Range([0, 1], {\n value: 0.4,\n label: \"Bandwidth\",\n disabled: !useManualBw\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1056,"value":"densities = {\n const a = [];\n _(baseTypes)\n .groupBy(\"influenceTag\")\n .forOwn((items, tag) => {\n const raw = items.map((g) => Math.log(g.value)).sort((a, b) => a - b);\n const bandwidth = useManualBw ? manualBandwidth : bwEstimate(raw);\n const data2 = kde(epanechnikov(bandwidth), raw)(raw);\n data2.forEach((f) =>\n a.push({ y: f[0], x: f[1], i: tag, m: d3.median(raw) })\n );\n });\n return a;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1234,"value":"**Imports**","pinned":false,"hidden":false,"mode":"md"},{"id":1237,"value":"//https://observablehq.com/@jonhelfman/plot-violin-chart-with-facet\nimport {kde, bwEstimate, epanechnikov} from \"@jonhelfman/plot-violin-chart-with-facet\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1272,"value":"import {Checkbox, Range, Toggle } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}