This is a simple data transformation task. I don't have particular requirements on languages to use -- you can use any programming language that you choose, as long as I can run it on a PC with Windows 7 (64-bit). My computer already has Java, Perl and Python but others are acceptable too.
Your program needs to
(1) allow me to specify an input text file (a tab-delimited csv file, just like a spreadsheet with rows and columns); the format will be described below.
(2) convert it to an output, in a different format (described below), and allow me to specify the path and name of the output.
Input data format:
This dataset basically describes relationships between people, e.g. B1 gives A1 $10, B1 gives A2 $1, etc. The format is the following; please note that spaces are tabs here, for illustration; and that the actual tables are usually much larger than 4X5 (it can be, for example, 3000 by 4000); P is meaningless; and in the actual table which is tab-delimited, cells that are empty can be considered 0. A1 A2 etc. can also be different in the actual tables (but will not contain tabs in their names)
P A1 A2 A3
B1 10 1 2
B2 4 0 0
B3 0 1 2
B4 0 0 0
Desired output format
The output should still be a text file, tab delimited, but should look like this (First row is header role, and should be written)
From To Amount
B1 A1 10
B1 A2 1
B1 A3 2
B2 A1 4
B2 A2 0
B2 A3 0
B3 A1 0
B3 A2 1
B3 A3 2
B4 A1 0
B4 A2 0
B4 A3 0
This should be straightforward and I hope this can be done very quickly. Thank you.
10 freelancers are bidding on average $28 for this job
Hello, I am oracle certified professional java programmer and have [url removed, login to view], I have done many similar projects, I am ready to start now, thanks
Hi. Certainly i can do it for you with that price. I did completed 100% projects for all my employers and they are very satisfied with my result. You can check it in my profile. Hope we have a deal. Thank you!
Hi, I've vast experience in parsing text files in java and processing them. I'll be get the desired processed output that you need. Please message me so that we can discuss on this further.
Hello, I am a programmer and ready to create software for you. Please send me an example of input file for testing software. Best regards, zhsoftstudio