06-29-2015
No problem. So what I intend to do is layout a grid to know the "genotype" (2nd column) for each "well" (4th column) against the "plate" (5th column)
As I mentioned before, I have started doing it in excel
I have used awk/sed a couple of times before as one liner functions to delete columns, replace values
For "plate" I mean the last column which has thirteen variables ranging from 1 to 11.1
The file has approx 4000 rows. So the unique values for the last column, ie "plates" will always be 13 variables, in the range 1 to 11.1 and for the "wells" will always be 384 variables ranging from A01-A24, B01-B24, C01-C24.... to P01-P24.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I have a file in the below format....
<A>
B
C
<A>
E
F
<A>
G
H
I need the result file to be:
<A>BC
<A>EF
<A>GH (3 Replies)
Discussion started by: new_ds_man
3 Replies
2. Shell Programming and Scripting
Hello all,
I want to transpose the rows of a file to the columns (every characters include spaces), i.e.:
input:
abcdefg
123 456
output:
a1
b2
c3
d
e4
f5
g6
I wrote a script:
#!/bin/csh -f (15 Replies)
Discussion started by: heavenfish
15 Replies
3. Shell Programming and Scripting
Hi ALL
I have one input file say FILE1 which looks as below.
a=1
b=2
c=3
a=4
b=5
c=6
.
.
.
Here a,b,c...etc are variable names.
The output file(FILE2) should look like
1,2,3
4,5,6
.....
..... (5 Replies)
Discussion started by: 46019
5 Replies
4. Shell Programming and Scripting
Hi I have an input file and I want to transpose it but I need to take care that if any field is missing for a record it should be popoulated with space for that field - using a shell script
INFILE
----------
emp=1
sal=2
loc=abc
emp=2
sal=21
sal=22
loc=xyz
emp=5
loc=abc
OUTFILE... (10 Replies)
Discussion started by: 46019
10 Replies
5. Shell Programming and Scripting
input
IndID ID1 ID2 ID3
a1 a/a b/b c/c
a2 a/a b/b c/c
a3 a/b b/b c/d
a6 a/b b/b c/e
a8 a/a b/c c/e
a9 b/b b/d c/e
output
IDName IndID IDtype C_No
ID1 a1 a/a 1
ID1 a2 a/a 1
ID1 a8 ... (1 Reply)
Discussion started by: stateperl
1 Replies
6. Shell Programming and Scripting
Hello,
I have a text file which is like a matrix m rows and n columns. Now I want to convert it into n rows and m columns.
Thanks for hint. (1 Reply)
Discussion started by: zhshqzyc
1 Replies
7. Shell Programming and Scripting
Hi,
I have a file like this
a b c
d e f
g h i
j k l
Case1:
I want to transpose the whole file
Output1
a d g j
b e h k
c f i l
Case2
Transpose a specific column - Say 3rd (6 Replies)
Discussion started by: jacobs.smith
6 Replies
8. Shell Programming and Scripting
Hi Friends,
I have a file with a structure like this:
<file1.csv>
field1,field2,field3,field4,field5,field6,field7,field8,field9,field10,field11,field12
Few Salient points on the file's structure
(1)The fields from field1 to field6 is fixed and they would always be present in the file... (2 Replies)
Discussion started by: mehimadri12
2 Replies
9. UNIX for Dummies Questions & Answers
Have various files like this:
InSlot=0x00000001
InPort=0x00000000
Inref=0x0000002f
InSID=0x00000001
OutSlot=0x00000001
OutPort=0x00000002
Outref=0x00000000
OutSID=0x0000000b
OutUName_2=14
InSlot=0x00000001
InPort=0x00000000
Inref=0x000001a8
InSID=0x00000001
OutSlot=0x00000001... (5 Replies)
Discussion started by: K@rlos
5 Replies
10. Shell Programming and Scripting
Hello,
I have a text file with 148 rows and 2532691 columns. I need to transpose the data. The command that I am using is
awk '
{
for (i=1; i<=NF; i++) {
a = $i
}
}
NF>p { p = NF }
END {
for(j=1; j<=p; j++) {
str=a
for(i=2; i<=NR; i++){
... (6 Replies)
Discussion started by: nans
6 Replies
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
ENVIRONMENT
The COLUMNS, LANG, LC_ALL and LC_CTYPE environment variables affect the execution of column as described in environ(7).
EXIT STATUS
The column utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ;
printf "HH:MM/YEAR NAME
" ;
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BUGS
Input lines are limited to LINE_MAX (2048) bytes in length.
BSD
July 29, 2004 BSD