08-20-2013
thanks alot its so fast ive tired it on a 15Million record file i got it in 3 min nearly but some numbers were wrong , can it be a sort problem , when i tried it on unsorted 100 number it got right answer but for the whole file it got mistakes ????
i Think it got me the first appearance only !!
Last edited by teefa; 08-20-2013 at 08:00 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file with 3 columns in it that are comma separated and it has about 5000 lines. What I want to do is find the most common value in column 3 using awk or a shell script or whatever works! I'm totally stuck on how to do this.
e.g.
value1,value2,bob
value1,value2,bob... (12 Replies)
Discussion started by: Donkey25
12 Replies
2. Shell Programming and Scripting
Hi, I have two files file1 and file2. I have to merge the columns of those two files into file3 based on common column of two files. To be simple.
file1:
Row-id name1
13456 Rahul
16789 Vishal
18901 Karan
file2 :
Row-id place
18901 Mumbai
... (2 Replies)
Discussion started by: manneni prakash
2 Replies
3. Shell Programming and Scripting
Hello All,
Please help me with this file.
My input file (Tab separated) is like:
Abc-01 pc1 -0.69
Abc-01 E2cR 0.459666666666667
Abc-01 5ez.2 1.2265625
Xyz-01 pc1 -0.153
Xyz-01 E2cR 1.7358
Xyz-01 5ez.2 2.0254
Ced-02 pc1 -0.5714
Ced-02 ... (7 Replies)
Discussion started by: mira
7 Replies
4. UNIX for Dummies Questions & Answers
Dear all
I have big file with two columns
A_AA960715 GO:0006952
A_AA960715 GO:0008152
A_AA960715 GO:0016491
A_AA960715 GO:0007165
A_AA960715 GO:0005618
A_AA960716 GO:0006952
A_AA960716 GO:0005618
A_AA960716... (15 Replies)
Discussion started by: AAWT
15 Replies
5. Shell Programming and Scripting
Input file A.txt :-
C2062 -117.6 -118.5 -117.5
C5145 0 0 0
C5696 0 0 0
Output file B.txt
C2062 X -117.6
C2062 Y -118.5
C2062 Z -117.5... (4 Replies)
Discussion started by: asavaliya
4 Replies
6. Shell Programming and Scripting
I have the following records from multiple files.
415 A G
415 A G
415 A T
415 A .
415 A .
421 G A
421 G A,C
421 G A
421 G A
421 G A,C
421 G .
427 A C
427 A ... (3 Replies)
Discussion started by: empyrean
3 Replies
7. Shell Programming and Scripting
hi i have two files and i wanted to join them using common column. try to do this using "join" command but that did not help.
File 1:
123 9a.vcf hy92.vcf hy90.vcf
Index Ref Alt Ref Alt Ref Alt
315 14 0 7 4 ... (6 Replies)
Discussion started by: empyrean
6 Replies
8. Shell Programming and Scripting
HI, I have a 3-column tab separated column (approx 1GB) in which I would like to count and output the frequency of all of the common elements in the 1st column.
For instance:
If my input was the following:
dot is-big 2
dot is-round 3
dot is-gray 4
cat is-big 3
hot in-summer 5
My... (4 Replies)
Discussion started by: owwow14
4 Replies
9. Shell Programming and Scripting
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies
10. Programming
Hi All,
I would like get the minimum value in the certain column with respect to other column.
For example, I have a text file like this.
ATOM 1 QSS SPH S 0 -2.790 -1.180 -2.282 2.28 2.28
ATOM 1 QSS SPH S 1 -2.915 -1.024 -2.032 2.31 2.31
ATOM 1 ... (4 Replies)
Discussion started by: bala06
4 Replies
dbar(1) User Commands dbar(1)
NAME
dbar - ASCII progresbar
SYNOPSIS
echo <percentage> | dbar [options] <indicator text>
DESCRIPTION
dbar lets you define static 0% and 100% marks or you can define these marks dynamically at runtime. Static and dynamic marks can be mixed,
in this case the value specified at runtime will have a higher priority.
You can specify ranges of numbers, negative, positive or ranges with a negative min value and positive max value.
All numbers are treated as double precision floating point, i.e. the input is NOT limited to integers.
OPTIONS
-l Label to be prepended to the bar (default: "" ).
-nonl
no new line, don't put '
' at the end of the bar (default: do print "
")
-max
Value to be considered 100% (default: 100).
-min
Value to be considered 0% (default: 0).
-s Symbol represeting the percentage value in the meter (default: "=").
-w Number of charcaters to be considered 100% in the meter (default: 25)
EXAMPLES
Static 100% mark or single value input:
echo 25 | dbar -max 100 -l text
Output: text 25% [====== ]
If your 100% mark changes dynamically or 2-values input:
echo "50 150" | dbar
| |
| |__ max value
|
|__ value to display
Output: 33% [======== ]
If your value range is not between [0, maxval] or 3-values input:
echo "50 -25 150" | dbar
| | |
| | |__ max value 100% mark
| |
| |_____ min value 0% mark
|
|________ value to display
Output: 43% [=========== ]
Multiple runs:
for i in 2 20 50 75 80; do echo $i; sleep 1; done | dbar | dzen2
Output: Find out yourself.
ENVIRONMENT
None.
FILES
None.
SEE ALSO
dzen2(1)
AUTHORS
Program was written by Robert Manea <rob.manea@gmail.com>.
This manual page was written by Jari Aalto <jari.aalto@cante.net> for the Debian GNU system (but may be used by others). Released under
license GNU GPL version 2 or (at your option) any later version. For more information about license, visit
<http://www.gnu.org/copyleft/gpl.html>.
dbar 2012-04-02 dbar(1)