sum multiple columns based on column value Post: 302401980

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Hi Friends I have the following input data in 2 columns. SNo 1 I1 Value I2 Value I3 Value SNo 2 I4 Value I5 Value I6 Value I7 Value SNo 3 I8 Value I9 Value ............... ................ SNo N

2. Shell Programming and Scripting

Sum a column value based on multiple keys

Hi, I have below as i/p file: 5ABC 36488989 K 000010000ASB BYTRES 5PQR 45757754 K 000200005KPC HGTRET 5ABC 36488989 K 000045000ASB HGTRET 5GTH 36488989 K 000200200ASB BYTRES 5FTU ...

3. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

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

4. Shell Programming and Scripting

Sum of multiple columns based on few conditions

Input file: 0014,A,2020,K,011115000000,xyxxxxxxxxxxxxxx ,B,00001,0003200,0000111 0014,A,2020,K,011115000000,xyxxxxxxxxxxxxxx ,B,00001,0003300,0000100 0014,A,2020,K,011116000000,xyxxxxxxxxxxxxxx ,B,00001,0003400,0000100 0014,A,2020,K,011116000000,xyxxxxxxxxxxxxxx ,B,00007,0003100,0000200...

5. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

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

6. Shell Programming and Scripting

Paste columns based on common column: multiple files

Hi all, I've multiple files. In this case 5. Space separated columns. Each file has 12 columns. Each file has 300-400K lines. I want to get the output such that if a value in column 2 is present in all the files then get all the columns of that value and print it side by side. Desired output...

7. Shell Programming and Scripting

Join columns across multiple lines in a Text based on common column using BASH

8. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

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

9. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

10. Shell Programming and Scripting

Sum of a column as new column based on header in a script

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

LEARN ABOUT LINUX

dh_clean

DH_CLEAN(1)							     Debhelper							       DH_CLEAN(1)

NAME

       dh_clean - clean up package build directories

SYNOPSIS

       dh_clean [debhelperoptions] [-k] [-d] [-Xitem] [file...]

DESCRIPTION

       dh_clean is a debhelper program that is responsible for cleaning up after a package is built. It removes the package build directories, and
       removes some other files including debian/files, and any detritus left behind by other debhelper commands. It also removes common files
       that should not appear in a Debian diff:
	 #*# *~ DEADJOE *.orig *.rej *.SUMS TAGS .deps/* *.P *-stamp

       It does not run "make clean" to clean up after the build process. Use dh_auto_clean(1) to do things like that.

       dh_clean (or "dh clean") should be the last debhelper command run in the clean target in debian/rules.

FILES

       debian/clean
	   Can list other files to be removed.

OPTIONS

       -k, --keep
	   This is deprecated, use dh_prep(1) instead.

       -d, --dirs-only
	   Only clean the package build directories, do not clean up any other files at all.

       -Xitem --exclude=item
	   Exclude files that contain item anywhere in their filename from being deleted, even if they would normally be deleted. You may use this
	   option multiple times to build up a list of things to exclude.

       file ...
	   Delete these files too.

SEE ALSO

       debhelper(7)

       This program is a part of debhelper.

AUTHOR

       Joey Hess <joeyh@debian.org>

8.9.0ubuntu2.1							    2012-06-12							       DH_CLEAN(1)