Написать простой парсер на Python с выгрузкой в MySQL таблицу.
5 USDЕсть таблица в MySQL куда вбиты урлы (с сайта hotline).
Подключаемся к БД и проходим все строки таблицы:
- получаем урл
- заходим на этот урл (например https://hotline.ua/computer-besprovodnoe-oborudovanie/ubiquiti-unifi-ac-pro-ap-uap-ac-pro/ )
- берём там 3 цены - максимальную, минимальную, и высчитываем среднюю ([сумма всех предложений] / [количество предложений] )
- обновляем данные в таблице
- обновляем дату парсинга
- next n
Нюансы:
- защита хотлайна, как минимум нужно поставить задержку парсинга
- есть список магазинов, предложения которых не нужно учитывать (дам массив)
- если магазин Rozetka - то нужно проверять кто продавец
-
182 4 0 Доброе утро!
Готов взяться. Пишите в Телеграмм Lanfir договоримся
Current freelance projects in the category Python
Technical Specification for Refinement of AI Bot for Generating Personalized SongsTECHNICAL TASK FOR IMPROVING THE AI PERSONAL SONG GENERATOR BOTMAIN GOAL Create a stable premium product that: generates the highest quality personal songs; does not fabricate facts about the client; works stably under load; is easily scalable; allows for analysis and… Python, Bot Development ∙ 26 minutes back ∙ 2 proposals |
Excel Specialist / Process Automation (Excel + preferably programming)We are looking for a specialist with ADVANCED knowledge of Excel to optimize the existing file and automate processes. It will be a great advantage if you also have programming skills / VBA / Power Query / Power Automate or experience in creating complex logic in Excel. Project… Python, Databases & SQL ∙ 3 hours 25 minutes back ∙ 22 proposals |
Automation of processes through API and PythonBelow I described the current process and the result I would like to achieve. I also attach files of the real process to better understand how it looks in reality Current process Currently, the entire process is performed manually: uploading/downloading files, transferring… AI & Machine Learning, Python ∙ 4 hours 26 minutes back ∙ 29 proposals |
A bot needs to be created in Telegram for subscription payment.
45 USD
A bot needs to be created in Telegram where users can subscribe for access to the webcams located in the yard. Organize payment for two types of subscriptions (monthly and daily) in the bot. The bot should automatically check the payment and then provide access links. Python, Bot Development ∙ 17 hours 12 minutes back ∙ 71 proposals |
Parsing and classification of a large array of imagesIt is necessary to implement a project for collecting and structuring a large array of architectural images from open web sources.The task includes: automated collection of images; uploading files in the highest available quality; classification of images by categories:… Python, Data Parsing ∙ 1 day back ∙ 30 proposals |