功能一：
得到某个属性的全部角色，将其封装在class中
"""各元素角色信息：一对多"""
from pandas import DataFrame, Series
import pandas as pd
import numpy as np
class FindType:
# 自动执行，将传入参数赋值给私有属性self.Attribute
def __init__(self, attribute):
self.Attribute = attribute
def find_type(self):
role_things = pd.read_excel("C:/Users/YHT/Desktop/项目/原神各属性角色信息.xlsx", header=0, index_col=0)
# 补全
role_things = role_things.fillna(axis=0, method="ffill")
# 按照"属性"这一列的信息，将所有数据重新分组，得到一个字典
things_list = role_things.groupby("属性").groups
return role_things.loc[things_list[self.Attribute]]
功能二：
定向查找某个角色信息，传入参数为该角色的名称
"""查找对应角色：一对一"""
from pandas import DataFrame, Series
import pandas as pd
import numpy as np
class FindRole:
def __init__(self, role_name):
self.role_name = role_name
def findrole(self):
role_things = pd.read_excel("C:/Users/YHT/Desktop/项目/原神各属性角色信息.xlsx", header=0, index_col=0)
# 将属性所包含的nan，进行填充
role_things = role_things.fillna(axis=0, method="ffill")
print(role_things)
print()
all_name = role_things["角色"]
print(all_name)
num = 0
for x in all_name:
if x == self.role_name:
return_role = role_things.loc[:, "角色":]
print(return_role.iloc[num])
Attribute = return_role.iloc[num]["属性"]
Name = return_role.iloc[num]["角色"]
Hp = return_role.iloc[num]["生命值"]
Def = return_role.iloc[num]["防御力"]
Atk = return_role.iloc[num]["攻击力"]
Break = return_role.iloc[num]["突破加成"]
print(Name, Attribute, Hp, Def, Atk, Break)
num += 1
功能三：
设置对应参数，筛选角色
比如，要找出生命值高于10000，防御力高于270，攻击力高于300的角色
"""设置限制参数，查找对应角色：多对多"""
from pandas import DataFrame, Series
import pandas as pd
import numpy as np
class Num:
def __init__(self, Hp, Def, Atk):
self.Hp = Hp
self.Def = Def
self.Atk = Atk
def num(self):
role_things = pd.read_excel("C:/Users/YHT/Desktop/项目/原神各属性角色信息.xlsx", header=0, index_col=0)
role_things = role_things.fillna(axis=0, method="ffill")
if self.Hp is None:
if self.Def is None:
if self.Atk is None:
print(role_things)
else:
return_things = role_things.loc[role_things["攻击力"] > self.Atk]
print(return_things)
else:
if self.Atk is None:
return_things = role_things.loc[role_things["防御力"] > self.Def]
print(return_things)
else:
return_things = role_things.loc[
(role_things["防御力"] > self.Def) & (role_things["攻击力"] > self.Atk)]
print(return_things)
else:
if self.Def is None:
if self.Atk is None:
return_things = role_things.loc[role_things["生命值"] > self.Hp]
print(return_things)
else:
return_things = role_things.loc[
(role_things["生命值"] > self.Hp) & (role_things["攻击力"] > self.Atk)]
print(return_things)
else:
if self.Atk is None:
return_things = role_things.loc[
(role_things["生命值"] > self.Hp) & (role_things["防御力"] > self.Def)]
print(return_things)
else:
return_things = role_things.loc[
(role_things["生命值"] > self.Hp) & (role_things["防御力"] > self.Def) & (
role_things["攻击力"] > self.Atk)]
print(return_things)
功能四：
按照某一参数，将角色顺序重新排列
例如，按照生命值大小，将所有角色重新排列
"""按照某一参数重新排序：一对多"""
from pandas import DataFrame, Series
import pandas as pd
import numpy as np
class Sort:
def __init__(self, input_x):
self.input_x = input_x
def sort(self):
type_bool = True
role_things = pd.read_excel("C:/Users/YHT/Desktop/项目/原神各属性角色信息.xlsx", header=0, index_col=0)
role_things = role_things.fillna(axis=0, method="ffill")
return_things = role_things.sort_values(by=self.input_x, ascending=type_bool, axis=0)
print(return_things)
