第八章代码运行不了 about data_science_tool_book_code HOT 2 OPEN

race_list=excel_content.iloc[0,:][1:][::3].tolist()
# print(excel_content.iloc[0,:][1:][::3])
# print(excel_content.head())

# race_list=(excel_content.ix[1:,::3]).values.tolist()
# print((excel_content.ix[1:,::3]).values.tolist())
# print((excel_content.ix[0:1,::3]))

# for m in race_list:
#     print (m.decode('utf-8'))
# print(race_list)
# print(excel_content.iloc[:,0])
age_list=map(lambda x:str(x).replace(' ',''),excel_content.iloc[:,0][2:].tolist())
# for m in age_list:
#     print(m.decode('utf-8')) 
# print(age_list)
excel_content=pd.read_excel('A0201.xls',skiprows=4)
# print(excel_content)

# r_dict=OrderedDict()
# for i,j in excel_content.iloc[:,[4,5,6]].to_dict().items():
#     new_v_dict=OrderedDict()
#     for vi,vj in j.items():
#         # print(vi,vj)
#         new_v_dict[age_list[int(vi)]]=vj
#     r_dict[i.split('.',1)[0]]=new_v_dict
# # print(new_v_dict)
# print(json.dumps(r_dict,ensure_ascii=False,indent=4))


def get_number(lines):
    ret_dict=OrderedDict()
    # print(lines.to_dict())
    for k,v in lines.to_dict('dict').items():
        
        new_v_dict=OrderedDict()
        for vk,vv in v.items():
            new_v_dict[age_list[int(vk)]]=vv
        ret_dict[k.split('.',1)[0]]=new_v_dict
    return ret_dict

result_dict=OrderedDict()
for i,x in enumerate(range(1,178,3)):
    ids=[x,x+1,x+2]
    # print(ids)
    race_list[i]=race_list[i].replace(' ','')
    # print(race_list[i])
    result_dict[str(race_list[i])]=get_number(excel_content.iloc[:,ids])
# print (race_list[1])
# for k,v in result_dict.items():
#     print(k,v)

return result_dict

#将json数据写入到.json文件中
with open("record.json","w") as f:
    f.write(json.dumps(read_data(),ensure_ascii=False,indent=4))