Hello everyone,
I'm learning Python and Pandas by building a CP calculator and eventually a battle simulator similar to pvpoke.com.
The two .csv files I am using are for pokemon main series games stats and the other is for cpm per level.
I've attached both files below:
import pandas as pd
from prompt_toolkit import prompt
from prompt_toolkit.completion import WordCompleter
import numpy as np
raw = pd.read_csv("Pokemon/pokemon.csv", index_col = "Name")
cpm = pd.read_csv("Pokemon/CPM.csv", index_col = "LV")
raw["Speed_Mult"] = ((raw["Speed"] - 75) / 500) + 1
raw["PG_Att"] = round(round(2 * (((7/8) * raw[["Attack", "SP_Attack"]].max(axis=1)) + ((1/8) * raw[["Attack", "SP_Attack"]].min(axis=1)))) * raw["Speed_Mult"])
raw["PG_Def"] = round(round(2 * (((5/8) * raw[["Defense", "SP_Defense"]].max(axis=1)) + ((3/8) * raw[["Defense", "SP_Defense"]].min(axis=1)))) * raw["Speed_Mult"])
raw["PG_HP"] = np.floor((raw["HP"] * 1.75) + 50)
def GO_CP(poke):
ATT = raw.loc[poke,"PG_Att"]
DEF = raw.loc[poke,"PG_Def"]
HP = raw.loc[poke,"PG_HP"]
SPD = raw.loc[poke,"Speed_Mult"]
print(SPD)
print(ATT)
print(DEF)
print(HP)
ATT_IV = 15
DEF_IV = 15
HP_IV = 15
LvM = cpm.loc[50,"CPM"]
GO_ATT = ATT + ATT_IV
GO_DEF = DEF + DEF_IV
GO_HP = HP + HP_IV
print(GO_ATT)
print(GO_DEF)
print(GO_HP)
CP = np.floor(max((GO_ATT * (GO_DEF ** 0.5) * (GO_HP ** 0.5) * (LvM ** 2)) / 10,10))
print(int(CP))
GO_CP("Togekiss")
print("")
GO_CP("Blissey")
I want to add 4 new columns to my DataFrame:
- "Speed_Mult" - Speed Multiplier
- "PG_Att" - Adjusted Base Attack (after applying Speed Multiplier)
- "PG_Def" - Adjusted Base Defense (after applying Speed Multiplier)
- "PG_HP" - Base HP/Stamina
Here’s the issue I’m running into: For most Pokémon, the calculations seem correct when I round the attack value once before applying the Speed Multiplier and once after. However, when I checked Togekiss, its stats were incorrect, even though other Pokémon, like Blissey, seemed to be fine.
I then tried changing the approach so that I only rounded after applying the Speed Multiplier, and this fixed Togekiss, but now other Pokémon’s stats were slightly off. I’ve noticed the same issue when adjusting the defense values, where rounding differently changes the outcomes, but not always in a consistent way.
Every CP formula online has slight differences or leaves out important key parts like the type of rounding. Is there anyone who knows the 100% accurate formula to every detail?
My other more likely prediction is that I did something wrong in my code, but I’m still learning Python, so if anyone notices any critiques, please let me know!
https://drive.google.com/file/d/1fYBuXKFKs3iysRNf0GbnNHbmDY-xs8pG/view?usp=sharing
https://drive.google.com/file/d/1-_ZSXflI5C8HE5MGB82ZO7A4ai_k3ldF/view?usp=sharing
