I gang

Software for data format conversion

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.

Færdigheder: Java, Perl, PHP, Python, Shell Script

Se mere: software programming languages, software for c++ programming, software for computer programming, python programming software, python look for file, python computer programming language, python computer programming, programming software for pc, look for illustration, g programming language, first computer programming language, computer program languages, python programming language , programming language python, software for programming, computer programming languages, name format, data format, data file conversion, B3, python convert file csv, convert python text file, java conversion program, python input csv file, tab delimited format

Om arbejdsgiveren:
( 1 bedømmelse ) Tucson, United States

Projekt-ID: #5994994

Tildelt til:

lafor

Hi, I specialize in automated data processing projects; on my feedback page you will find many examples of similar jobs I've completed here on Freelancer. The transformation you need is very simple, indeed. I can Mere

$30 USD in 0 dage
(61 bedømmelser)
6.1

10 freelancers are bidding on average $28 for this job

gangabass

Hi, I can create such program for you in less than a day and I can offer you best price here. I'm talking about Perl program which will read input tab separated file and generate another tab separated file with out Mere

$30 USD på 1 dag
(226 bedømmelser)
6.4
wbslivera

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

$28 USD in 0 dage
(94 bedømmelser)
5.7
gokulanand

Hello, I can get this task done in Excel using VBA ( if you have a the input file as a csv or tsv format which can be opened n excel ). Or I can also get this done using Java. Which ever you prefer, I am fine with i Mere

$25 USD in 0 dage
(33 bedømmelser)
5.2
cungthehung

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!

$30 USD på 1 dag
(12 bedømmelser)
3.5
adyuthindia

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.

$25 USD på 1 dag
(5 bedømmelser)
3.4
zhsoftstudio

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

$25 USD på 1 dag
(4 bedømmelser)
2.8
priyamehtag

I can complete the task quickly. I am interested to develop it in Java (Core) if it is fine for you.

$30 USD in 0 dage
(2 bedømmelser)
1.5
wentie727

Hi, I think I can finish this project in short time, and the result will satisfy you. Please contact me, if you are glad to hire me. Thank you.

$30 USD på 1 dag
(8 bedømmelser)
1.6
Gavin0123

Hello , I'm Gavin , good at programming and logic . This is easy, so I can do it quickly . If can , I will use java , thanks .

$25 USD in 2 dage
(0 bedømmelser)
0.0