【python】2024年微软excel电竞大赛决赛-魔兽世界

import pandas as pd

upgrade_xp = [400]  # 升级所需经验
total_xp = [0]  # 累积经验
for i in range(1, 40):
    total_xp.append(total_xp[i-1] + upgrade_xp[i-1])
    upgrade_xp.append(upgrade_xp[i-1]*1.125)

# 为了直观看到他们的关系，写进一个表格内
degree = pd.DataFrame({'degree': range(1, 41), 'total_xp': total_xp, 'upgrade_xp': upgrade_xp})

# 查找玩家的等级，把player_xp替换成玩家当前的总经验值即可
player_degree = [player_xp >= i for i in total_xp].index(False)

import pandas as pd

location = pd.read_excel('Quest.xlsx', sheet_name='location')   # 加载种族位置顺序表

site = pd.read_excel('Quest.xlsx', sheet_name='site')   # 任务顺序表


def get_money(race, init_xp, gold_collected, current_location):
    '''
    :param race: 种族
    :param init_xp: 初始xp
    :param gold_collected: 初始金币
    :param current_location: 当前位置
    :return: 达到40级时的经验值、银币数量
    '''

    degree_xp = degree[degree['degree'] == 40]['total_xp'].values[0]  # 达到40级的累积经验
    race_location_sort = location[race] # 根据种族查找位置顺序
    quest_location = list(race_location_sort).index(current_location)
    df = site[site['Location'].isin(race_location_sort[quest_location:])]
    df['Location'] = pd.Categorical(df['Location'], categories=race_location_sort)
    df = df.sort_values(['Location', 'Quest ID'])
    df['gold_collected_cumsum'] = df['Gold Granted'].cumsum()
    df['xp_cumsum'] = df['XP Granted'].cumsum()
    total_xp = df[df['xp_cumsum'] > (degree_xp - init_xp)]['xp_cumsum'].min()  # 达到40级时获得的xp
    gold_granted = df[df['xp_cumsum'] > (degree_xp - init_xp)]['gold_collected_cumsum'].min()  # 达到40级时获得的金币
    current_location = df[df['xp_cumsum'] > (degree_xp - init_xp)]['Location'].iloc[0] # 40级时的位置
    total_xp += init_xp
    total_sliver = int(round((gold_collected + gold_granted) * 100, 0))
    return total_xp, total_sliver

copper_color = get_cell_color(wb['resource']['B1'])
tin_color = get_cell_color(wb['resource']['C1'])
icon_color = get_cell_color(wb['resource']['D1'])
mithril_color = get_cell_color(wb['resource']['E1'])
thorium_color = get_cell_color(wb['resource']['F1'])
schedule = wb['mining schedule']


def check_resource(color):
    if color == copper_color:
        return 'Copper'
    elif color == tin_color:
        return 'Tin'
    elif color == icon_color:
        return 'Iron'
    elif color == mithril_color:
        return 'Mithril'
    elif color == thorium_color:
        return 'Thorium'


print('请输入player_id和银币数量：') # 基于表格的位置读取日期的
player_id = int(input())
sliver_collected = int(input()) 
resource_remain = {
    'Copper': 0, 
    'Tin': 0, 
    'Iron': 0, 
    'Mithril': 0, 
    'Thorium': 0, 
    'gold_collected': sliver_collected/100,
    'week': '1'
}

