Sponsored Content
Top Forums Shell Programming and Scripting Transpose matrix based on second column using awk Post 302934738 by RavinderSingh13 on Tuesday 10th of February 2015 08:26:16 AM
Old 02-10-2015
Hello quincyjones,

Could you please try following and let us know if this helps.
Code:
awk '{X[$1];Y[$2];Z[$1,$2]=$3}
END{
printf "%20s",""; for(i in X) printf "%10s",i;print "";
for(j in Y) {printf "%10s",j;printf "%10s",""
for(i in X) printf "%10s",Z[i,j];print "";}
}' Input_file

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

two-column data to matrix in AWK

Howdy, I need to convert an association data matrix, currently in a two-column format, into a matrix with numbers indicating the number of associations. I've been looking around for AWK code in the list, but could not find anything. Here's an example of what I want to perform: original... (10 Replies)
Discussion started by: sramirez
10 Replies

2. Shell Programming and Scripting

awk: Transpose csv row to column.

Hello, am I new to awk, and I am tryint to: INPUT FILE: "73423555","73423556","73423557","73423558","73423559" OUTPUT FILE: 73423555 73423556 73423557 73423558 73423559 My useless code so far: #!/bin/awk -F ',' BEGIN { i=0; } (8 Replies)
Discussion started by: drbiloukos
8 Replies

3. 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 (5 Replies)
Discussion started by: sdf
5 Replies

4. Shell Programming and Scripting

awk transpose row into 2 field column

Need to transpose every 2 fields of a row into a single 2 field column. input 4 135 114 76 217 30 346 110 5 185 115 45 218 85 347 125 6 85 116 130 220 65 352 95 11 30 117 55 221 42 355 75 16 72 118 55 224 37 357 430 17 30 119 55 225 40 358 62 21 52 120 65 232 480 360 180 ....... (8 Replies)
Discussion started by: sdf
8 Replies

5. Shell Programming and Scripting

Matrix transpose

Hello to everyone! I'm pretty tired and I cannot concentrate properly, but I need some help!!! I have a matrix like the one in the attachment (matrice_prova) and I would like an output like this: L1 L1 0.0 L1 L2 2.1 L1 L3 3.1 L1 L4 3.2 .... How is it possible do that in Perl or Awk?? Any... (3 Replies)
Discussion started by: gabrysfe
3 Replies

6. Shell Programming and Scripting

3 column .csv --> correlation matrix; awk, perl?

Greetings, salutations. I have a 3 column csv file with ~13 million rows and I would like to generate a correlation matrix. Interestingly, you all previously provided a solution to the inverse of this problem. Thread title: "awk? adjacency matrix to adjacency list / correlation matrix to list"... (6 Replies)
Discussion started by: R3353
6 Replies

7. Shell Programming and Scripting

Transpose timestamp based on column values and calculate time difference

Hello Expert, I need to transpose Date-Timestamp based on same column values and calculate time difference. The input file would be as below and required output is mentioned in the bottom INPUT File ======== 08/23/2012 12:36:09 JOB_5340 08/23/2012 12:36:14 JOB_5340 08/23/2012... (2 Replies)
Discussion started by: asnandhakumar
2 Replies

8. 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... (1 Reply)
Discussion started by: ux4me
1 Replies

9. Shell Programming and Scripting

Transpose column to row - awk

Hi there, I have a small csv file example below: source,cu_001,cu_001_volume,cu_001_mass,cu_002,cu_002_volume,cu_002_mass,cu_003,cu_003_volume,cu_003_mass ja116,1.33,3024000,9374400,1.54,3026200,9375123,1.98,3028000,9385512 I want to transpose columns to rows starting at the second... (3 Replies)
Discussion started by: theflamingmoe
3 Replies

10. Shell Programming and Scripting

awk transpose column to row and sort

I am trying to awk the output from below output for each port: i need separate line with comma source file Output required (3 Replies)
Discussion started by: ranjancom2000
3 Replies
SPRINTF(3)								 1								SPRINTF(3)

sprintf - Return a formatted string

SYNOPSIS
string sprintf (string $format, [mixed $args], [mixed $...]) DESCRIPTION
Returns a string produced according to the formatting string $format. PARAMETERS
o $format - The format string is composed of zero or more directives: ordinary characters (excluding %) that are copied directly to the result, and conversion specifications, each of which results in fetching its own parameter. This applies to both sprintf(3) and printf(3). Each conversion specification consists of a percent sign ( %), followed by one or more of these elements, in order: o An optional sign specifier that forces a sign (- or +) to be used on a number. By default, only the - sign is used on a number if it's negative. This specifier forces positive numbers to have the + sign attached as well, and was added in PHP 4.3.0. o An optional padding specifier that says what character will be used for padding the results to the right string size. This may be a space character or a 0 (zero character). The default is to pad with spaces. An alternate padding character can be specified by prefixing it with a single quote ( '). See the examples below. o An optional alignment specifier that says if the result should be left-justified or right-justified. The default is right-justified; a - character here will make it left-justified. o An optional number, a width specifier that says how many characters (minimum) this conversion should result in. o An optional precision specifier in the form of a period ( .) followed by an optional decimal digit string that says how many decimal digits should be displayed for floating-point numbers. When using this specifier on a string, it acts as a cutoff point, setting a maximum character limit to the string. Additionally, the character to use when padding a number may optionally be specified between the period and the digit. o A type specifier that says what type the argument data should be treated as. Possible types: o % - a literal percent character. No argument is required. o b - the argument is treated as an integer, and presented as a binary number. o c - the argument is treated as an integer, and presented as the character with that ASCII value. o d - the argument is treated as an integer, and presented as a (signed) decimal number. o e - the argument is treated as scientific notation (e.g. 1.2e+2). The precision specifier stands for the number of digits after the decimal point since PHP 5.2.1. In earlier versions, it was taken as number of significant digits (one less). o E - like %e but uses uppercase letter (e.g. 1.2E+2). o f - the argument is treated as a float, and presented as a floating-point number (locale aware). o F - the argument is treated as a float, and presented as a floating-point number (non-locale aware). Available since PHP 4.3.10 and PHP 5.0.3. o g - shorter of %e and %f. o G - shorter of %E and %f. o o - the argument is treated as an integer, and presented as an octal number. o s - the argument is treated as and presented as a string. o u - the argument is treated as an integer, and presented as an unsigned decimal number. o x - the argument is treated as an integer and presented as a hexadecimal number (with lowercase letters). o X - the argument is treated as an integer and presented as a hexadecimal number (with uppercase letters). Variables will be co-erced to a suitable type for the specifier: Type Handling +--------+---------------------+ | Type | | | | | | | Specifiers | | | | +--------+---------------------+ | | | |string | | | | | | | | | | s | | | | | | | |integer | | | | | | | | | | d, u, c, o, x, X, b | | | | | | | |double | | | | | | | | | | g, G, e, E, f, F | | | | +--------+---------------------+ Warning Attempting to use a combination of the string and width specifiers with character sets that require more than one byte per character may result in unexpected results The format string supports argument numbering/swapping. Here is an example: Example #1 Argument swapping <?php $num = 5; $location = 'tree'; $format = 'There are %d monkeys in the %s'; echo sprintf($format, $num, $location); ?> This will output "There are 5 monkeys in the tree". But imagine we are creating a format string in a separate file, commonly because we would like to internationalize it and we rewrite it as: Example #2 Argument swapping <?php $format = 'The %s contains %d monkeys'; echo sprintf($format, $num, $location); ?> We now have a problem. The order of the placeholders in the format string does not match the order of the arguments in the code. We would like to leave the code as is and simply indicate in the format string which arguments the placeholders refer to. We would write the format string like this instead: Example #3 Argument swapping <?php $format = 'The %2$s contains %1$d monkeys'; echo sprintf($format, $num, $location); ?> An added benefit here is that you can repeat the placeholders without adding more arguments in the code. For example: Example #4 Argument swapping <?php $format = 'The %2$s contains %1$d monkeys. That's a nice %2$s full of %1$d monkeys.'; echo sprintf($format, $num, $location); ?> When using argument swapping, the n$ position specifier must come immediately after the percent sign ( %), before any other speci- fiers, as shown in the example below. Example #5 Specifying padding character <?php echo sprintf("%'.9d ", 123); echo sprintf("%'.09d ", 123); ?> The above example will output: 000000123 Example #6 Position specifier with other specifiers <?php $format = 'The %2$s contains %1$04d monkeys'; echo sprintf($format, $num, $location); ?> The above example will output: The tree contains 0005 monkeys Note Attempting to use a position specifier greater than PHP_INT_MAX will result in sprintf(3) generating warnings. Warning The c type specifier ignores padding and width o $args - o $... - RETURN VALUES
Returns a string produced according to the formatting string $format. EXAMPLES
Example #7 printf(3): various examples <?php $n = 43951789; $u = -43951789; $c = 65; // ASCII 65 is 'A' // notice the double %%, this prints a literal '%' character printf("%%b = '%b' ", $n); // binary representation printf("%%c = '%c' ", $c); // print the ascii character, same as chr() function printf("%%d = '%d' ", $n); // standard integer representation printf("%%e = '%e' ", $n); // scientific notation printf("%%u = '%u' ", $n); // unsigned integer representation of a positive integer printf("%%u = '%u' ", $u); // unsigned integer representation of a negative integer printf("%%f = '%f' ", $n); // floating point representation printf("%%o = '%o' ", $n); // octal representation printf("%%s = '%s' ", $n); // string representation printf("%%x = '%x' ", $n); // hexadecimal representation (lower-case) printf("%%X = '%X' ", $n); // hexadecimal representation (upper-case) printf("%%+d = '%+d' ", $n); // sign specifier on a positive integer printf("%%+d = '%+d' ", $u); // sign specifier on a negative integer ?> The above example will output: %b = '10100111101010011010101101' %c = 'A' %d = '43951789' %e = '4.39518e+7' %u = '43951789' %u = '4251015507' %f = '43951789.000000' %o = '247523255' %s = '43951789' %x = '29ea6ad' %X = '29EA6AD' %+d = '+43951789' %+d = '-43951789' Example #8 printf(3): string specifiers <?php $s = 'monkey'; $t = 'many monkeys'; printf("[%s] ", $s); // standard string output printf("[%10s] ", $s); // right-justification with spaces printf("[%-10s] ", $s); // left-justification with spaces printf("[%010s] ", $s); // zero-padding works on strings too printf("[%'#10s] ", $s); // use the custom padding character '#' printf("[%10.10s] ", $t); // left-justification but with a cutoff of 10 characters ?> The above example will output: [monkey] [ monkey] [monkey ] [0000monkey] [####monkey] [many monke] Example #9 sprintf(3): zero-padded integers <?php $isodate = sprintf("%04d-%02d-%02d", $year, $month, $day); ?> Example #10 sprintf(3): formatting currency <?php $money1 = 68.75; $money2 = 54.35; $money = $money1 + $money2; // echo $money will output "123.1"; $formatted = sprintf("%01.2f", $money); // echo $formatted will output "123.10" ?> Example #11 sprintf(3): scientific notation <?php $number = 362525200; echo sprintf("%.3e", $number); // outputs 3.625e+8 ?> SEE ALSO
printf(3), sscanf(3), fscanf(3), vsprintf(3), number_format(3). PHP Documentation Group SPRINTF(3)
All times are GMT -4. The time now is 02:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy