Hello:
I want to print out the entire row with max value in column 3 based on column 2. Input file is millions rows. test.dat:
I first tried:
and the output is:
As I want to print out the whole row of the max values of each item, then I tried:
and the output is:
Obviously I had something wrong with the second script. I am very nervous with the second script for millions of rows, but could not figure it out myself. Thanks in advance!
YT
I have a file like:
<word> 5
<word> 3
<word> 5
<word> 2
<word> 6
<word> 8
<word> 12
and i need to know the max value of the second column, in this case 12.
Plz help me!
Actually i need the TOTAL, AVERANGE and MAX VALUE and i'm using this in... (10 Replies)
Hi,
I have a file with 1M records
ABC 200 400 2.4 5.6
ABC 410 299 12 1.5
XYZ 4 5 6 7
MNO 22 40 30 70
MNO 47 55 80 150
What I want is for all the rows it should take the max value where there are duplicates
output
ABC 410 400 12 5.6
XYZ 4 5 6 7
MNO 47 55 80 150
How can i... (6 Replies)
Hi,
I am a new bie i need some help with respect to shell onliner;
I have data in following format
Name FromDate UntilDate Active Changed Touched
Test 28-03-2013 28-03-2013 1 0.6667 100
Test2 28-03-2013 03-04-2013 ... (1 Reply)
Hello Team,
Need your expertise on following:
Here is the set of data:
C1|4|C1SP1|A1|C1BP1|T1
C1|4|C1SP2|A1|C1BP2|T2
C2|3|C2SP1|A2|C2BP1|T2
C3|3|C3SP1|A3|C3BP1|T2
C2|2|C2SP2|A2|C2BP2|T1
I need to filter above date base on following two steps:
1. Group them by column 1 and 4
2.... (12 Replies)
Hello,
I have this table:
chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67
chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885
chr1_16857_18061 - chr1 ... (5 Replies)
Discussion started by: coppuca
5 Replies
LEARN ABOUT BSD
ntpdc
NTPDC(8) System Manager's Manual NTPDC(8)NAME
ntpdc - monitor operation of ntp daemon
SYNOPSIS
ntpdc [-n] [-v] hosts...
DESCRIPTION
ntpdc sends an INFO_QUERY packet to an ntp daemon running on the given hosts. Each daemon responds with information about each of its
peers, which ntpdc formats on the standard output.
Normally, the name of the responding host and its peers are printed. The -n switch disables this, printing only internet addresses.
Default is a terse, table-style report. The -t switch generates an alternate form of the terse report. The -v switch generates a verbose
report.
TERSE REPORT
A typical terse report looks like:
(rem) Address (lcl) Strat Poll Reach Delay Offset Disp
==========================================================================
-umd1 128.8.10.14 1 64 266 3.0 -65.0 0.0
*DCN1.ARPA 128.8.10.14 1 256 332 155.0 -4.0 0.0
128.8.251.92 128.8.10.14 2 64 367 -16.0-61.0 0.0
idunno.Princeto 128.8.10.14 3 64 252 60.0 -53.0 0.0
leo 128.8.10.14 2 64 275 4.0 -273.0 1536.2
The alternate form is only slightly different; it looks like:
Address Reference Strat Poll Reach Delay Offset Disp
==========================================================================
-umd1 WWVB 1 64 266 3.0 -65.0 0.0
*DCN1.ARPA WWVB 1 256 332 155.0 -4.0 0.0
128.8.251.92 umd1 2 64 367 -16.0-61.0 0.0
idunno.Prince trantor 3 64 252 60.0 -53.0 0.0
leo umd1 2 64 275 4.0 -273.0 1536.2
Fields are interpreted as follows:
- or *:
The - mark indicates a pre-configured peer (mentioned in ntp.conf). the * mark shows which pre-configured peer (if any) is cur-
rently being used for synchronization.
(rem) address:
The remote host name or internet address of a peer.
(lcl) address:
The "local" host as specified as an argument to ntpdc.
Reference:
The reference time source being used for synchronization by the peer.
Strat: The stratum level of the peer (as perceived by the local host).
Poll: Current polling interval in seconds for this peer.
Reach: Octal value of a shift register indicating which responses were received from the previous 8 polls to this peer (see RFC-????).
Delay: Round-trip delay in milliseconds for this peer as of the latest poll.
Disp: Current value of dispersion (see RFC-????) in milliseconds for this peer.
VERBOSE REPORTS
When the -v flag is given a series of verbose reports are presented. A typical one looks like this:
Neighbor address 128.4.0.6 port:123 local address 192.35.201.47
Reach: 0376 stratum: 1 poll int(HPI): 10 precision: -10
Sync distance: 0 disp: 0.014000 flags: 0 leap: 0
Reference clock ID: WWV timestamp: a7c2832e.6f9d0000
Poll int(MPI): 10 threshold: 1024 timer: 1024 send: 266 received: 192 samples: 9
Delay(ms) 1144.00 1296.00 1118.00 1115.00 1225.00 1129.00 1086.00 1087.00
Offset(ms) 19.00 92.00 -17.00 12.00 41.00 4.00 -1.00-14.00
delay: 1086.000000 offset: -1.000000 dsp 0.014000
Fields are interpreted as follows:
Neighbor address...:
The address and port number of this neighbor, followed by the local address.
Reach: nn
Reachability in response to last 8 polls (octal value of shift register)
stratum: n
Stratum level.
poll interval: time
precision: nn
The precision of this clock, given in seconds as a power of 2. e.g A clock derived from the power line frequency (60 Hz) has a pre-
cision of 1/60 second (about 2^-6) and would be indicated by a precision of -6.
Syn distance: 0
Synchronizing distance. Always zero in the current implementation.
disp: nn
Dispersion.
flags: nn
leap: flag
The leap second indicator. Non-zero if there is to be a leap second added or subtracted at the new year.
Reference clock ID: [address]
timestamp: nn
Poll interval: time
threshold: nn
timer: nn
send: nn
The number of ntp packets sent to this neighbor.
received: nn
The number of ntp packets received from this neighbor.
samples: nn
Delay and Offset
The round-trip delay and clock offset for the last eight ntp packet exchanges. If there are fewer than eight valid samples, the
delay field will be zero.
delay: avg-delay offset: avg-offset dsp ???
Average delay, offset, and dispersion calculated from the above samples. Meanings...???
BUGS
Probably a few. Report bugs to Louis A. Mamakos (louie@trantor.umd.edu).
SEE ALSO
RFC-???? Network Time Protocol(1), Dave Mills and ...
ntpd(8), ntp(8)
10 March 1989 NTPDC(8)