|
|
Sponsored Content
Top Forums
UNIX for Beginners Questions & Answers
Pivoting values from column to rows
Post 302995954 by drl on Saturday 15th of April 2017 07:15:27 PM
04-15-2017
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Original file we are getting .......
Item Period Amt
P1 106 1000
P1 206 1500
P1 106 2000
P2 256 5800
P2 650 7500
My output should be like this
Item 106 206 256 650 ............
P1 1000 1500 0 ... (1 Reply)
Discussion started by: dprakash
1 Replies
2. Shell Programming and Scripting
Hi Guys,
Thank you all for helping me with my different queries and I continue to get better at scripting because of help from all of you!
I have a file that would look something like -
ID SUB ID VALUE
1 10 5
2 18 7
1 ... (1 Reply)
Discussion started by: sncoupons
1 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I'm trying to assign a score to each row which will allow me to identify which rows differ. In the example file below, I've used "," to indicate column separators (my actual file has tab separators). In this example, I'd like to identify that row 1 and row 5 are the same, and row 2 and row... (4 Replies)
Discussion started by: auburn
4 Replies
4. UNIX for Dummies Questions & Answers
Could anybody help with this?
I have input below .....
david,39
david,39
emelie,40
clarissa,22
bob,42
bob,42
tim,32
bob,39
david,38
emelie,47
what i want to do is count how many names there are with different ages, so output would be like this ....
david,2
emelie,2
clarissa,1... (3 Replies)
Discussion started by: itsme999
3 Replies
5. Shell Programming and Scripting
Hi,
Please help me to convert the input file to a new one.
input file:
--------
1231231231 3 A
4561223343 0 D
1231231231 1 A
1231231231 2 A
1231231231 4 D
7654343444 2 A
4561223343 1 D
4561223343 2 D
the output should be:
--------------------
1231231231 3#1#2 A
4561223343 0 D... (3 Replies)
Discussion started by: vsachan
3 Replies
6. Shell Programming and Scripting
Here is the contents of an input file.
A,1,2,3,4
10,aaa,bbb,ccc,ddd
11,eee,fff,ggg,hhh
12,iii,jjj,lll,mmm
13,nnn,ooo,ppp
I wanted the output to be
A
10 1 aaa
10 2 bbb
10 3 ccc
10 4 ddd
11 1 eee
11 2 fff
11 3 ggg
11 4 hhh .....
and so on How to do it in ksh... (9 Replies)
Discussion started by: ksatish89
9 Replies
7. Shell Programming and Scripting
Hi All,
I have a big file with 232 columns and 9 million rows, I want to delete all rows with same column values in col3 through col232. Also the output should be sorted based on first 2 columns.
Here is a reduced example with 6 columns. I want to remove rows with duplicate values in col3... (9 Replies)
Discussion started by: alpesh
9 Replies
8. Shell Programming and Scripting
I have a .csv file:
A,B,0.6
C,D,-0.7
D,E,0.1
A,E,0.45
D,G, -0.4
I want to select rows based on the values of the 3rd columns such that it is >=0.5 or <= -0.5
Thanks.
A,B,0.6
D,G, -0.7 (1 Reply)
Discussion started by: Sanchari
1 Replies
9. Shell Programming and Scripting
Hi all ,
I have a file with the below content
Header Section
employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep
Data section ... (1 Reply)
Discussion started by: Hypesslearner
1 Replies
10. UNIX for Beginners Questions & Answers
I would like to compare values in column 8, and grep the ones where the different is > 1, columns 1 and 2 are the key for array.
Every 4 rows the records values in columns 1 and 2 changed. Then, the comparison in the column 8 need to be done for the 4 rows everytime columns 1 and 2 changed
... (4 Replies)
Discussion started by: jiam912
4 Replies
LEARN ABOUT MINIX
clog2
CLOG2(3) Linux Programmer's Manual CLOG2(3) NAME
clog2, clog2f, clog2l - base-2 logarithm of a complex number SYNOPSIS
#include <complex.h> double complex clog2(double complex z); float complex clog2f(float complex z); long double complex clog2l(long double complex z); DESCRIPTION
The call clog2(z) is equivalent to clog(z)/log(2). The other functions perform the same task for float and long double. Note that z close to zero will cause an overflow. CONFORMING TO
These function names are reserved for future use in C99. AVAILABILITY
Not yet in glibc, as at version 2.19. SEE ALSO
cabs(3), cexp(3), clog(3), clog10(3), complex(7) COLOPHON
This page is part of release 4.15 of the Linux man-pages project. A description of the project, information about reporting bugs, and the latest version of this page, can be found at https://www.kernel.org/doc/man-pages/. 2017-09-15 CLOG2(3)