Sponsored Content
Top Forums Shell Programming and Scripting Calculate the average of a column based on the value of another column Post 302761995 by jackken007 on Sunday 27th of January 2013 03:42:52 PM
Old 01-27-2013
It works like a charm!

Thank you so much!
 

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

Use awk to calculate average of column 3

Suppose I have 500 files in a directory and I need to Use awk to calculate average of column 3 for each of the file, how would I do that? (6 Replies)
Discussion started by: grossgermany
6 Replies

3. Shell Programming and Scripting

AWK: how to get average based on certain column

Hi, I'm new to shell programming, can anyone help me on this? I want to do following operations - 1. Average salary for each country 2. Total salary for each city and data that looks like - salary country city 10000 zzz BN 25000 zzz BN 30000 zzz BN 10000 yyy ZN 15000 yyy ZN ... (3 Replies)
Discussion started by: shell123
3 Replies

4. Shell Programming and Scripting

Average values in a column based on range

Hi i have data with two columns like below. I want to find average of column values like if the value in column 2 is between 0-250000 the average of column 1 is some xx and average of column2 is ww then if value is 250001-5000000 average of column 1 is yy and average of column 2 is zz. And my... (5 Replies)
Discussion started by: bhargavpbk88
5 Replies

5. Shell Programming and Scripting

Calculate 2nd Column Based on 1st Column

Dear All, I have input file like this. input.txt CE2_12-15 3950.00 589221.0 9849709.0 768.0 CE2_12_2012 CE2_12-15 3949.00 589199.0 9849721.0 768.0 CE2_12_2012 CE2_12-15 3948.00 589178.0 9849734.0 768.0 CE2_12_2012 CE2_12-52 1157.00 ... (3 Replies)
Discussion started by: attila
3 Replies

6. UNIX for Dummies Questions & Answers

Find the average based on similar names in the first column

I have a table, say this: name1 num1 num2 num3 num4 name2 num5 num6 num7 num8 name3 num1 num3 num4 num9 name2 num8 num9 num1 num2 name2 num4 num5 num6 num4 name4 num4 num5 num7 num8 name5 num1 num3 num9 num7 name5 num6 num8 num3 num4 I want a code that will sort my data according... (4 Replies)
Discussion started by: FelipeAd
4 Replies

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

8. Shell Programming and Scripting

Calculate Average time of one column

Hello dears, I have a log file with records like below and want to get a average of one column based on the search of one specific keyword. 2015-02-07 08:15:28 10.102.51.100 10.112.55.101 "kevin.c" POST ... (2 Replies)
Discussion started by: Newman
2 Replies

9. Shell Programming and Scripting

Match first two columns and calculate percent of average in third column

I have the need to match the first two columns and when they match, calculate the percent of average for the third columns. The following awk script does not give me the expected results. awk 'NR==FNR {T=$3; next} $1,$2 in T {P=T/$3*100; printf "%s %s %.0f\n", $1, $2, (P>=0)?P:-P}' diff.file... (1 Reply)
Discussion started by: ncwxpanther
1 Replies

10. Shell Programming and Scripting

Calculate 5th percentile based on another column

I would like to have some help in calculating 5th percentile value of column 2 for each site, the input is like below:site val1 val2 002 10 25.3 002 20 25.3 002 30 25.3 002 40 20 002 50 20 002 60 20 002 70 20 002 80 30 002 90 30 002 100 30 002 120 30 003 20 30.3 003 20 30.3 003 30 20... (2 Replies)
Discussion started by: wuhuai
2 Replies
XTEDDY(6)							   Games Manual 							 XTEDDY(6)

