mirror of
https://github.com/kristoferssolo/School.git
synced 2025-10-21 20:10:38 +00:00
130 lines
4.6 KiB
Python
130 lines
4.6 KiB
Python
# Author - Kristiāns Francis Cagulis
|
|
# Date - 07.12.2021
|
|
# Title - Patstāvīgais darbs "SS.com scraping"
|
|
|
|
from bs4 import BeautifulSoup
|
|
import requests
|
|
import pandas as pd
|
|
from PIL import Image
|
|
from io import BytesIO
|
|
from openpyxl.styles import Font, Alignment
|
|
import openpyxl
|
|
|
|
HEADERS = {
|
|
"User-Agent": 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.97 Safari/537.36 Vivaldi/4.1.2369.21'}
|
|
|
|
|
|
class SS:
|
|
def __init__(self, url):
|
|
self.url = url
|
|
|
|
def _get_page_amount(self):
|
|
page = requests.get(self.url, headers=HEADERS)
|
|
soup = BeautifulSoup(page.content, 'html.parser')
|
|
|
|
last_url = soup.find(class_='td2').findChild('a')['href']
|
|
page_amount = last_url[last_url.find(
|
|
"page") + 4:last_url.find(".html")]
|
|
print(f"Page amount = {page_amount}")
|
|
|
|
return int(page_amount)
|
|
|
|
def get_data(self):
|
|
items = []
|
|
images = []
|
|
item_no = 1
|
|
for page_number in range(1, self._get_page_amount() + 1):
|
|
url = self.url + f"/page{page_number}.html"
|
|
|
|
page = requests.get(url, headers=HEADERS)
|
|
soup = BeautifulSoup(page.content, 'html.parser')
|
|
|
|
# item ids
|
|
ids = [tag['id']
|
|
for tag in soup.select('tr[id]')] # creates list with ids
|
|
# removes "tr_bnr" elements from list
|
|
ids = [x for x in ids if "tr_bnr" not in x]
|
|
ids.remove("head_line") # removes first "head_line" id
|
|
print(f"Page {page_number}")
|
|
|
|
# getting item data
|
|
for el in soup.find_all(id=ids):
|
|
print(f"Item {item_no}")
|
|
item_no += 1
|
|
|
|
# image
|
|
image_url = el.find(class_='msga2').find_next_sibling().findChild(
|
|
'a').findChild('img')['src'] # gets image url
|
|
response = requests.get(image_url)
|
|
img = Image.open(BytesIO(response.content))
|
|
images.append(img)
|
|
print(img)
|
|
for elem in el.find_all(class_='msga2-o pp6'):
|
|
items.append(elem.get_text())
|
|
|
|
# adverts url
|
|
item_url = el.findChild(class_='msg2').findChild(
|
|
'div').findChild('a')['href'] # gets url
|
|
item_url = "https://www.ss.com" + item_url
|
|
item_page = requests.get(item_url, headers=HEADERS)
|
|
item_soup = BeautifulSoup(item_page.content, 'html.parser')
|
|
|
|
# adverts full text
|
|
item_text = item_soup.find(
|
|
id='msg_div_msg').get_text() # gets full text
|
|
# removes text last part (table)
|
|
item_text = item_text[:item_text.find("Pilsēta:")]
|
|
items.append(item_text)
|
|
|
|
# adverts publication date
|
|
# gets all 'msg_footer' class'
|
|
item_date = item_soup.find_all('td', class_='msg_footer')
|
|
item_date = item_date[2].get_text() # extracts 3rd element
|
|
items.append(item_date[8:18]) # crops date
|
|
|
|
chunk_size = 8
|
|
# combines each 'chunk_size' elements into array
|
|
chunked_items_list = [items[i:i + chunk_size]
|
|
for i in range(0, len(items), chunk_size)]
|
|
columns = ["Atrašanās vieta", "Istabu skaits", "Kvadratūra", "Stāvs",
|
|
"Sērija", "Cena", "Pilns sludinājuma teksts", "Izvietošanas datums"]
|
|
df = pd.DataFrame(chunked_items_list, columns=columns)
|
|
df.to_excel(excel_writer='output.xlsx', index=False)
|
|
|
|
wb = openpyxl.load_workbook("output.xlsx")
|
|
ws = wb.worksheets[0]
|
|
sheet = wb.active
|
|
|
|
# 'I1' cell setup
|
|
ws['I1'] = "Attēli"
|
|
ws['I1'].font = Font(bold=True)
|
|
ws["I1"].alignment = Alignment(horizontal='center', vertical='top')
|
|
|
|
# sets cell width
|
|
sheet.column_dimensions['A'].width = 20
|
|
sheet.column_dimensions['G'].width = 50
|
|
sheet.column_dimensions['H'].width = 20
|
|
sheet.column_dimensions['I'].width = 13
|
|
|
|
for i in range(len(images)):
|
|
sheet.row_dimensions[i + 2].height = 51 # sets cell height
|
|
# enables word wrap
|
|
ws[f'G{i + 2}'].alignment = Alignment(wrap_text=True)
|
|
|
|
img = openpyxl.drawing.image.Image(images[i])
|
|
ws.add_image(img, f"I{i + 2}") # adds images
|
|
wb.save("output.xlsx")
|
|
print("Done")
|
|
|
|
|
|
flats = SS("https://www.ss.com/lv/real-estate/flats/riga/all/sell/")
|
|
flats2 = SS("https://www.ss.com/lv/real-estate/flats/riga-region/all/sell/")
|
|
|
|
|
|
def main():
|
|
flats.get_data()
|
|
|
|
|
|
if __name__ == '__main__':
|
|
main()
|