读取配置表中 loc与iloc的慎用
loc可筛选同名index
iloc只能指定某位置index, 毕竟位置不能重名
所以
loc
dict_configuration = {}
for i in pd.ExcelFile(str_addr_configuration).sheet_names:
df_configuration_i = pd.read_excel(str_addr_configuration, sheet_name=i, index_col="name").astype(str)
for j in df_configuration_i.index:
dict_configuration[j] = df_configuration_i.loc[j, "value"]
iloc
dict_configuration = {}
for i in pd.ExcelFile(str_addr_configuration).sheet_names:
df_configuration_i = pd.read_excel(str_addr_configuration, sheet_name=i, index_col='name').astype(str) # 统一格式为字符串
for j in range(df_configuration_i.shape[0]):
str_index = df_configuration_i.index[j]
dict_configuration[str_index] = df_configuration_i.iloc[j, 0]