python处理字典之表格-城市排行榜

# 中国城市排行榜
import xlrd
book=xlrd.open_workbook('city_data.xls')
sheet=book.sheet_by_index(0)
main_data_list=[]
for row in range(3,sheet.nrows):
    temp_dict={}
    # print(sheet.row_values(row))
    temp_dict["城市"]=sheet.row_values(row)[0]
    temp_dict["2019GDP"] = sheet.row_values(row)[1]
    temp_dict["2018总人口"] = sheet.row_values(row)[2]
    temp_dict["2018平均房价"] = sheet.row_values(row)[3]
    temp_dict["2018平均工资"] = sheet.row_values(row)[4]
    temp_dict["地铁总里程"] = sheet.row_values(row)[5]
    temp_dict["高效数量"] = sheet.row_values(row)[6]
    temp_dict["三甲医院"] = sheet.row_values(row)[7]
    temp_dict["小学数量"] = sheet.row_values(row)[8]
    main_data_list.append(temp_dict)
    # print(main_data_dic)
for i_list in range(len(main_data_list)):
    main_data_list[i_list]['原榜单得分']=len(main_data_list)-i_list
print("城市原榜得分从高到低：")
for j_list in range(len(main_data_list)):
    print(main_data_list[j_list]["城市"],main_data_list[j_list]['原榜单得分'])
print('='*80)

for i in range(len(main_data_list)):
    main_data_list[i]['收入房价比']=format(main_data_list[i]['2018平均工资&