Analysis of orders and what they buy first and how often
44 USDThere is a file with a list of orders by xls customers - 14 thousand records, they have a unique customer_id.Date and time in the column date_created.There is a product item NMID.The goods are divided by brand.It is necessary to determine:
1 .For those buyers who made more than 2 purchases (only with a time difference over 24 hours), which product was the first in the series of purchases, and how many times this item was the first.in the form of a table.In the framework of brand (brand)
2ndFor each item to extract the amount of goods in one order of this item (one order, this order made within 24 hours.12 hours ago or 12 hours ahead.In the form of a frequency table in %.For example art.21059767 bought by 1st - 95%, by 2st - 5%, by 3st - 5%.ThreeBetween which brands the buyers cross (% and the number of people who buy the same brand)
4 .If the brands cross, then which brand they bought first.( one ofThe order is a order made within 24 hours.12 hours ago or 12 hours ahead.
As a result, a script/project/file is issued that allows you to repeat the procedure with our data again and again.Any BD/language/software software.
Нужно проанализировать файл с заказами покупателей и выяснит какой продукт покупают первым и как часто
Есть файл со списком заказов по клиентам xls - 14 тысяч записей, у них уникальный customer_id. Дата и время заказа в колонке date_created. Есть артикул товара nmid. Товары разделены по brand.
Нужно определить:
1. Для тех покупателей, которые сделали более 2 покупок (только с разницей во времени более 24 часов), какой продукт был первым в серии покупок, и сколько раз этот артикул был первым.
В виде таблице. В рамках бренда (brand)
2. По каждому артикулу вывести количество товаров в одном заказе этого артикула (один заказ, это заказ сделанный в течение 24 часов. То есть 12 часов назад или 12 часов вперед). В виде таблицы частотности в %. Например арт. 21059767 купили по 1шт - 95%, по 2шт-5%, по 3шт-5%.
3. Между какими брендами пересекаются покупатели (% и количество людей которые покупают и тот и тот бренд)
4. Если бренды пересекаются, то какой бренд купили первым.(один заказ, это заказ сделанный в течение 24 часов. То есть 12 часов назад или 12 часов вперед)
В результате выдается скрип/проект/файл который позволяет повторять процедуру с нашими данными вновь и вновь.
Любая БД/язык/программное обеспечение.
Applications 1
-
1484 55 2 1 Hello to you,
I can write a program for order analysis and reporting.
Здравствуйте,
смогу написать программу для анализа заказов и формирования отчётов.
-
1710 109 0 Hello Andrei.
I can provide the necessary analysis with the help of scripts and summary tables.
Write to Ls, we will discuss the details.
Здравствуйте, Андрей.
Могу предоставить необходимый анализ с помощью скриптов и сводных таблиц.
Пишите в лс, обсудим детали.
-
563 14 1 Hello Andrei !
I read TZ. I am ready to implement this project in Python. Write in the face!
Здравствуйте, Андрей!
Прочитал ТЗ. Готов реализовать этот проект на языке Python. Пишите в личку!
Current freelance projects in the category Databases
Development of database architecture
503 USD
Database Architecture Development Description: We are looking for an experienced database architect to conduct an analysis of our current database architecture and develop recommendations for its improvement. Our goal is to optimize performance, ensure scalability, and enhance… Databases ∙ 1 proposal |
Data analysis and fundamentals of artificial intelligence in PythonHello, I am looking for a freelancer with knowledge of Python and libraries for data visualization (matplotlib, seaborn, etc.), as well as knowledge of data science, data analysis, basics of artificial intelligence (and a bit of higher mathematics). All of this is at a basic… Python, Databases ∙ 1 proposal |
Data table formatting and RFM analysis1. The CRM table of all customer orders has been exported. It needs to be formatted in such a way that it becomes convenient for reading and working. The following columns should be included: customer (full name), phone number, total number of orders, date of the last order,… Databases, Data processing ∙ 6 proposals |
Set up the transmission of the array rro_info in payments from the WordPress website
25 USD
Implement the transfer of the rro_info array via API in order to fiscalize payments using the LiqPay payment aggregator. A mandatory condition for fiscalization is the presence of data on the goods for which the payment is made. To transfer data on goods in the Liqpay request… Databases, Web programming ∙ 1 proposal |
Online store improvement!!! Please, experience with OpenCart 3 of 3 years !!! 1. **Performance optimization:** - Identification and elimination of performance bottlenecks in the store, such as slow database queries, inefficient algorithms, etc. 2. **Development and implementation of new… Databases, Web programming ∙ 1 proposal |