买房指南，链家最近房源

本是古典何须时尚 2021-11-10 07:44 145阅读 0赞

# coding=utf-8
    
    """
    Author: nieliangcai
    version: 0.1
    
    date: 2019/7/29 11:30
    """
    
    import requests_html
    import xlwt
    import time
    
    now_time = time.strftime("%Y%m%d%H%M")
    session = requests_html.HTMLSession()
    
    
    House_List = ["海棠馨苑","馨浦苑","欣沁苑","欣乐苑","瑞和明庭","平安小区","景家堰","西林南路51号"]
    
    def write_house_data(table_info,title="地区房价%s.xls" %now_time):
    
        file = xlwt.Workbook()
    
        for i in range(len(table_info)):
    
            address = table_info[i][0]
            Values = table_info[i][1]
    
            table = file.add_sheet(address)
            title_list = ['Title','house_info','height','total_price','unit_price']
            for i in range(5):
                table.write(0,i,title_list[i])
    
        # print(Values)
            for i in range(len(Values)):
                for j in range(len(Values[i])):
                        # print(Values[i][j])
                        table.write(i+1,j,Values[i][j])
        file.save(title)
    
    all_house = []
    for house in House_List:
        URL = "https://sh.lianjia.com/ershoufang/rs%s/" %house
        res = session.get(URL)
        title_all = res.html.find(".title>a")   #获取标题信息
        house_info_all = res.html.find(".houseInfo")    #房源信息
        position_Info_all = res.html.find(".positionInfo")  #位置
        totalPrice = res.html.find(".totalPrice")   #总价
        unitPrice = res.html.find(".unitPrice")     #单价
    
        list_house = []
        for i in range(len(title_all)):
            list_house.append([title_all[i].text,house_info_all[i].text,position_Info_all[i].text,totalPrice[i].text,unitPrice[i].text])
        all_house.append(list_house)
    # print(House_List,all_house)
    zipped = list(zip(House_List,all_house))
    # print(zipped)
    write_house_data(zipped)

转载于:https://www.cnblogs.com/nieliangcai/p/11263581.html