Skip to content

Instantly share code, notes, and snippets.

@james4k
Created June 6, 2014 18:51
Show Gist options
  • Save james4k/ecab13c32dee8149e567 to your computer and use it in GitHub Desktop.
Save james4k/ecab13c32dee8149e567 to your computer and use it in GitHub Desktop.
linear regression on indie category w/o r2 constraint
appid | name | slope | r2 | avg
--------+-------------------------------------------------------------+-----------------------+----------------------+-------
221100 | DayZ | 0.0234480534248668 | 0.592159361502954 | 23093
4000 | Garry's Mod | 0.0215832431644035 | 0.883818454084834 | 28318
244850 | Space Engineers | 0.0102031501830021 | 0.646860944517838 | 4660
105600 | Terraria | 0.0083959098260543 | 0.114798916115606 | 41057
242920 | Banished | 0.00784941120625064 | 0.182961120318323 | 5875
208090 | Loadout | 0.00699533711903867 | 0.12655549373197 | 13612
227300 | Euro Truck Simulator 2 | 0.00278312958235827 | 0.639483614573286 | 3391
220200 | Kerbal Space Program | 0.00203382991389009 | 0.278723065688733 | 4107
251570 | 7 Days to Die | 0.00143803695280915 | 0.178100191544251 | 2365
233450 | Prison Architect | 0.00126280749260566 | 0.438898324878937 | 1913
244210 | Assetto Corsa | 0.00105252315151711 | 0.621812029226013 | 599
226700 | Infestation: Survivor Stories | 0.000953702679491732 | 0.111181291064644 | 3648
222880 | Insurgency | 0.000884431346767985 | 0.518522725585889 | 1184
223390 | Forge | 0.000846646862954869 | 0.590377262948021 | 927
234650 | Shadowrun Returns | 0.000591307364314857 | 0.0319683447685836 | 2213
232810 | Godus | 0.000537352556637411 | 0.140675308155681 | 1116
209080 | Guns of Icarus Online | 0.000529192014908579 | 0.310808610323933 | 1159
104900 | ORION: Dino Horde | 0.000484943081891728 | 0.262858378575352 | 1174
221910 | The Stanley Parable | 0.000455662590601548 | 0.247425225706541 | 908
108600 | Project Zomboid | 0.000419617815970081 | 0.0951458493593201 | 679
264140 | Pixel Piracy | 0.000410420369789488 | 0.0702432064833054 | 420
224500 | Gnomoria | 0.000361685276617598 | 0.469833673579904 | 459
230230 | Divinity Original Sin | 0.000281786715490469 | 0.615663938969335 | 259
247830 | Aerena | 0.000243175996000367 | 0.476133736877838 | 117
214770 | Guacamelee! Gold Edition | 0.00023273171751007 | 0.0812334853405487 | 422
263760 | Turbo Dismount | 0.000217354967136677 | 0.546999105641483 | 115
204300 | Awesomenauts | 0.000194914496373597 | 0.0174996787506795 | 2428
113020 | Monaco | 0.000179159585170725 | 0.114775042745536 | 451
232790 | Broken Age | 0.000176216196684941 | 0.195240730521798 | 299
223470 | POSTAL 2 | 0.000173333380414369 | 0.339301474174193 | 353
224760 | FEZ | 0.000155609099635209 | 0.098740559184912 | 490
225600 | Blade Symphony | 0.000151966976780318 | 0.392735415982925 | 272
224480 | Octodad: Dadliest Catch | 0.000148749018940545 | 0.232220525552928 | 371
210770 | Sanctum 2 | 0.000132417245404721 | 0.00340227330934136 | 1601
233150 | LUFTRAUSERS | 0.000131214098329587 | 0.485283432818178 | 122
207140 | SpeedRunners | 0.000130930554881763 | 0.384420306245372 | 116
225080 | Brothers - A Tale of Two Sons | 0.000123052130085528 | 0.241771398603522 | 232
219640 | Chivalry: Medieval Warfare | 0.000114664178803755 | 0.000978722867455333 | 4867
228380 | Next Car Game | 0.000101594541493109 | 0.505373139822167 | 102
219740 | Don't Starve | 9.99142822042615e-05 | 0.00129988671774792 | 3432
227860 | Castle Story | 8.69531428426422e-05 | 0.045008396337931 | 283
231740 | Knights of Pen and Paper +1 | 7.50592377994758e-05 | 0.103392540316434 | 155
223410 | Perpetuum | 7.37330024629853e-05 | 0.29991647941775 | 147
220660 | StarDrive | 7.34271347657285e-05 | 0.0134481586100967 | 785
254440 | Pool Nation | 6.96659537939919e-05 | 0.0626807293719315 | 119
72200 | Universe Sandbox | 6.73194071646928e-05 | 0.191583634921279 | 266
207230 | Archeblade | 6.1415506762215e-05 | 0.00655349500155725 | 610
236130 | Horizon | 6.08354617005869e-05 | 0.129514840678817 | 136
232430 | Gone Home | 5.85946726953557e-05 | 0.0706509601204593 | 166
235250 | Super Sanctum TD | 5.52350928909979e-05 | 0.144823569370166 | 123
206500 | AirMech | 5.40190654972058e-05 | 0.0122412447614118 | 684
224420 | Afterfall InSanity Extended Edition | 5.12155253303664e-05 | 0.254926843607261 | 101
219890 | Antichamber | 4.54081735573762e-05 | 0.00932973962597773 | 593
108200 | Ticket to Ride | 4.38615087792117e-05 | 0.276171473686712 | 182
35720 | Trine 2 | 4.30251962006943e-05 | 0.00436622735313371 | 779
2400 | The Ship | 4.24556807235626e-05 | 0.0893283198210808 | 199
70000 | Dino D-Day | 3.9415108127477e-05 | 0.0282828921378012 | 308
236090 | Dust: An Elysian Tail | 3.9101535657964e-05 | 0.00165881880529599 | 707
214340 | Deponia | 3.50913836022577e-05 | 0.0627027531487356 | 172
218740 | Pid | 3.27432227485605e-05 | 0.119618333376564 | 137
238320 | Outlast | 2.9289966437184e-05 | 0.000488727462086343 | 669
218060 | BIT.TRIP Presents... Runner2: Future Legend of Rhythm Alien | 2.92472143801582e-05 | 0.016965633549493 | 234
206440 | To the Moon | 2.65536266300317e-05 | 0.0703972463160073 | 139
221640 | Super Hexagon | 2.52311656943264e-05 | 0.00723127025124342 | 315
220780 | Thomas Was Alone | 2.10372502793194e-05 | 0.0126289971626501 | 218
70300 | VVVVVV | 1.35335033937898e-05 | 0.0410199135494909 | 110
222520 | Champions of Regnum | 1.17667725521398e-05 | 0.00383968411845037 | 233
230700 | La-Mulana | 1.01526836743613e-05 | 0.00378131063071767 | 123
38600 | Faerie Solitaire | 9.85059310073276e-06 | 0.00559885100810356 | 159
35700 | Trine | 5.49562842009719e-06 | 0.000720085429515726 | 260
250460 | Bridge Constructor | 4.16488111601632e-06 | 0.000236156221241638 | 102
224440 | Folk Tale | 2.56574911305799e-06 | 0.000921332713279434 | 108
98200 | Frozen Synapse | -1.62233537293023e-06 | 0.000109554498242188 | 195
49600 | Beat Hazard | -7.29724360778963e-06 | 0.00607802801102479 | 123
220860 | McPixel | -8.47986474784178e-06 | 0.00139092237536786 | 291
97000 | Solar 2 | -1.09053723387691e-05 | 0.00773605124643071 | 145
237430 | Expeditions: Conquistador | -2.01864250902707e-05 | 0.00796560971920396 | 168
22230 | Rock of Ages | -2.18577688912464e-05 | 0.111094558731892 | 104
26800 | Braid | -2.81825256349889e-05 | 0.0937275538937896 | 116
91700 | E.Y.E: Divine Cybermancy | -3.29740970776228e-05 | 0.0402377468580704 | 230
204260 | Trine 2 Demo | -3.36526826059941e-05 | 0.0012974082059874 | 1458
203510 | Fortune Summoners: Secret of the Elemental Stone | -3.48638826660179e-05 | 0.249854488686964 | 109
227220 | Sang-Froid - Tales of Werewolves | -3.56566285031642e-05 | 0.091251423420611 | 103
42170 | Krater | -3.59049465083894e-05 | 0.137823461389533 | 129
96300 | Ravaged Zombie Apocalypse | -3.85412414894011e-05 | 0.0621993108258765 | 239
71000 | Evochron Mercenary | -4.11886394097604e-05 | 0.219701344500483 | 138
233720 | Surgeon Simulator 2013 | -4.19852789831474e-05 | 0.00509914701607966 | 503
41070 | Serious Sam 3: BFE | -4.74451457322182e-05 | 0.012440396934778 | 709
218090 | Unity of Command | -4.77504346293649e-05 | 0.253613723940023 | 125
40800 | Super Meat Boy | -4.81955738093103e-05 | 0.0237659590869626 | 440
238280 | Legend of Dungeon | -4.94062662170859e-05 | 0.0579172453226184 | 103
92800 | SpaceChem | -5.29972685201731e-05 | 0.463226800654019 | 115
41800 | Gratuitous Space Battles | -5.35671105543444e-05 | 0.0530152528764537 | 339
203810 | Dear Esther | -5.44599175007195e-05 | 0.178248975575107 | 208
218410 | Defender's Quest: Valley of the Forgotten | -5.69082260744774e-05 | 0.0453736675489807 | 237
219680 | Proteus | -5.87181135293744e-05 | 0.290612016471552 | 110
218640 | Lucius | -6.37273061038934e-05 | 0.138933710954185 | 227
215470 | Primal Carnage | -6.4173432390048e-05 | 0.165306890076265 | 263
200900 | Cave Story+ | -6.47353613100235e-05 | 0.232324786989119 | 197
237570 | Penny Arcade's On the Rain-Slick Precipice of Darkness 4 | -6.49825428752742e-05 | 0.156479434474416 | 125
96400 | Shoot Many Robots | -6.82389917883183e-05 | 0.219087810814132 | 228
249050 | Dungeon of the Endless | -6.86711452669734e-05 | 0.145769987800779 | 103
259060 | Dominions 4 | -7.0413791300711e-05 | 0.25961355702697 | 126
215020 | Orcs Must Die! 2 Demo | -7.23483855751448e-05 | 0.155578795414025 | 288
212010 | Galaxy on Fire 2™ Full HD | -7.24352231399562e-05 | 0.294065905005024 | 201
12900 | Audiosurf | -7.37336405372966e-05 | 0.128796663907342 | 374
22100 | Mount & Blade | -7.76755105627879e-05 | 0.33134297228529 | 248
238530 | Super Puzzle Platformer Deluxe | -8.51420958561696e-05 | 0.311708029919779 | 107
17510 | Age of Chivalry | -8.56849750740318e-05 | 0.511043186860057 | 197
214360 | Tower Wars | -8.57157012688121e-05 | 0.153197237099959 | 337
238930 | 7 Grand Steps, Step 1: What Ancients Begat | -8.61258055914658e-05 | 0.243214998790412 | 111
233860 | Kenshi | -8.88541552121309e-05 | 0.0652928017592354 | 362
18500 | Defense Grid: The Awakening | -8.99060513684151e-05 | 0.198302733075056 | 318
233470 | Evoland | -9.17810752626053e-05 | 0.0970075516249668 | 256
248390 | Craft The World | -9.69533880625852e-05 | 0.00782248306536557 | 502
209950 | Triple Town | -9.72354648111521e-05 | 0.475093808996054 | 170
231410 | Kerbal Space Program Demo | -9.81397180137356e-05 | 0.115196395181621 | 241
242880 | Sir, You Are Being Hunted | -0.000105266920129922 | 0.295818164801751 | 104
238890 | Skyward Collapse | -0.000105468827288736 | 0.265906154529611 | 145
107100 | Bastion | -0.000111713203918517 | 0.0284723240831744 | 953
261820 | Estranged: Act I | -0.000116308269452936 | 0.0338094749563477 | 202
17570 | Pirates, Vikings, & Knights II | -0.000117825698586494 | 0.692466028731789 | 212
239700 | Hate Plus | -0.000120027026562925 | 0.322493272894344 | 107
211580 | Wanderlust: Rebirth | -0.000122454971180427 | 0.164076840695896 | 465
227680 | StarForge Alpha | -0.000127689436873877 | 0.24021205005283 | 194
209670 | Cortex Command | -0.000128978111846514 | 0.133550792786685 | 484
70400 | Recettear: An Item Shop's Tale | -0.000129301892630553 | 0.187638067800654 | 487
221260 | Little Inferno | -0.000130035324265091 | 0.19283537029237 | 334
212800 | Super Crate Box | -0.00013077715441716 | 0.306354228976846 | 351
231160 | The Swapper | -0.000131360347704504 | 0.181170521758699 | 218
230860 | Cannon Brawl | -0.000136788179446895 | 0.414991699515425 | 118
235360 | Prime World: Defenders | -0.000138646140843561 | 0.165975999454528 | 253
269210 | Hero Siege | -0.000143188940436907 | 0.123513589697166 | 142
230050 | DLC Quest | -0.000144241240980875 | 0.400264493086702 | 193
98800 | Dungeons of Dredmor | -0.000147900948823235 | 0.338692738311041 | 395
231120 | Euro Truck Simulator 2 Demo | -0.000148158933729103 | 0.217670691337044 | 327
219850 | Torchlight II Demo | -0.000153769641973214 | 0.519477347710949 | 268
209540 | Strike Suit Zero | -0.000156716771779207 | 0.152353700122957 | 410
91600 | Sanctum | -0.000158700516681161 | 0.207872852911522 | 423
48000 | LIMBO | -0.000165505965387253 | 0.234782485397753 | 548
250520 | Underrail | -0.000165506483151735 | 0.399586334344437 | 119
41010 | Serious Sam HD: The Second Encounter | -0.000166845502363855 | 0.0092264357061038 | 2038
239840 | Dead State | -0.000166953921214523 | 0.103085972279534 | 112
250260 | Jazzpunk | -0.000172886034461195 | 0.122574453926034 | 107
238240 | Edge of Space | -0.000173304393695372 | 0.16333664234631 | 267
213650 | Dwarfs F2P | -0.000176127003973059 | 0.444853081887369 | 337
249990 | FORCED | -0.000178660621206612 | 0.118851937822962 | 202
241720 | Guncraft | -0.000179937272137152 | 0.464083533584649 | 145
250420 | 8BitMMO | -0.000185143498445447 | 0.127535206740337 | 159
247240 | Volgarr the Viking | -0.000189321355966548 | 0.513103036666071 | 125
249330 | Unholy Heights | -0.000198987828608699 | 0.491233490112795 | 114
219150 | Hotline Miami | -0.000203517261313539 | 0.0991396356091782 | 840
17500 | Zombie Panic Source | -0.000207416295854617 | 0.747535702648493 | 472
57300 | Amnesia: The Dark Descent | -0.000212183375519278 | 0.467185207098033 | 552
200210 | Realm of the Mad God | -0.000212233338746343 | 0.0939615977153024 | 1447
233700 | Sword of the Stars: The Pit | -0.000219096631873074 | 0.406705638075603 | 326
211400 | Deadlight | -0.000226972988828674 | 0.359970321677585 | 482
242570 | Space Hulk | -0.000238776780888006 | 0.184375733911614 | 332
107200 | Space Pirates and Zombies | -0.000239217073488814 | 0.387446025944828 | 602
247020 | Cook, Serve, Delicious! | -0.000240358700280837 | 0.521918072122283 | 126
227580 | 10,000,000 | -0.000240676453485362 | 0.218991503899307 | 522
219990 | Grim Dawn | -0.000249846302803053 | 0.154526355900349 | 264
233740 | Organ Trail: Director's Cut | -0.000252894120615909 | 0.330879561496559 | 304
246090 | Spacebase DF-9 | -0.000254339898769385 | 0.517790309867723 | 174
239070 | Hammerwatch | -0.000256936919317259 | 0.0699489396160255 | 462
248630 | Kingdoms Rise | -0.000256951173227978 | 0.569004473549886 | 106
214790 | The Basement Collection | -0.000257335736779599 | 0.221411728350053 | 789
246760 | Legends of Eisenwald | -0.00026472472873106 | 0.471030807335541 | 149
113200 | The Binding of Isaac | -0.000266986177911619 | 0.0155419337381206 | 4976
237740 | Angry Video Game Nerd Adventures | -0.000274155531034037 | 0.553364399724915 | 170
227180 | Dawn of Fantasy: Kingdom Wars | -0.000274245447962035 | 0.382392623760147 | 309
207170 | Legend of Grimrock | -0.000290238018805088 | 0.312334016152301 | 591
244730 | Divekick | -0.000295099796913914 | 0.435249377951829 | 230
218820 | Mercenary Kings | -0.000299193226538149 | 0.172425065299201 | 423
248410 | Legends of Aethereus | -0.000305339707459754 | 0.348321468193595 | 222
209270 | Hero Academy | -0.000310743214172573 | 0.54429759783188 | 614
214560 | Mark of the Ninja | -0.000320126360814869 | 0.142622195035404 | 934
240760 | Wasteland 2 | -0.000349019325944514 | 0.172329545923129 | 335
224540 | Ace of Spades | -0.000363761806908577 | 0.0605332069195827 | 1859
227400 | Darkfall Unholy Wars | -0.000364547163087262 | 0.7690970346729 | 297
280220 | Creeper World 3: Arc Eternal | -0.000364575917224358 | 0.155010510890292 | 246
257970 | Loren The Amazon Princess | -0.000385338972055363 | 0.558253772122651 | 115
252030 | Valdis Story: Abyssal City | -0.000387178129228049 | 0.185036000275906 | 357
257050 | Darkout | -0.000391659696082532 | 0.667705546632342 | 138
266210 | One Way Heroics | -0.000392170925836018 | 0.186300654230849 | 158
245170 | Skullgirls | -0.000407536802988526 | 0.313951336372181 | 435
102600 | Orcs Must Die! | -0.000410825410275815 | 0.2303914285379 | 1349
104700 | Super Monday Night Combat | -0.000418581793081338 | 0.550999336194398 | 809
212680 | FTL: Faster Than Light | -0.000445329724803658 | 0.00606297150076814 | 6990
219340 | The Banner Saga: Factions | -0.000449189204807656 | 0.361686253553673 | 631
204360 | Castle Crashers | -0.000456653924552182 | 0.146480343295815 | 1370
206190 | Gunpoint | -0.000457159528483555 | 0.428673549394123 | 463
252410 | SteamWorld Dig | -0.000458016389585947 | 0.599565186814927 | 168
241910 | Goodbye Deponia | -0.000463906272740504 | 0.397064961676407 | 293
249650 | Blackguards | -0.000466610552690045 | 0.0828633607569103 | 523
25000 | Overgrowth | -0.00047729441133417 | 0.689163018187729 | 173
245470 | Democracy 3 | -0.000518256076262553 | 0.259680530443432 | 384
271820 | Card City Nights | -0.000527584067715153 | 0.564470089477124 | 116
208140 | Endless Space | -0.000555055531416459 | 0.145339347935167 | 2154
218330 | Smashmuck Champions | -0.0005614895427471 | 0.619027423833627 | 325
232050 | Eador. Masters of the Broken World | -0.000572134739501102 | 0.625160417391802 | 689
262790 | Our Darker Purpose | -0.000585818099783405 | 0.778099265793476 | 122
226620 | Desktop Dungeons | -0.000596720757930177 | 0.244675748020789 | 437
249570 | The Castle Doctrine | -0.000640222591591244 | 0.773215418008614 | 151
270550 | Yet Another Zombie Defense | -0.000644904836489629 | 0.410014883208971 | 138
259680 | Tales of Maj'Eyal | -0.000659400921859752 | 0.729912201811806 | 244
251990 | Long Live The Queen | -0.00066060342099511 | 0.877862338902085 | 223
247750 | The Stanley Parable Demo | -0.000681768719308743 | 0.527061608088126 | 364
94400 | Nidhogg | -0.000699507196267035 | 0.563601819814985 | 221
250340 | Blockland | -0.000700815994005298 | 0.607164420487084 | 343
265210 | Viscera Cleanup Detail: Santa's Rampage | -0.000740461191272829 | 0.530257339687473 | 280
241410 | CastleStorm | -0.00082392329168961 | 0.322760118338189 | 829
283880 | Heroine's Quest: The Herald of Ragnarok | -0.000831939104845982 | 0.698424163005592 | 139
221020 | Towns | -0.000841534875396987 | 0.580632633056456 | 1310
239200 | Amnesia: A Machine for Pigs | -0.000885458996570658 | 0.360231671516138 | 655
273450 | Blackguards Demo | -0.000906181437336429 | 0.61364514839398 | 242
222730 | Reus | -0.000917153070444458 | 0.331695185347054 | 1137
239350 | Spelunky | -0.000929016261462903 | 0.34928887779819 | 989
274480 | Drox Operative | -0.000929961552230608 | 0.718395052458884 | 186
4920 | Natural Selection 2 | -0.000948684092014388 | 0.168193064861495 | 2828
246420 | Kingdom Rush | -0.000958934872994332 | 0.428734357206289 | 377
223710 | Cry of Fear | -0.000976553796646121 | 0.380632566182046 | 1332
219830 | King Arthur's Gold | -0.000988163775238149 | 0.754201470689836 | 435
237990 | The Banner Saga | -0.00101283132057716 | 0.102147166007111 | 900
239030 | Papers, Please | -0.0010595566269939 | 0.436766633702994 | 936
233980 | Unepic | -0.00109884984812993 | 0.317765923514973 | 1275
272060 | Serena | -0.00112845304513199 | 0.530123658482861 | 318
238430 | Contagion | -0.00114866073594334 | 0.450390318327375 | 658
265930 | Goat Simulator | -0.00131027813375101 | 0.0117241213436469 | 2182
247730 | Nether | -0.00141846417713741 | 0.668266505856103 | 790
215530 | The Incredible Adventures of Van Helsing | -0.00161830823819605 | 0.362828771030232 | 2044
239820 | Game Dev Tycoon | -0.00171154899614055 | 0.566429132195465 | 1101
264200 | One Finger Death Punch | -0.00233028976220988 | 0.837970924339168 | 391
263500 | Dragons and Titans | -0.00234616023541696 | 0.873430881870217 | 436
241600 | Rogue Legacy | -0.0025893722768068 | 0.379484218289385 | 2833
246620 | Plague Inc: Evolved | -0.00271977203513263 | 0.889239918554865 | 900
65800 | Dungeon Defenders | -0.00282863511801719 | 0.48860378523038 | 6195
201790 | Orcs Must Die! 2 | -0.00299377501296301 | 0.230057924029127 | 9790
257730 | Infinity Wars - Animated Trading Card Game | -0.00371281195902174 | 0.897527173848809 | 863
248820 | Risk of Rain | -0.00402267523021049 | 0.763973147595768 | 1859
224260 | No More Room in Hell | -0.00482984291870826 | 0.346260760017185 | 4105
237870 | Planet Explorers | -0.00571693008685747 | 0.782044358662432 | 909
200710 | Torchlight II | -0.0105016967463197 | 0.306616713305719 | 26981
242720 | GunZ 2: The Second Duel | -0.0210717162466346 | 0.717613897809994 | 4969
252490 | Rust | -0.027085756700474 | 0.0770436272904635 | 34753
238960 | Path of Exile | -0.0407878893848003 | 0.83007455602979 | 19346
211820 | Starbound | -0.117648702164366 | 0.689336462697144 | 39647
(247 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment