Написать простой парсер на Python с выгрузкой в MySQL таблицу.
5 USDЕсть таблица в MySQL куда вбиты урлы (с сайта hotline).
Подключаемся к БД и проходим все строки таблицы:
- получаем урл
- заходим на этот урл (например https://hotline.ua/computer-besprovodnoe-oborudovanie/ubiquiti-unifi-ac-pro-ap-uap-ac-pro/ )
- берём там 3 цены - максимальную, минимальную, и высчитываем среднюю ([сумма всех предложений] / [количество предложений] )
- обновляем данные в таблице
- обновляем дату парсинга
- next n
Нюансы:
- защита хотлайна, как минимум нужно поставить задержку парсинга
- есть список магазинов, предложения которых не нужно учитывать (дам массив)
- если магазин Rozetka - то нужно проверять кто продавец
-
162 4 0 Доброе утро!
Готов взяться. Пишите в Телеграмм Lanfir договоримся
Current freelance projects in the category Python
AI Commenting Platform for TikTok and Instagram.Project Goal Develop a system that allows managing a large number of TikTok and Instagram accounts and automatically posting relevant comments under selected videos using AI. Main Functionality1. Account Management It is necessary to implement the ability to connect accounts:… AI & Machine Learning, Python ∙ 9 hours 25 minutes back ∙ 11 proposals |
Build a customer classification model1. There is client data in Mongo/SQL (approximately 20,000 entries with raw data). 2. It is necessary to build features and a classification model of clients into behavioral groups based on this data. 3. The project should be completed in Python. AI & Machine Learning, Python ∙ 2 days 3 hours back ∙ 33 proposals |
IT Automation of VAT Reporting
223 USD
It is necessary to develop a system for automating the transfer of sales data from the CRM to the accounting system Wafeq. The system should import bank and payment reports, automatically reconcile payments with invoices, generate invoices for VAT reporting, and minimize manual… AI & Machine Learning, Python ∙ 2 days 9 hours back ∙ 43 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 2 days 21 hours back ∙ 42 proposals |
Automatic video posting on social media according to a scheduleTechnical Assignment (TA) Automatic video publication on social media according to a scheduleProject Description A script/bot (Python preferred, or any other solution of your choice — the main thing is stability and ease of maintenance) is needed, which automatically publishes… Python, Bot Development ∙ 3 days 9 hours back ∙ 59 proposals |