Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Using awk to find and use the maximum value in column of data Post 302898194 by tintin72 on Sunday 20th of April 2014 03:37:01 AM
Old 04-20-2014
works like a dream! Many thanks!
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Find different column numbers among rows in data

I want to find the different column numbers among rows in a file. For example: A001 a b c d e ... N A002 a b c d e ... N A003 a b c d e ... N+1 A004 a b c d e ... N A005 a b c d e ... N+2 : : For most of the lines I will have N columns (say 1000 rows) in each line except the line 3... (5 Replies)
Discussion started by: AMBER
5 Replies

2. Shell Programming and Scripting

find expression with awk in only one column, and if it fits, print whole column

Hi. How do I find an expression with awk in only one column, and if it fits, then print that whole column. 1 apple oranges 2 bannanas pears 3 cats dogs 4 hesaid shesaid echo "which number:" read NUMBER (user inputs number 2 for this example) awk " /$NUMBER/ {field to search is field... (2 Replies)
Discussion started by: glev2005
2 Replies

3. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ... (1 Reply)
Discussion started by: Diya123
1 Replies

4. Homework & Coursework Questions

Find the Maximum value and average of a column

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I am trying to complete a script which will allow me to find: a) reads a value from the keyboard. (ask the... (4 Replies)
Discussion started by: dstewie
4 Replies

5. Shell Programming and Scripting

AWK, Perl or Shell? Unique strings and their maximum values from 3 column data file

I have a file containing data like so: 2012-01-02 GREEN 4 2012-01-02 GREEN 6 2012-01-02 GREEN 7 2012-01-02 BLUE 4 2012-01-02 BLUE 3 2012-01-02 GREEN 4 2012-01-02 RED 4 2012-01-02 RED 8 2012-01-02 GREEN 4 2012-01-02 YELLOW 5 2012-01-02 YELLOW 2 I can't always predict what the... (4 Replies)
Discussion started by: rich@ardz
4 Replies

6. Programming

Find gaps in time data and replace missing time value and column 2 value by interpolation in awk

Dear all, I am kindly seeking assistance on the following issue. I am working with data that is sampled every 0.05 hours (that is 3 minutes intervals) here is a sample data from the file 5.00000 15.5030 5.05000 15.6680 5.10000 16.0100 5.15000 16.3450 5.20000 16.7120 5.25000... (4 Replies)
Discussion started by: malandisa
4 Replies

7. Shell Programming and Scripting

Find minimum and maximum values based on column with associative array

Hello, I need to find out the minimum and maximum values based on specific column, and then print out the entire row with the max value. Infile.txt: scf6 290173 290416 . + X_047241 T_00113118-1 scf6 290491 290957 . + X_047241 T_00113118-2 scf6 290898 290957 . + X_047241 T_00113119-3 scf6... (2 Replies)
Discussion started by: yifangt
2 Replies

8. Shell Programming and Scripting

awk to select lines with maximum value of each record based on column value

Hello, I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record? Input: A1 chr5D 634 7 82 707 A2 chr5D 637 6 82 713 A3 chr5D 637 5 82 713 A4 chr5D 626 1 82 704... (4 Replies)
Discussion started by: yifangt
4 Replies

9. Shell Programming and Scripting

Get maximum per column from CSV file, based on date column

Hello everyone, I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this: 20170628-23:25:01,1,0,0,1,1,1,1,55,55,1 20170628-23:30:01,1,0,0,1,1,1,1,56,56,1 20170628-23:35:00,1,0,0,1,1,2,1,57,57,2 20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Discussion started by: ejianu
6 Replies

10. Shell Programming and Scripting

awk to find maximum and minimum from column and store in other column

Need your support for below. Please help to get required output If column 5 is INV then only consider column1 and take out duplicates/identical rows/values from column1 and then put minimum value of column6 in column7 and put maximum value in column 8 and then need to do subtract values of... (7 Replies)
Discussion started by: as7951
7 Replies
between(6)							       Games								between(6)

NAME
between - a game about consciousness and isolation SYNOPSIS
between DESCRIPTION
Between is a video game written by Jason Rohrer about consciousness and isolation. Between is a multiplayer-only art game. As a result, some people like it, many people do not get it and some people hate it. Search the internet for the author's name and the game title to find some discussion about the game before dismissing it. Some sample discussions and reactions are listed below. You can play Between with a friend or stranger over the Internet. Both players will see a field, sky, clouds, a square structure and a shimmering tower. The interface reveals the initial controls (reference below). The players place red-green-blue blocks on the field and pile them upwards. Placing blocks over the shimmering tower causes pleasant tones while the colours match. Soon enough the players will not be able to match any more blocks with the complex patterns and colour variety in the tower. To the left is a bed indicating sleep. To the right is a bright room indicating wakefulness. Cycling through the dream and wakefulness states gives players three different realities in which to build the shimmering tower. Eventually in the state between dream and reality, mysterious interactions between the two players block placements and reality cycling patterns will result in blocks with new colours and patterns appearing on the field. These new blocks can then be used to match more and more of the shimmering tower over time... The most interesting part about this game is the emotions it evokes within the player of the game. The ultra-low-res pixel art helps here, by not being too distracting and by leaving plenty room for viewer interpretation. USAGE
Between has no command-line options. The left and right arrow keys move left and right. The spacebar is used to place or grab blocks. The b/n keys are used to change the colour of the placed blocks. The s/w keys are used to sleep/wake the player. The Esc key is used to quit the game. The game resolution and use of fullscreen or a window can be set by editing the files in /etc/between. SEE ALSO
The website: http://www.esquire.com/features/best-and-brightest-2008/rohrer-game http://www.destructoid.com/jason-rohrer-s-new-game-between-is-out-111382.phtml http://mile222.com/2008/11/jason-rohrers-latest-game-between-leaves-me-unenthused/ http://www.gamasutra.com/view/feature/3853/persuasive_games_disjunctive_play.php http://www.gamerswithjobs.com/node/42515 http://kotaku.com/5096755/disjunctive-play-and-otherness-between December 2010 between(6)
All times are GMT -4. The time now is 01:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy