This project was successfully completed by hbxfnzwpf for $136 USD in a day.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In1 day
I need the project completed in 24 hours.
The programming project is on a task part of a research project. I have an excel file (MASTER FILE) with observations on thousands of entries (UNITS). For each entry I have an identifier code (ID) and a list of variables (POINTS). Each UNIT has at least two POINTS. An example is :
ID POINT1 POINT 2 POINT 3 POINT 4
1 101 102 103
2 102 104 105 101
3 105 101 102
I need a program that automates the following procedures for the thousands of UNITS.
STEP 1: For each UNIT, I need to create all possible combinations of POINTS. For the above example, the combinations will be for ID # 1:
101-101 , 101-102 , 101-103 , 102-101 , 102-102, 102-103 , 103-101 , 103-102 , 103-103
STEP 2: I have an excel file (USE FILE) with a list of all possible combinations and a corresponding value for the combination.
The file looks like this:
101 101 0.5
101 102 [url removed, login to view]
101 103 0
102 101 [url removed, login to view]
102 102 [url removed, login to view]
I need to compare the created combinations of POINTS from the master file (STEP 1) with the values in the use file. If the average of values of points combinations (X-Y) and (Y-X) is above 0.1, then I want the newly created output file (OUTPUT) to write the combination, otherwise the combination is not included in the output file. For example,
101-102 has a value of [url removed, login to view] and 102-101 has 0.22. The average of the two is [url removed, login to view] which is above the threshold of 0.1. The combinations 101 102 and 102 101 will be written in the output file. The output file MUST be a text file that has the combinations in two columns. As example is:
So for each Unit or ID we will have a txt file.
STEP 3: A publically available program or algorithm uses the OUTPUT file in STEP 2 above as an input to calculate a certain value (INDEX). The program is an .exe file that uses the runs in windows like the command prompt (black screen with questions to be answered by typing the answers). The first question is to enter the name of the input file (the OUTPUT from step 2 above). IMPORTANT: The extension of the input file used (OUTPUT) must be changed from .txt to .dat. The next two questions ask about specific numbers that will be identical. I will provide you with these numbers. The program then runs and stops automatically once it is finished. The results are stored in a dat file named "[url removed, login to view]". IMPORTANT: each time the program runs, the results are stored in a file with the same name "[url removed, login to view]" if the program ran in the same folder previously, the newly created file will overwrite the existing file.
The result file "[url removed, login to view]" is a text file that includes information , the important is written in last line. An example of a results file is:
1 4 7 5 2 [url removed, login to view] [url removed, login to view] [url removed, login to view] --- 4 2 1 3
2 10 16 15 1 [url removed, login to view] [url removed, login to view] [url removed, login to view] --- 100 6 9 8 10 5 11 12 7 13
4 4 6 5 1 [url removed, login to view] [url removed, login to view] [url removed, login to view] --- 23 21 22 20
# Modularity = [url removed, login to view]
The important information is the modularity INDEX, 0.505487. I need to run the program for each and every UNIT or ID (thousands).
STEP 4: For each UNIT or ID, I need to read the # modularity (INDEX) and write it back to the original file (MASTER FILE) or a new file as long as the ID is retained so I can identify the UNIT. The target file should look like this:
1 [url removed, login to view]
2 [url removed, login to view]
3 [url removed, login to view]
Step 5: I want to repeat the steps above with a small change in STEP 2. Instead of calculating the average of values of two point combinations now, I simply want to take each pair of points by itself and keep it if its value is above 0.1.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online