Skip to content

Instantly share code, notes, and snippets.

Donald Miner donaldpminer

  • Miner & Kasch Data Science
  • Maryland, USA
Block or report user

Report or block donaldpminer

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View gist:4e9df0d3e3240a842ac4b4345e3c5430
commander | solringcount | totalcount | perc
---------------------------------+--------------+------------+-------------------
Budoka Gardener | 5 | 38 | 0.131578947368421
Marhault Elsdragon | 3 | 17 | 0.176470588235294
Barktooth Warbeard | 3 | 16 | 0.1875
Zurgo Bellstriker | 54 | 275 | 0.196363636363636
Kasimir the Lone Wolf | 1 | 5 | 0.2
Jerrard of the Closed Fist | 5 | 21 | 0.238095238095238
Toothy, Imaginary Friend | 1 | 4 | 0.25
Sir Shandlar of Eberyn | 6 | 22 | 0.272727272727273
View gist:1d186f833af31eea29bf145a839a7f55
commander | count
-----------------------------+-------
Lu Su, Wu Advisor | 1
Lu Meng, Wu General | 1
Zhang Fei, Fierce Warrior | 1
Gosta Dirk | 1
Rashka the Slayer | 1
Sun Ce, Young Conquerer | 1
Xun Yu, Wei Advisor | 2
Ma Chao, Western Warrior | 2
View gist:8997c54cde507faa65b6bce8f6a7ffdc
http://www.mtggoldfish.com/deck/1460884
http://www.mtggoldfish.com/deck/1458732
http://www.mtggoldfish.com/deck/1458618
https://deckstats.net/decks/52564/1136525-meren-of-clan-nel-toth/en
http://www.mtggoldfish.com/deck/1467819
http://www.mtggoldfish.com/deck/1401177
https://deckstats.net/decks/117927/1124261--5-goreclaw-timmy/en
http://www.mtggoldfish.com/deck/1408287
http://www.mtggoldfish.com/deck/1510944
https://deckstats.net/decks/119744/1139988-emmara-tappy-tokens/en
View gist:3dc1b11b18ed64cf3123f5f29dcba53a
commander | commander2 | count | avg
---------------------------------+-----------------------------+-------+------------------
Thrasios, Triton Hero | Tymna the Weaver | 346 | 3301.1952601156
Sliver Queen | | 495 | 2225.49319191919
Silas Renn, Seeker Adept | Thrasios, Triton Hero | 61 | 2180.3006557377
Teferi, Temporal Archmage | | 699 | 1941.90190271817
Leovold, Emissary of Trest | | 801 | 1862.86240948814
Mishra, Artificer Prodigy | | 333 | 1828.92678678678
Xiahou Dun, the One-Eyed | | 161 | 1794.77869565217
Tana, the Bloodsower | Tymna the Weaver | 262 | 1650.03530534351
View gist:b6488359978f0c66697f8d4e28213c1f
commander | count | avg
---------------------------------+-------+------------------
Thrasios, Triton Hero | 796 | 2287.74810301507
Sliver Queen | 495 | 2225.49319191919
Teferi, Temporal Archmage | 699 | 1941.90190271817
Leovold, Emissary of Trest | 801 | 1862.86240948814
Mishra, Artificer Prodigy | 333 | 1828.92678678678
Xiahou Dun, the One-Eyed | 161 | 1794.77869565217
Kess, Dissident Mage | 980 | 1505.38154081633
Tana, the Bloodsower | 319 | 1472.02467084639
View gist:da44ec9772ec8cf1257bc3bbcee322c8
card | count | price
---------------------------------+-------+---------
Mana Crypt | 25449 | 154.99
Mox Diamond | 10064 | 229.99
Scrubland | 9665 | 189.99
Savannah | 9593 | 164.99
Bayou | 9574 | 279.99
Underground Sea | 9304 | 659.99
Grim Monolith | 9160 | 124.99
Tropical Island | 9076 | 299.99
View gist:d0124845d41ba6ca0844d8d8a65b1c3c
card | count | price | count * price
---------------------------------+--------+---------+------------
Timetwister | 2652 | 3499.99 | 9281973.48
Underground Sea | 9304 | 659.99 | 6140546.96
Mana Crypt | 25449 | 154.99 | 3944340.51
Volcanic Island | 7506 | 499.99 | 3752924.94
Gaea's Cradle | 8307 | 409.99 | 3405786.93
Mishra's Workshop | 1401 | 2199.99 | 3082185.99
Tundra | 8479 | 339.99 | 2882775.21
The Tabernacle at Pendrell Vale | 976 | 2899.99 | 2830390.24
View top_by_color_by_cid.csv
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
{} 0 Everflowing Chalice 401 1
{} 0 Endless One 184 2
{} 0 Mana Crypt 114 3
{} 1 Sol Ring 469 1
{} 1 Voltaic Key 288 2
{} 1 Expedition Map 273 3
{} 2 Mind Stone 404 1
{} 2 Warping Wail 327 2
{} 2 Lightning Greaves 305 3
{} 3 Worn Powerstone 400 1
@donaldpminer
donaldpminer / gist:aa8ffdb087688bd3a4f9b66b7bdb7605
Created Oct 21, 2018
Top Cards per color identity and per cmc
View gist:aa8ffdb087688bd3a4f9b66b7bdb7605
October 21st, 2018 from EDHREC data
SELECT * FROM
(SELECT coloridentity, cmc, card, cnt, RANK() OVER (PARTITION BY (coloridentity, cmc) ORDER BY cnt DESC) rank
FROM
(SELECT card, aa.coloridentity as coloridentity, cmc, cnt FROM
(SELECT ccid.card as card, coloridentity, COUNT(*) as cnt FROM (SELECT card, coloridentity FROM cards JOIN (SELECT * FROM decks WHERE savedate>='2017-10-20') decks ON cards.url=decks.url) ccid
GROUP BY ccid.card, coloridentity) aa JOIN cardref ON aa.card=cardref.name) bb
) cc WHERE rank <= 3
ORDER BY coloridentity, cmc, rank
@donaldpminer
donaldpminer / gist:5318c5973e42a01370f697d0ad61dfaa
Created Oct 13, 2018
EDHREC's Top 100 Money Volume Cards
View gist:5318c5973e42a01370f697d0ad61dfaa
Braden Bowdish
@bowdish_braden
@edhrec Which card has had the most amount of money spent on it? Assuming
no one proxies or owns 1 copy and puts it in each deck.
price * number of decks it is in = ??
-----
Prices are from October 12th, 2018 Cardkingdom prices.
You can’t perform that action at this time.