Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak
  1. Freelancers

Oleksandr A.

Offer Oleksandr work on your next project.

Ukraine Odessa, Ukraine
7 months 17 days back
Available for hire available for hire
on the service 3 years
Freelancer Oleksandr A. — Ukraine, Odessa. Core skill — Python, Databases & SQL

Rating

Successful projects
No data
Average rating
No data
Rating
159
Python
1439 place out of 4464
Databases & SQL
402 place out of 1205

Language proficiency level

Українська Українська: fluent

Skills and abilities

Programming

Portfolio


  • Парсинг даних з різних джерел за допомогою багатопотоковості

    Python
    Парсинг даних з різних джерел за допомогою багатопотоковості — example of freelancer's portfolio work in category Python
    A brief description of the code:

    The necessary libraries are imported: OS to work with the operating system, Pandas to work with data in the form of tables, and concurrent.futures to implement parallel execution flows.Features are imported from different modules (e.g., alko_run, bradasua_run, and so on) that carry out data parsing from the corresponding sources.The run_all_parsers() function is determined, which uses the flow pool to perform parallel parsing functions.A list of futures is created, in which each element represents the launch of the corresponding parsing function in a separate stream.The function concurrent.futures.wait() is called, which expects the completion of all the flows from the futures list.Then the result_dir directory is determined, where the parsing results are expected in the form of Excel files.This is a dataframe result.For each file in the result_dir directory, the Excel file is read using pd.read_excel() and the received data is aggregated using pd.concat() in the DataFrame result.Check that the result is not empty.If so, the results are stored in the Excel file all_product.xlsx.

    … Therefore, this code carries out parsing data from several sources at the same time using multi-flow, and then collects results into one general Excel file if parsing results have been obtained.

  • Телеграм-бот для вирішування проблем у фотографів

    Python
    Телеграм-бот для вирішування проблем у фотографів — example of freelancer's portfolio work in category Python
    Telegram-bot that helps users solve problems associated with different locations.The basic functionality of the bot includes:

    The Google Spreadsheets:

    … The bot gets access to Google Spreadsheets and records information about users and their problems in the indicated table.Working with the database:

    The bot will count and verify user data in the CSV file.It also saves and updates user information in a JSON file.Processing of commands and messages from users:

    Processing the /start command or the first user entrance to the bot.Ask the user to share the contact.Check the user in the list.Choosing the city and the location where the problem arose.Processing of the location and reflection of problems:

    After choosing the location, the bot suggests to select the problem from the list.Interaction with the user for a deeper disclosure of the problem:

    The bot displays a specific problem and provides the option to choose the user’s subsequent actions, such as “Help” or “Scribe to Admin”.Information in Google Spreadsheets:

    After the user processing is completed, the bot saves the information in the specified Google Spreadsheets.Starting the BOT:

    After the processing is completed, the bot can be restarted for the start of a new discussion.#telegram-bot #telebot #Python3 #GoogleSheets #pandas #json

  • Freelancer Agregator

    Python
    Freelancer Agregator — example of freelancer's portfolio work in category Python
    A site that pars sites for freelance orders and collects everything in one database, allowing users to search for work according to certain criteria. On the site you can also create your own personal office and track new orders according to your wishes. The project used such technologies as #python #html #css #flask #sqlite #bs4 #flask_bcrypt.

  • Gas prices on the site cegh.at

    Python
    Gas prices on the site cegh.at — example of freelancer's portfolio work in category Python
    It is based on a function that accepts query parameters and column index for data extract. The code itets the list of query parameters, calls the function and records the received values in the CSV file.

Activity

  Latest proposals 2
Parsing product cards from the website
18 USD
Adding goods to the site, parsing
11 USD