#!/usr/bin/env python
d={}
for line in open("file"):
line=line.strip().split()
d.setdefault(''.join(line[4:6]),[])
d[''.join(line[4:6])].append(line[-1])
for i,j in d.iteritems():
print i, min(j)
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Hello there.
I've got the query like that
SELECT count(tour_id) AS cnt
FROM orders
JOIN tours
ON orders.tour_id=tours.id
GROUP BY tour_id
The result Is
cnt
1
4
2
1
1
Now i have to select all records with minimum values in field "cnt"
MySQL function min() returns only one.... (2 Replies)
Hi all,
I am having multiple files with the pattern given below:
I need to find the minimum value of 5th column if column 1 is x and 2nd column is awh or vbn or ... (20 different strings).
the output must be like:
Kindly help me to figure out this prob....
Thanks in... (4 Replies)
Hi All,
I have multiple files which contains 5 columns and multiple rows.....
I want to calculate the minimum value of column 5th, if column 2 is MET, till column 1 comes to the next number.
Also it must skip the condition similar to 1st line where column number 1 and 3 are same and... (9 Replies)
I have two LARGE files of data more than 20,000 line each, file-1 and file-2, and I wish to do the following if possible:
file-1
1 2 5 7 9
2 4 6 3 8 9
4 6 8 9 3 2 1 3
1 2
.
.
.
file-2
1 2 3
2 5 7
5 7 3
7 9 4
. (5 Replies)
Deal All,
I have millions of input file like this:
input 1:
disk minimum
DISK01 5173
DISK02 5227
DISK03 5284
DISK04 5346
DISK05 5400
DISK06 5456
DISK07 5511
DISK08 5572
.
.
.
input 2:
range 5180-5300 (3 Replies)
I am trying to find the minimum maximum and average from one file which has values
Received message from https://www.demandmatrix.net/app/dm/xml] in milliseconds.
Received message from https://www.demandmatrix.net/app/dm/xml] in milliseconds.
Received message from... (5 Replies)
input
1 2 3 4 5 2 8
2 1 1 1 4 2 1
5 4 4 4 2 1 3
2 2 6 7 4 5 4
5 5 5 4 3 3 5
I woud like to print a min of each row such that my output would look like
1
1
1
2
3 (5 Replies)
I have a fixed length file and I want to find out row number along with row length.
I have a program that give me the line length if it satisfy the condition; but i would like to add row number as well?
How do I do that?
while IFS= read -r line; do
if ; then
echo ${line}
echo... (8 Replies)
Discussion started by: princetd001
8 Replies
LEARN ABOUT BSD
join
JOIN(1) General Commands Manual JOIN(1)NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO sort(1), comm(1), awk(1)BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)