I spend a lot of time playing Evony – The Kings Return on my iPad and recently, I’ve been most obsessed with constructing the best outfit that will allow for fast gathering. An example of what I am talking about can be found here.

As I sat down with a pen and paper, jotting down all the possibilities, I thought it would be fun to throw something into a Python notebook. With that, I took to Excel and wrote down all the specifications for those armors that offer gathering buffs. The spreadsheet can be found here.

I loaded all the data into a spreadsheet and uploaded it onto my Google drive. Then, I spun up a GoogleColab notebook and wrote the code below.

Google Colab Code

import pandas as pd

armor = pd.read_excel("/content/drive/MyDrive/Evony/data/Evony Fun with Armor.xlsx", "Armor Options Excel")

armor.describe()

armor.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 44 entries, 0 to 43
Data columns (total 6 columns):
 #   Column                                              Non-Null Count  Dtype  
---  ------                                              --------------  -----  
 0   Armor                                               44 non-null     object 
 1   Clothing                                            44 non-null     object 
 2   Resource                                            44 non-null     object 
 3   Bonus                                               36 non-null     float64
 4   Extra Bonus (if > 0 assume two equipment required)  15 non-null     float64
 5   Total Bonus                                         44 non-null     int64  
dtypes: float64(2), int64(1), object(3)
memory usage: 2.2+ KB

armor.head()

armor.fillna(0)

armor['Resource'] = armor["Resource"].str.strip()

food = armor[armor['Resource'] == 'Food']

food[['Total Bonus', 'Clothing']].groupby(by="Clothing").max()

resources = armor["Resource"].unique()

armor[['Resource','Total Bonus']].groupby(by="Resource").describe()

weapon_types = ['Spear', 'Axe', 'Bow', 'Sword']
armor_types = ['Helmet', 'Clothes', 'Boots', 'Pants', 'Ring']

ore = armor[armor['Resource'] == 'Ore']
ore_selection = ore[(ore['Total Bonus'] >= 15) & (ore['Armor'] != 'Champion')]

ore_selection['Total Bonus'].sum()

75

ore_clothing = ore_selection[ore_selection["Clothing"] != 'Pick One']
for armor in armor_types:
  if armor not in set(ore_clothing['Clothing']):
    print('Needed', armor)

if not any(weapon in weapon_types for weapon in ore_clothing['Clothing']):
  print("Needed Weapon")

Needed Clothes
Needed Pants
Needed Ring

Great Potential

I want to focus on ore gathering speed, where the notebook stopped. In the referenced wiki, there is a mention of the cost effectiveness of the type of armor. Reducing the focus to one gathering style, I can see potential in creating an application that could identify the best armor combination for a player.

I choose to stop here. There may be a situation where I return to the GoogleColab notebook to find out which set that I should spin up to get lumber or food the fastest way possible. It is unlikely that I’ll create the application that this project is tempting.

I am having too much fun building the gathering armor that I’m playing with in Evony – The Kings Return and there is already a wiki available to answer the question, mostly.