Project translated automatically. Log in or register, to view the original Core I5 2.4 11Gen, 16GBThere is a data mass, a .csv file.It consists of several columns c with arbitrary names in Latin.The number of lines 500k+.As a result, it is necessary to calculate and write into the file another three columns.S1 column, the average values of the D column, the sample for the N1 line 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: , > =

Update #1 from 4 August 2022

Core I5 2.4 11Gen, 16GBThere is a data mass, a .csv file.It consists of several columns c with arbitrary names in Latin.The number of lines 500k+.As a result, it is necessary to calculate and write into the file another three columns.S1 column, the average values of the D column, the sample for the N1 line 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: , > = Log in or register, to view the original

Update #2 from 4 August 2022

He specified the range of values and the description of the system's work, but automatically copied it all. Log in or register, to view the original

Proposals 4

Mykhailo P.

Winning proposal

123 0

Budget: 1000 UAH Deadline: 2 days

Ready to perform the task.
The speed of calculations depends greatly on the parameters n1 and n2. What are the parameters in which intervals?

Vladislav N.

284 0

Projects 282
Rating -
Rating 5 863

Budget: 1500 UAH Deadline: 2 days

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#.

Sergey Morlang

25 1

Projects 19
Rating -
Rating 366

Budget: 1000 UAH Deadline: 2 days

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.)

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 17 proposals 11:47

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 19 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 42 proposals 27 July

179 USD
Client registration and visit confirmation system (MVP)

Web Programming 162 proposals 10 July

Not specified

Sergey Petrov
Mykolaiv, Ukraine

Projects 6
Rating -
Rating 162

Sergey Petrov

Mykhailo P.

Mykhailo P.

Vladislav N.

Sergey Morlang

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client registration and visit confirmation system (MVP)