while True:
	for week in range(1, 5):
	    if week == 1:	# week 1
		    resource_type = check_resource(get_cell_color(schedule.cell(player_id+1, week+1)))
		    start_date = schedule.cell(player_id+1, week+1).value
		    sell_date = start_date + datetime.timedelta(days=6)
		    resource_remain['week'] = '1'
    
    		stack = schedule.cell(player_id+1, week+1).value // 20
    		resource_remain[resource_type] = schedule.cell(player_id+1, week+1).value % 20 + 		resource_remain[resource_type]
    		resource_remain['gold_collected'] = (resource[resource['date'] == sell_date][resource_type] * stack).values[0] + resource_remain['gold_collected']
		    for i in ['Copper', 'Tin', 'Iron', 'Mithril', 'Thorium']:
		        if resource_remain[i] >= 20:
		            stack = resource_remain[i] // 20
		            resource_remain[i] = resource_remain[i] % 20
		            resource_remain['gold_collected'] = (resource[resource['date'] == sell_date][i]*stack).values[0] + resource_remain['gold_collected']
		    if resource_remain['gold_collected'] >= 90:
		        break
    
    else:	# week 2-5
	    resource_type = check_resource(get_cell_color(schedule.cell(player_id+1, week+1)))
	    start_date = start_date + datetime.timedelta(days=7)
	    sell_date = start_date + datetime.timedelta(days=6)
	    resource_remain['week'] = week
	    stack = schedule.cell(player_id+1, week+1).value // 20
	    resource_remain[resource_type] = schedule.cell(player_id+1, week+1).value % 20 + resource_remain[resource_type]
	    resource_remain['gold_collected'] = (resource[resource['date'] == sell_date][resource_type] * stack).values[0] + resource_remain['gold_collected']
	
	    for i in ['Copper', 'Tin', 'Iron', 'Mithril', 'Thorium']:
	        if resource_remain[i] >= 20:
	            stack = resource_remain[i] // 20
	            resource_remain[i] = resource_remain[i] % 20
	            resource_remain['gold_collected'] = (resource[resource['date'] == sell_date][i]*stack).values[0] + resource_remain['gold_collected']
	    if resource_remain['gold_collected'] >= 90:
	        break
 
print('剩余金币数：', (resource_remain['gold_collected'] - 90) * 100)

# L4
quest_list = pd.read_excel('L4.xlsx', sheet_name='Quest List')
quest_item = pd.read_excel('L4.xlsx', sheet_name='Quest Item')
class_stat = pd.read_excel('L4.xlsx', sheet_name='Stat')
data = pd.merge(quest_list, quest_item, left_on='Item Granted', right_on='Item Name', how='left')

print('请输入玩家种族：')
race = input()
print('请输入当前xp：')
player_xp = int(input())	# L2得到
print('请输入玩家职业：')
player_class = input()
print('请输入L3后剩余银币：')
sliver_granted = int(input())
gold_granted = sliver_granted / 100
print(gold_granted)
target = class_stat[class_stat['Class'] == player_class]['Target'].values[0]

if player_class in ['Warlock', 'Priest', 'Mage']:
    player_class = 'Warlock, Priest, Mage'
elif player_class in ['Druid', 'Rogue']:
    player_class = 'Druid, Rogue'


class_data = data[data['Available to Class'] == player_class]
class_data.sort_values(by=['Amount of Stats', 'XP Granted'], ascending=False, inplace=True)

class_data['total_stat'] = class_data['Amount of Stats'].cumsum()
class_data['xp_granted'] = class_data['XP Granted'].cumsum()
class_data['gold_granted'] = class_data['Gold Granted'].cumsum()
player_xp = class_data[class_data['total_stat'] >= target]['xp_granted'].values[0] + player_xp
gold_granted = class_data[class_data['total_stat'] >= target]['gold_granted'].values[0] + gold_granted
stats_amount = class_data[class_data['total_stat'] >= target]['total_stat'].values[0]

print('玩家的总经验值：', player_xp)
print('玩家的总金币数：', gold_granted)
print('玩家的属性值：', stats_amount)

print('请输入玩家职业：')
player_class = input()
print('请输入L4后的xp：')
player_xp = int(input())
player_degree = degree[degree['total_xp'] <= player_xp]['degree'].max()

visit_on_degree = 1
armor_stats = 0
armor_price = 0
armor = 'null'
print('请输入L4后的金币数：')
gold_granted = float(input())
print('请输入L4后的属性值：')
stats_amount = int(input())

if player_class == 'Mage':
    player_class = 'Warlock, Mage'

while True:
    df = dungeons[dungeons['Min Level'] <= player_degree]
    df.sort_values(['XP Granted', 'Min Level'], ascending=[False, False], inplace=True)

    # 判断进入地下城次数
    if visit_on_degree % 3 == 1:
        data = df[df['Visit'] == '1, 4, 7,…']
    elif visit_on_degree % 3 == 2:
        data = df[df['Visit'] == '2, 5, 8,…']
    else:
        data = df[df['Visit'] == '3, 6, 9,…'] 
    
    
    if player_class != data['Class'].values[0]:
        # Warlock单独判断
        if player_class == 'Warlock':
            if data['Class'].values[0] == 'Warlock, Mage':
                if armor_stats <= data['Stats Amount'].values[0]: # 丢弃旧装备
                    gold_granted = gold_granted + data['Gold Granted'].values[0] + armor_price
                    armor_price = data['Sales Price'].values[0]
                    stats_amount = stats_amount + data['Stats Amount'].values[0] - armor_stats
                    armor_stats = data['Stats Amount'].values[0]
                    armor = data['Gear Reward (Weapons)'].values[0]
                else: # 丢弃新装备
                    gold_granted += data['Gold Granted'].values[0]
            else:
                gold_granted = gold_granted + data['Gold Granted'].values[0] + data['Sales Price'].values[0]
        else:
            gold_granted = gold_granted + data['Gold Granted'].values[0] + data['Sales Price'].values[0]
    else:
        # 判断新获得的装备是否比旧装备强，强则丢弃旧装备，反之丢弃新装备
        if armor_stats <= data['Stats Amount'].values[0]: # 丢弃旧装备
            gold_granted = gold_granted + data['Gold Granted'].values[0] + armor_price
            armor_price = data['Sales Price'].values[0]
            stats_amount = stats_amount + data['Stats Amount'].values[0] - armor_stats
            armor_stats = data['Stats Amount'].values[0]
            armor = data['Gear Reward (Weapons)'].values[0]
        else: # 丢弃新装备
            gold_granted = gold_granted + data['Gold Granted'].values[0] + data['Sales Price'].values[0]
            

    # 判断等级
    player_xp += data['XP Granted'].values[0]
    player_degree = [player_xp >= i for i in total_xp].index(False)
    print(player_xp, player_degree, gold_granted, stats_amount, armor_stats)
    if player_degree == 60:
        break
    else:
        # 查看是否能否开启下一级地下城
        if df.shape[0] < dungeons[dungeons['Min Level'] <= player_degree].shape[0]: # 能够开启下一个地下城
            visit_on_degree = 1 # 探索次数重置为1
        else:
            visit_on_degree += 1 
print(gold_granted*100)

# L6
attribute_df = pd.read_excel('L6.xlsx', sheet_name='attribute')
opponent_df = pd.read_excel('L6.xlsx', sheet_name='opponent')

# 两位对战的玩家分别叫玩家a和玩家b，并传入对应得属性
print('请输入玩家a的职业：')
player_class_a = input()
A = attribute_df[attribute_df['Class'] == player_class_a].to_dict('records')[0]
print('请输入玩家b的职业：')
player_class_b = input()
B = attribute_df[attribute_df['Class'] == player_class_b].to_dict('records')[0]

hp_a = (60 * 50) * A['HP %']
hp_b = (60 * 50) * B['HP %']
seconds = 0
print('请输入玩家A的属性值：')
player_attribute_a = int(input())
print('请输入玩家B的属性值：')
player_attribute_b = int(input())
if A['Combat Stat'] == 'DPS':
    damage_a = player_attribute_a * A['Combat Multiplier']
    healer_a = 0
else: 
    damage_a = 0
    healer_a = player_attribute_a * A['Combat Multiplier']
if B['Combat Stat'] == 'DPS':
    damage_b = player_attribute_b * B['Combat Multiplier']
    healer_b = 0
else: 
    damage_b = 0
    healer_b = player_attribute_b * B['Combat Multiplier']

while (hp_a > 0) & (hp_b > 0):
    hp_a -= damage_b
    hp_a += healer_a
    hp_b -= damage_a
    hp_b += healer_b
    seconds += 1

print(seconds)