10-26-2012
Could you please double check your data and the script you're using?
This User Gave Thanks to radoulov For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Can we transpose rows to columns? Fields within row are separated by a comma. (10 Replies)
Discussion started by: videsh77
10 Replies
2. Shell Programming and Scripting
I have seen many posts to transpose rows into columns, but not for multiple rows to columns..so please help me how to do this..
I have around 1000 rows and 1000 columns, i want to transpose it..
A1 A2 A3
B1 B2 B3
C1 C2 C3
D1 D2 D3
I want output to be like
A1 B1 C1 D1
A2 B2 C2 D2... (5 Replies)
Discussion started by: ganeshss
5 Replies
3. Shell Programming and Scripting
Hi i have a file which has values seperated by "," as shown below and I want to transpose for every doc_id in one row.
Input:
DOC_ID,KEYWORD
105,REGISTROS
105,GEOLOGIA
105,NUCLEOS
105,EXPEDIENTE
105,PROGRAMAS
10025,EXPEDIENTE
10025,LOCALIZACIONES
10025,OFICIOS
10025,PROGRAMAS... (4 Replies)
Discussion started by: juelillo
4 Replies
4. UNIX for Dummies Questions & Answers
Hi there,
Below is sample three rows which i need transpose into multiple rows.
By keeping first 2 fields static and split them into multiple rows depend following date field. Each into seperate rows.
Sample code:
... (6 Replies)
Discussion started by: ganeshd
6 Replies
5. Shell Programming and Scripting
Hi Folks,
Iam a kinda newbie to unix shell scripting, the scenario is i have a text file containing the following info
Charlie chicago 15
Charlie newyork 26
jonny chicago 14
jonny newyork 15
joe chicago 15
joe newyork 18output should be
Name chicago ... (3 Replies)
Discussion started by: tech_frk
3 Replies
6. Shell Programming and Scripting
Hi All,
In shell, I have below data coming from some some text file as below:
. 351706 5861.8 0.026 0.012 12.584 0.026 0.012 12.582 0.000 0.000 0.000
Now i need the above data to be transposed as below
351706... (16 Replies)
Discussion started by: Anamica
16 Replies
7. Shell Programming and Scripting
I'm using the testawk.awk from the following thread
https://www.unix.com/shell-programming-and-scripting/18897-row-column-transpose.htmlI'm getting the following output
fieldname1 data1
fieldname2 data2
fieldname3 data3
How can I get like this instead
1 fieldname1 data1
2 fieldname2 data2... (1 Reply)
Discussion started by: makkan
1 Replies
8. Shell Programming and Scripting
Gents
Using the attached file
and using this code.
awk '{print substr($0,4,2)}' input.txt | sort -k1n | awk '{a++}END{for(i in a) print i,a}' | sort -k1 > output
i got the this output.
00 739
01 807
02 840
03 735
04 782
05 850
06 754
07 295
08 388
09 670
10 669
11 762 (8 Replies)
Discussion started by: jiam912
8 Replies
9. UNIX for Beginners Questions & Answers
Hi all,
I have a data file. It contains one header line followed by a new line which is one row of different characters without separators (charahters can be dots, dash, capital and small letters). What I need is ignoring header line to transpose these characters so they form a column. So, from... (4 Replies)
Discussion started by: kush
4 Replies
10. Shell Programming and Scripting
Hello guys,
First of all happy holidays and happy new year.
I'm new in bioinformatic and also it is my first time that I write in this forum. Therefore, sorry if I make some mistakes.
I'm writing to ask your help to fix a problem:
I have a file like this:
gene1 GO:0016491|GO:0055114... (8 Replies)
Discussion started by: Salvatore_espos
8 Replies
LEARN ABOUT CENTOS
spi_modifytuple
SPI_MODIFYTUPLE(3) PostgreSQL 9.2.7 Documentation SPI_MODIFYTUPLE(3)
NAME
SPI_modifytuple - create a row by replacing selected fields of a given row
SYNOPSIS
HeapTuple SPI_modifytuple(Relation rel, HeapTuple row, int ncols,
int * colnum, Datum * values, const char * nulls)
DESCRIPTION
SPI_modifytuple creates a new row by substituting new values for selected columns, copying the original row's columns at other positions.
The input row is not modified.
ARGUMENTS
Relation rel
Used only as the source of the row descriptor for the row. (Passing a relation rather than a row descriptor is a misfeature.)
HeapTuple row
row to be modified
int ncols
number of column numbers in the array colnum
int * colnum
array of the numbers of the columns that are to be changed (column numbers start at 1)
Datum * values
new values for the specified columns
const char * Nulls
which new values are null, if any (see SPI_execute_plan for the format)
RETURN VALUE
new row with modifications, allocated in the upper executor context; NULL only if row is NULL
On error, SPI_result is set as follows:
SPI_ERROR_ARGUMENT
if rel is NULL, or if row is NULL, or if ncols is less than or equal to 0, or if colnum is NULL, or if values is NULL.
SPI_ERROR_NOATTRIBUTE
if colnum contains an invalid column number (less than or equal to 0 or greater than the number of column in row)
PostgreSQL 9.2.7 2014-02-17 SPI_MODIFYTUPLE(3)