Min and max

timus221 · 05-22-2016, 05:44 AM

Hello I have problem.
Do You know how to find minimum and maximum in each line if i have :

9111 1320
6548 76
1649 567 5700 4596 4586 6428
8625
2714 1241 6907 5996 8139 6357 9922

8134 9727 3553
3945 8573
1273
8719 1366 1076 8420 6859
1637 2327 6554 7458
1399 4370 9612 5217
6911 2235
504
2770 396
4149 151 6900 2107 1354
3550 3324 8695 8543 2258 7039
2630 4006
726 1256 7255
2214 1866 1935
5592 193 7491 2053 6353
5731 916 981 8463 5749
9557 8166

2959 6813 4701

HMW · 05-22-2016, 05:49 AM

Hi!

Yes, I do. And there are several ways to do it, but what have you tried this far?

Best regards,
HMW

timus221 · 05-22-2016, 06:00 AM

For example :
cat numbers.txt|sort -n numbers.txt
cat numbers.txt|awk -F " " '{print $0}'|sort -n numbers.txt

but it doesn't work

grail · 05-22-2016, 06:06 AM

Not sure why you would think that sorting would work? You will not eliminate any of the data not required.

Your original question asked for the min & max per line, whilst sorting in this way would work on a column. Please show your suggested output for your current input data?

The addition of the awk in your second script will yield no difference whatsoever as you are simply printing the whole line

timus221 · 05-22-2016, 06:16 AM

Yea I want min & max per line but i have no i idea how to do that,i am newbie yet.

For my current idea: cat numbers.txt|sort -n numbers.txt
the output is:
504
726 1256 7255
1273
1399 4370 9612 5217
1637 2327 6554 7458
1649 567 5700 4596 4586 6428
2214 1866 1935
2630 4006
2714 1241 6907 5996 8139 6357 9922
2770 396
2959 6813 4701
3550 3324 8695 8543 2258 7039
3945 8573
4149 151 6900 2107 1354
5592 193 7491 2053 6353
5731 916 981 8463 5749
6548 76
6911 2235
8134 9727 3553
8625
8719 1366 1076 8420 6859
9111 1320
9557 8166

but i want something like that or similar :
min1:1320 max1:9111
min2:76 max2:6549
....

HMW · 05-22-2016, 06:23 AM

I'm sure you can do this in bash, but for these kind of things I tend to use Python:

Code:

$ ./min_max.py 
Max 9111, Min 1320
Max 6548, Min 76
Max 6428, Min 567
Max 8625, Min 8625
Max 9922, Min 1241
Max 9727, Min 3553
Max 8573, Min 3945
Max 1273, Min 1273
Max 8719, Min 1076
Max 7458, Min 1637
Max 9612, Min 1399
Max 6911, Min 2235
Max 504, Min 504
Max 2770, Min 396
Max 6900, Min 151
Max 8695, Min 2258
Max 4006, Min 2630
Max 7255, Min 726
Max 2214, Min 1866
Max 7491, Min 193
Max 8463, Min 916
Max 9557, Min 8166
Max 6813, Min 2959

With Python, you can use min and max on a list.
See here for more info:
http://thelivingpearl.com/2013/10/24...ist-in-python/

Best regards,
HMW

PS. I am sure there is a killer oneliner in awk just waiting to be done by grail... DS.
PSS. My python script is just 8 lines long, so it's really quick and easy once you know what to do. DSS.

timus221 · 05-22-2016, 06:33 AM

Thank You,but i would prefer do this in bash,but unfortunately i can't,so please guys could You give me a solution or hint ?

dunne · 05-22-2016, 06:47 AM

A simple piece of awk should do the trick:

Code:

awk '
{
    for (i = 1; i <= NF; i++) {
	if (i == 1)
	    min = max = $i
	else if ($i < min)
	    min = $i
	else if ($i > max)
	    max = $i
    }
    print min, max
}'

wpeckham · 05-22-2016, 06:59 AM

The bash would look something similar.
Loop through the file, for each line slurp the line and break it into a list words, find the smallest and largest words in the list, and write out your answer for that line.

Now, can you code?

timus221 · 05-22-2016, 08:51 AM

I am not good in bash,I'm just started learning, so not specially

dunne · 05-22-2016, 09:03 AM

Quote:

Originally Posted by timus221

I am not good in bash,I'm just started learning, so not specially

A bash wrapper for the bit of awk above is trivial. Save it to a file, add

Code:

#!/bin/bash

as the first line, make the file executable, and you are good to go.

HMW · 05-22-2016, 09:07 AM

Quote:

Originally Posted by timus221

I am not good in bash,I'm just started learning, so not specially

But here is a template:

Quote:

Originally Posted by wpeckham

Loop through the file, for each line slurp the line and break it into a list words, find the smallest and largest words in the list, and write out your answer for that line.

Also, that is the approach I took in my Python script. You can use the same approach with Bash.

First things first, do you know how to read a file, line by line in Bash? If not:
https://is.gd/A6RKTL

My suggestion is that you start there, and get back with your follow-up questions.

Best regards,
HMW

HMW · 05-22-2016, 09:23 AM

...actually, this turned out to be more trivial in Bash (7 lines including blank ones) than I first thought. A rough script produces this:

Code:

$ ./min_max.sh 
Min: 1320 Max: 9111
Min: 76 Max: 6548
Min: 567 Max: 6428
Min: 8625 Max: 8625
Min: 1241 Max: 9922
Min:  Max: 
Min: 3553 Max: 9727
Min: 3945 Max: 8573
Min: 1273 Max: 1273
Min: 1076 Max: 8719
Min: 1637 Max: 7458
Min: 1399 Max: 9612
Min: 2235 Max: 6911
Min: 504 Max: 504
Min: 396 Max: 2770
Min: 151 Max: 6900
Min: 2258 Max: 8695
Min: 2630 Max: 4006
Min: 726 Max: 7255
Min: 1866 Max: 2214
Min: 193 Max: 7491
Min: 916 Max: 8463
Min: 8166 Max: 9557
Min:  Max: 
Min: 2959 Max: 6813

Apart from the while loop (for reading the file) no looping or if/else is needed, just two pipelines.
Hint:

Code:

echo "99 20 333" | tr ' ' '\n' | sort -n | head -1

Best regards,
HMW

grail · 05-22-2016, 09:43 AM

I managed 2 awk scripts, bash and ruby. All have a fairly similar idea to the examples shown

keefaz · 05-22-2016, 09:54 AM

Using perl's sort function

Code:

perl -ane 'print "Min: $a[0], Max: $a[-1]\n" if @a=sort {$a <=> $b}@F' data.txt