31:T546,32:T6d6,function plotTeamDotPlot(data = all_data) { return Plot.plot({ width: width, y: { domain: d3.sort(data, (d) => -d["W/L%"]).map((d) => d.team), grid: true }, x: { grid: true }, color: { range: ["green", "red"], domain: ["HIT", "MISS"], legend: true }, tooltip: { stroke: "black" }, marginLeft: 150, marks: [ Plot.link(data_merged, { x1: "W/L%", y1: "team", x2: "target_percent", y2: "team", strokeWidth: (d) => d.lock * 2, stroke: (d) => { return didHit(d) > 0 ? "HIT" : "MISS"; } }), Plot.dotX(data_merged, { fill: "black", r: 8, y: "team", x: "W/L%" }), Plot.text(data_merged, { x: "W/L%", y: "team", filter: (d) => d.team.includes("Chicago"), text: (d) => "Win/Loss %", fontSize: 15, dy: 5, dx: 50 }), Plot.text(data_merged, { x: "target_percent", y: "team", filter: (d) => d.team.includes("Chicago"), text: (d) => "Over/Under %", fontSize: 15, dy: 5, dx: -60 }), Plot.dotX(data_merged, { y: "team", stroke: "black", shape: "square", fill: "white", r: 8, x: "target_percent" }), Plot.barX(data_merged, { x1: "W/L%", width: 20, fill: "transparent", y: "team", x2: "target_percent", title: (d) => ` ${d.team} \n Over/Under Line: ${d.target_games}\n TOTAL WINS: ${d.W} \n TOTAL LOSSES: ${d.L} \n \n What did I pick? ${d.over_under} \n Lock amount: ${d.lock}` }) ] }); }33:[{"id":"b753f01bdf6235908bb56a7238673c76326ce9ba63ca3dba93d9650673491c7fd0dc60cab958bb3f67cc28a7762c3b9b4dc7f0edf8e52dcb4d0c12b0673269b9","href":"https://static.observableusercontent.com/files/b753f01bdf6235908bb56a7238673c76326ce9ba63ca3dba93d9650673491c7fd0dc60cab958bb3f67cc28a7762c3b9b4dc7f0edf8e52dcb4d0c12b0673269b9","name":"casey_standings.csv","type":"text/csv","lastModified":1641431959156.666,"size":423}] 2f:{"title":"NBA over/under updated daily","cells":[{"id":4,"value":"# NBA over/under updated daily\n\nNBA live standings data is scraped from basketball-reference. This [github repo](https://github.com/caHaber/flat-data-nba-standings) scrapes the standings data from [Basketball Reference](https://www.basketball-reference.com/leagues/NBA_2022_standings.html). Upload your over/unders or see my predictions below. (See table below chart for example of how over/under csv must be formatted.)","pinned":false,"hidden":false,"mode":"md"},{"id":201,"value":"viewof csvfile = Inputs.file({\n label: \"Upload your over/unders\",\n accept: \".csv\",\n required: false\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":274,"value":"## Projected points: ${total_points} / 56","pinned":false,"hidden":false,"mode":"md"},{"id":367,"value":"$31","pinned":false,"hidden":false,"mode":"html"},{"id":293,"value":"dotPlot = plotTeamDotPlot()","pinned":false,"hidden":false,"mode":"ojs"},{"id":515,"value":"Inputs.table(file)","pinned":false,"hidden":false,"mode":"ojs"},{"id":286,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"function plotTeamBarChart(data = data_merged) {\n return Plot.plot({\n width: width,\n y: {\n domain: d3.sort(data, (d) => -d[\"W/L%\"]).map((d) => d.team)\n },\n x: {\n domain: [0, 1],\n grid: true\n },\n color: {\n domain: [\"over\", \"under\"],\n range: [\"green\", \"red\"],\n legend: true\n },\n tooltip: {\n stroke: \"black\"\n },\n marginLeft: 150,\n marks: [\n Plot.barX(data, {\n fill: \"skyblue\",\n y: \"team\",\n x: \"W/L%\",\n title: (d) =>\n `${d.team} \\n Over or Under: ${d.over_under} \\n Lock amount: ${\n d.lock\n } \\n Difference in W/L %: ${parseFloat(\n d.target_percent - d[\"W/L%\"]\n ).toFixed(3)}`\n }),\n Plot.dotX(data_merged, {\n y: \"team\",\n fill: \"over_under\",\n r: \"lock\",\n x: \"target_percent\"\n })\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":310,"value":"function didHit(d) {\n if (d.over_under === \"over\" && d.target_percent < d[\"W/L%\"]) return d.lock;\n if (d.over_under === \"under\" && d.target_percent > d[\"W/L%\"]) return d.lock;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":262,"value":"total_points = d3.sum(data_merged, (d) => {\n if (d.over_under === \"over\" && d.target_percent < d[\"W/L%\"]) return d.lock;\n if (d.over_under === \"under\" && d.target_percent > d[\"W/L%\"]) return d.lock;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":602,"value":"// plotTeamBarChart(data_merged)","pinned":true,"hidden":false,"mode":"ojs"},{"id":246,"value":"file = {\n if (csvfile) return csvfile.csv();\n return FileAttachment(\"casey_standings.csv\").csv();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":530,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":127,"value":"rawOvers = file","pinned":false,"hidden":false,"mode":"ojs"},{"id":150,"value":"data_merged = d3\n .sort(all_data, (d) => d.team)\n .map((d, i) => {\n d.target_percent = parseFloat(rawOvers[0][rawOvers.columns[i]]) / 82;\n d.target_games = parseFloat(rawOvers[0][rawOvers.columns[i]]);\n d.over_under = rawOvers[1][rawOvers.columns[i]] === \"o\" ? \"over\" : \"under\";\n d.lock = +rawOvers[3][rawOvers.columns[i]];\n return d;\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":129,"value":"all_data = [...west_data, ...east_data]","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"EAST_RAW = d3.csv(\n \"https://raw.githubusercontent.com/caHaber/flat-data-nba-standings/master/EAST_standings.csv\",\n {\n \"Cache-Control\": \"no-cache\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":107,"value":"west_data = parseRawStandings(WEST_RAW, \"Western Conference\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":57,"value":"east_data = parseRawStandings(EAST_RAW, \"Eastern Conference\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"WEST_RAW = d3.csv(\n \"https://raw.githubusercontent.com/caHaber/flat-data-nba-standings/master/WEST_standings.csv\",\n {\n \"Cache-Control\": \"no-cache\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":96,"value":"function parseRawStandings(data, conference) {\n data.map((d) => {\n d.team = d[conference];\n d[\"W/L%\"] = +d[\"W/L%\"];\n return d;\n });\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":221,"value":"import { Plot } from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}