In [1]:
import pandas as pd
moves = pd.read_excel("Pokemon Go - All Movesets.xlsx", "Simple")
moves = moves.fillna("")
moves["Standard"] = moves[["Standard Move 1", "Standard Move 2"]].apply(tuple, axis = 1)
moves["Special"] = moves[["Special Move 1", "Special Move 2", "Special Move 3"]].apply(tuple, axis = 1)
C:\Anaconda\lib\site-packages\pandas\io\excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >=1.6.1 and <2.0.0.
.format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver))
In [2]:
moves.head()
Out[2]:
#
Pokemon
Unnamed: 2
Standard Move 1
Standard Move 2
Unnamed: 5
Special Move 1
Special Move 2
Special Move 3
Unnamed: 9
Standard
Special
0
1
Bulbasaur
Vine Whip
Tackle
Sludge Bomb
Seed Bomb
Power Whip
(Vine Whip, Tackle)
(Sludge Bomb, Seed Bomb, Power Whip)
1
2
Ivysaur
Razor Leaf
Vine Whip
Sludge Bomb
Solar Beam
Power Whip
(Razor Leaf, Vine Whip)
(Sludge Bomb, Solar Beam, Power Whip)
2
3
Venusaur
Razor Leaf
Vine Whip
Sludge Bomb
Petal Blizzard
Solar Beam
(Razor Leaf, Vine Whip)
(Sludge Bomb, Petal Blizzard, Solar Beam)
3
4
Charmander
Ember
Scratch
Flame Charge
Flame Burst
Flamethrower
(Ember, Scratch)
(Flame Charge, Flame Burst, Flamethrower)
4
5
Charmeleon
Ember
Scratch
Fire Punch
Flame Burst
Flamethrower
(Ember, Scratch)
(Fire Punch, Flame Burst, Flamethrower)
In [3]:
moves2 = pd.read_excel("Pokemon Go - All Movesets.xlsx", "Advanced", skiprows=[0])
moves2 = moves2.fillna("")
moves2["Types"] = moves2[["Type 1", "Type 2"]].apply(tuple, axis = 1)
moves2.head()
Out[3]:
Unnamed: 0
Unnamed: 1
Unnamed: 2
Type 1
Type 2
CP/U
Unnamed: 6
Move
Type
Duration (ms)
...
DPE.2
Move.5
Type.5
Duration (ms).5
Power.5
Damage (after crit).3
DPS.5
Energy Cost.3
DPE.3
Types
0
1
Bulbasaur
Grass
Poison
13.746
Vine Whip
Grass
650
...
750
(Grass, Poison)
1
2
Ivysaur
Grass
Poison
21.435
Razor Leaf
Grass
1450
...
750
(Grass, Poison)
2
3
Venusaur
Grass
Poison
34.576
Razor Leaf
Grass
1450
...
853.13
(Grass, Poison)
3
4
Charmander
Fire
12.152
Ember
Fire
1050
...
1312.5
(Fire, )
4
5
Charmeleon
Fire
20.403
Ember
Fire
1050
...
1312.5
(Fire, )
5 rows × 55 columns
In [4]:
moves_dict = {}
for row in moves2.iterrows():
row = row[1]
for suffix in ["", ".1", ".2", ".3", ".4", ".5"]:
s = "Move" + suffix
move = row[s]
if move in moves_dict:
continue
else:
energyc = 0
energyph = 0
try:
energyph = row["Energy/hit"+suffix]
except:
pass
try:
energyc = row["Energy Cost"+suffix]
except:
pass
moves_dict[move] = {"Type": row["Type" + suffix],
"DPS": row["DPS" + suffix],
"Energy Cost": energyc,
"Energy Per Hit": energyph,
"Duration": row["Duration (ms)" + suffix],
"Power": row["Power" + suffix]
}
In [5]:
moves_dict
Out[5]:
{'': {'DPS': '',
'Duration': '',
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': '',
'Type': ''},
u'Acid': {'DPS': 11.9,
'Duration': 1050.0,
'Energy Cost': 50.0,
'Energy Per Hit': 7.0,
'Power': 12.5,
'Type': u'Poison'},
u'Aerial Ace': {'DPS': 9.05,
'Duration': 2900.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 25.0,
'Type': u'Flying'},
u'Air Cutter': {'DPS': 11.84,
'Duration': 3300.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 31.25,
'Type': u'Flying'},
u'Ancient Power': {'DPS': 10.94,
'Duration': 3600.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 37.5,
'Type': u'Rock'},
u'Aqua Jet': {'DPS': 6.7,
'Duration': 2350.0,
'Energy Cost': 25.0,
'Energy Per Hit': 0,
'Power': 18.75,
'Type': u'Water'},
u'Aqua Tail': {'DPS': 27.93,
'Duration': 2350.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 62.5,
'Type': u'Water'},
u'Bite': {'DPS': 12.0,
'Duration': 500.0,
'Energy Cost': 50.0,
'Energy Per Hit': 7.0,
'Power': 6.0,
'Type': u'Dark'},
u'Blizzard': {'DPS': 16.15,
'Duration': 3900.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 60.0,
'Type': u'Ice'},
u'Body Slam': {'DPS': 42.07,
'Duration': 1560.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 62.5,
'Type': u'Normal'},
u'Bone Club': {'DPS': 13.13,
'Duration': 1600.0,
'Energy Cost': 25.0,
'Energy Per Hit': 0,
'Power': 25.0,
'Type': u'Ground'},
u'Brick Break': {'DPS': 23.44,
'Duration': 1600.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 30.0,
'Type': u'Fight'},
u'Brine': {'DPS': 10.94,
'Duration': 2400.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 25.0,
'Type': u'Water'},
u'Bubble': {'DPS': 8.15,
'Duration': 2300.0,
'Energy Cost': 20.0,
'Energy Per Hit': 15.0,
'Power': 18.75,
'Type': u'Water'},
u'Bubble Beam': {'DPS': 9.05,
'Duration': 2900.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 31.25,
'Type': u'Water'},
u'Bug Bite': {'DPS': 16.7,
'Duration': 450.0,
'Energy Cost': 20.0,
'Energy Per Hit': 7.0,
'Power': 7.5,
'Type': u'Bug'},
u'Bug Buzz': {'DPS': 12.35,
'Duration': 4250.0,
'Energy Cost': 33.0,
'Energy Per Hit': 0,
'Power': 62.5,
'Type': u'Bug'},
u'Bulldoze': {'DPS': 11.58,
'Duration': 3400.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 37.5,
'Type': u'Ground'},
u'Bullet Punch': {'DPS': 8.33,
'Duration': 1200.0,
'Energy Cost': 100.0,
'Energy Per Hit': 7.0,
'Power': 10.0,
'Type': u'Steel'},
u'Confusion': {'DPS': 7.95,
'Duration': 1510.0,
'Energy Cost': 50.0,
'Energy Per Hit': 7.0,
'Power': 12.0,
'Type': u'Psychic'},
u'Cross Chop': {'DPS': 34.38,
'Duration': 2000.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 55.0,
'Type': u'Fight'},
u'Cross Poison': {'DPS': 16.67,
'Duration': 1500.0,
'Energy Cost': 33.0,
'Energy Per Hit': 0,
'Power': 20.0,
'Type': u'Poison'},
u'Cut': {'DPS': 13.3,
'Duration': 1130.0,
'Energy Cost': 25.0,
'Energy Per Hit': 7.0,
'Power': 15.0,
'Type': u'Normal'},
u'Dark Pulse': {'DPS': 13.5,
'Duration': 3500.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 45.0,
'Type': u'Normal'},
u'Dazzling Gleam': {'DPS': 11.25,
'Duration': 4200.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 56.25,
'Type': u'Fairy'},
u'Dig': {'DPS': 8.15,
'Duration': 5800.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 45.0,
'Type': u'Ground'},
u'Disarming Voice': {'DPS': 5.38,
'Duration': 3900.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 25.0,
'Type': u'Fairy'},
u'Discharge': {'DPS': 16.8,
'Duration': 2500.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 50.0,
'Type': u'Electric'},
u'Dragon Breath': {'DPS': 12.0,
'Duration': 500.0,
'Energy Cost': 50.0,
'Energy Per Hit': 7.0,
'Power': 6.0,
'Type': u'Dragon'},
u'Dragon Claw': {'DPS': 33.33,
'Duration': 1500.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 40.0,
'Type': u'Dragon'},
u'Dragon Pulse': {'DPS': 14.58,
'Duration': 3600.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 50.0,
'Type': u'Dragon'},
u'Draining Kiss': {'DPS': 5.63,
'Duration': 2800.0,
'Energy Cost': 33.0,
'Energy Per Hit': 0,
'Power': 15.0,
'Type': u'Fairy'},
u'Drill Peck': {'DPS': 14.58,
'Duration': 2700.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 37.5,
'Type': u'Flying'},
u'Drill Run': {'DPS': 14.71,
'Duration': 3400.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 40.0,
'Type': u'Ground'},
u'Earthquake': {'DPS': 15.0,
'Duration': 4200.0,
'Energy Cost': 25.0,
'Energy Per Hit': 0,
'Power': 75.0,
'Type': u'Ground'},
u'Ember': {'DPS': 11.9,
'Duration': 1050.0,
'Energy Cost': 20.0,
'Energy Per Hit': 7.0,
'Power': 12.5,
'Type': u'Fire'},
u'Feint Attack': {'DPS': 11.5,
'Duration': 1040.0,
'Energy Cost': 100.0,
'Energy Per Hit': 7.0,
'Power': 12.0,
'Type': u'Dark'},
u'Fire Blast': {'DPS': 15.37,
'Duration': 4100.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 75.0,
'Type': u'Fire'},
u'Fire Fang': {'DPS': 10.4,
'Duration': 840.0,
'Energy Cost': 100.0,
'Energy Per Hit': 4.0,
'Power': 8.75,
'Type': u'Fire'},
u'Fire Punch': {'DPS': 13.13,
'Duration': 2800.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 43.75,
'Type': u'Fire'},
u'Flame Burst': {'DPS': 15.63,
'Duration': 2100.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 31.25,
'Type': u'Fire'},
u'Flame Charge': {'DPS': 6.77,
'Duration': 3100.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 25.0,
'Type': u'Fire'},
u'Flame Wheel': {'DPS': 7.99,
'Duration': 4600.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 43.75,
'Type': u'Fire'},
u'Flamethrower': {'DPS': 22.63,
'Duration': 2900.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 62.5,
'Type': u'Fire'},
u'Flash Cannon': {'DPS': 14.81,
'Duration': 3900.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 55.0,
'Type': u'Steel'},
u'Frost Breath': {'DPS': 18.5,
'Duration': 810.0,
'Energy Cost': 20.0,
'Energy Per Hit': 7.0,
'Power': 15.0,
'Type': u'Ice'},
u'Fury Cutter': {'DPS': 7.5,
'Duration': 400.0,
'Energy Cost': 100.0,
'Energy Per Hit': 12.0,
'Power': 3.0,
'Type': u'Bug'},
u'Gunk Shot': {'DPS': 26.25,
'Duration': 3000.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 75.0,
'Type': u'Poison'},
u'Heat Wave': {'DPS': 16.58,
'Duration': 3800.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 75.0,
'Type': u'Fire'},
u'Horn Attack': {'DPS': 9.55,
'Duration': 2200.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 20.0,
'Type': u'Normal'},
u'Hurricane': {'DPS': 19.69,
'Duration': 3200.0,
'Energy Cost': 25.0,
'Energy Per Hit': 0,
'Power': 75.0,
'Type': u'Flying'},
u'Hydro Pump': {'DPS': 20.72,
'Duration': 3800.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 75.0,
'Type': u'Water'},
u'Hyper Beam': {'DPS': 18.38,
'Duration': 5000.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 87.5,
'Type': u'Normal'},
u'Hyper Fang': {'DPS': 21.88,
'Duration': 2100.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 43.75,
'Type': u'Normal'},
u'Ice Beam': {'DPS': 14.38,
'Duration': 3650.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 50.0,
'Type': u'Ice'},
u'Ice Punch': {'DPS': 13.5,
'Duration': 3500.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 45.0,
'Type': u'Ice'},
u'Ice Shard': {'DPS': 7.14,
'Duration': 1400.0,
'Energy Cost': 20.0,
'Energy Per Hit': 7.0,
'Power': 10.0,
'Type': u'Ice'},
u'Icy Wind': {'DPS': 4.14,
'Duration': 3800.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 15.0,
'Type': u'Ice'},
u'Iron Head': {'DPS': 21.0,
'Duration': 2000.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 40.0,
'Type': u'Steel'},
u'Karate Chop': {'DPS': 9.38,
'Duration': 800.0,
'Energy Cost': 100.0,
'Energy Per Hit': 7.0,
'Power': 7.5,
'Type': u'Fight'},
u'Leaf Blade': {'DPS': 20.09,
'Duration': 2800.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 56.25,
'Type': u'Grass'},
u'Lick': {'DPS': 25.0,
'Duration': 500.0,
'Energy Cost': 25.0,
'Energy Per Hit': 7.0,
'Power': 12.5,
'Type': u'Ghost'},
u'Low Kick': {'DPS': 10.4,
'Duration': 600.0,
'Energy Cost': 100.0,
'Energy Per Hit': 7.0,
'Power': 6.25,
'Type': u'Fight'},
u'Low Sweep': {'DPS': 12.87,
'Duration': 2550.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 31.25,
'Type': u'Fight'},
u'Magnet Bomb': {'DPS': 11.72,
'Duration': 2800.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 31.25,
'Type': u'Steel'},
u'Megahorn': {'DPS': 18.05,
'Duration': 3200.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 55.0,
'Type': u'Bug'},
u'Metal Claw': {'DPS': 19.0,
'Duration': 630.0,
'Energy Cost': 100.0,
'Energy Per Hit': 7.0,
'Power': 12.0,
'Type': u'Steel'},
u'Moonblast': {'DPS': 19.21,
'Duration': 4100.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 75.0,
'Type': u'Fairy'},
u'Mud Bomb': {'DPS': 12.62,
'Duration': 2600.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 31.25,
'Type': u'Ground'},
u'Mud Shot': {'DPS': 27.27,
'Duration': 550.0,
'Energy Cost': 33.0,
'Energy Per Hit': 7.0,
'Power': 15.0,
'Type': u'Ground'},
u'Mud Slap': {'DPS': 4.44,
'Duration': 1350.0,
'Energy Cost': 25.0,
'Energy Per Hit': 9.0,
'Power': 6.0,
'Type': u'Ground'},
u'Night Slash': {'DPS': 11.57,
'Duration': 2700.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 25.0,
'Type': u'Dark'},
u'Ominous Wind': {'DPS': 8.47,
'Duration': 3100.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 25.0,
'Type': u'Ghost'},
u'Peck': {'DPS': 10.9,
'Duration': 1150.0,
'Energy Cost': 25.0,
'Energy Per Hit': 10.0,
'Power': 12.5,
'Type': u'Flying'},
u'Petal Blizzard': {'DPS': 20.51,
'Duration': 3200.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 62.5,
'Type': u'Grass'},
u'Play Rough': {'DPS': 22.63,
'Duration': 2900.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 62.5,
'Type': u'Fairy'},
u'Poison Fang': {'DPS': 6.56,
'Duration': 2400.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 18.75,
'Type': u'Poison'},
u'Poison Jab': {'DPS': 17.86,
'Duration': 1050.0,
'Energy Cost': 25.0,
'Energy Per Hit': 7.0,
'Power': 18.75,
'Type': u'Poison'},
u'Poison Sting': {'DPS': 13.04,
'Duration': 575.0,
'Energy Cost': '',
'Energy Per Hit': 4.0,
'Power': 7.5,
'Type': u'Poison'},
u'Pound': {'DPS': 14.8,
'Duration': 540.0,
'Energy Cost': 20.0,
'Energy Per Hit': 7.0,
'Power': 8.0,
'Type': u'Normal'},
u'Power Gem': {'DPS': 14.48,
'Duration': 2900.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 40.0,
'Type': u'Rock'},
u'Power Whip': {'DPS': 26.79,
'Duration': 2800.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 75.0,
'Type': u'Grass'},
u'Psybeam': {'DPS': 9.67,
'Duration': 3800.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 35.0,
'Type': u'Psychic'},
u'Psychic': {'DPS': 18.75,
'Duration': 2800.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 50.0,
'Type': u'Psychic'},
u'Psycho Cut': {'DPS': 32.9,
'Duration': 570.0,
'Energy Cost': 25.0,
'Energy Per Hit': 7.0,
'Power': 18.75,
'Type': u'Psychic'},
u'Psyshock': {'DPS': 15.56,
'Duration': 2700.0,
'Energy Cost': 33.0,
'Energy Per Hit': 0,
'Power': 50.0,
'Type': u'Psychic'},
u'Quick Attack': {'DPS': 9.4,
'Duration': 1330.0,
'Energy Cost': 20.0,
'Energy Per Hit': 7.0,
'Power': 12.5,
'Type': u'Normal'},
u'Razor Leaf': {'DPS': 12.9,
'Duration': 1450.0,
'Energy Cost': 50.0,
'Energy Per Hit': 7.0,
'Power': 18.75,
'Type': u'Grass'},
u'Rock Slide': {'DPS': 13.13,
'Duration': 3200.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 40.0,
'Type': u'Rock'},
u'Rock Smash': {'DPS': 3.55,
'Duration': 1410.0,
'Energy Cost': 33.0,
'Energy Per Hit': 7.0,
'Power': 5.0,
'Type': u'Fight'},
u'Rock Throw': {'DPS': 11.0,
'Duration': 1360.0,
'Energy Cost': 33.0,
'Energy Per Hit': 7.0,
'Power': 15.0,
'Type': u'Rock'},
u'Rock Tomb': {'DPS': 9.19,
'Duration': 3400.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 25.0,
'Type': u'Rock'},
u'Scald': {'DPS': 9.19,
'Duration': 4000.0,
'Energy Cost': 25.0,
'Energy Per Hit': 0,
'Power': 43.75,
'Type': u'Water'},
u'Scratch': {'DPS': 20.0,
'Duration': 500.0,
'Energy Cost': 25.0,
'Energy Per Hit': 7.0,
'Power': 10.0,
'Type': u'Normal'},
u'Seed Bomb': {'DPS': 16.41,
'Duration': 2400.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 37.5,
'Type': u'Grass'},
u'Shadow Ball': {'DPS': 13.64,
'Duration': 3080.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 40.0,
'Type': u'Ghost'},
u'Shadow Claw': {'DPS': 21.1,
'Duration': 950.0,
'Energy Cost': 33.0,
'Energy Per Hit': 7.0,
'Power': 20.0,
'Type': u'Ghost'},
u'Signal Beam': {'DPS': 14.82,
'Duration': 3100.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 43.75,
'Type': u'Bug'},
u'Sludge': {'DPS': 10.1,
'Duration': 2600.0,
'Energy Cost': 50.0,
'Energy Per Hit': 0,
'Power': 31.25,
'Type': u'Poison'},
u'Sludge Bomb': {'DPS': 25.24,
'Duration': 2600.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 62.5,
'Type': u'Poison'},
u'Sludge Wave': {'DPS': 23.16,
'Duration': 3400.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 75.0,
'Type': u'Poison'},
u'Solar Beam': {'DPS': 17.41,
'Duration': 4900.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 81.25,
'Type': u'Grass'},
u'Spark': {'DPS': 12.5,
'Duration': 700.0,
'Energy Cost': 33.0,
'Energy Per Hit': 4.0,
'Power': 8.75,
'Type': u'Electric'},
u'Splash': {'DPS': 0.0,
'Duration': 1230.0,
'Energy Cost': 20.0,
'Energy Per Hit': 7.0,
'Power': 0.0,
'Type': u'Water'},
u'Steel Wing': {'DPS': 11.28,
'Duration': 1330.0,
'Energy Cost': 25.0,
'Energy Per Hit': 4.0,
'Power': 15.0,
'Type': u'Steel'},
u'Stomp': {'DPS': 12.5,
'Duration': 2100.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 25.0,
'Type': u'Normal'},
u'Stone Edge': {'DPS': 26.61,
'Duration': 3100.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 55.0,
'Type': u'Rock'},
u'Struggle': {'DPS': 8.85,
'Duration': 1695.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 15.0,
'Type': u'Normal'},
u'Submission': {'DPS': 18.75,
'Duration': 2100.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 37.5,
'Type': u'Fight'},
u'Sucker Punch': {'DPS': 10.0,
'Duration': 700.0,
'Energy Cost': 100.0,
'Energy Per Hit': 4.0,
'Power': 7.0,
'Type': u'Dark'},
u'Swift': {'DPS': 10.94,
'Duration': 3000.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 31.25,
'Type': u'Normal'},
u'Tackle': {'DPS': 10.91,
'Duration': 1100.0,
'Energy Cost': 33.0,
'Energy Per Hit': 7.0,
'Power': 12.0,
'Type': u'Normal'},
u'Thunder': {'DPS': 19.84,
'Duration': 4300.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 81.25,
'Type': u'Electric'},
u'Thunder Punch': {'DPS': 21.88,
'Duration': 2400.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 50.0,
'Type': u'Electric'},
u'Thunder Shock': {'DPS': 10.4,
'Duration': 600.0,
'Energy Cost': 33.0,
'Energy Per Hit': 7.0,
'Power': 6.25,
'Type': u'Electric'},
u'Thunderbolt': {'DPS': 24.31,
'Duration': 2700.0,
'Energy Cost': '',
'Energy Per Hit': 0,
'Power': 62.5,
'Type': u'Electric'},
u'Twister': {'DPS': 5.83,
'Duration': 2700.0,
'Energy Cost': 25.0,
'Energy Per Hit': 0,
'Power': 15.0,
'Type': u'Dragon'},
u'Vice Grip': {'DPS': 7.5,
'Duration': 2100.0,
'Energy Cost': 25.0,
'Energy Per Hit': 0,
'Power': 15.0,
'Type': u'Normal'},
u'Vine Whip': {'DPS': 19.23,
'Duration': 650.0,
'Energy Cost': 50.0,
'Energy Per Hit': 7.0,
'Power': 12.5,
'Type': u'Grass'},
u'Water Gun': {'DPS': 25.0,
'Duration': 500.0,
'Energy Cost': 20.0,
'Energy Per Hit': 7.0,
'Power': 12.5,
'Type': u'Water'},
u'Water Pulse': {'DPS': 11.93,
'Duration': 3300.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 37.5,
'Type': u'Water'},
u'Wing Attack': {'DPS': 20.0,
'Duration': 750.0,
'Energy Cost': 50.0,
'Energy Per Hit': 7.0,
'Power': 15.0,
'Type': u'Flying'},
u'Wrap': {'DPS': 3.94,
'Duration': 4000.0,
'Energy Cost': 100.0,
'Energy Per Hit': 0,
'Power': 15.0,
'Type': u'Normal'},
u'X-Scissor': {'DPS': 18.75,
'Duration': 2100.0,
'Energy Cost': 0,
'Energy Per Hit': 0,
'Power': 37.5,
'Type': u'Bug'},
u'Zen Headbutt': {'DPS': 14.29,
'Duration': 1050.0,
'Energy Cost': 50.0,
'Energy Per Hit': 4.0,
'Power': 15.0,
'Type': u'Psychic'}}
In [6]:
pokemon_dict = {}
for row in moves.iterrows():
row = row[1]
name = row["Pokemon"]
if name not in pokemon_dict:
pokemon_dict[name] = {"Standard":row["Standard"],
"Special":row["Special"]}
for row in moves2.iterrows():
row = row[1]
name = row["Unnamed: 1"]
if name in pokemon_dict:
pokemon_dict[name]["Types"] = row["Types"]
pokemon_dict
Out[6]:
{u'Abra': {'Special': (u'Psyshock', u'Signal Beam', u'Shadow Ball'),
'Standard': (u'Zen Headbutt', ''),
'Types': (u'Psychic', '')},
u'Aerodactyl': {'Special': (u'Ancient Power', u'Iron Head', u'Hyper Beam'),
'Standard': (u'Steel Wing', u'Bite'),
'Types': (u'Rock', u'Flying')},
u'Alakazam': {'Special': (u'Psychic', u'Dazzling Gleam', u'Shadow Ball'),
'Standard': (u'Psycho Cut', u'Confusion'),
'Types': (u'Psychic', '')},
u'Arbok': {'Special': (u'Dark Pulse', u'Sludge Wave', u'Gunk Shot'),
'Standard': (u'Bite', u'Acid'),
'Types': (u'Poison', '')},
u'Arcanine': {'Special': (u'Fire Blast', u'Flamethrower', u'Bulldoze'),
'Standard': (u'Fire Fang', u'Bite'),
'Types': (u'Fire', '')},
u'Articuno': {'Special': (u'Ice Beam', u'Icy Wind', u'Blizzard'),
'Standard': (u'Frost Breath', ''),
'Types': (u'Ice', u'Flying')},
u'Beedrill': {'Special': (u'Sludge Bomb', u'Aerial Ace', u'X-Scissor'),
'Standard': (u'Bug Bite', u'Poison Jab'),
'Types': (u'Bug', u'Poison')},
u'Bellsprout': {'Special': (u'Power Whip', u'Sludge Bomb', u'Wrap'),
'Standard': (u'Vine Whip', u'Acid'),
'Types': (u'Grass', u'Poison')},
u'Blastoise': {'Special': (u'Flash Cannon', u'Ice Beam', u'Hydro Pump'),
'Standard': (u'Water Gun', u'Bite'),
'Types': (u'Water', '')},
u'Bulbasaur': {'Special': (u'Sludge Bomb', u'Seed Bomb', u'Power Whip'),
'Standard': (u'Vine Whip', u'Tackle'),
'Types': (u'Grass', u'Poison')},
u'Butterfree': {'Special': (u'Bug Buzz', u'Psychic', u'Signal Beam'),
'Standard': (u'Bug Bite', u'Confusion'),
'Types': (u'Bug', u'Flying')},
u'Caterpie': {'Special': (u'Struggle', '', ''),
'Standard': (u'Bug Bite', u'Tackle'),
'Types': (u'Bug', '')},
u'Chansey': {'Special': (u'Psychic', u'Psybeam', u'Dazzling Gleam'),
'Standard': (u'Pound', u'Zen Headbutt'),
'Types': (u'Normal', '')},
u'Charizard': {'Special': (u'Fire Blast', u'Dragon Claw', u'Flamethrower'),
'Standard': (u'Ember', u'Wing Attack'),
'Types': (u'Fire', u'Flying')},
u'Charmander': {'Special': (u'Flame Charge', u'Flame Burst', u'Flamethrower'),
'Standard': (u'Ember', u'Scratch'),
'Types': (u'Fire', '')},
u'Charmeleon': {'Special': (u'Fire Punch', u'Flame Burst', u'Flamethrower'),
'Standard': (u'Ember', u'Scratch'),
'Types': (u'Fire', '')},
u'Clefable': {'Special': (u'Dazzling Gleam', u'Psychic', u'Moonblast'),
'Standard': (u'Pound', u'Zen Headbutt'),
'Types': (u'Fairy', '')},
u'Clefairy': {'Special': (u'Disarming Voice', u'Body Slam', u'Moonblast'),
'Standard': (u'Pound', u'Zen Headbutt'),
'Types': (u'Fairy', '')},
u'Cloyster': {'Special': (u'Icy Wind', u'Hydro Pump', u'Blizzard'),
'Standard': (u'Frost Breath', u'Ice Shard'),
'Types': (u'Water', u'Ice')},
u'Cubone': {'Special': (u'Bone Club', u'Dig', u'Bulldoze'),
'Standard': (u'Mud Slap', u'Rock Smash'),
'Types': (u'Ground', '')},
u'Dewgong': {'Special': (u'Icy Wind', u'Aqua Jet', u'Blizzard'),
'Standard': (u'Frost Breath', u'Ice Shard'),
'Types': (u'Water', u'Ice')},
u'Diglett': {'Special': (u'Dig', u'Mud Bomb', u'Rock Tomb'),
'Standard': (u'Mud Shot', u'Scratch'),
'Types': (u'Ground', '')},
u'Ditto': {'Special': (u'Struggle', '', ''),
'Standard': (u'Pound', ''),
'Types': (u'Normal', '')},
u'Dodrio': {'Special': (u'Drill Peck', u'Aerial Ace', u'Air Cutter'),
'Standard': (u'Feint Attack', u'Steel Wing'),
'Types': (u'Normal', u'Flying')},
u'Doduo': {'Special': (u'Drill Peck', u'Aerial Ace', u'Swift'),
'Standard': (u'Peck', u'Quick Attack'),
'Types': (u'Normal', u'Flying')},
u'Dragonair': {'Special': (u'Wrap', u'Aqua Tail', u'Dragon Pulse'),
'Standard': (u'Dragon Breath', ''),
'Types': (u'Dragon', '')},
u'Dragonite': {'Special': (u'Dragon Pulse', u'Hyper Beam', u'Dragon Claw'),
'Standard': (u'Dragon Breath', u'Steel Wing'),
'Types': (u'Dragon', u'Flying')},
u'Dratini': {'Special': (u'Wrap', u'Twister', u'Aqua Tail'),
'Standard': (u'Dragon Breath', ''),
'Types': (u'Dragon', '')},
u'Drowzee': {'Special': (u'Psybeam', u'Psyshock', u'Psychic'),
'Standard': (u'Pound', u'Confusion'),
'Types': (u'Psychic', '')},
u'Dugtrio': {'Special': (u'Earthquake', u'Mud Bomb', u'Stone Edge'),
'Standard': (u'Sucker Punch', u'Mud Shot'),
'Types': (u'Ground', '')},
u'Eevee': {'Special': (u'Dig', u'Swift', u'Body Slam'),
'Standard': (u'Quick Attack', u'Tackle'),
'Types': (u'Normal', '')},
u'Ekans': {'Special': (u'Wrap', u'Sludge Bomb', u'Gunk Shot'),
'Standard': (u'Poison Sting', u'Acid'),
'Types': (u'Poison', '')},
u'Electabuzz': {'Special': (u'Thunder Punch', u'Thunderbolt', u'Thunder'),
'Standard': (u'Thunder Shock', u'Low Kick'),
'Types': (u'Electric', '')},
u'Electrode': {'Special': (u'Discharge', u'Thunderbolt', u'Hyper Beam'),
'Standard': (u'Spark', u'Tackle'),
'Types': (u'Electric', '')},
u'Exeggcute': {'Special': (u'Seed Bomb', u'Psychic', u'Ancient Power'),
'Standard': (u'Confusion', ''),
'Types': (u'Grass', u'Psychic')},
u'Exeggutor': {'Special': (u'Seed Bomb', u'Psychic', u'Solar Beam'),
'Standard': (u'Confusion', u'Zen Headbutt'),
'Types': (u'Grass', u'Psychic')},
u"Farfetch'd": {'Special': (u'Aerial Ace', u'Air Cutter', u'Leaf Blade'),
'Standard': (u'Cut', u'Fury Cutter'),
'Types': (u'Normal', u'Flying')},
u'Fearow': {'Special': (u'Aerial Ace', u'Drill Run', u'Twister'),
'Standard': (u'Peck', u'Steel Wing'),
'Types': (u'Normal', u'Flying')},
u'Flareon': {'Special': (u'Fire Blast', u'Flamethrower', u'Heat Wave'),
'Standard': (u'Ember', ''),
'Types': (u'Fire', '')},
u'Gastly': {'Special': (u'Ominous Wind', u'Dark Pulse', u'Sludge Bomb'),
'Standard': (u'Lick', u'Sucker Punch'),
'Types': (u'Ghost', u'Poison')},
u'Gengar': {'Special': (u'Shadow Ball', u'Dark Pulse', u'Sludge Wave'),
'Standard': (u'Sucker Punch', u'Shadow Claw'),
'Types': (u'Ghost', u'Poison')},
u'Geodude': {'Special': (u'Rock Slide', u'Rock Tomb', u'Dig'),
'Standard': (u'Rock Throw', u'Tackle'),
'Types': (u'Rock', u'Ground')},
u'Gloom': {'Special': (u'Petal Blizzard', u'Sludge Bomb', u'Moonblast'),
'Standard': (u'Razor Leaf', u'Acid'),
'Types': (u'Grass', u'Poison')},
u'Golbat': {'Special': (u'Poison Fang', u'Air Cutter', u'Ominous Wind'),
'Standard': (u'Wing Attack', u'Bite'),
'Types': (u'Poison', u'Flying')},
u'Goldeen': {'Special': (u'Water Pulse', u'Horn Attack', u'Aqua Tail'),
'Standard': (u'Peck', u'Mud Shot'),
'Types': (u'Water', '')},
u'Golduck': {'Special': (u'Psychic', u'Hydro Pump', u'Ice Beam'),
'Standard': (u'Water Gun', u'Confusion'),
'Types': (u'Water', '')},
u'Golem': {'Special': (u'Stone Edge', u'Ancient Power', u'Earthquake'),
'Standard': (u'Rock Throw', u'Mud Shot'),
'Types': (u'Rock', u'Ground')},
u'Graveler': {'Special': (u'Dig', u'Stone Edge', u'Rock Slide'),
'Standard': (u'Rock Throw', u'Mud Shot'),
'Types': (u'Rock', u'Ground')},
u'Grimer': {'Special': (u'Sludge', u'Mud Bomb', u'Sludge Bomb'),
'Standard': (u'Acid', u'Mud Slap'),
'Types': (u'Poison', '')},
u'Growlithe': {'Special': (u'Flame Wheel', u'Body Slam', u'Flamethrower'),
'Standard': (u'Ember', u'Bite'),
'Types': (u'Fire', '')},
u'Gyarados': {'Special': (u'Hydro Pump', u'Twister', u'Dragon Pulse'),
'Standard': (u'Dragon Breath', u'Bite'),
'Types': (u'Water', u'Flying')},
u'Haunter': {'Special': (u'Shadow Ball', u'Dark Pulse', u'Sludge Bomb'),
'Standard': (u'Shadow Claw', u'Lick'),
'Types': (u'Ghost', u'Poison')},
u'Hitmonchan': {'Special': (u'Fire Punch', u'Ice Punch', u'Thunder Punch'),
'Standard': (u'Bullet Punch', u'Rock Smash'),
'Types': (u'Fight', '')},
u'Hitmonlee': {'Special': (u'Stomp', u'Low Sweep', u'Stone Edge'),
'Standard': (u'Low Kick', u'Rock Smash'),
'Types': (u'Fight', '')},
u'Horsea': {'Special': (u'Bubble Beam', u'Dragon Pulse', u'Flash Cannon'),
'Standard': (u'Water Gun', u'Bubble'),
'Types': (u'Water', '')},
u'Hypno': {'Special': (u'Psyshock', u'Psychic', u'Shadow Ball'),
'Standard': (u'Zen Headbutt', u'Confusion'),
'Types': (u'Psychic', '')},
u'Ivysaur': {'Special': (u'Sludge Bomb', u'Solar Beam', u'Power Whip'),
'Standard': (u'Razor Leaf', u'Vine Whip'),
'Types': (u'Grass', u'Poison')},
u'Jigglypuff': {'Special': (u'Disarming Voice', u'Body Slam', u'Play Rough'),
'Standard': (u'Pound', u'Feint Attack'),
'Types': (u'Normal', u'Fairy')},
u'Jolteon': {'Special': (u'Discharge', u'Thunderbolt', u'Thunder'),
'Standard': (u'Thunder Shock', ''),
'Types': (u'Electric', '')},
u'Jynx': {'Special': (u'Draining Kiss', u'Ice Punch', u'Psyshock'),
'Standard': (u'Frost Breath', u'Pound'),
'Types': (u'Ice', u'Psychic')},
u'Kabuto': {'Special': (u'Ancient Power', u'Aqua Jet', u'Rock Tomb'),
'Standard': (u'Scratch', u'Mud Shot'),
'Types': (u'Rock', u'Water')},
u'Kabutops': {'Special': (u'Ancient Power', u'Water Pulse', u'Stone Edge'),
'Standard': (u'Mud Shot', u'Fury Cutter'),
'Types': (u'Rock', u'Water')},
u'Kadabra': {'Special': (u'Psybeam', u'Dazzling Gleam', u'Shadow Ball'),
'Standard': (u'Psycho Cut', u'Confusion'),
'Types': (u'Psychic', '')},
u'Kakuna': {'Special': (u'Struggle', '', ''),
'Standard': (u'Bug Bite', u'Poison Sting'),
'Types': (u'Bug', u'Poison')},
u'Kangaskhan': {'Special': (u'Brick Break', u'Earthquake', u'Stomp'),
'Standard': (u'Mud Slap', u'Low Kick'),
'Types': (u'Normal', '')},
u'Kingler': {'Special': (u'Vice Grip', u'X-Scissor', u'Water Pulse'),
'Standard': (u'Metal Claw', u'Mud Shot'),
'Types': (u'Water', '')},
u'Koffing': {'Special': (u'Sludge', u'Sludge Bomb', u'Dark Pulse'),
'Standard': (u'Acid', u'Tackle'),
'Types': (u'Poison', '')},
u'Krabby': {'Special': (u'Vice Grip', u'Bubble Beam', u'Water Pulse'),
'Standard': (u'Bubble', u'Mud Shot'),
'Types': (u'Water', '')},
u'Lapras': {'Special': (u'Dragon Pulse', u'Ice Beam', u'Blizzard'),
'Standard': (u'Frost Breath', u'Ice Shard'),
'Types': (u'Water', u'Ice')},
u'Lickitung': {'Special': (u'Hyper Beam', u'Stomp', u'Power Whip'),
'Standard': (u'Lick', u'Zen Headbutt'),
'Types': (u'Normal', '')},
u'Machamp': {'Special': (u'Stone Edge', u'Submission', u'Cross Chop'),
'Standard': (u'Bullet Punch', u'Karate Chop'),
'Types': (u'Fight', '')},
u'Machoke': {'Special': (u'Submission', u'Brick Break', u'Cross Chop'),
'Standard': (u'Low Kick', u'Karate Chop'),
'Types': (u'Fight', '')},
u'Machop': {'Special': (u'Low Sweep', u'Brick Break', u'Cross Chop'),
'Standard': (u'Low Kick', u'Karate Chop'),
'Types': (u'Fight', '')},
u'Magikarp': {'Special': (u'Struggle', '', ''),
'Standard': (u'Splash', ''),
'Types': (u'Water', '')},
u'Magmar': {'Special': (u'Fire Blast', u'Fire Punch', u'Flamethrower'),
'Standard': (u'Ember', u'Karate Chop'),
'Types': (u'Fire', '')},
u'Magnemite': {'Special': (u'Discharge', u'Magnet Bomb', u'Thunderbolt'),
'Standard': (u'Spark', u'Thunder Shock'),
'Types': (u'Electric', u'Steel')},
u'Magneton': {'Special': (u'Discharge', u'Magnet Bomb', u'Flash Cannon'),
'Standard': (u'Spark', u'Thunder Shock'),
'Types': (u'Electric', u'Steel')},
u'Mankey': {'Special': (u'Cross Chop', u'Low Sweep', u'Brick Break'),
'Standard': (u'Karate Chop', u'Scratch'),
'Types': (u'Fight', '')},
u'Marowak': {'Special': (u'Bone Club', u'Dig', u'Earthquake'),
'Standard': (u'Mud Slap', u'Rock Smash'),
'Types': (u'Ground', '')},
u'Meowth': {'Special': (u'Night Slash', u'Dark Pulse', u'Body Slam'),
'Standard': (u'Scratch', u'Bite'),
'Types': (u'Normal', '')},
u'Metapod': {'Special': (u'Struggle', '', ''),
'Standard': (u'Bug Bite', u'Tackle'),
'Types': (u'Bug', '')},
u'Mew': {'Special': (u'-', u'-', u'-'),
'Standard': (u'Pound', ''),
'Types': (u'Psychic', '')},
u'Mewtwo': {'Special': (u'Psychic', u'Shadow Ball', u'Hyper Beam'),
'Standard': (u'Psycho Cut', u'Confusion'),
'Types': (u'Psychic', '')},
u'Moltres': {'Special': (u'Fire Blast', u'Heat Wave', u'Flamethrower'),
'Standard': (u'Ember', ''),
'Types': (u'Fire', u'Flying')},
u'Mr. Mime': {'Special': (u'Psybeam', u'Psychic', u'Shadow Ball'),
'Standard': (u'Confusion', u'Zen Headbutt'),
'Types': (u'Psychic', u'Fairy')},
u'Muk': {'Special': (u'Dark Pulse', u'Gunk Shot', u'Sludge Wave'),
'Standard': (u'Acid', u'Poison Jab'),
'Types': (u'Poison', '')},
u'Nidoking': {'Special': (u'Earthquake', u'Sludge Wave', u'Megahorn'),
'Standard': (u'Poison Jab', u'Fury Cutter'),
'Types': (u'Poison', u'Ground')},
u'Nidoqueen': {'Special': (u'Earthquake', u'Sludge Wave', u'Stone Edge'),
'Standard': (u'Poison Jab', u'Bite'),
'Types': (u'Poison', u'Ground')},
u'Nidoran F': {'Special': (u'Poison Fang', u'Body Slam', u'Sludge Bomb'),
'Standard': (u'Bite', u'Poison Sting'),
'Types': (u'Poison', '')},
u'Nidoran M': {'Special': (u'Horn Attack', u'Body Slam', u'Sludge Bomb'),
'Standard': (u'Peck', u'Poison Sting'),
'Types': (u'Poison', '')},
u'Nidorina': {'Special': (u'Poison Fang', u'Dig', u'Sludge Bomb'),
'Standard': (u'Bite', u'Poison Sting'),
'Types': (u'Poison', '')},
u'Nidorino': {'Special': (u'Horn Attack', u'Dig', u'Sludge Bomb'),
'Standard': (u'Poison Jab', u'Poison Sting'),
'Types': (u'Poison', '')},
u'Ninetales': {'Special': (u'Heat Wave', u'Flamethrower', u'Fire Blast'),
'Standard': (u'Feint Attack', u'Ember'),
'Types': (u'Fire', '')},
u'Oddish': {'Special': (u'Seed Bomb', u'Sludge Bomb', u'Moonblast'),
'Standard': (u'Razor Leaf', u'Acid'),
'Types': (u'Grass', u'Poison')},
u'Omanyte': {'Special': (u'Ancient Power', u'Brine', u'Rock Tomb'),
'Standard': (u'Water Gun', u'Mud Shot'),
'Types': (u'Rock', u'Water')},
u'Omastar': {'Special': (u'Ancient Power', u'Hydro Pump', u'Rock Slide'),
'Standard': (u'Rock Throw', u'Water Gun'),
'Types': (u'Rock', u'Water')},
u'Onix': {'Special': (u'Rock Slide', u'Stone Edge', u'Iron Head'),
'Standard': (u'Rock Throw', u'Tackle'),
'Types': (u'Rock', u'Ground')},
u'Paras': {'Special': (u'Cross Poison', u'X-Scissor', u'Seed Bomb'),
'Standard': (u'Scratch', u'Bug Bite'),
'Types': (u'Bug', u'Grass')},
u'Parasect': {'Special': (u'Cross Poison', u'X-Scissor', u'Solar Beam'),
'Standard': (u'Bug Bite', u'Fury Cutter'),
'Types': (u'Bug', u'Grass')},
u'Persian': {'Special': (u'Night Slash', u'Power Gem', u'Play Rough'),
'Standard': (u'Scratch', u'Feint Attack'),
'Types': (u'Normal', '')},
u'Pidgeot': {'Special': (u'Hurricane', u'Aerial Ace', u'Air Cutter'),
'Standard': (u'Wing Attack', u'Steel Wing'),
'Types': (u'Normal', u'Flying')},
u'Pidgeotto': {'Special': (u'Twister', u'Aerial Ace', u'Air Cutter'),
'Standard': (u'Wing Attack', u'Steel Wing'),
'Types': (u'Normal', u'Flying')},
u'Pidgey': {'Special': (u'Twister', u'Aerial Ace', u'Air Cutter'),
'Standard': (u'Quick Attack', u'Tackle'),
'Types': (u'Normal', u'Flying')},
u'Pikachu': {'Special': (u'Discharge', u'Thunderbolt', u'Thunder'),
'Standard': (u'Thunder Shock', u'Quick Attack'),
'Types': (u'Electric', '')},
u'Pinsir': {'Special': (u'Vice Grip', u'X-Scissor', u'Submission'),
'Standard': (u'Rock Smash', u'Fury Cutter'),
'Types': (u'Bug', '')},
u'Poliwag': {'Special': (u'Bubble Beam', u'Mud Bomb', u'Body Slam'),
'Standard': (u'Bubble', u'Mud Shot'),
'Types': (u'Water', '')},
u'Poliwhirl': {'Special': (u'Scald', u'Mud Bomb', u'Bubble Beam'),
'Standard': (u'Bubble', u'Mud Shot'),
'Types': (u'Water', '')},
u'Poliwrath': {'Special': (u'Hydro Pump', u'Submission', u'Ice Punch'),
'Standard': (u'Bubble', u'Mud Shot'),
'Types': (u'Water', u'Fight')},
u'Ponyta': {'Special': (u'Flame Charge', u'Flame Wheel', u'Fire Blast'),
'Standard': (u'Tackle', u'Ember'),
'Types': (u'Fire', '')},
u'Porygon': {'Special': (u'Psybeam', u'Signal Beam', u'Discharge'),
'Standard': (u'Quick Attack', u'Tackle'),
'Types': (u'Normal', '')},
u'Primeape': {'Special': (u'Cross Chop', u'Low Sweep', u'Night Slash'),
'Standard': (u'Low Kick', u'Karate Chop'),
'Types': (u'Fight', '')},
u'Psyduck': {'Special': (u'Psybeam', u'Aqua Tail', u'Cross Chop'),
'Standard': (u'Water Gun', u'Zen Headbutt'),
'Types': (u'Water', '')},
u'Raichu': {'Special': (u'Brick Break', u'Thunder Punch', u'Thunder'),
'Standard': (u'Thunder Shock', u'Spark'),
'Types': (u'Electric', '')},
u'Rapidash': {'Special': (u'Fire Blast', u'Drill Run', u'Heat Wave'),
'Standard': (u'Low Kick', u'Ember'),
'Types': (u'Fire', '')},
u'Raticate': {'Special': (u'Dig', u'Hyper Fang', u'Hyper Beam'),
'Standard': (u'Bite', u'Quick Attack'),
'Types': (u'Normal', '')},
u'Rattata': {'Special': (u'Dig', u'Hyper Fang', u'Body Slam'),
'Standard': (u'Tackle', u'Quick Attack'),
'Types': (u'Normal', '')},
u'Rhydon': {'Special': (u'Megahorn', u'Earthquake', u'Stone Edge'),
'Standard': (u'Mud Slap', u'Rock Smash'),
'Types': (u'Ground', u'Rock')},
u'Rhyhorn': {'Special': (u'Bulldoze', u'Horn Attack', u'Stomp'),
'Standard': (u'Mud Slap', u'Rock Smash'),
'Types': (u'Ground', u'Rock')},
u'Sandshrew': {'Special': (u'Dig', u'Rock Slide', u'Rock Tomb'),
'Standard': (u'Scratch', u'Mud Shot'),
'Types': (u'Ground', '')},
u'Sandslash': {'Special': (u'Earthquake', u'Rock Tomb', u'Bulldoze'),
'Standard': (u'Metal Claw', u'Mud Shot'),
'Types': (u'Ground', '')},
u'Scyther': {'Special': (u'Night Slash', u'X-Scissor', u'Bug Buzz'),
'Standard': (u'Fury Cutter', u'Steel Wing'),
'Types': (u'Bug', u'Flying')},
u'Seadra': {'Special': (u'Blizzard', u'Dragon Pulse', u'Hydro Pump'),
'Standard': (u'Water Gun', u'Dragon Breath'),
'Types': (u'Water', '')},
u'Seaking': {'Special': (u'Icy Wind', u'Drill Run', u'Megahorn'),
'Standard': (u'Peck', u'Poison Jab'),
'Types': (u'Water', '')},
u'Seel': {'Special': (u'Aqua Jet', u'Icy Wind', u'Aqua Tail'),
'Standard': (u'Ice Shard', u'Water Gun'),
'Types': (u'Water', '')},
u'Shellder': {'Special': (u'Bubble Beam', u'Water Pulse', u'Icy Wind'),
'Standard': (u'Ice Shard', u'Tackle'),
'Types': (u'Water', '')},
u'Slowbro': {'Special': (u'Water Pulse', u'Psychic', u'Ice Beam'),
'Standard': (u'Water Gun', u'Confusion'),
'Types': (u'Water', u'Psychic')},
u'Slowpoke': {'Special': (u'Water Pulse', u'Psyshock', u'Psychic'),
'Standard': (u'Water Gun', u'Confusion'),
'Types': (u'Water', u'Psychic')},
u'Snorlax': {'Special': (u'Body Slam', u'Hyper Beam', u'Earthquake'),
'Standard': (u'Zen Headbutt', u'Lick'),
'Types': (u'Normal', '')},
u'Spearow': {'Special': (u'Aerial Ace', u'Drill Peck', u'Twister'),
'Standard': (u'Peck', u'Quick Attack'),
'Types': (u'Normal', u'Flying')},
u'Squirtle': {'Special': (u'Aqua Jet', u'Aqua Tail', u'Water Pulse'),
'Standard': (u'Bubble', u'Tackle'),
'Types': (u'Water', '')},
u'Starmie': {'Special': (u'Hydro Pump', u'Power Gem', u'Psybeam'),
'Standard': (u'Quick Attack', u'Water Gun'),
'Types': (u'Water', u'Psychic')},
u'Staryu': {'Special': (u'Swift', u'Bubble Beam', u'Power Gem'),
'Standard': (u'Quick Attack', u'Water Gun'),
'Types': (u'Water', '')},
u'Tangela': {'Special': (u'Power Whip', u'Sludge Bomb', u'Solar Beam'),
'Standard': (u'Vine Whip', ''),
'Types': (u'Grass', '')},
u'Tauros': {'Special': (u'Horn Attack', u'Iron Head', u'Earthquake'),
'Standard': (u'Tackle', u'Zen Headbutt'),
'Types': (u'Normal', '')},
u'Tentacool': {'Special': (u'Bubble Beam', u'Water Pulse', u'Wrap'),
'Standard': (u'Bubble', u'Poison Sting'),
'Types': (u'Water', u'Poison')},
u'Tentacruel': {'Special': (u'Hydro Pump', u'Sludge Wave', u'Blizzard'),
'Standard': (u'Acid', u'Poison Jab'),
'Types': (u'Water', u'Poison')},
u'Vaporeon': {'Special': (u'Water Pulse', u'Hydro Pump', u'Aqua Tail'),
'Standard': (u'Water Gun', ''),
'Types': (u'Water', '')},
u'Venomoth': {'Special': (u'Poison Fang', u'Psychic', u'Bug Buzz'),
'Standard': (u'Bug Bite', u'Confusion'),
'Types': (u'Bug', u'Poison')},
u'Venonat': {'Special': (u'Poison Fang', u'Psybeam', u'Signal Beam'),
'Standard': (u'Bug Bite', u'Confusion'),
'Types': (u'Bug', u'Poison')},
u'Venusaur': {'Special': (u'Sludge Bomb', u'Petal Blizzard', u'Solar Beam'),
'Standard': (u'Razor Leaf', u'Vine Whip'),
'Types': (u'Grass', u'Poison')},
u'Victreebel': {'Special': (u'Leaf Blade', u'Sludge Bomb', u'Solar Beam'),
'Standard': (u'Razor Leaf', u'Acid'),
'Types': (u'Grass', u'Poison')},
u'Vileplume': {'Special': (u'Petal Blizzard', u'Solar Beam', u'Moonblast'),
'Standard': (u'Razor Leaf', u'Acid'),
'Types': (u'Grass', u'Poison')},
u'Voltorb': {'Special': (u'Discharge', u'Thunderbolt', u'Signal Beam'),
'Standard': (u'Spark', u'Tackle'),
'Types': (u'Electric', '')},
u'Vulpix': {'Special': (u'Body Slam', u'Flamethrower', u'Flame Charge'),
'Standard': (u'Quick Attack', u'Ember'),
'Types': (u'Fire', '')},
u'Wartortle': {'Special': (u'Aqua Jet', u'Ice Beam', u'Hydro Pump'),
'Standard': (u'Water Gun', u'Bite'),
'Types': (u'Water', '')},
u'Weedle': {'Special': (u'Struggle', '', ''),
'Standard': (u'Bug Bite', u'Poison Sting'),
'Types': (u'Bug', u'Poison')},
u'Weepinbell': {'Special': (u'Power Whip', u'Sludge Bomb', u'Seed Bomb'),
'Standard': (u'Razor Leaf', u'Acid'),
'Types': (u'Grass', u'Poison')},
u'Weezing': {'Special': (u'Sludge Bomb', u'Shadow Ball', u'Dark Pulse'),
'Standard': (u'Acid', u'Tackle'),
'Types': (u'Poison', '')},
u'Wigglytuff': {'Special': (u'Dazzling Gleam', u'Hyper Beam', u'Play Rough'),
'Standard': (u'Pound', u'Feint Attack'),
'Types': (u'Normal', u'Fairy')},
u'Zapdos': {'Special': (u'Discharge', u'Thunderbolt', u'Thunder'),
'Standard': (u'Thunder Shock', ''),
'Types': (u'Electric', u'Flying')},
u'Zubat': {'Special': (u'Poison Fang', u'Air Cutter', u'Sludge Bomb'),
'Standard': (u'Quick Attack', u'Bite'),
'Types': (u'Poison', u'Flying')}}
In [7]:
types = pd.read_excel("Pokemon Go Spreadsheet.xlsx", "Type Advantage Chart", index_col=0)
types = types.fillna("")
types.head()
Out[7]:
NORMAL
FIGHTING
FLYING
POISON
GROUND
ROCK
BUG
GHOST
STEEL
FIRE
WATER
GRASS
ELECTRIC
PSYCHIC
ICE
DRAGON
DARK
FAIRY
NORMAL
1.00
1.00
1.0
1.00
1.0
0.80
1.00
0.8
0.80
1.00
1
1.00
1.00
1.0
1.00
1
1.00
1.00
FIGHTING
1.25
1.00
0.8
0.80
1.0
1.25
0.80
0.8
1.25
1.00
1
1.00
1.00
0.8
1.25
1
1.25
0.80
FLYING
1.00
1.25
1.0
1.00
1.0
0.80
1.25
1.0
0.80
1.00
1
1.25
0.80
1.0
1.00
1
1.00
1.00
POISON
1.00
1.00
1.0
0.80
0.8
0.80
1.00
0.8
0.80
1.00
1
1.25
1.00
1.0
1.00
1
1.00
1.25
GROUND
1.00
1.00
0.8
1.25
1.0
1.25
0.80
1.0
1.25
1.25
1
0.80
1.25
1.0
1.00
1
1.00
1.00
In [8]:
types_dict = types.T.to_dict()
In [9]:
types_dict
Out[9]:
{u'BUG': {u'BUG': 1.0,
u'DARK': 1.25,
u'DRAGON': 1.0,
u'ELECTRIC': 1.0,
u'FAIRY': 0.80000000000000004,
u'FIGHTING': 0.80000000000000004,
u'FIRE': 0.80000000000000004,
u'FLYING': 0.80000000000000004,
u'GHOST': 0.80000000000000004,
u'GRASS': 1.25,
u'GROUND': 1.0,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 0.80000000000000004,
u'PSYCHIC': 1.25,
u'ROCK': 1.0,
u'STEEL': 0.80000000000000004,
u'WATER': 1.0},
u'DARK': {u'BUG': 1.0,
u'DARK': 0.80000000000000004,
u'DRAGON': 1.0,
u'ELECTRIC': 1.0,
u'FAIRY': 0.80000000000000004,
u'FIGHTING': 0.80000000000000004,
u'FIRE': 1.0,
u'FLYING': 1.0,
u'GHOST': 1.25,
u'GRASS': 1.0,
u'GROUND': 1.0,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.25,
u'ROCK': 1.0,
u'STEEL': 1.0,
u'WATER': 1.0},
u'DRAGON': {u'BUG': 1.0,
u'DARK': 1.0,
u'DRAGON': 1.25,
u'ELECTRIC': 1.0,
u'FAIRY': 0.80000000000000004,
u'FIGHTING': 1.0,
u'FIRE': 1.0,
u'FLYING': 1.0,
u'GHOST': 1.0,
u'GRASS': 1.0,
u'GROUND': 1.0,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.0,
u'ROCK': 1.0,
u'STEEL': 0.80000000000000004,
u'WATER': 1.0},
u'ELECTRIC': {u'BUG': 1.0,
u'DARK': 1.0,
u'DRAGON': 0.80000000000000004,
u'ELECTRIC': 0.80000000000000004,
u'FAIRY': 1.0,
u'FIGHTING': 1.0,
u'FIRE': 1.0,
u'FLYING': 1.25,
u'GHOST': 1.0,
u'GRASS': 0.80000000000000004,
u'GROUND': 0.80000000000000004,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.0,
u'ROCK': 1.0,
u'STEEL': 1.0,
u'WATER': 1.25},
u'FAIRY': {u'BUG': 1.0,
u'DARK': 1.25,
u'DRAGON': 1.25,
u'ELECTRIC': 1.0,
u'FAIRY': 1.0,
u'FIGHTING': 1.25,
u'FIRE': 0.80000000000000004,
u'FLYING': 1.0,
u'GHOST': 1.0,
u'GRASS': 1.0,
u'GROUND': 1.0,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 0.80000000000000004,
u'PSYCHIC': 1.0,
u'ROCK': 1.0,
u'STEEL': 0.80000000000000004,
u'WATER': 1.0},
u'FIGHTING': {u'BUG': 0.80000000000000004,
u'DARK': 1.25,
u'DRAGON': 1.0,
u'ELECTRIC': 1.0,
u'FAIRY': 0.80000000000000004,
u'FIGHTING': 1.0,
u'FIRE': 1.0,
u'FLYING': 0.80000000000000004,
u'GHOST': 0.80000000000000004,
u'GRASS': 1.0,
u'GROUND': 1.0,
u'ICE': 1.25,
u'NORMAL': 1.25,
u'POISON': 0.80000000000000004,
u'PSYCHIC': 0.80000000000000004,
u'ROCK': 1.25,
u'STEEL': 1.25,
u'WATER': 1.0},
u'FIRE': {u'BUG': 1.25,
u'DARK': 1.0,
u'DRAGON': 0.80000000000000004,
u'ELECTRIC': 1.0,
u'FAIRY': 1.0,
u'FIGHTING': 1.0,
u'FIRE': 0.80000000000000004,
u'FLYING': 1.0,
u'GHOST': 1.0,
u'GRASS': 1.25,
u'GROUND': 1.0,
u'ICE': 1.25,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.0,
u'ROCK': 0.80000000000000004,
u'STEEL': 1.25,
u'WATER': 0.80000000000000004},
u'FLYING': {u'BUG': 1.25,
u'DARK': 1.0,
u'DRAGON': 1.0,
u'ELECTRIC': 0.80000000000000004,
u'FAIRY': 1.0,
u'FIGHTING': 1.25,
u'FIRE': 1.0,
u'FLYING': 1.0,
u'GHOST': 1.0,
u'GRASS': 1.25,
u'GROUND': 1.0,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.0,
u'ROCK': 0.80000000000000004,
u'STEEL': 0.80000000000000004,
u'WATER': 1.0},
u'GHOST': {u'BUG': 1.0,
u'DARK': 0.80000000000000004,
u'DRAGON': 1.0,
u'ELECTRIC': 1.0,
u'FAIRY': 1.0,
u'FIGHTING': 1.0,
u'FIRE': 1.0,
u'FLYING': 1.0,
u'GHOST': 1.25,
u'GRASS': 1.0,
u'GROUND': 1.0,
u'ICE': 1.0,
u'NORMAL': 0.80000000000000004,
u'POISON': 1.0,
u'PSYCHIC': 1.25,
u'ROCK': 1.0,
u'STEEL': 1.0,
u'WATER': 1.0},
u'GRASS': {u'BUG': 0.80000000000000004,
u'DARK': 1.0,
u'DRAGON': 0.80000000000000004,
u'ELECTRIC': 1.0,
u'FAIRY': 1.0,
u'FIGHTING': 1.0,
u'FIRE': 0.80000000000000004,
u'FLYING': 0.80000000000000004,
u'GHOST': 1.0,
u'GRASS': 0.80000000000000004,
u'GROUND': 1.25,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 0.80000000000000004,
u'PSYCHIC': 1.0,
u'ROCK': 1.25,
u'STEEL': 0.80000000000000004,
u'WATER': 1.25},
u'GROUND': {u'BUG': 0.80000000000000004,
u'DARK': 1.0,
u'DRAGON': 1.0,
u'ELECTRIC': 1.25,
u'FAIRY': 1.0,
u'FIGHTING': 1.0,
u'FIRE': 1.25,
u'FLYING': 0.80000000000000004,
u'GHOST': 1.0,
u'GRASS': 0.80000000000000004,
u'GROUND': 1.0,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 1.25,
u'PSYCHIC': 1.0,
u'ROCK': 1.25,
u'STEEL': 1.25,
u'WATER': 1.0},
u'ICE': {u'BUG': 1.0,
u'DARK': 1.0,
u'DRAGON': 1.25,
u'ELECTRIC': 1.0,
u'FAIRY': 1.0,
u'FIGHTING': 1.0,
u'FIRE': 0.80000000000000004,
u'FLYING': 1.25,
u'GHOST': 1.0,
u'GRASS': 1.25,
u'GROUND': 1.25,
u'ICE': 0.80000000000000004,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.0,
u'ROCK': 1.0,
u'STEEL': 0.80000000000000004,
u'WATER': 0.80000000000000004},
u'NORMAL': {u'BUG': 1.0,
u'DARK': 1.0,
u'DRAGON': 1.0,
u'ELECTRIC': 1.0,
u'FAIRY': 1.0,
u'FIGHTING': 1.0,
u'FIRE': 1.0,
u'FLYING': 1.0,
u'GHOST': 0.80000000000000004,
u'GRASS': 1.0,
u'GROUND': 1.0,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.0,
u'ROCK': 0.80000000000000004,
u'STEEL': 0.80000000000000004,
u'WATER': 1.0},
u'POISON': {u'BUG': 1.0,
u'DARK': 1.0,
u'DRAGON': 1.0,
u'ELECTRIC': 1.0,
u'FAIRY': 1.25,
u'FIGHTING': 1.0,
u'FIRE': 1.0,
u'FLYING': 1.0,
u'GHOST': 0.80000000000000004,
u'GRASS': 1.25,
u'GROUND': 0.80000000000000004,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 0.80000000000000004,
u'PSYCHIC': 1.0,
u'ROCK': 0.80000000000000004,
u'STEEL': 0.80000000000000004,
u'WATER': 1.0},
u'PSYCHIC': {u'BUG': 1.0,
u'DARK': 0.80000000000000004,
u'DRAGON': 1.0,
u'ELECTRIC': 1.0,
u'FAIRY': 1.0,
u'FIGHTING': 1.25,
u'FIRE': 1.0,
u'FLYING': 1.0,
u'GHOST': 1.0,
u'GRASS': 1.0,
u'GROUND': 1.0,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 1.25,
u'PSYCHIC': 0.80000000000000004,
u'ROCK': 1.0,
u'STEEL': 0.80000000000000004,
u'WATER': 1.0},
u'ROCK': {u'BUG': 1.25,
u'DARK': 1.0,
u'DRAGON': 1.0,
u'ELECTRIC': 1.0,
u'FAIRY': 1.0,
u'FIGHTING': 0.80000000000000004,
u'FIRE': 1.25,
u'FLYING': 1.25,
u'GHOST': 1.0,
u'GRASS': 1.0,
u'GROUND': 0.80000000000000004,
u'ICE': 1.25,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.0,
u'ROCK': 1.0,
u'STEEL': 0.80000000000000004,
u'WATER': 1.0},
u'STEEL': {u'BUG': 1.0,
u'DARK': 1.0,
u'DRAGON': 1.0,
u'ELECTRIC': 0.80000000000000004,
u'FAIRY': 1.25,
u'FIGHTING': 1.0,
u'FIRE': 0.80000000000000004,
u'FLYING': 1.0,
u'GHOST': 1.0,
u'GRASS': 1.0,
u'GROUND': 1.0,
u'ICE': 1.25,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.0,
u'ROCK': 1.25,
u'STEEL': 0.80000000000000004,
u'WATER': 0.80000000000000004},
u'WATER': {u'BUG': 1.0,
u'DARK': 1.0,
u'DRAGON': 0.80000000000000004,
u'ELECTRIC': 1.0,
u'FAIRY': 1.0,
u'FIGHTING': 1.0,
u'FIRE': 1.25,
u'FLYING': 1.0,
u'GHOST': 1.0,
u'GRASS': 0.80000000000000004,
u'GROUND': 1.25,
u'ICE': 1.0,
u'NORMAL': 1.0,
u'POISON': 1.0,
u'PSYCHIC': 1.0,
u'ROCK': 1.25,
u'STEEL': 1.0,
u'WATER': 0.80000000000000004}}
In [10]:
stats = pd.read_excel("Pokemon Go Spreadsheet.xlsx", "Go Base Stats", index_col=1)
stats.head()
stats_dict = stats.T.to_dict()
stats_dict
Out[10]:
{u'Abra': {u'#': 63, u'Attack': 110, u'Defense': 76, u'Stamina': 50},
u'Aerodactyl': {u'#': 142, u'Attack': 182, u'Defense': 162, u'Stamina': 160},
u'Alakazam': {u'#': 65, u'Attack': 186, u'Defense': 152, u'Stamina': 110},
u'Arbok': {u'#': 24, u'Attack': 166, u'Defense': 166, u'Stamina': 120},
u'Arcanine': {u'#': 59, u'Attack': 230, u'Defense': 180, u'Stamina': 180},
u'Articuno': {u'#': 144, u'Attack': 198, u'Defense': 242, u'Stamina': 180},
u'Beedrill': {u'#': 15, u'Attack': 144, u'Defense': 130, u'Stamina': 130},
u'Bellsprout': {u'#': 69, u'Attack': 158, u'Defense': 78, u'Stamina': 100},
u'Blastoise': {u'#': 9, u'Attack': 186, u'Defense': 222, u'Stamina': 158},
u'Bulbasaur': {u'#': 1, u'Attack': 126, u'Defense': 126, u'Stamina': 90},
u'Butterfree': {u'#': 12, u'Attack': 144, u'Defense': 144, u'Stamina': 120},
u'Caterpie': {u'#': 10, u'Attack': 62, u'Defense': 66, u'Stamina': 90},
u'Chansey': {u'#': 113, u'Attack': 40, u'Defense': 60, u'Stamina': 500},
u'Charizard': {u'#': 6, u'Attack': 212, u'Defense': 182, u'Stamina': 156},
u'Charmander': {u'#': 4, u'Attack': 128, u'Defense': 108, u'Stamina': 78},
u'Charmeleon': {u'#': 5, u'Attack': 160, u'Defense': 140, u'Stamina': 116},
u'Clefable': {u'#': 36, u'Attack': 178, u'Defense': 178, u'Stamina': 190},
u'Clefairy': {u'#': 35, u'Attack': 116, u'Defense': 124, u'Stamina': 140},
u'Cloyster': {u'#': 91, u'Attack': 196, u'Defense': 196, u'Stamina': 100},
u'Cubone': {u'#': 104, u'Attack': 102, u'Defense': 150, u'Stamina': 100},
u'Dewgong': {u'#': 87, u'Attack': 156, u'Defense': 192, u'Stamina': 180},
u'Diglett': {u'#': 50, u'Attack': 108, u'Defense': 86, u'Stamina': 20},
u'Ditto': {u'#': 132, u'Attack': 110, u'Defense': 110, u'Stamina': 96},
u'Dodrio': {u'#': 85, u'Attack': 182, u'Defense': 150, u'Stamina': 120},
u'Doduo': {u'#': 84, u'Attack': 126, u'Defense': 96, u'Stamina': 70},
u'Dragonair': {u'#': 148, u'Attack': 170, u'Defense': 152, u'Stamina': 122},
u'Dragonite': {u'#': 149, u'Attack': 250, u'Defense': 212, u'Stamina': 182},
u'Dratini': {u'#': 147, u'Attack': 128, u'Defense': 110, u'Stamina': 82},
u'Drowzee': {u'#': 96, u'Attack': 104, u'Defense': 140, u'Stamina': 120},
u'Dugtrio': {u'#': 51, u'Attack': 148, u'Defense': 140, u'Stamina': 70},
u'Eevee': {u'#': 133, u'Attack': 114, u'Defense': 128, u'Stamina': 110},
u'Ekans': {u'#': 23, u'Attack': 112, u'Defense': 112, u'Stamina': 70},
u'Electabuzz': {u'#': 125, u'Attack': 198, u'Defense': 160, u'Stamina': 130},
u'Electrode': {u'#': 101, u'Attack': 150, u'Defense': 174, u'Stamina': 120},
u'Exeggcute': {u'#': 102, u'Attack': 110, u'Defense': 132, u'Stamina': 120},
u'Exeggutor': {u'#': 103, u'Attack': 232, u'Defense': 164, u'Stamina': 190},
u"Farfetch'd": {u'#': 83, u'Attack': 138, u'Defense': 132, u'Stamina': 104},
u'Fearow': {u'#': 22, u'Attack': 168, u'Defense': 146, u'Stamina': 130},
u'Flareon': {u'#': 136, u'Attack': 238, u'Defense': 178, u'Stamina': 130},
u'Gastly': {u'#': 92, u'Attack': 136, u'Defense': 82, u'Stamina': 60},
u'Gengar': {u'#': 94, u'Attack': 204, u'Defense': 156, u'Stamina': 120},
u'Geodude': {u'#': 74, u'Attack': 106, u'Defense': 118, u'Stamina': 80},
u'Gloom': {u'#': 44, u'Attack': 162, u'Defense': 158, u'Stamina': 120},
u'Golbat': {u'#': 42, u'Attack': 164, u'Defense': 164, u'Stamina': 150},
u'Goldeen': {u'#': 118, u'Attack': 112, u'Defense': 126, u'Stamina': 90},
u'Golduck': {u'#': 55, u'Attack': 194, u'Defense': 176, u'Stamina': 160},
u'Golem': {u'#': 76, u'Attack': 176, u'Defense': 198, u'Stamina': 160},
u'Graveler': {u'#': 75, u'Attack': 142, u'Defense': 156, u'Stamina': 110},
u'Grimer': {u'#': 88, u'Attack': 124, u'Defense': 110, u'Stamina': 160},
u'Growlithe': {u'#': 58, u'Attack': 156, u'Defense': 110, u'Stamina': 110},
u'Gyarados': {u'#': 130, u'Attack': 192, u'Defense': 196, u'Stamina': 190},
u'Haunter': {u'#': 93, u'Attack': 172, u'Defense': 118, u'Stamina': 90},
u'Hitmonchan': {u'#': 107, u'Attack': 138, u'Defense': 204, u'Stamina': 100},
u'Hitmonlee': {u'#': 106, u'Attack': 148, u'Defense': 172, u'Stamina': 100},
u'Horsea': {u'#': 116, u'Attack': 122, u'Defense': 100, u'Stamina': 60},
u'Hypno': {u'#': 97, u'Attack': 162, u'Defense': 196, u'Stamina': 170},
u'Ivysaur': {u'#': 2, u'Attack': 156, u'Defense': 158, u'Stamina': 120},
u'Jigglypuff': {u'#': 39, u'Attack': 98, u'Defense': 54, u'Stamina': 230},
u'Jolteon': {u'#': 135, u'Attack': 192, u'Defense': 174, u'Stamina': 130},
u'Jynx': {u'#': 124, u'Attack': 172, u'Defense': 134, u'Stamina': 130},
u'Kabuto': {u'#': 140, u'Attack': 148, u'Defense': 142, u'Stamina': 60},
u'Kabutops': {u'#': 141, u'Attack': 190, u'Defense': 190, u'Stamina': 120},
u'Kadabra': {u'#': 64, u'Attack': 150, u'Defense': 112, u'Stamina': 80},
u'Kakuna': {u'#': 14, u'Attack': 62, u'Defense': 82, u'Stamina': 90},
u'Kangaskhan': {u'#': 115, u'Attack': 142, u'Defense': 178, u'Stamina': 210},
u'Kingler': {u'#': 99, u'Attack': 178, u'Defense': 168, u'Stamina': 110},
u'Koffing': {u'#': 109, u'Attack': 136, u'Defense': 142, u'Stamina': 80},
u'Krabby': {u'#': 98, u'Attack': 116, u'Defense': 110, u'Stamina': 60},
u'Lapras': {u'#': 131, u'Attack': 186, u'Defense': 190, u'Stamina': 260},
u'Lickitung': {u'#': 108, u'Attack': 126, u'Defense': 160, u'Stamina': 180},
u'Machamp': {u'#': 68, u'Attack': 198, u'Defense': 180, u'Stamina': 180},
u'Machoke': {u'#': 67, u'Attack': 154, u'Defense': 144, u'Stamina': 160},
u'Machop': {u'#': 66, u'Attack': 118, u'Defense': 96, u'Stamina': 140},
u'Magikarp': {u'#': 129, u'Attack': 42, u'Defense': 84, u'Stamina': 40},
u'Magmar': {u'#': 126, u'Attack': 214, u'Defense': 158, u'Stamina': 130},
u'Magnemite': {u'#': 81, u'Attack': 128, u'Defense': 138, u'Stamina': 50},
u'Magneton': {u'#': 82, u'Attack': 186, u'Defense': 180, u'Stamina': 100},
u'Mankey': {u'#': 56, u'Attack': 122, u'Defense': 96, u'Stamina': 80},
u'Marowak': {u'#': 105, u'Attack': 140, u'Defense': 202, u'Stamina': 120},
u'Meowth': {u'#': 52, u'Attack': 104, u'Defense': 94, u'Stamina': 80},
u'Metapod': {u'#': 11, u'Attack': 56, u'Defense': 86, u'Stamina': 100},
u'Mew': {u'#': 151, u'Attack': 220, u'Defense': 220, u'Stamina': 200},
u'Mewtwo': {u'#': 150, u'Attack': 284, u'Defense': 202, u'Stamina': 212},
u'Moltres': {u'#': 146, u'Attack': 242, u'Defense': 194, u'Stamina': 180},
u'Mr. Mime': {u'#': 122, u'Attack': 154, u'Defense': 196, u'Stamina': 80},
u'Muk': {u'#': 89, u'Attack': 180, u'Defense': 188, u'Stamina': 210},
u'Nidoking': {u'#': 34, u'Attack': 204, u'Defense': 170, u'Stamina': 162},
u'Nidoqueen': {u'#': 31, u'Attack': 184, u'Defense': 190, u'Stamina': 180},
u'Nidoran \u2640': {u'#': 29,
u'Attack': 100,
u'Defense': 104,
u'Stamina': 110},
u'Nidoran \u2642': {u'#': 32, u'Attack': 110, u'Defense': 94, u'Stamina': 92},
u'Nidorina': {u'#': 30, u'Attack': 132, u'Defense': 136, u'Stamina': 140},
u'Nidorino': {u'#': 33, u'Attack': 142, u'Defense': 128, u'Stamina': 122},
u'Ninetales': {u'#': 38, u'Attack': 176, u'Defense': 194, u'Stamina': 146},
u'Oddish': {u'#': 43, u'Attack': 134, u'Defense': 130, u'Stamina': 90},
u'Omanyte': {u'#': 138, u'Attack': 132, u'Defense': 160, u'Stamina': 70},
u'Omastar': {u'#': 139, u'Attack': 180, u'Defense': 202, u'Stamina': 140},
u'Onix': {u'#': 95, u'Attack': 90, u'Defense': 186, u'Stamina': 70},
u'Paras': {u'#': 46, u'Attack': 122, u'Defense': 120, u'Stamina': 70},
u'Parasect': {u'#': 47, u'Attack': 162, u'Defense': 170, u'Stamina': 120},
u'Persian': {u'#': 53, u'Attack': 156, u'Defense': 146, u'Stamina': 130},
u'Pidgeot': {u'#': 18, u'Attack': 170, u'Defense': 166, u'Stamina': 166},
u'Pidgeotto': {u'#': 17, u'Attack': 126, u'Defense': 122, u'Stamina': 126},
u'Pidgey': {u'#': 16, u'Attack': 94, u'Defense': 90, u'Stamina': 80},
u'Pikachu': {u'#': 25, u'Attack': 124, u'Defense': 108, u'Stamina': 70},
u'Pinsir': {u'#': 127, u'Attack': 184, u'Defense': 186, u'Stamina': 130},
u'Poliwag': {u'#': 60, u'Attack': 108, u'Defense': 98, u'Stamina': 80},
u'Poliwhirl': {u'#': 61, u'Attack': 132, u'Defense': 132, u'Stamina': 130},
u'Poliwrath': {u'#': 62, u'Attack': 180, u'Defense': 202, u'Stamina': 180},
u'Ponyta': {u'#': 77, u'Attack': 168, u'Defense': 138, u'Stamina': 100},
u'Porygon': {u'#': 137, u'Attack': 156, u'Defense': 158, u'Stamina': 130},
u'Primeape': {u'#': 57, u'Attack': 178, u'Defense': 150, u'Stamina': 130},
u'Psyduck': {u'#': 54, u'Attack': 132, u'Defense': 112, u'Stamina': 100},
u'Raichu': {u'#': 26, u'Attack': 200, u'Defense': 154, u'Stamina': 120},
u'Rapidash': {u'#': 78, u'Attack': 200, u'Defense': 170, u'Stamina': 130},
u'Raticate': {u'#': 20, u'Attack': 146, u'Defense': 150, u'Stamina': 110},
u'Rattata': {u'#': 19, u'Attack': 92, u'Defense': 86, u'Stamina': 60},
u'Rhydon': {u'#': 112, u'Attack': 166, u'Defense': 160, u'Stamina': 210},
u'Rhyhorn': {u'#': 111, u'Attack': 110, u'Defense': 116, u'Stamina': 160},
u'Sandshrew': {u'#': 27, u'Attack': 90, u'Defense': 114, u'Stamina': 100},
u'Sandslash': {u'#': 28, u'Attack': 150, u'Defense': 172, u'Stamina': 150},
u'Scyther': {u'#': 123, u'Attack': 176, u'Defense': 180, u'Stamina': 140},
u'Seadra': {u'#': 117, u'Attack': 176, u'Defense': 150, u'Stamina': 110},
u'Seaking': {u'#': 119, u'Attack': 172, u'Defense': 160, u'Stamina': 160},
u'Seel': {u'#': 86, u'Attack': 104, u'Defense': 138, u'Stamina': 130},
u'Shellder': {u'#': 90, u'Attack': 120, u'Defense': 112, u'Stamina': 60},
u'Slowbro': {u'#': 80, u'Attack': 184, u'Defense': 198, u'Stamina': 190},
u'Slowpoke': {u'#': 79, u'Attack': 110, u'Defense': 110, u'Stamina': 180},
u'Snorlax': {u'#': 143, u'Attack': 180, u'Defense': 180, u'Stamina': 320},
u'Spearow': {u'#': 21, u'Attack': 102, u'Defense': 78, u'Stamina': 80},
u'Squirtle': {u'#': 7, u'Attack': 112, u'Defense': 142, u'Stamina': 88},
u'Starmie': {u'#': 121, u'Attack': 194, u'Defense': 192, u'Stamina': 120},
u'Staryu': {u'#': 120, u'Attack': 130, u'Defense': 128, u'Stamina': 60},
u'Tangela': {u'#': 114, u'Attack': 164, u'Defense': 152, u'Stamina': 130},
u'Tauros': {u'#': 128, u'Attack': 148, u'Defense': 184, u'Stamina': 150},
u'Tentacool': {u'#': 72, u'Attack': 106, u'Defense': 136, u'Stamina': 80},
u'Tentacruel': {u'#': 73, u'Attack': 170, u'Defense': 196, u'Stamina': 160},
u'Vaporeon': {u'#': 134, u'Attack': 186, u'Defense': 168, u'Stamina': 260},
u'Venomoth': {u'#': 49, u'Attack': 172, u'Defense': 154, u'Stamina': 140},
u'Venonat': {u'#': 48, u'Attack': 108, u'Defense': 118, u'Stamina': 120},
u'Venusaur': {u'#': 3, u'Attack': 198, u'Defense': 200, u'Stamina': 160},
u'Victreebel': {u'#': 71, u'Attack': 222, u'Defense': 152, u'Stamina': 160},
u'Vileplume': {u'#': 45, u'Attack': 202, u'Defense': 190, u'Stamina': 150},
u'Voltorb': {u'#': 100, u'Attack': 102, u'Defense': 124, u'Stamina': 80},
u'Vulpix': {u'#': 37, u'Attack': 106, u'Defense': 118, u'Stamina': 76},
u'Wartortle': {u'#': 8, u'Attack': 144, u'Defense': 176, u'Stamina': 118},
u'Weedle': {u'#': 13, u'Attack': 68, u'Defense': 64, u'Stamina': 80},
u'Weepinbell': {u'#': 70, u'Attack': 190, u'Defense': 110, u'Stamina': 130},
u'Weezing': {u'#': 110, u'Attack': 190, u'Defense': 198, u'Stamina': 130},
u'Wigglytuff': {u'#': 40, u'Attack': 168, u'Defense': 108, u'Stamina': 280},
u'Zapdos': {u'#': 145, u'Attack': 232, u'Defense': 194, u'Stamina': 180},
u'Zubat': {u'#': 41, u'Attack': 88, u'Defense': 90, u'Stamina': 80}}
In [11]:
basic = pd.read_excel("Pokemon Go Species Data.xlsx", "Basic Moves", index_col=1)
In [12]:
basic['i'] = float(1.0)
basic['Duration'] = basic['Duration (ms)']
basic['Energy Per Hit'] = basic['i']*basic['NRG']
basic['Energy Cost'] = 0.0
basic['Power'] = basic['PW']
basic['Crit'] = 0.0
basic[['Power', 'DPS', 'Energy Per Hit', 'Energy Cost', 'Crit', 'Type', 'Duration']].head()
Out[12]:
Power
DPS
Energy Per Hit
Energy Cost
Crit
Type
Duration
Name
Fury Cutter
3
7.50
6
0
0
Bug
400
Bug Bite
5
11.11
7
0
0
Bug
450
Bite
6
12.00
7
0
0
Dark
500
Sucker Punch
7
10.00
9
0
0
Dark
700
Dragon Breath
6
12.00
7
0
0
Dragon
500
In [13]:
special = pd.read_excel("Pokemon Go Species Data.xlsx", "Charged Moves", index_col=1)
In [14]:
special['Power']=special['PW']
special['Duration'] = special['Duration (ms)']
special['Energy Per Hit']=0.0
special['Energy Cost'] = special['NRG Cost']
special['Crit'] = special['Crit%']
special['DPS'] = 1000.0/special['Duration']*((1-special['Crit'])*special['Power'] + special['Crit']*2*special['Power'])
special[['Power', 'DPS', 'Energy Per Hit', 'Energy Cost', 'Crit', 'Type', 'Duration']].head()
Out[14]:
Power
DPS
Energy Per Hit
Energy Cost
Crit
Type
Duration
Name
Wrap
25
6.562500
0
20
0.05
Normal
4000
Hyper Beam
120
25.200000
0
100
0.05
Normal
5000
Dark Pulse
45
13.500000
0
33
0.05
Dark
3500
Sludge
30
12.115385
0
25
0.05
Poison
2600
Vice Grip
25
12.500000
0
20
0.05
Normal
2100
In [16]:
basic[['Power', 'DPS', 'Energy Per Hit', 'Energy Cost', 'Crit', 'Type', 'Duration']].fillna(0.0).T.to_dict()
Out[16]:
{u'Acid': {'Crit': 0.0,
u'DPS': 9.52,
'Duration': 1050L,
'Energy Cost': 0.0,
'Energy Per Hit': 10.0,
'Power': 10L,
u'Type': u'Poison'},
u'Bite': {'Crit': 0.0,
u'DPS': 12.0,
'Duration': 500L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 6L,
u'Type': u'Dark'},
u'Bubble': {'Crit': 0.0,
u'DPS': 10.87,
'Duration': 2300L,
'Energy Cost': 0.0,
'Energy Per Hit': 25.0,
'Power': 25L,
u'Type': u'Water'},
u'Bug Bite': {'Crit': 0.0,
u'DPS': 11.11,
'Duration': 450L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 5L,
u'Type': u'Bug'},
u'Bullet Punch': {'Crit': 0.0,
u'DPS': 8.33,
'Duration': 1200L,
'Energy Cost': 0.0,
'Energy Per Hit': 10.0,
'Power': 10L,
u'Type': u'Steel'},
u'Confusion': {'Crit': 0.0,
u'DPS': 9.93,
'Duration': 1510L,
'Energy Cost': 0.0,
'Energy Per Hit': 14.0,
'Power': 15L,
u'Type': u'Psychic'},
u'Cut': {'Crit': 0.0,
u'DPS': 10.62,
'Duration': 1130L,
'Energy Cost': 0.0,
'Energy Per Hit': 10.0,
'Power': 12L,
u'Type': u'Normal'},
u'Dragon Breath': {'Crit': 0.0,
u'DPS': 12.0,
'Duration': 500L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 6L,
u'Type': u'Dragon'},
u'Ember': {'Crit': 0.0,
u'DPS': 9.52,
'Duration': 1050L,
'Energy Cost': 0.0,
'Energy Per Hit': 10.0,
'Power': 10L,
u'Type': u'Fire'},
u'Feint Attack': {'Crit': 0.0,
u'DPS': 11.54,
'Duration': 1040L,
'Energy Cost': 0.0,
'Energy Per Hit': 10.0,
'Power': 12L,
u'Type': u'Dark'},
u'Fire Fang': {'Crit': 0.0,
u'DPS': 11.9,
'Duration': 840L,
'Energy Cost': 0.0,
'Energy Per Hit': 8.0,
'Power': 10L,
u'Type': u'Fire'},
u'Frost Breath': {'Crit': 0.0,
u'DPS': 11.11,
'Duration': 810L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 9L,
u'Type': u'Ice'},
u'Fury Cutter': {'Crit': 0.0,
u'DPS': 7.5,
'Duration': 400L,
'Energy Cost': 0.0,
'Energy Per Hit': 6.0,
'Power': 3L,
u'Type': u'Bug'},
u'Ice Shard': {'Crit': 0.0,
u'DPS': 10.71,
'Duration': 1400L,
'Energy Cost': 0.0,
'Energy Per Hit': 12.0,
'Power': 15L,
u'Type': u'Ice'},
u'Karate Chop': {'Crit': 0.0,
u'DPS': 7.5,
'Duration': 800L,
'Energy Cost': 0.0,
'Energy Per Hit': 8.0,
'Power': 6L,
u'Type': u'Fighting'},
u'Lick': {'Crit': 0.0,
u'DPS': 10.0,
'Duration': 500L,
'Energy Cost': 0.0,
'Energy Per Hit': 6.0,
'Power': 5L,
u'Type': u'Ghost'},
u'Low Kick': {'Crit': 0.0,
u'DPS': 8.33,
'Duration': 600L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 5L,
u'Type': u'Fighting'},
u'Metal Claw': {'Crit': 0.0,
u'DPS': 12.7,
'Duration': 630L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 8L,
u'Type': u'Steel'},
u'Mud Shot': {'Crit': 0.0,
u'DPS': 10.91,
'Duration': 550L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 6L,
u'Type': u'Ground'},
u'Mud Slap': {'Crit': 0.0,
u'DPS': 11.11,
'Duration': 1350L,
'Energy Cost': 0.0,
'Energy Per Hit': 12.0,
'Power': 15L,
u'Type': u'Ground'},
u'Peck': {'Crit': 0.0,
u'DPS': 8.7,
'Duration': 1150L,
'Energy Cost': 0.0,
'Energy Per Hit': 10.0,
'Power': 10L,
u'Type': u'Flying'},
u'Poison Jab': {'Crit': 0.0,
u'DPS': 11.43,
'Duration': 1050L,
'Energy Cost': 0.0,
'Energy Per Hit': 10.0,
'Power': 12L,
u'Type': u'Poison'},
u'Poison Sting': {'Crit': 0.0,
u'DPS': 10.43,
'Duration': 575L,
'Energy Cost': 0.0,
'Energy Per Hit': 8.0,
'Power': 6L,
u'Type': u'Poison'},
u'Pound': {'Crit': 0.0,
u'DPS': 12.96,
'Duration': 540L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 7L,
u'Type': u'Normal'},
u'Psycho Cut': {'Crit': 0.0,
u'DPS': 12.28,
'Duration': 570L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 7L,
u'Type': u'Psychic'},
u'Quick Attack': {'Crit': 0.0,
u'DPS': 7.52,
'Duration': 1330L,
'Energy Cost': 0.0,
'Energy Per Hit': 12.0,
'Power': 10L,
u'Type': u'Normal'},
u'Razor Leaf': {'Crit': 0.0,
u'DPS': 10.34,
'Duration': 1450L,
'Energy Cost': 0.0,
'Energy Per Hit': 12.0,
'Power': 15L,
u'Type': u'Grass'},
u'Rock Smash': {'Crit': 0.0,
u'DPS': 10.64,
'Duration': 1410L,
'Energy Cost': 0.0,
'Energy Per Hit': 12.0,
'Power': 15L,
u'Type': u'Fighting'},
u'Rock Throw': {'Crit': 0.0,
u'DPS': 8.82,
'Duration': 1360L,
'Energy Cost': 0.0,
'Energy Per Hit': 15.0,
'Power': 12L,
u'Type': u'Rock'},
u'Scratch': {'Crit': 0.0,
u'DPS': 12.0,
'Duration': 500L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 6L,
u'Type': u'Normal'},
u'Shadow Claw': {'Crit': 0.0,
u'DPS': 11.58,
'Duration': 950L,
'Energy Cost': 0.0,
'Energy Per Hit': 8.0,
'Power': 11L,
u'Type': u'Ghost'},
u'Spark': {'Crit': 0.0,
u'DPS': 10.0,
'Duration': 700L,
'Energy Cost': 0.0,
'Energy Per Hit': 8.0,
'Power': 7L,
u'Type': u'Electric'},
u'Splash': {'Crit': 0.0,
u'DPS': 0.0,
'Duration': 1230L,
'Energy Cost': 0.0,
'Energy Per Hit': 10.0,
'Power': 0L,
u'Type': u'Water'},
u'Steel Wing': {'Crit': 0.0,
u'DPS': 11.28,
'Duration': 1330L,
'Energy Cost': 0.0,
'Energy Per Hit': 12.0,
'Power': 15L,
u'Type': u'Steel'},
u'Sucker Punch': {'Crit': 0.0,
u'DPS': 10.0,
'Duration': 700L,
'Energy Cost': 0.0,
'Energy Per Hit': 9.0,
'Power': 7L,
u'Type': u'Dark'},
u'Tackle': {'Crit': 0.0,
u'DPS': 10.91,
'Duration': 1100L,
'Energy Cost': 0.0,
'Energy Per Hit': 10.0,
'Power': 12L,
u'Type': u'Normal'},
u'Thunder Shock': {'Crit': 0.0,
u'DPS': 8.33,
'Duration': 600L,
'Energy Cost': 0.0,
'Energy Per Hit': 8.0,
'Power': 5L,
u'Type': u'Electric'},
u'Vine Whip': {'Crit': 0.0,
u'DPS': 10.77,
'Duration': 650L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 7L,
u'Type': u'Grass'},
u'Water Gun': {'Crit': 0.0,
u'DPS': 12.0,
'Duration': 500L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 6L,
u'Type': u'Water'},
u'Water Gun (Blastoise)': {'Crit': 0.0,
u'DPS': 12.0,
'Duration': 500L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 6L,
u'Type': u'Water'},
u'Wing Attack': {'Crit': 0.0,
u'DPS': 12.0,
'Duration': 750L,
'Energy Cost': 0.0,
'Energy Per Hit': 7.0,
'Power': 9L,
u'Type': u'Flying'},
u'Zen Headbutt': {'Crit': 0.0,
u'DPS': 11.43,
'Duration': 1050L,
'Energy Cost': 0.0,
'Energy Per Hit': 9.0,
'Power': 12L,
u'Type': u'Psychic'}}
In [17]:
special[['Power', 'DPS', 'Energy Per Hit', 'Energy Cost', 'Crit', 'Type', 'Duration']].fillna(0.0).T.to_dict()
Out[17]:
{u'Aerial Ace': {'Crit': 0.05,
'DPS': 10.862068965517242,
'Duration': 2900L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Flying'},
u'Air Cutter': {'Crit': 0.25,
'DPS': 11.363636363636363,
'Duration': 3300L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Flying'},
u'Ancient Power': {'Crit': 0.05,
'DPS': 10.208333333333334,
'Duration': 3600L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 35L,
u'Type': u'Rock'},
u'Aqua Jet': {'Crit': 0.05,
'DPS': 11.170212765957446,
'Duration': 2350L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Water'},
u'Aqua Tail': {'Crit': 0.05,
'DPS': 20.106382978723403,
'Duration': 2350L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 45L,
u'Type': u'Water'},
u'Blizzard': {'Crit': 0.05,
'DPS': 26.92307692307692,
'Duration': 3900L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 100L,
u'Type': u'Ice'},
u'Body Slam': {'Crit': 0.05,
'DPS': 26.923076923076927,
'Duration': 1560L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 40L,
u'Type': u'Normal'},
u'Bone Club': {'Crit': 0.05,
'DPS': 16.40625,
'Duration': 1600L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Ground'},
u'Brick Break': {'Crit': 0.25,
'DPS': 23.4375,
'Duration': 1600L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Fighting'},
u'Brine': {'Crit': 0.05,
'DPS': 10.9375,
'Duration': 2400L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Water'},
u'Bubble Beam': {'Crit': 0.05,
'DPS': 10.862068965517242,
'Duration': 2900L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Water'},
u'Bug Buzz': {'Crit': 0.05,
'DPS': 18.52941176470588,
'Duration': 4250L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 75L,
u'Type': u'Bug'},
u'Bulldoze': {'Crit': 0.05,
'DPS': 10.808823529411764,
'Duration': 3400L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 35L,
u'Type': u'Ground'},
u'Cross Chop': {'Crit': 0.25,
'DPS': 37.5,
'Duration': 2000L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 60L,
u'Type': u'Fighting'},
u'Cross Poison': {'Crit': 0.25,
'DPS': 20.833333333333332,
'Duration': 1500L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Poison'},
u'Dark Pulse': {'Crit': 0.05,
'DPS': 13.5,
'Duration': 3500L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 45L,
u'Type': u'Dark'},
u'Dazzling Gleam': {'Crit': 0.05,
'DPS': 13.75,
'Duration': 4200L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 55L,
u'Type': u'Fairy'},
u'Dig': {'Crit': 0.05,
'DPS': 12.672413793103448,
'Duration': 5800L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 70L,
u'Type': u'Ground'},
u'Disarming Voice': {'Crit': 0.05,
'DPS': 6.73076923076923,
'Duration': 3900L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Fairy'},
u'Discharge': {'Crit': 0.05,
'DPS': 14.700000000000001,
'Duration': 2500L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 35L,
u'Type': u'Electric'},
u'Dragon Claw': {'Crit': 0.25,
'DPS': 29.166666666666664,
'Duration': 1500L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 35L,
u'Type': u'Dragon'},
u'Dragon Pulse': {'Crit': 0.05,
'DPS': 18.958333333333336,
'Duration': 3600L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 65L,
u'Type': u'Dragon'},
u'Draining Kiss': {'Crit': 0.05,
'DPS': 9.375,
'Duration': 2800L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Fairy'},
u'Drill Peck': {'Crit': 0.05,
'DPS': 15.555555555555555,
'Duration': 2700L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 40L,
u'Type': u'Flying'},
u'Drill Run': {'Crit': 0.25,
'DPS': 18.38235294117647,
'Duration': 3400L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 50L,
u'Type': u'Ground'},
u'Earthquake': {'Crit': 0.05,
'DPS': 25.0,
'Duration': 4200L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 100L,
u'Type': u'Ground'},
u'Fire Blast': {'Crit': 0.05,
'DPS': 25.609756097560975,
'Duration': 4100L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 100L,
u'Type': u'Fire'},
u'Fire Punch': {'Crit': 0.05,
'DPS': 15.0,
'Duration': 2800L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 40L,
u'Type': u'Fire'},
u'Flame Burst': {'Crit': 0.05,
'DPS': 15.0,
'Duration': 2100L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Fire'},
u'Flame Charge': {'Crit': 0.05,
'DPS': 8.46774193548387,
'Duration': 3100L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Fire'},
u'Flame Wheel': {'Crit': 0.05,
'DPS': 9.130434782608695,
'Duration': 4600L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 40L,
u'Type': u'Fire'},
u'Flamethrower': {'Crit': 0.05,
'DPS': 19.913793103448278,
'Duration': 2900L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 55L,
u'Type': u'Fire'},
u'Flash Cannon': {'Crit': 0.05,
'DPS': 16.153846153846153,
'Duration': 3900L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 60L,
u'Type': u'Steel'},
u'Giga Drain': {'Crit': 0.05,
'DPS': 14.583333333333334,
'Duration': 3600L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 50L,
u'Type': u'Grass'},
u'Gunk Shot': {'Crit': 0.05,
'DPS': 22.75,
'Duration': 3000L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 65L,
u'Type': u'Poison'},
u'Heart Stamp': {'Crit': 0.05,
'DPS': 10.294117647058824,
'Duration': 2550L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Psychic'},
u'Heat Wave': {'Crit': 0.05,
'DPS': 22.105263157894736,
'Duration': 3800L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 80L,
u'Type': u'Fire'},
u'Horn Attack': {'Crit': 0.05,
'DPS': 11.931818181818182,
'Duration': 2200L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Normal'},
u'Hurricane': {'Crit': 0.05,
'DPS': 26.25,
'Duration': 3200L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 80L,
u'Type': u'Flying'},
u'Hydro Pump': {'Crit': 0.05,
'DPS': 24.86842105263158,
'Duration': 3800L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 90L,
u'Type': u'Water'},
u'Hydro Pump (Blastoise)': {'Crit': 0.05,
'DPS': 24.86842105263158,
'Duration': 3800L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 90L,
u'Type': u'Water'},
u'Hyper Beam': {'Crit': 0.05,
'DPS': 25.200000000000003,
'Duration': 5000L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 120L,
u'Type': u'Normal'},
u'Hyper Fang': {'Crit': 0.05,
'DPS': 17.5,
'Duration': 2100L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 35L,
u'Type': u'Normal'},
u'Ice Beam': {'Crit': 0.05,
'DPS': 18.6986301369863,
'Duration': 3650L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 65L,
u'Type': u'Ice'},
u'Ice Punch': {'Crit': 0.05,
'DPS': 13.5,
'Duration': 3500L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 45L,
u'Type': u'Ice'},
u'Icy Wind': {'Crit': 0.05,
'DPS': 6.907894736842105,
'Duration': 3800L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Ice'},
u'Iron Head': {'Crit': 0.05,
'DPS': 15.75,
'Duration': 2000L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Steel'},
u'Leaf Blade': {'Crit': 0.25,
'DPS': 24.55357142857143,
'Duration': 2800L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 55L,
u'Type': u'Grass'},
u'Low Sweep': {'Crit': 0.05,
'DPS': 14.0,
'Duration': 2250L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Fighting'},
u'Magnet Bomb': {'Crit': 0.05,
'DPS': 11.25,
'Duration': 2800L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Steel'},
u'Mega Drain': {'Crit': 0.05,
'DPS': 8.203125,
'Duration': 3200L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Grass'},
u'Megahorn': {'Crit': 0.05,
'DPS': 26.25,
'Duration': 3200L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 80L,
u'Type': u'Bug'},
u'Moonblast': {'Crit': 0.05,
'DPS': 21.76829268292683,
'Duration': 4100L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 85L,
u'Type': u'Fairy'},
u'Mud Bomb': {'Crit': 0.05,
'DPS': 12.115384615384617,
'Duration': 2600L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Ground'},
u'Night Slash': {'Crit': 0.25,
'DPS': 13.888888888888888,
'Duration': 2700L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Dark'},
u'Ominous Wind': {'Crit': 0.05,
'DPS': 10.161290322580644,
'Duration': 3100L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Ghost'},
u'Parabolic Charge': {'Crit': 0.05,
'DPS': 12.5,
'Duration': 2100L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Electric'},
u'Petal Blizzard': {'Crit': 0.05,
'DPS': 21.328125,
'Duration': 3200L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 65L,
u'Type': u'Grass'},
u'Play Rough': {'Crit': 0.05,
'DPS': 19.913793103448278,
'Duration': 2900L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 55L,
u'Type': u'Fairy'},
u'Poison Fang': {'Crit': 0.05,
'DPS': 10.9375,
'Duration': 2400L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Poison'},
u'Power Gem': {'Crit': 0.05,
'DPS': 14.482758620689657,
'Duration': 2900L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 40L,
u'Type': u'Rock'},
u'Power Whip': {'Crit': 0.0,
'DPS': 25.0,
'Duration': 2800L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 70L,
u'Type': u'Grass'},
u'Psybeam': {'Crit': 0.05,
'DPS': 11.052631578947368,
'Duration': 3800L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 40L,
u'Type': u'Psychic'},
u'Psychic': {'Crit': 0.05,
'DPS': 20.625,
'Duration': 2800L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 55L,
u'Type': u'Psychic'},
u'Psyshock': {'Crit': 0.05,
'DPS': 15.555555555555555,
'Duration': 2700L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 40L,
u'Type': u'Psychic'},
u'Psystrike': {'Crit': 0.05,
'DPS': 20.58823529411765,
'Duration': 5100L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 100L,
u'Type': u'Psychic'},
u'Rest': {'Crit': 0.0,
'DPS': 11.29032258064516,
'Duration': 3100L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 35L,
u'Type': u'Normal'},
u'Rock Slide': {'Crit': 0.05,
'DPS': 16.40625,
'Duration': 3200L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 50L,
u'Type': u'Rock'},
u'Rock Tomb': {'Crit': 0.25,
'DPS': 11.029411764705882,
'Duration': 3400L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Rock'},
u'Scald': {'Crit': 0.05,
'DPS': 14.4375,
'Duration': 4000L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 55L,
u'Type': u'Water'},
u'Scald (Blastoise)': {'Crit': 0.05,
'DPS': 14.4375,
'Duration': 4000L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 55L,
u'Type': u'Water'},
u'Seed Bomb': {'Crit': 0.05,
'DPS': 17.5,
'Duration': 2400L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 40L,
u'Type': u'Grass'},
u'Shadow Ball': {'Crit': 0.05,
'DPS': 15.34090909090909,
'Duration': 3080L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 45L,
u'Type': u'Ghost'},
u'Shadow Punch': {'Crit': 0.05,
'DPS': 12.5,
'Duration': 2100L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Ghost'},
u'Shadow Sneak': {'Crit': 0.05,
'DPS': 8.46774193548387,
'Duration': 3100L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Ghost'},
u'Signal Beam': {'Crit': 0.05,
'DPS': 15.241935483870968,
'Duration': 3100L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 45L,
u'Type': u'Bug'},
u'Sludge': {'Crit': 0.05,
'DPS': 12.115384615384617,
'Duration': 2600L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Poison'},
u'Sludge Bomb': {'Crit': 0.05,
'DPS': 22.211538461538463,
'Duration': 2600L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 55L,
u'Type': u'Poison'},
u'Sludge Wave': {'Crit': 0.05,
'DPS': 21.61764705882353,
'Duration': 3400L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 70L,
u'Type': u'Poison'},
u'Solar Beam': {'Crit': 0.05,
'DPS': 25.714285714285715,
'Duration': 4900L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 120L,
u'Type': u'Grass'},
u'Stomp': {'Crit': 0.05,
'DPS': 15.0,
'Duration': 2100L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Normal'},
u'Stone Edge': {'Crit': 0.5,
'DPS': 38.70967741935484,
'Duration': 3100L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 80L,
u'Type': u'Rock'},
u'Struggle': {'Crit': 0.0,
'DPS': 8.849557522123893,
'Duration': 1695L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 15L,
u'Type': u'Normal'},
u'Submission': {'Crit': 0.05,
'DPS': 15.0,
'Duration': 2100L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Fighting'},
u'Swift': {'Crit': 0.05,
'DPS': 10.5,
'Duration': 3000L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 30L,
u'Type': u'Normal'},
u'Thunder': {'Crit': 0.05,
'DPS': 24.41860465116279,
'Duration': 4300L,
'Energy Cost': 100L,
'Energy Per Hit': 0.0,
'Power': 100L,
u'Type': u'Electric'},
u'Thunder Punch': {'Crit': 0.05,
'DPS': 17.5,
'Duration': 2400L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 40L,
u'Type': u'Electric'},
u'Thunderbolt': {'Crit': 0.05,
'DPS': 21.38888888888889,
'Duration': 2700L,
'Energy Cost': 50L,
'Energy Per Hit': 0.0,
'Power': 55L,
u'Type': u'Electric'},
u'Twister': {'Crit': 0.05,
'DPS': 9.722222222222221,
'Duration': 2700L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Dragon'},
u'Vice Grip': {'Crit': 0.05,
'DPS': 12.5,
'Duration': 2100L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Normal'},
u'Water Pulse': {'Crit': 0.05,
'DPS': 11.136363636363637,
'Duration': 3300L,
'Energy Cost': 25L,
'Energy Per Hit': 0.0,
'Power': 35L,
u'Type': u'Water'},
u'Wrap': {'Crit': 0.05,
'DPS': 6.5625,
'Duration': 4000L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Normal'},
u'Wrap (Green)': {'Crit': 0.05,
'DPS': 7.094594594594595,
'Duration': 3700L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Normal'},
u'Wrap (Pink)': {'Crit': 0.05,
'DPS': 7.094594594594595,
'Duration': 3700L,
'Energy Cost': 20L,
'Energy Per Hit': 0.0,
'Power': 25L,
u'Type': u'Normal'},
u'X-Scissor': {'Crit': 0.05,
'DPS': 17.5,
'Duration': 2100L,
'Energy Cost': 33L,
'Energy Per Hit': 0.0,
'Power': 35L,
u'Type': u'Bug'}}
In [ ]:
Content source: JackDragon/pokemon-go-sim
Similar notebooks: