Python爬取链家租房信息并保存数据至本地-源码_爬取南宁链家租房信息-CSDN博客

本文链接：https://blog.csdn.net/m0_62855839/article/details/137357175

该篇文章介绍了如何使用Python的requests、parsel和BeautifulSoup库抓取链家租房网站上的房源信息，包括价格、面积、朝向等，并将数据结构化后写入CSV文件。

摘要由CSDN通过智能技术生成

import random
import requests
import parsel
import pprint
import csv
import re
from bs4 import BeautifulSoup
import time
import pymssql

f = open('house_data.csv',mode='a',encoding='utf-8',newline='')
csv_writer = csv.DictWriter(f, fieldnames=[
    '标题',
    '月租',
    '面积',
    '朝向',
    '楼层',
    '电梯',
    '车位',
    '用水',
    '用电',
    '燃气',
    '暖气',
    '详情页'
])
# 写入表头
csv_writer.writeheader()

for i in range(1,27):
    url=f'https://cd.lianjia.com/zufang/jinjiang/ab200301001000pg{i}l0/'

    user_agents =[
        'Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11',
        'Opera/9.25 (Windows NT 5.1; U; en)',
        'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)',
        'Mozilla/5.0 (compatible; Konqueror/3.5; Linux) KHTML/3.5.5 (like Gecko) (Kubuntu)',
        'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.12) Gecko/20070731 Ubuntu/dapper-security Firefox/1.5.0.12',
        'Lynx/2.8.5rel.1 libwww-FM/2.14 SSL-MM/1.4.1 GNUTLS/1.2.9',
        'Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:10.0) Gecko/20100101 Firefox/10.0',
    ]
    agent = random.choice(user_agents)
    headers = {
        'User-Agent': agent
    }

    response = requests.get(url=url,headers=headers)
    #parsel模块无法直接对字符串数据解析提取
    selector = parsel.Selector(response.text)
    #css选择器，根据标签属性内容提取对应数据
    href = selector.css('#content > div.content__article > div.content__list > div > a::attr(href)').getall()

    for index in href:
        link = "https://cd.lianjia.com"+index
        house_data = requests.get(url=link,headers=headers).text
        selector_house = parsel.Selector(house_data)
        title = selector_house.css('body > div.wrapper > div > div.content.clear.w1150 > div.top_content > div.top_left > p::text'
                                   or 'body > div.wrapper > div > div.content.clear.w1150 > p::text').get()
        price = selector_house.css('#aside > div.content__aside--title > span::text').get()
        house_info = selector_house.css('#info > ul > li::text').getall()
        area = house_info[1][3:]
        direction = house_info[2][3:]
        floor = house_info[7][3:]
        lift = house_info[8][3:]
        car = house_info[10][3:]
        water = house_info[11][3:]
        electricity = house_info[13][3:]
        gas = house_info[14][3:]
        heating = house_info[16][3:]
        info = {
            '详情页': link,
            '标题': title,
            '月租': price,
            '面积': area,
            '朝向': direction,
            '楼层': floor,
            '电梯': lift,
            '车位': car,
            '用水': water,
            '用电': electricity,
            '燃气': gas,
            '暖气': heating
        }
        # pprint.pprint(info)
        csv_writer.writerow(info)
        print(info)