Processing of data mass .csv
22 USD S2 column, the average values of the D column, the sample for the N2 lines
The resulting column Z is filled according to the conditions and formulas:
If the condition1 [S1+S2>10] and the condition2 [S1*D>k/6-30] are met
Z = D, otherwise Z = empty
where S1, S2, D is the value of the corresponding columns, k is the coefficient.How it should look in the ideal (screen):
_________________________
Dialogue window with the selection of the file.The input window of the values N1=[ ], N2=[ ], k=[ ]
The window of assignment to the variable columns: [name of the column] = [variable]
Optional to:
The window of entry of the conditions values1: [left part] [mark =] [right part]
The entrance window of the value of the condition2: [operator before the condition2: and/or] [left part] [mark =] [right part]
The entrance window of the values of the condition 3: [to take into account the condition] [operator before the condition 3: and/or] [left part] [mark =] [right part]
The entrance window of the values of the condition4: [not the condition] [operator before the condition4: I/O] [left part] [mark =] [right part]
Formulas 3 and 4 will be taken into account in individual cases, mainly the formulas 1 and 2 are taken into account.
- in the left and right part of the conditions can be indicated: numbers, scraps, signs (+-/*) and values of columns in the form of variables (S1, S2, A, B, C, D, E)
Sign between the parts: , > =
S2 column, the average values of the D column, the sample for the N2 lines
The resulting column Z is filled according to the conditions and formulas:
If the condition1 [S1+S2>10] and the condition2 [S1*D>k/6-30] are met
Z = D, otherwise Z = empty
where S1, S2, D is the value of the corresponding columns, k is the coefficient.Value range N1 and N2 - up to 2000
How it should look in the ideal (screen):
_________________________
Dialogue window with the selection of the file.The input window of the values N1=[ ], N2=[ ], k=[ ]
The window of assignment to the variable columns: [name of the column] = [variable]
Optional to:
The window of entry of the conditions values1: [left part] [mark =] [right part]
The entrance window of the value of the condition2: [operator before the condition2: and/or] [left part] [mark =] [right part]
The entrance window of the values of the condition 3: [to take into account the condition] [operator before the condition 3: and/or] [left part] [mark =] [right part]
The entrance window of the values of the condition4: [not the condition] [operator before the condition4: I/O] [left part] [mark =] [right part]
Formulas 3 and 4 will be taken into account in individual cases, mainly the formulas 1 and 2 are taken into account.
- in the left and right part of the conditions can be indicated: numbers, scraps, signs (+-/*) and values of columns in the form of variables (S1, S2, A, B, C, D, E)
Sign between the parts: , > =
Железо Core I5 2,4 11Gen, 16Gb.
Есть массив данных, файл .csv. Состоит из нескольких столбцов c произвольными названиями латиницей. Количество строк 500к+.
В результате необходимо рассчитать и дописать в файл еще три столбца.
Столбец S1, cкользящая средняя значений столбца D, выборка за N1 строк
Столбец S2, cкользящая средняя значений столбца D, выборка за N2 строк
Результирующий столбец Z, заполняется по условиям и формулам:
Если условие1 [S1+S2>10] И условие2 [S1*D>k/6-30] соблюдаются
то Z=D, иначе Z=пусто
где S1,S2,D - значение соответствующих столбцов, k - коэффициент.
Диапазон значений N1 и N2 - до 2000
Как это должно выглядеть в идеале (скрин):
_____________
Диалоговое окно с выбором файла.
Окно ввода значений N1=[ ], N2=[ ], k=[ ]
Окно присвоения переменных столбцам: [название столбца] = [переменная]
Опционно:
Окно ввода значений условия1: [левая часть] [знак <>=] [правая часть]
Окно ввода значений условия2: [оператор перед условием2: И/ИЛИ] [левая часть] [знак <>=] [правая часть]
Окно ввода значений условия3: [учитывать ли условие] [оператор перед условием3: И/ИЛИ] [левая часть] [знак <>=] [правая часть]
Окно ввода значений условия4: [учитывать ли условие] [оператор перед условием4: И/ИЛИ] [левая часть] [знак <>=] [правая часть]
- формулы 3 и 4 будут учитываться в отдельных случаях, в основном учитываются формулы 1 и 2, галочка выбора
- в левой и правой части условий можно указывать: цифры, скобки, знаки (+-/*) и значения столбцов в виде переменных (S1, S2, A,B,C,D,E)
- знак между частями: <, >, >=, <=
кнопка "Заполнить"
________________
Это идеальный вариант. По умолчанию рассматриваем базовый вариант.
В базовом варианте условия можно редактировать и дополнять в коде - не проблема, это делается редко.
Цель задания: После введения значений N1, N2, k и названий переменных столбцов, нажатия кнопки "Заполнить" система рассчитывает и записывает данные в столбцы S1, S2, Z.
Основное требование: выполнение вычислений и заполнения файла с 500к строк в течении нескольких (2-3) минут, очень желательно одной минуты.
Как должна работать система: файл предназначен для другой программы, в ней идет визуализация данных и анализ. После анализа корректируются N1, N2, k, после файл пересчитывается, перезаписывается, подгружается и снова визуализация и анализ. И так циклически много раз. Поэтому кроме того что быстро, должно быть удобно.
Проект интересует в базе. Но если опционная часть не сильно удорожит, то тоже нужно.
Язык написания не принципиален.
Уточнил диапазон значений и описание работы системы, но машинально скопировал все.
Applications 2
Client's review of cooperation with Mykhailo P.
Processing of data mass .csvFast, clearly, all about the matter. Everything was done as you wanted, even in a larger amount.
I recommend it.
Freelancer's review of cooperation with Sergey Petrov
Processing of data mass .csvThe customer is serious about the preparation of the TZ!
constantly in contact.
Operatively checked the work.
I will be happy to cooperate again.
-
Winning proposal2 days22 USD
4159 123 0 Winning proposal2 days22 USD
Ready to perform the task.
The speed of calculations depends greatly on the parameters n1 and n2. What are the parameters in which intervals?
-
2 days33 USD
6055 284 0 2 days33 USD
Good day . I can write a program under Windows, it will work very quickly. Oriented, less than 1 minute with the record in the file. The price is indicated for the basic option. It will be written in C#.
-
2 days22 USD
366 25 1 2 days22 USD
Hello to you. Ready to write on the c# WinForms application using PostgreSQL.
On my iron (i5-2520m / 8 Gb) the calculation of a simple sliding average of 1 million double values was 21 ms. With a record in the file for less than a second.
There is also experience in developing a parser of mathematical formulas (scouts, compositions, readings, etc.)
Current freelance projects in the category Databases & SQL
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 1 day 5 hours back ∙ 10 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 1 day 16 hours back ∙ 4 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 2 days 4 hours back ∙ 40 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 4 days 23 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
603 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 7 days 3 hours back ∙ 59 proposals |
Mykolaiv