30:T66a,table = html` ${ category === "SEN" ? ` ${Array.from( { length: top / 5 }, (_, rowIndex) => ` ${Array.from({ length: 5 }, (_, colIndex) => { const playerIndex = rowIndex * 5 + colIndex; // const playerData = AllPlayerProfilePics.find((d) => d.ittfid == data.Result[playerIndex].IttfId); const playerName = data.Result[playerIndex].PlayerName; // const photo = AllPlayerProfilePics[playerIndex].headShot; // const photo = IttfId_2_pic(data.Result[playerIndex].IttfId); // const photo = players[playerIndex].image; // const photo ="https://wtt-web-frontdoor-cthahjeqhbh6aqe3.a01.azurefd.net/websitefiles/images/general/" +(SubEventCode == "MS" ? "men" : "women") +"_default_left.png"; const photo = players_with_headshot.filter( (d) => d.IttfId == data.Result[playerIndex].IttfId )[0].HeadShot; return ` `; }).join("")} ` ).join("")}

${ playerIndex + 1 + ". " + playerName }

` : "" } `31:[{"id":"e2b470f4eff6786d7df6513268635029c2ee81a638d5dc7be1e81c164b6d54cc3fbdbebdadcfe305e79fea6e9757b70716134cf8d83b35f913c4569f26e30c4b","href":"https://static.observableusercontent.com/files/e2b470f4eff6786d7df6513268635029c2ee81a638d5dc7be1e81c164b6d54cc3fbdbebdadcfe305e79fea6e9757b70716134cf8d83b35f913c4569f26e30c4b","name":"players_with_headshot.csv","type":"text/csv","lastModified":1752709407887.623,"size":190399}] 2e:{"title":"Table Tennis","cells":[{"id":0,"value":"# Table Tennis","pinned":false,"hidden":false,"mode":"md"},{"id":264,"value":"## WTT Ranking\n### ${m(CurrentRankingPublishDate.Result[0].RankingStatusDate).format(\"YYYY-MM-DD\")}","pinned":false,"hidden":false,"mode":"md"},{"id":344,"value":"viewof SubEventCode = Inputs.radio([\"MS\", \"WS\"], {\n label: \"gender\",\n value: \"MS\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1166,"value":"viewof con_nombres = Inputs.radio([\"Yes\", \"No\"], {\n label: \"names\",\n value: \"Yes\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1143,"value":"viewof top = Inputs.radio([5, 10, 20, 30, 40, 50], {\n label: \"Top\",\n value: 10\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1126,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":310,"value":"viewof category = Inputs.radio([\"SEN\", \"YOU\"], {\n label: \"category\",\n value: \"SEN\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1387,"value":"// lista de players para el WTT Top10 memory game\n//\nplayers = search.slice(0, 10).map((d, i) => ({\n name: d.PlayerName,\n image: players_with_headshot.filter(\n (d) => d.IttfId == data.Result[i].IttfId\n )[0].HeadShot,\n // image: AllPlayerProfilePics.find((d) => d.ittfid == data.Result[i].IttfId).headShot,\n // image: players_with_headshot.filter((d) => d.IttfId == \"137237\")[0][\"HeadShot\"],\n // image: \"https://wtt-web-frontdoor-cthahjeqhbh6aqe3.a01.azurefd.net/websitefiles/images/general/men_default_left.png\",\n rank: i + 1\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1604,"value":"search.slice(0, 20)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1366,"value":"1. [WTT Top10 memory game (hecho con lovable.app)](https://memory-match-game-fun.lovable.app/)\n2. [WTT Top10 memory game (hecho con Claude.AI, hosteado en Vercel)](https://memory-game-sigma-bay.vercel.app/)","pinned":false,"hidden":false,"mode":"md"},{"id":1313,"value":"___\n### Top ${EndRank}","pinned":false,"hidden":false,"mode":"md"},{"id":893,"value":"viewof EndRank = Inputs.radio([100, 250, 500, 1000, 3000], {\n label: \"Top (EndRank)\",\n value: 100\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":429,"value":"viewof search = Inputs.search(data.Result, {\n label: \"Country or Player\",\n columns: [\"CountryName\", \"PlayerName\"]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":139,"value":"Inputs.table(search, {\n columns: [\"CurrentRank\", \"PlayerName\", \"CountryName\", \"RankingPointsYTD\"]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1629,"value":"Plot.plot({\n width: width,\n // x: { axis: true },\n marks: [\n Plot.tickX(search, {\n tip: true,\n title: \"PlayerName\",\n x: (d) => +d[\"RankingPointsYTD\"],\n strokeOpacity: 1,\n stroke: \"CountryName\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1686,"value":"Plot.plot({\n height: 200,\n width: width,\n marks: [\n Plot.dot(\n search,\n Plot.dodgeY(\"middle\", {\n x: (d) => +d[\"RankingPointsYTD\"],\n fill: \"CountryName\",\n tip: true,\n title: \"PlayerName\"\n // ]r: 4\n })\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":185,"value":"\n \n \n \n ${Array.from(\n dataByAssoc,\n ([key, values]) => html`\n \n \n \n `\n )}\n

Assoc	Athletes
${key}	${values\n .map((d) => d.PlayerName + \" (#\" + d.CurrentRank + \")\")\n .join(\", \")}

","pinned":false,"hidden":false,"mode":"html"},{"id":1728,"value":"{\n const jugadores_por_pais = d3\n .groups(data.Result, (d) => d.CountryName)\n .map(([CountryName, grupos]) => ({\n pais: CountryName,\n cantidad: grupos.length,\n jugadores: grupos.map((d, i) => i + 1 + \". \" + d.PlayerName).join(\"\\n\")\n }))\n .sort(\n (a, b) =>\n d3.descending(a.cantidad, b.cantidad) || d3.ascending(a.pais, b.pais)\n );\n\n return Plot.plot({\n title: \"Cantidad de Jugadores por Pais\",\n marginLeft: 120,\n marks: [\n Plot.barX(jugadores_por_pais, {\n x: \"cantidad\",\n y: \"pais\",\n sort: { y: \"x\", reverse: true },\n fill: \"steelblue\",\n tip: true,\n title: \"jugadores\"\n }),\n Plot.ruleX([0])\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":604,"value":"Puntaje en lo que va del año (_RankingPointsYTD_) de cada jugador","pinned":false,"hidden":false,"mode":"md"},{"id":481,"value":"Plot.barX(data.Result.slice(0, 10), {\n x: \"RankingPointsYTD\",\n y: \"PlayerName\",\n sort: { y: \"x\", reverse: true },\n fill: \"CountryName\",\n stroke: \"black\",\n strokeWidth: 0.2,\n tip: true\n}).plot({\n marginLeft: 130,\n title: SubEventCode === \"WS\" ? \"Top10 Femenino\" : \"Top10 Masculino\",\n color: {\n legend: false,\n type: \"categorical\",\n domain: [\n \"Brazil\",\n \"China\",\n \"France\",\n \"Germany\",\n \"Japan\",\n \"Sweden\",\n \"Chinese Taipei\",\n \"Korea Republic\",\n \"Slovenia\",\n \"Macao, China\"\n ],\n range: [\n \"#009440\",\n \"#EE1C25\",\n \"#002654\",\n \"#FFCE00\",\n \"#EEE\",\n \"#005293\",\n \"#de2d26\",\n \"#111\",\n \"steelblue\",\n \"#0f7562\"\n ]\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":460,"value":"_______\n\n### Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":1568,"value":"Obteniendo la información de un jugador, hay que pasarle el IttfId https://wttcmsapigateway-new.azure-api.net/ttu/Players/GetPlayers?IttfId=115641\n\nPor ejemplo, aca estamos consultando sobre Hugo Calderano\n\n```d3.json(\"https://wttcmsapigateway-new.azure-api.net/ttu/Players/GetPlayers?IttfId=115641\")```\n\n\nEsta URL entrega los 100 registros https://wttcmsapigateway-new.azure-api.net/ttu/Players/GetPlayers\n\nEl resultado, contiene un JSON con 53.756 jugadores https://wttcmsapigateway-new.azure-api.net/ttu/Players/GetPlayers?limit=55000\n","pinned":false,"hidden":false,"mode":"md"},{"id":1461,"value":"\"https://wttcmsapigateway-new.azure-api.net/ttu/Rankings/GetRankingIndividuals?CategoryCode=\" +\n category +\n \"&SubEventCode=\" +\n SubEventCode +\n \"&StartRank=1&EndRank=\" +\n EndRank","pinned":false,"hidden":false,"mode":"ojs"},{"id":873,"value":"data = {\n let url =\n \"https://wttcmsapigateway-new.azure-api.net/ttu/Rankings/GetRankingIndividuals?CategoryCode=\" +\n category +\n \"&SubEventCode=\" +\n SubEventCode +\n \"&StartRank=1&EndRank=\" +\n EndRank;\n return d3.json(url);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1353,"value":"data.Result","pinned":true,"hidden":false,"mode":"ojs"},{"id":397,"value":"data.Result","pinned":false,"hidden":false,"mode":"ojs"},{"id":1346,"value":"CountryNames = [...new Set(data.Result.map((d) => d.CountryName))]","pinned":true,"hidden":false,"mode":"ojs"},{"id":201,"value":"d3.rollup(\n data.Result,\n (v) => v.length,\n (d) => d.CountryCode\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":303,"value":"data.Result.filter((d) => d.CountryCode == \"ARG\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":182,"value":"dataByAssoc.get(\"BRA\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":178,"value":"dataByAssoc = d3.group(data.Result, (d) => d.CountryCode)","pinned":true,"hidden":false,"mode":"ojs"},{"id":9,"value":"```javascript\nd3 = require(\"d3@7\")\nimport { vl } from \"@vega/vega-lite-api\"\n```\nYa no hace falta, importar **d3** o **vl (vega-lite)**, son parte de las librerías recomendadas que se cargan si las usas. \nhttps://observablehq.com/@observablehq/recommended-libraries","pinned":false,"hidden":false,"mode":"md"},{"id":743,"value":"____\n\nAnexo","pinned":false,"hidden":false,"mode":"md"},{"id":763,"value":"CurrentRankingPublishDate = await d3.json(\n \"https://cors-anywhere.herokuapp.com/https://wttcmsapigateway-new.azure-api.net/ttu/Rankings/GetCurrentRankingPublishDate?CategoryCode=\" +\n category,\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1374,"value":"category","pinned":true,"hidden":false,"mode":"ojs"},{"id":1048,"value":"m(CurrentRankingPublishDate.Result[0].RankingStatusDate).format(\"YYYY-MM-DD\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":1041,"value":"m = require(\"moment\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":772,"value":"Inputs.table(data.Result)","pinned":false,"hidden":false,"mode":"ojs"},{"id":930,"value":"// AllPlayerProfilePics = await d3.json(\"https://wttapigateway-new.azure-api.net/prod/api/cms/GetAllPlayerProfilePics\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1356,"value":"// AllPlayerProfilePics[0].headShot","pinned":true,"hidden":false,"mode":"ojs"},{"id":1586,"value":"players_with_headshot = FileAttachment(\"players_with_headshot.csv\").csv({\n typed: true\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1498,"value":"_AllPlayerProfilePics = data.Result.map((d) => ({\n IttfId: d.IttfId,\n PlayerName: d.PlayerName,\n // no sirve para todos, hay que sacarlo de otro lado\n headShot:\n \"https://photofiles.worldtabletennis.com/wtt-media/photos/400px/\" +\n d.IttfId +\n \"_Headshot_R_\" + // L = Left, R = Right\n d.PlayerName.replace(\" \", \"_\") +\n \".png\"\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1464,"value":"data","pinned":true,"hidden":false,"mode":"ojs"},{"id":1563,"value":"// para obtener informacion de 1 jugador, esta es la URL\n// https://wttcmsapigateway-new.azure-api.net/ttu/Players/GetPlayers?IttfId=115641\n\n// Sino le paso ningun parametro\n// https://wttcmsapigateway-new.azure-api.net/ttu/Players/GetPlayers","pinned":true,"hidden":false,"mode":"ojs"},{"id":1215,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":785,"value":"Plot.plot({\n title: \"Cantidad de Jugadores por Pais\",\n marginLeft: 120,\n marks: [\n Plot.barX(\n data.Result,\n Plot.groupY(\n { x: \"count\" },\n {\n y: \"CountryName\",\n tip: true,\n fill: \"steelblue\",\n sort: { y: \"x\", reverse: true }\n }\n )\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"vl\n .markBar()\n .title(\"Cantidad de jugadores por Pais - vega-lite API\")\n .data(data.Result)\n .encode(\n vl\n .y()\n .fieldO(\"CountryName\")\n .sort(vl.count(\"CountryName\").order(\"descending\")),\n vl.x().count(\"CountryName\").title(\"# players\"),\n vl.tooltip().count(\"CountryName\").title(\"Jugadores\")\n )\n //.width(300).height(1000)\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1301,"value":"embed({\n $schema: \"https://vega.github.io/schema/vega-lite/v5.json\",\n title: \"Cantidad de jugadores por Pais - Vega-lite embed\",\n data: { values: data.Result },\n mark: \"bar\",\n encoding: {\n y: {\n field: \"CountryName\",\n type: \"ordinal\",\n sort: { op: \"count\", order: \"descending\" }\n },\n x: {\n aggregate: \"count\",\n field: \"CountryName\",\n title: \"# players\"\n },\n tooltip: [\n {\n aggregate: \"count\",\n field: \"CountryName\",\n title: \"Jugadores\"\n }\n ]\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1303,"value":"embed = require(\"vega-embed\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1413,"value":"import { toggle } from \"@kelleyvanevert/little-things\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1426,"value":"viewof toggle_value = toggle({\n title_off: \"Off\",\n title: \"On\",\n value: true\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1224,"value":"","pinned":false,"hidden":false,"mode":"html"}],"files":"$W31","stdlib":"1","titling":"auto"}