05-21-2011
the smallest number from 90% of highest numbers from all numbers in file
Hello All,
I am having problem to find what is the smallest number from 90% of highest numbers from all numbers in file. I am having file with thousands of lines and hundreds of columns.
I am familiar mainly with bash but I am open to whatever suggestion witch will lead to the solutions.
If I explain it differently I have fx 1000 numbers between 0 and 10000. The results could be:
90% of numbers are bigger than 1000
80% of numbers are bigger than 2342
70% of numbers are bigger than 5674
etc.
I am looking for numbers like 1000, 2342, 5674 as in this example.
I am sure that there is some statistical method how to do this, but I cannot remember and can find it how it is called. If I know what method can be used to do this I may find the way to calculate it too.
Thank you for help
10 More Discussions You Might Find Interesting
1. AIX
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
2. Shell Programming and Scripting
. . . . . . (3 Replies)
Discussion started by: some124one
3 Replies
3. UNIX for Dummies Questions & Answers
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
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
6. Programming
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
7. UNIX for Dummies Questions & Answers
##### (0 Replies)
Discussion started by: lucasvs
0 Replies
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. UNIX for Beginners Questions & Answers
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
LEARN ABOUT DEBIAN
numbound
NUMBOUND(1) User Contributed Perl Documentation NUMBOUND(1)
NAME
numbound - Find boundary numbers in files or STDIN.
SYNOPSIS
numbound [-dhlV] <FILE>
| numbound [-dhlV] (Input on STDIN from pipeline.)
numbound [-dhlV] (Input on STDIN. Use Ctrl-D to stop.)
DESCRIPTION
numbound will find boundary numbers (minimum and maximum) in files or STDIN. By default it will find the upper bound in the set of numbers
(the maximum number) in the files or on STDIN. You can use the -l option for finding the lower bound (minumum number).
OPTIONS
-l -- Return the lower bound number in the set (the minimum number)
-h Help: You're looking at it.
-V Increase verbosity.
-d Debug mode. For developers
BUGS
numbound currently will only gather the first number on each line instead of all the numbers on the lines.
SEE ALSO
numaverage(1), numinterval(1), numnormalize(1), numgrep(1), numprocess(1), numsum(1), numrandom(1), numrange(1), numround(1)
COPYRIGHT
numbound is part of the num-utils package, which is copyrighted by Suso Banderas and released under the GPL license. Please read the
COPYING and LICENSE files that came with the num-utils package
Developers can read the GOALS file and contact me about providing
submitions or help for the project.
MORE INFO
More info on numbound can be found at:
http://suso.suso.org/programs/num-utils/
perl v5.10.1 2009-10-31 NUMBOUND(1)