Hi Experts,
Can you please help me in transposing Datefield from rows to column and calculate the time difference for each of the Jobids:
Input File:
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012 12:36:26,JOB_5350
Required Output:... (6 Replies)
Gurus:
How can I transpose the output below to a format in which I can plot a graph to show VSZ memory usage by PIDs?
stdout:
Tue Jan 22 07:29:19 CUT 2013
42336296 1841272 java wilyadm
21889232 438616 jlaunch sidadm
42532994 414336 jlaunch sidadm
Tue Jan 22 07:49:20 CUT 2013... (1 Reply)
I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows:
NAME=BOB
ADDRESS=COLORADO
PET=CAT
NAME=SUSAN
ADDRESS=TEXAS
PET=BIRD
NAME=TOM
ADDRESS=UTAH
PET=DOG
I would... (7 Replies)
How to change the uploaded weekly file data to the following format?
New Well_Id,Old Well_Id,District,Thana,Date,Data,R.L,WellType,Lati.,Longi.
BAG001,PT006,BARGUNA,AMTALI,1/2/1978,1.81,2.29,Piezometer,220825,901430
BAG001,PT006,BARGUNA,AMTALI,1/9/1978,1.87,2.29,Piezometer,220825,901430... (3 Replies)
Hi I have below requirement, need help
One file contains the meta data information and other file would have the data, match the column from file1 and with file2 and extract corresponding column value and display in another file
File1:
CUSTTYPECD
COSTCENTER
FNAME
LNAME
SERVICELVL
... (1 Reply)
Dear all,
Plz let me know syntax for transposing rows into column in perl,
I am having 30 csv files which are merged into a single xls sheet.
but i want to transpose each row into column in excel sheet in each tab (1 CSV = 1tab in xls sheet)
example is as below
... (0 Replies)
Hi,
i am having an HDFS file which is comma seperated, i need to transpose from rows to column only the header columns
text.csv
cnt,name,place
1,hi,nz
2,hello,aus
I need
cnt,
name,
place
while using below command in hadoop getting the error
hadoop fs -fmt -1 text.csv (0 Replies)
hello,
I have a server that collect some performance statistics of 4 servers in the following input file :
$ cat inputfile
Time,A,Server1,KPI1,data1
Time,A,Server1,KPI2,data2
Time,A,Server1,KPI3,data3
Time,A,Server1,KPI4,data4
Time,A,Server1,KPI5,data5
Time,A,Server2,KPI1,data6... (9 Replies)
Hello Everyone,
I am very new to the world of regular expressions. I am trying to use grep/sed for the following:
Input file is something like this and there are multiple such files:
abc
1
2
3
4
5
***END***
abc
6
7
8
9
***END***
abc
10 (2 Replies)
Discussion started by: shellnewuser
2 Replies
LEARN ABOUT PLAN9
transpose
TRANSPOSE(9.1) TRANSPOSE(9.1)
NAME
rotate, transpose - re-orient an image
SYNOPSIS
fb/rotate angle [ input ]
fb/transpose [ -vhadrlui ] [ -ox y ] [ input ]
DESCRIPTION
Rotate rotates the image in its input picture file (default standard input) clockwise by angle degrees, writing the resulting picture file
on standard output.
Transpose turns its input picture file on its side by reflection through its major (descending from left to right) diagonal, writing the
resulting picture file on standard output. If no file name is given, the picture is read from standard input. Options yield all possible
symmetries of the square grid:
-d reflects the image through its descending diagonal (the default).
-a reflects the image through its ascending diagonal.
-v reflects the image left-to-right through its vertical center line.
-h inverts the image top-to-bottom through its horizontal center line.
-r rotates the image to the right (clockwise) 90 degrees.
-l rotates the image to the left (counterclockwise) 90 degrees.
-u rotates the image upside down (180 degrees).
-i identity transformation (for completeness only.)
-o x y translates by (x,y). Without -o, the input and output files have the same upper-left corner.
Transpose is particularly useful to convince programs that work on the rows of a picture file to operate on columns. For example
fb/transpose big |
fb/resample 48 |
fb/transpose |
fb/resample 48 >tiny
makes a tiny 48x48 version of a big picture.
SOURCE
/sys/src/fb/rotate.c
/sys/src/fb/transpose.c
SEE ALSO
picfile(9.6), resample(9.1)
BUGS
Very large images may not fit in memory. The result of rotate is not anti-aliased.
TRANSPOSE(9.1)