I have four TSV files like this:
file_1:
abc \t 1
def \t 3
ghi \t 5
file_2:
abc \t 10
def \t 4
ghi \t 7
file_3:
abc \t 8
def \t 5
ghi \t 1
file_4:
abc \t 4
def \t 2
ghi \t 1
I want to combine those TSV files into the one TSV like this:
dataset \t file_1 \t file_2 \t file_3 \t file_4
abc \t 1 \t 10 \t 8 \t 4
def \t 3 \t 4 \t 5 \t 2
ghi \t 5 \t 7 \t 1 \t 1
How I can get that?
I have thousands data like this:
abc_1
abc_2
abc_3
abc_4
def_1
def_2
def_3
ghi_1
ghi_2
I want to filter it to get only data with the highest number which is abc_4, def_3, ghi_2.
How I can get it?
I have TSV file like this:
abc_1
def_2
ghi_3
jkl_4
mno_5
I want to split that in to the:
abc
def
ghi
jkl
mno
and
1
2
3
4
5
How I can get that?