index	name	col_1	col_2	col_3	col_4	col_5
1	name_1	6.55903	0	0	0	3.44097
2	name_2	6.73342	0	4.45826	0	5.80832
3	name_3	6.7876	0	9.04868	0	8.16372
4	name_4	7.07704	0	2.06362	-0.6363	0.6673
5	name_5	0	13.15	0	10.4517	3.39833

#! /bin/sh

# assumes that the input file has a header row
# assumes that the first column is the index and the second column is a name
# assumes that all columns after the first two contain data

# input file name
input_file=$1
# output file name
output_file=$2

awk ' NR>1 { split($0, line_array, "\t");
             id=line_array[1];
             name=line_array[2];
             delete line_array[1];
             delete line_array[2];
             asort(line_array);
             for(x in line_array) {
                if(line_array[x] != 0) { print id "\t" name "\t" line_array[x];  break; }
             }
             delete line_array;
           }' $input_file > $output_file

1	name_1	3.44097
2	name_2	4.45826
3	name_3	6.7876
4	name_4	-0.6363
5	name_5	3.39833