NAME
xteddy - cuddly teddy bear for your X Windows desktop. SYNOPSIS
xteddy [ -wm -float -noquit -nocursor -F<file> ] [ -geometry WIDTHxHEIGHT+X+Y -display SERVER ] [ -h --help -v ] DESCRIPTION
Xteddy is a cuddly teddy bear for your X Windows desktop. Normally, xteddy just sits around doing nothing. After all, that's what teddy bears are for. Look at him, talk to him, place heavy windows on top of him, zap him around until he becomes dizzy, do what you like; he will always be your true (albeit virtual) friend. You can move xteddy with the mouse by pointing at him and dragging him around. When clicked upon, he will pop up on top of all other win- dows. If you type "q" or "Esc" on him, he will exit (or, as I like to think of it, be tucked away in the file system until you need him next time). That's it. But he's cute. OPTIONS
-wm Use the window manager. Normally, xteddy sets the override_redirect flag for his window, which will cause most window managers to ignore him. However, some window managers might have problems coping with a window that is nailed directly to the root. In that case, use this option. If possible, instruct your window manager not to put any title bar or window frame on the window, or xteddy will lose some of his charm. -float Float up on top of overlapping windows. This will make xteddy stay in sight at all times, so you won't lose him. However, this is a bit intrusive and quite unlike a real teddy bear, so it is not the default action. -noquit Disable the "quit" command (do not quit when typing "q" in the window, but of course still on explicit window kills or process kills). This might seem an unnecessary option, but if you use the -wm option Xteddy might keep receiving keyboard events even after the mouse has left his window. I you use the -wm option in conjunction with a click-to-type window manager, you would probably want to include this option. -nocursor Disable the X11 cursor over the xteddy window. -F,-f < file > Display another image instead of xteddy. file can be the full name of an image file which reasonably should contain a transparent background. If there is no such file in the current working directory xteddy searches in $(installation_pre- fix)/share/xteddy, where $(installation_prefix) is determined at compile time (for instance /usr/X11R6). If this fails by default /usr/share/xteddy is searched. Failing this, /usr/local/share/xteddy is searched. If there is no such file in these directories the following appendixes where appended to the given name: xpm, png, tif, jpg, jpeg, gif and pnm. These files will be searched in the three directories. If all files the last try is to append the extensions in upper cases. '-F' and '-f' are equivalent, and the space in '-f <file>' is optional. If no `-F` parameter is given file equals to xteddy or more precisely to the name of the calling program. For instance if there is a sym- link ln -s xteddy xpenguin then file equals to xpenguin and the appropriate pixmaps with the name xpenguin are searched for. -geometry The standard X geometry specification. Only X and Y position requests are honored. Any height and width specifications will be ignored. -display Specify an X server other than the local display. -h, --help Print a help message and exit. -v Print the version number and exit. BEARS
The cast of characters is currently: teddy xalex xbobo xbrummi xcherubino xduck xhedgehog xklitze xnamu xorca xpenguin xpuppy xruessel xteddy xtrouble.png xtrouble_large xtuxxy. AUTHOR
Stefan Gustavson, ISY-LiTH (stegu@itn.liu.se). Xteddy is distributed under the GNU General Public License. BUGS
The Desktop Manager in Sun CDE (Common Desktop Environment) does not like xteddy. Xteddy by default does not use the window manager, and so he shows up as a sticky window on all desktops. If you don't like this, and try to circumvent it by running him with the -wm option, move him by grabbing him by the tummy instead of by the title bar, and then move him partly off the screen, the image is lost and never redrawn again, so all you see is a silhouette of a teddy bear. I have no idea why this happens. If you know, please tell me, and if you can fix it, please do. If you run CDE on other platforms than Sun, please tell me if it works for you. CDE does something which xteddy does not handle properly, and since I have a Sun with CDE myself I would like to know what the problem is. For most X servers, the -float option does not work properly if xteddy is moved partially off the screen. This is the X server's fault, not mine. If two copies of xteddy are placed so they overlap, and both were run with the -float option, the X server will try to put each on top of the other in an endless loop, which looks very bad and takes a lot of CPU power. Xteddy does not make use of the X resource database. I just didn't get around to that. Please send bug reports, fixes, suggestions, fan mail or or hacks to: stegu@itn.liu.se. X Version 11 25 May 2005 XTEDDY(6)
All times are GMT -4. The time now is 05:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy