Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Transposing column to row, joining with another file, then sorting columns

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Transposing column to row, joining with another file, then sorting columns
# 1  
Old 10-02-2009
Data Transposing column to row, joining with another file, then sorting columns
Hello!
I am very new to Linux and I do not know where to begin...

I have a column with >64,000 elements (that are not in numberical order) like this:

name
2
5
9
.
.
.
64,000

I would like to transpose this column into a row that will later become the header of a very large file (>1000 rows X >64,000 columns) so that the row looks like:

name 2 5 9 . . . 64,000

Next I need to concatenate this header with the actual data file (data points are letters) so that:

name 2 5 9 . . .64,000
jim A C A . . .T
max T G A . . .T
mary T C T . . .A
.
.
.
kate A C A . . .A

Finally, I need to sort the columns so that they are in numerical order but the name column remains in the first position so that

name 1 2 3 . . .64,000
jim A A A . . .G
max C T A . . .C
mary C T T . . .C
.
.
.
kate A A T . . .G

Can anyone help me with this?

Thanks,
doob
# 2  
Old 10-02-2009
Code:
{
 tr '\n' ' ' < file1 ## name 2 5 9 ...
 echo
 sort -k2 < file2 ## data file
} > newfile

# 3  
Old 10-02-2009
Computer Thanks!
Thanks cfajohnson!!!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk split columns to row after N number of column

I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end Source file will have 001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C Need Output from every 5 tab and remove the comma from end of each row ... (4 Replies)
Discussion started by: ranjancom2000
4 Replies

2. UNIX for Beginners Questions & Answers

Copy columns from one file into another and get sum of column values and row count

I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv abc.csv- UTF-8,,,,,,,,,,,,,,,,,,,,,,,,, ... (6 Replies)
Discussion started by: Tahir_M
6 Replies

3. Shell Programming and Scripting

Joining files using awk not extracting all columns from File 2

Hello All I'm joining two files using Awk by Left outer join on the file 1 File 1 1 AA 2 BB 3 CC 4 DD File 2 1 IND 100 200 300 2 AUS 400 500 600 5 USA 700 800 900 (18 Replies)
Discussion started by: venkat_reddy
18 Replies

4. Shell Programming and Scripting

Convert row to columns start from nth column

Dear All, We have input like this: 161 57 1378 176 1392 262 1444 441 1548 538 1611 670 1684 241 57 1378 208 1393 269 1447 444 1549 538 1610 677 1700 321 ... (4 Replies)
Discussion started by: attila
4 Replies

5. UNIX for Dummies Questions & Answers

File joining and sorting

Hi, I'm having some trouble joining these two files for some reason. Here is what they look like: head * I'm using: join -a 1 -1 2 -2 1 f1 f2 -t, > joinfile.out but unfortunately nothing is happening. I did notice that I was having trouble sorting f1 and I'm not sure why using:... (6 Replies)
Discussion started by: verse123
6 Replies

6. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies

7. Shell Programming and Scripting

Help newbie: transposing column into row (pivot)

Hi, I have a file in this format. Name | organization John | INT Abby| DOM John | DOM John | MIX Jason | INT Anna | DOM Abby |MIX I want the output to look this. Name | organization John | INT, DOM, MIX Abby | DOM, MIX Jason | INT Anna | DOM (5 Replies)
Discussion started by: sirrtuan
5 Replies

8. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

9. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Hi Friends I have the following input data in 2 columns. SNo 1 I1 Value I2 Value I3 Value SNo 2 I4 Value I5 Value I6 Value I7 Value SNo 3 I8 Value I9 Value ............... ................ SNo N (1 Reply)
Discussion started by: ks_reddy
1 Replies

10. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like... (9 Replies)
Discussion started by: aYankeeFan
9 Replies
Login or Register to Ask a Question