The Power Query
How to solve such a task in Excel, Power query or Python:
You need to add the column "group" and place the group numbers on the basis of the data in the column "cluster".
Applications 1
-
1 day9 USD
1115 109 0 1 day9 USD
Good day . I write a script on VBA to process the Excel file. Write to Ls, I'll do it quickly.
-
1 day9 USD
137 1 0 1 day9 USD
I have more than 10 years of experience in Excel, I will do everything quickly and quality.
-
1 day11 USD
2864 72 0 1 day11 USD
Macro VBA or formulas of the letter. Makros is a formula. Formulas are simpler (200-300 UAH), but not so universal. And the formulas load the file if the data is too much.
The price is more accurate after the task
from Excel in 2008.
-
1 day11 USD
419 13 0 1 day11 USD
Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
За яким алгоритмом зі значень колонки cluster можна отримати значення колонки group?
-
Яка логіка одержання номера групи? Від чого він залежить?
-
Номери автоматично проставити для group.
Приклад
45527356 : 1093,
1666012405 : [1093, 710],31481062 : 710
це все одна група тому що:
перший рядок має значення 1093 таке значення є в другому рядкудругий рядок має ще значення 710 таке значення є в третьому рядку
третій рядок має звязок з першим через значення в другому рядку -
Як правильно?
1. Група закінчується, коли в рядку нижче немає ні одного значення cruster, яке є в цій групі (група - нерозривний діапазон рядків)
2. До групи належать всі id, в яких можна знайти один або декілька cruster із групи ("розірвані" діапазони - в групу входять рядки, які можуть знаходитись між рядками других груп )
-
Рішення є для будь-якого варіанту, але треба чітко розуміти задачу.
-
Current freelance projects in the category Data Processing
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 2 days 11 hours back ∙ 17 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 3 days 3 hours back ∙ 10 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 5 days 3 hours back ∙ 21 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 5 days 3 hours back ∙ 19 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 7 days 12 hours back ∙ 14 proposals |
Kyiv