Within millions of lines of data, there are perhaps 20 "spikes" that are very narrow. I want only the highest value from each spike within a range of 10 rows. Possible?
My data looks like this, 8 columns of integers, millions of rows. There are clear spikes when you graph columns.
Currently, my code will give me all the consecutive-row increases in column 1 over a specified value of 5000:
The output looks like this:
increase of 140539 at Line 5
increase of 55416 at Line 4
increase of 85064 at Line 6
However, I want the output to look like this, filtering out the smaller increases within that data range:
increase of 140539 at Line 5
increase of 5662 at Line 48924
increase of 10334 at Line 589332
...
Hi :) I'm a unix beginner and i've recently got an assignment to write up a script to print the most common IP address that made requests from a webserver.
I'm really lost in this one...and if someone could pls tell me where to start i'll be really greatful !
thanx (1 Reply)
Hi all!
I'm working on a KSH script to select files between a user inputed date range (stored in a variable) and then move them and unzip them. I'm stuck at how to get the files between the user inputed date range selected. Any help would be greatly appreciated!
The files are as such:
... (6 Replies)
Hi,
I have a file that looks like this:
s6 98
s6 91
s6 56
s5 32
s5 10
s5 4
So what I want to do is print only the highest value for each value in the column:
So the file will look like this:
s6 98
s5 32
Thanks (4 Replies)
I want to print between the range two patterns if a particular pattern is present in between the two patterns. I am new to Unix. Any help would be greatly appreciated.
e.g.
Pattern1
Bombay
Calcutta
Delhi
Pattern2
Pattern1
Patna
Madras
Gwalior
Delhi
Pattern2
Pattern1... (2 Replies)
Hi Gurus,
I've using HPUX B.11.23 U ia64 with shell = sh.
I've been having some problem get the highest number of this script.
Actually I wanted to get the highest number from this listing (TEST123 data and based on this highest number, there will be email being sent out.
For example,... (6 Replies)
Hi All,
Is there a way to get a range of lines from a file??? I want to search through a set of scripts and need to select the group of lines which do the FTP.
Say,
Line1
Line2
ftp SERVER
user UNAME PASS
send FILE_TO_BE_SENT
close
Line3
Line4
Line5
ftp SERVER1
user USER1 PASS1... (6 Replies)
Hi all,
I have a simple problem. I have given an example of the problem below.
There are 4 space-delimited columns.
2655 96 IA -0.8179
2655 96 IA -0.9144
2655 96 CPU -0.4275
2655 96 RMA -0.3407
2655 96 IA -0.9373
2655 96 ... (2 Replies)
Hi all,
I'm trying to get the item with the maximum value, and was wondering if someone can help me with it.
Heres my input file:
apples 15
books 15
books 17
pens 12
pens 15
umbrella 13Here's what my output file should look like:
apples 15
books 17
pens 15
umbrella 13
Can... (2 Replies)
Hi,
I have a file with the following columns:
361459 447394 CHL1
290282 290282 CHL1
361459 447394 CHL1
361459 447394 CHL1
178352861 178363529 AGA
178352861 178363529 AGA
178363657 178363657 AGA
Essentially, using CHL1 as an example. For any line that has CHL1 in... (2 Replies)
Hi All
I do have a matrix in the following format
a_2 a_3 s_4 t_6
b 0 0.9 0.004 0
c 0 0 1 0
d 0 0.98 0 0
e 0.0023 0.96 0 0.0034
I have thousands of rows
I would like to parse the maximum value in each of the row and out put that highest value along the column header of... (2 Replies)