To transpose rows to column in hadoop

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to transpose pieces of data in a column to multiple rows?

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. UNIX for Beginners Questions & Answers

Transpose rows to certain columns

Hello, I have the following data and I want to use awk to transpose each value to a certain column , so in case the value is not available the column should be empty. Example: Box Name: BoxA Weight: 1 Length :2 Depth :3 Color: red Box Name: BoxB Weight: 3 Length :4 Color: Yellow...

3. Shell Programming and Scripting

Linux - Transpose rows into column

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...

4. Shell Programming and Scripting

Peel syntax for transpose rows into column

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 ...

5. Shell Programming and Scripting

Transpose multiple rows (with a mix of space and enter) to a single column

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...

6. Shell Programming and Scripting

Transpose Column of Data to Rows

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. Shell Programming and Scripting

awk to transpose preceding row to 1st column of next rows

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...

8. Shell Programming and Scripting

Transpose Datefield from rows to column + Print time diff

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:...

9. Shell Programming and Scripting

awk transpose rows to column

Need to transpose in awk rows to column like this: input: A1,6,5,4 3,2,1, A2,8,7,9,10,11,12,13,14 A3,1,2,3,5,7,8,9 A4,9,4,8,1,5,3, output: A1,1 A1,2 A1,4 ... A2,7 A2,8 ... A3,1 A3,2 ... A4,1 A4,3

10. Shell Programming and Scripting

Transpose Rows

Hi, Am trying to transpose a set of rows into a set of comma separated values. For eg. if the output of ps -ef | tail +2 | awk 'BEGIN{ FS=" " } { print $2 }' is 0 1 3 4 I need to transpose it to - '0','1','3','4' Am currently trying -

LEARN ABOUT DEBIAN

tk::table

Table(3pm)						User Contributed Perl Documentation						Table(3pm)

NAME

       Tk::Table - Scrollable 2 dimensional table of Tk widgets

SYNOPSIS

	 use Tk::Table;

	 $table = $parent->Table(-rows => number,
				 -columns => number,
				 -scrollbars => anchor,
				 -fixedrows => number,
				 -fixedcolumns => number,
				 -takefocus => boolean);

	 $widget = $table->Button(...);

	 $old = $table->put($row,$col,$widget);
	 $old = $table->put($row,$col,"Text");	# simple Label
	 $widget = $table->get($row,$col);

	 $cols = $table->totalColumns;
	 $rows = $table->totalRows;

	 $table->see($widget);
	 $table->see($row,$col);

	 ($row,$col) = $table->Posn($widget);

DESCRIPTION

       Tk::Table is an all-perl widget/geometry manager which allows a two dimensional table of arbitary perl/Tk widgets to be displayed.

       Entries in the Table are simply ordinary perl/Tk widgets. They should be created with the Table as their parent. Widgets are positioned in
       the table using:

	$table->put($row,$col,$widget)

       If $widget is not a reference it is treated as a string, and a Lable widget is created with the string as its text.

       All the widgets in each column are set to the same width - the requested width of the widest widget in the column.  Likewise, all the
       widgets in each row are set to the same height - the requested height of the tallest widget in the column.

       A number of rows and/or columns can be marked as 'fixed' - and so can serve as 'headings' for the remainder the rows which are scrollable.

       The requested size of the table as a whole is such that the number of rows specified by -rows (default 10), and number of columns specified
       by -columns (default 10) can be displayed.

       If the Table is told it can take the keyboard focus then cursor and scroll keys scroll the displayed widgets.

       The Table will create and manage its own scrollbars if requested via -scrollbars.

       The table can be emptied using

	$table->clear

       the widgets which were in the table are destroyed.

       The Tk::Table widget is derived from a Tk::Frame, so inherits all its configure options.

BUGS 
/ Snags / Possible enhancements
       o   Very large Tables consume a lot of X windows.

       o   No equivalent of pack's -anchor/-pad etc. options

SEE ALSO

       Tk::grid, Tk::HList, Tk::TableMatrix, Tk::MListbox, Tk::Columns

perl v5.14.2							    2010-05-29								Table(3pm)

Programming