Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

the smallest number from 90% of highest numbers from all numbers in file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting the smallest number from 90% of highest numbers from all numbers in file
# 8  
Old 05-22-2011
Quote:
Originally Posted by Perderabo
The OP does not know what the limits are... he or she needs to find them. Consider:
Code:
1 2 3 4 7 8 9
1 2 3 6 7 8 9

Now find the middle point. It the first list 4 is the mid point. But in the second list its 6. You don't know 4 or 6 ahead of time. The mid point is the 50% point. Now image a much longer list and you need to find the data element at 10%, 20%, 30%...90% points in the list.
I hope it is reply to ananthap's post, cause if it is directed for me, then I completely don't get it Smilie
# 9  
Old 05-22-2011
Quote:
Originally Posted by bartus11
I hope it is reply to ananthap's post, cause if it is directed for me, then I completely don't get it Smilie
I apologise, bartus11. I'm just learning perl and I did not realise how close yours comes to being correct. Running it though, it does seem to need a little work.

Code:
$ ./sc nums
100% of numbers is bigger than 0.04942771
80% of numbers is bigger than 1.15580244
60% of numbers is bigger than 1.22634608
40% of numbers is bigger than 1.42818227
20% of numbers is bigger than 3.07701713
$
$
$
$
$ grep 0.04942771 nums
0.31556582 0.36677924 0.04942771 1.15580244 1.02877668
$

100% of the numbers are larger than 0.04942771; however one of the numbers is 0.04942771. I have to say that raises a flag. Smilie Maybe you have an off by 1 situation?
# 10  
Old 05-22-2011
Well, maybe I should explain how I understood OP request: get all the numbers into one big set, and in this set find numbers from which 100%, 80%, etc of remaining numbers are greater. So it is not calculating the percentages by lines. It reads all of the number in all of the lines first, and then does the calculation.
# 11  
Old 05-22-2011
I think the OP is after calculating the percentiles.
# 12  
Old 05-22-2011
The OP did say 1000 numbers. Anyway wc or $NR in awk will give the count in the file..
Last edited by ananthap; 05-23-2011 at 04:44 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Decimal numbers and letters in the same collums: round numbers

Hi! I found and then adapt the code for my pipeline... awk -F"," -vOFS="," '{printf "%0.2f %0.f\n",$2,$4}' xxx > yyy I add -F"," -vOFS="," (for input and output as csv file) and I change the columns and the number of decimal... It works but I have also some problems... here my columns ... (7 Replies)
Discussion started by: echo manolis
7 Replies

2. Shell Programming and Scripting

Adding (as in arithmetic) to numbers in columns in file, and writing new file with new numbers

Hi again. Sorry for all the questions — I've tried to do all this myself but I'm just not good enough yet, and the help I've received so far from bartus11 has been absolutely invaluable. Hopefully this will be the last bit of file manipulation I need to do. I have a file which is formatted as... (4 Replies)
Discussion started by: crunchgargoyle
4 Replies

3. Shell Programming and Scripting

Print numbers between two number ranges

Hi, I have a list.txt file with number ranges and want to print/save new all.txt file with all the numbers and between the numbers. == list.txt == 65936 65938 65942 && 65943 65945 ... (7 Replies)
Discussion started by: AK47
7 Replies

4. UNIX for Dummies Questions & Answers

Print numbers and associated text belonging to an interval of numbers

##### (0 Replies)
Discussion started by: lucasvs
0 Replies

5. Programming

Help with find highest and smallest number in a file with c

Input file: #data_1 AGDG #data_2 ADG #data_3 ASDDG DG #data_4 A Desired result: Highest 7 Slowest 1 code that I try but failed to archive my goal :( #include <stdio.h> (2 Replies)
Discussion started by: cpp_beginner
2 Replies

6. Shell Programming and Scripting

trying to make an AWK code for ordering numbers in a column from least to highest

Hi all, I have a large column of numbers like 5.6789 2.4578 9.4678 13.5673 1.6589 ..... I am trying to make an awk code so that awk can easily go through the column and arrange the numbers from least to highest like 1.6589 2.4578 5.6789 ....... can anybody suggest, how can I do... (5 Replies)
Discussion started by: ananyob
5 Replies

7. Shell Programming and Scripting

read numbers from file and output which numbers belongs to which range

Howdy experts, We have some ranges of number which belongs to particual group as below. GroupNo StartRange EndRange Group0125 935300 935399 Group2006 935400 935476 937430 937459 Group0324 935477 935549 ... (6 Replies)
Discussion started by: thepurple
6 Replies

8. UNIX for Dummies Questions & Answers

seperating records with numbers from a set of numbers

I have two files one (numbers file)contains the numbers(approximately 30000) and the other file(record file) contains the records(approximately 40000)which may or may not contain the numbers from that file. I want to seperate the records which has the field 1=(any of the number from numbers... (15 Replies)
Discussion started by: Shiv@jad
15 Replies

9. Shell Programming and Scripting

Perl ? - How to find and print the lowest and highest numbers punched in by the user?

. . . . . . (3 Replies)
Discussion started by: some124one
3 Replies

10. AIX

How to replace many numbers with one number in a file

How to replace many numbers with one number in a file. Many numbers like 444565,454678,443298,etc. i want to replace these with one number (300).Please halp me out. (2 Replies)
Discussion started by: vpandey
2 Replies
Login or Register to Ask a Question