04-23-2010
How to sum rows in e.g. column 1 by a category in e.g. column 2
Hi,
I've shown an example of what I would like to achieve below. In the example file, I would like to sum the values in column 2 for each distinct category in column 3 (presumably making an array?) and print the sum as well as the category name and length (note:length always corresponds with name). In case it matters, the actual file is huge with many rows and columns. Any notes on what the commands do would also be fantastic if anyone has time to do this.
Thanks!!
example input file:
coord,value,name,length
1,2,alpha,4
2,4,alpha,4
3,5,alpha,4
4,0,alpha,4
5,0,beta,5
6,12,beta,5
7,2,beta,5
8,5,beta,5
9,3,beta,5
10,13,gamma,3
11,3,gamma,3
12,0,gamma,3
request output file:
value_sum,name,length
11,alpha,4
22,beta,5
16,gamma,3
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi All,
I have the following input which i want to process using AWK.
Rows,NC,amount
1,1202,0.192387
2,1201,0.111111
3,1201,0.123456
i want the following output
count of rows = 3 ,sum of amount = 0.426954
Many thanks (2 Replies)
Discussion started by: pistachio
2 Replies
2. Shell Programming and Scripting
Dear All,
I have a data file input.csv like below. (Only five column shown here for example.)
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
3,2,4,5,6
5,3,5,5,6
From this I want the below output
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies
3. Shell Programming and Scripting
I have a following inputfile
MT,AP,CDM,TTML,MUM,GS,SUCC,3
MT,AP,CDM,TTSL,AP,GS,FAIL,9
MT,AP,CDM,RCom,MAH,GS,SUCC,3
MT,AP,CDM,RTL,HP,GS,SUCC,1
MT,AP,CDM,Uni,UPE,GS,SUCC,2
MT,AP,CDM,Uni,MUM,GS,SUCC,2
TTSL,AP,GS,MT,MAH,CDM,SUCC,20
TTML,AP,GS,MT,MAH,CDM,FAIL,10... (2 Replies)
Discussion started by: siramitsharma
2 Replies
4. Shell Programming and Scripting
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies
5. Shell Programming and Scripting
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies
6. Shell Programming and Scripting
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
Discussion started by: tpk
9 Replies
8. UNIX for Beginners Questions & Answers
I have a file which need to be summed up using date column.
I/P:
2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/01/01 a 60
2017/01/01 b 50
2017/01/01 c 40
2017/01/01 a 20
2017/01/01 b 30
2017/01/01 c 40
2017/02/01 a 10
2017/02/01 b 20
2017/02/01 c 30
2017/02/01 a 10... (6 Replies)
Discussion started by: Booo
6 Replies
9. Shell Programming and Scripting
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (1 Reply)
Discussion started by: as7951
1 Replies
10. Shell Programming and Scripting
Hello,
I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically
I/p
c1,c2,c3,c4,c5
10,20,30,40,50
20,30,40,50,60
If i want to find sum only column c1, c3 and output it as c6,c7
O/p
c1,c2,c3,c4,c5,c6,c7
10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies
LEARN ABOUT MOJAVE
mpscnnnormalizationgammaandbetastate
MPSCNNNormalizationGammaAndBetaState(3) MetalPerformanceShaders.framework MPSCNNNormalizationGammaAndBetaState(3)
NAME
MPSCNNNormalizationGammaAndBetaState
SYNOPSIS
#import <MPSCNNNormalizationWeights.h>
Inherits MPSState.
Instance Methods
(nonnull instancetype) - initWithGamma:beta:
Class Methods
(nonnull instancetype) + temporaryStateWithCommandBuffer:numberOfFeatureChannels:
Properties
__nonnull id< MTLBuffer > gamma
__nonnull id< MTLBuffer > beta
Method Documentation
- (nonnull instancetype) initWithGamma: (__nonnull id< MTLBuffer >) gamma(__nonnull id< MTLBuffer >) beta
Initialize a MPSCNNNormalizationGammaAndBetaState object using values contained in MTLBuffers.
Parameters:
gamma The MTLBuffer containing gamma terms.
beta The MTLBuffer containing beta terms.
+ (nonnull instancetype) temporaryStateWithCommandBuffer: (__nonnull id< MTLCommandBuffer >) commandBuffer(NSUInteger) numberOfFeatureChannels
Create a temporary MPSCNNNormalizationGammaAndBetaState suitable for a normalization operation on images containing no more than the
specified number of feature channels.
Parameters:
commandBuffer The command buffer on which the temporary state will be used.
numberOfFeatureChannels The number of feature channels used to size the state.
Property Documentation
- beta [read], [nonatomic], [assign]
A MTLBuffer containing the beta terms.
- gamma [read], [nonatomic], [assign]
A MTLBuffer containing the gamma terms.
Author
Generated automatically by Doxygen for MetalPerformanceShaders.framework from the source code.
Version MetalPerformanceShaders-100 Thu Feb 8 2018 MPSCNNNormalizationGammaAndBetaState(3)