Converting a single col into mutiple rows (GNUPLOT file)

Question

I'm trying to make a gnuplot picture from a file, have a problem with the distribution of 'data.txt' file. The actual distribution is :

The first line makes reference to the number of lines that i want, and the other colums make reference to the x and y axis.

I'm trying two approximations to make the picture without success:

Use some gnuplot function to sketch the picture using the actual distribution that my file have. I have not found this command.
Make a bash script to convert the actual file into another with the correct distribution

4 x1 x3 x5 16 x2 x4 x6

I haven't understood yet what you need the first column for. In your example I could deduce the desired output just using the second and third columns. Is your example too symmetric? — Marcus Rickert
– Marcus Rickert, Commented Dec 17, 2013 at 13:18

glenn jackman · Accepted Answer · 2013-12-17 14:46:16Z

1

Addressing #2

awk '{a[$2] = a[$2] $3 " "} END {for (i in a) print i, a[i]}' file

4 x1 x3 x5
16 x2 x4 x6

answered Dec 17, 2013 at 14:46

glenn jackman

249k42 gold badges233 silver badges362 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1