banana_depot_scene_towers (view)
22 rows
This data as json, CSV (advanced)
Suggested facets: Wins, Losses
Tower | Games | Wins | Losses | Winrate | Pickrate | Winrate_LowerBound_95CI |
---|---|---|---|---|---|---|
MortarMonkey | 428 | 267 | 161 | 62.38% | 5.46% | 57.79% |
BananaFarm | 1466 | 823 | 643 | 56.14% | 18.71% | 53.60% |
TackShooter | 1025 | 569 | 456 | 55.51% | 13.08% | 52.47% |
BombShooter | 938 | 513 | 425 | 54.69% | 11.97% | 51.51% |
WizardMonkey | 697 | 369 | 328 | 52.94% | 8.89% | 49.24% |
SpikeFactory | 741 | 390 | 351 | 52.63% | 9.46% | 49.04% |
IceMonkey | 279 | 134 | 145 | 48.03% | 3.56% | 42.17% |
MonkeySub | 211 | 96 | 115 | 45.50% | 2.69% | 38.78% |
MonkeyAce | 56 | 29 | 27 | 51.79% | 0.71% | 38.70% |
SniperMonkey | 230 | 103 | 127 | 44.78% | 2.94% | 38.36% |
EngineerMonkey | 67 | 31 | 36 | 46.27% | 0.86% | 34.33% |
HeliPilot | 306 | 118 | 188 | 38.56% | 3.91% | 33.11% |
BoomerangMonkey | 126 | 49 | 77 | 38.89% | 1.61% | 30.38% |
MonkeyBuccaneer | 89 | 36 | 53 | 40.45% | 1.14% | 30.25% |
SuperMonkey | 215 | 76 | 139 | 35.35% | 2.74% | 28.96% |
GlueGunner | 274 | 94 | 180 | 34.31% | 3.50% | 28.69% |
MonkeyVillage | 233 | 75 | 158 | 32.19% | 2.97% | 26.19% |
DartMonkey | 95 | 34 | 61 | 35.79% | 1.21% | 26.15% |
Druid | 57 | 21 | 36 | 36.84% | 0.73% | 24.32% |
NinjaMonkey | 164 | 49 | 115 | 29.88% | 2.09% | 22.87% |
Alchemist | 88 | 26 | 62 | 29.55% | 1.12% | 20.01% |
DartlingGunner | 51 | 16 | 35 | 31.37% | 0.65% | 18.64% |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW banana_depot_scene_towers AS WITH banana_depot_scene AS (SELECT * FROM matches WHERE map = 'banana_depot_scene') SELECT Tower, Games, Wins, Losses, printf('%.2f%%', WR * 100) AS Winrate, printf('%.2f%%', PR * 100) AS Pickrate, printf('%.2f%%', (WR - 1.96 * SQRT((WR * (1 - WR)) / Games)) * 100) AS Winrate_LowerBound_95CI FROM (SELECT Tower, Games, Wins, Losses, CAST(Wins AS REAL) / Games AS WR, CAST(Games AS REAL) / ( (SELECT COUNT(*) FROM banana_depot_scene) * 6) AS PR FROM (SELECT Tower, SUM(Win) + SUM(NOT Win) AS Games, SUM(Win) AS Wins, SUM(NOT Win) AS Losses FROM (SELECT lt1 AS Tower, playerLeftWin AS Win FROM banana_depot_scene UNION ALL SELECT lt2 AS Tower, playerLeftWin AS Win FROM banana_depot_scene UNION ALL SELECT lt3 AS Tower, playerLeftWin AS Win FROM banana_depot_scene UNION ALL SELECT rt1 AS Tower, NOT playerLeftWin AS Win FROM banana_depot_scene UNION ALL SELECT rt2 AS Tower, NOT playerLeftWin AS Win FROM banana_depot_scene UNION ALL SELECT rt3 AS Tower, NOT playerLeftWin AS Win FROM banana_depot_scene) GROUP BY Tower)) WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6 ORDER BY Winrate_LowerBound_95CI DESC;