Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Average each numeric column
Top Forums Shell Programming and Scripting Average each numeric column Post 303030499 by Neo on Monday 11th of February 2019 11:36:38 PM
Old 02-12-2019
Moderator's Comments:
Mod Comment
First of all, you should be writing scripts and asking us for help on your attempts to create your own scripts, not posting asking us for scripts. Please do your own work and homework. We are here to help you, not do your work for you.

Second, please be careful when you are cutting and pasting into this site. I just noticed you cut-and-paste a bunch of CSS (style sheet) "garbage" from another site into your post above and had to delete it and reformat your post.

Cutting-and-pasting "junk" into our site and at the same time asking us to do your work for you is not an acceptable community standard for forums, here and elsewhere.

Neo
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

calculate average of column 2

Hi I have fakebook.csv as following: F1(current date) F2(popularity) F3(name of book) F4(release date of book) 2006-06-21,6860,"Harry Potter",2006-12-31 2006-06-22,,"Harry Potter",2006-12-31 2006-06-23,7120,"Harry Potter",2006-12-31 2006-06-24,,"Harry Potter",2006-12-31... (0 Replies)
Discussion started by: onthetopo
0 Replies

2. UNIX for Dummies Questions & Answers

average of a column in a table

Hello, Is there a quick way to compute the average of a column data in a numerical tab delimeted file? Thanks, Gussi (2 Replies)
Discussion started by: Gussifinknottle
2 Replies

3. Shell Programming and Scripting

How to check if a column is having a numeric value or not in a file?

Hi, I want to know, how we find out if a column is having a numeric value or not. For Example if we have a csv file as ASDF,QWER,GHJK,123,FGHY,9876 GHTY,NVHR,WOPI,623,HFBS,5386 we need to find out if the 4th and 6th column has muneric value or not. Thanks in advance Keerthan (9 Replies)
Discussion started by: keerthan
9 Replies

4. Shell Programming and Scripting

average of rows with same value in the first column

Dear All, I have this file tab delimited A 1 12 22 B 3 34 33 C 55 9 32 A 12 81 71 D 11 1 66 E 455 4 2 B 89 4 3 I would like to make the average every column where the first column is the same, for example, A 6,5 46,5 46,5 B 46,0 19,0 18,0 C 55,0 9,0 32,0 D 11,0 1,0 66,0... (8 Replies)
Discussion started by: paolo.kunder
8 Replies

5. Shell Programming and Scripting

Calculate the average of a column based on the value of another column

Hi, I would like to calculate the average of column 'y' based on the value of column 'pos'. For example, here is file1 id pos y c 11 1 220 aa 11 4333 207 f 11 5333 112 ee 11 11116 305 e 11 11117 310 r 11 22228 781 gg 11 ... (2 Replies)
Discussion started by: jackken007
2 Replies

6. Shell Programming and Scripting

Remove certain column with numeric value

I have file1.txt LBP298W2,300,-18,-115,-12,-105 LBP298W2,300,-18,-115,LBP298W3,300 LBP298W3,300,-18,-115,-12,-105---------- Post updated at 03:35 AM ---------- Previous update was at 03:34 AM ---------- i want to remove every line with non numeric value in column 5 expected result ... (4 Replies)
Discussion started by: radius
4 Replies

7. Shell Programming and Scripting

Get column average using ID

I have a file that looks like this: id window BV 1 1 0.5 1 2 0.2 1 3 0.1 2 1 0.5 2 2 0.1 2 3 0.2 3 1 0.4 3 2 0.6 3 3 0.8 Using awk, how would I get the average BV for window 1? Output like this: window avgBV 1 0.47 2 0.23 (10 Replies)
Discussion started by: jwbucha
10 Replies

8. Shell Programming and Scripting

Check first column - average second column based on a condition

Hi, My input file Gene1 1 Gene1 2 Gene1 3 Gene1 0 Gene2 0 Gene2 0 Gene2 4 Gene2 8 Gene3 9 Gene3 9 Gene4 0 Condition: If the first column matches, then look in the second column. If there is a value of zero in the second column, then don't consider that record while averaging. ... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

9. UNIX for Advanced & Expert Users

Sort by second column numeric values

From googling and reading man pages I figured out this sorts the first column by numeric values. sort -g -k 1,1 Why does the -n option not work? The man pages were a bit confusing. And what if I want to sort the second column numerically? I haven't been able to figure that out. The file... (7 Replies)
Discussion started by: cokedude
7 Replies

10. UNIX for Beginners Questions & Answers

Replace a numeric values in a certain column

Hi All, I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7 I tried awk '{gsub("8","7",$35)}1' infile > outfile ----> not working sed -i 's/8/7'g' infile --- it is replacing all... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies

LEARN ABOUT HPUX

uusnap

uusnap(1M)																uusnap(1M)

NAME

       uusnap - show snapshot of the UUCP system

SYNOPSIS

DESCRIPTION

       The commands, including are targeted for removal from HP-UX; see the below.

       displays in tabular format a synopsis of the current UUCP situation.  The format of each line is as follows:

	      site    N Cmds	N Data	  N Xqts    Message

       Where  site is the name of the site with work, N is a count of each of the three possible types of work (command, data, or remote execute),
       and Message is the current status message for that site as found in the file.

       Included in Message may be the time left before UUCP can re-try the call, and the count of the number of times that UUCP has tried to reach
       the site.  The process id of may also be shown if it is in a TALKING state.

WARNINGS

       Use of commands, including is discouraged because they are targeted for removal from HP-UX.  Use ftp(1) or rcp(1) instead.

AUTHOR

       was developed by the University of California, Berkeley.

SEE ALSO

       uucp(1).

       Tim O'Reilly and Grace Todino,
	      O'Reilly & Associates, Inc. USA.

       Grace Todino and Dale Dougherty,
	      O'Reilly & Associates, Inc. USA.

								  TO BE OBSOLETED							uusnap(1M)
All times are GMT -4. The time now is 12:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy