Search Results

Search: Posts Made By: jiam912
6,024
Posted By jiam912
Hi nezabudka...
Hi nezabudka (https://www.unix.com/member_modal.php?u=302181242&modal=1).


The codes works perfect, thanks a lot for your help. Yes, As you mentioned the list in the file are sorted by ID...
6,024
Posted By jiam912
I get the results using datamash. But i will like...
I get the results using datamash. But i will like to get the same with awk

datamash -W -g1 min 3 max 3 min 5 max 5 min 6 max 6 sum 6 count 1 < file


2010 44413 50000 21.75 28 ...
6,024
Posted By jiam912
Min/max/total for selected columns based on first column as ID
For every ID in column one, I want to get the min/max/total for each ID.


The values in different columns are not sorted, the actual attempt, works only if the columns are sorted.


input...
6,388
Posted By jiam912
Sort in ascending and descending column by defined blocks of rows.
I am trying to sort column 2 considering blocks of 5 rows all time.
E.g.
First block rows 1 to 5 : Sort column 2 in ascending order
Second block rows 6 to 10 : Sort column 2 in descending order ...
9,709
Posted By jiam912
Dear RudiC and nezabudka Thanks a lot for the...
Dear RudiC and nezabudka
Thanks a lot for the codes.
9,709
Posted By jiam912
Delete lines between two patterns excluding the other lines containing these pattern
I would want to only remove the lines between PATTERN1(aaa) and PATTERN2(ccc), excluding the others lines where the patterns matches.

I trying to delete the empty line between PATTERN1(aaa) and...
5,062
Posted By jiam912
Hi RudiC,,, Tks a lot for the update it...
Hi RudiC,,,

Tks a lot for the update it works fine...
5,062
Posted By jiam912
Hi RudiC, Kindly can you help with the...
Hi RudiC,

Kindly can you help with the desired output. still I am trying to set the min at beginning.

Please check how i modify the code to get the desired output , but still i got troubles...
5,062
Posted By jiam912
I get the maximun like this NBIR=20 #NUMBER...
I get the maximun like this

NBIR=20 #NUMBER OF RANGES ON BINS
awk -v"MIN=0" -v"MAX=20" -v"NRB=$NBIR" '
BEGIN {delta = (delta=="")?1:delta
MXBCK = (MAX / delta) + 1
}

...
5,062
Posted By jiam912
Create range of bins counting values and add the percentage
Objective, create a table of range of bins to count the values for each range in column 2.

The purpose is to count at beginning all values in column 2 which contends value =0 or < 0.01
Then...
6,478
Posted By jiam912
Hi RudiC. Thanks a lot for the answer..
Hi RudiC.
Thanks a lot for the answer..
4,393
Posted By jiam912
Dear RudiC.. Thanks a lot code is great.. I will...
Dear RudiC.. Thanks a lot code is great.. I will post a new one similar
4,393
Posted By jiam912
Dear rdrtx1 , I have updated my post with correct...
Dear rdrtx1 , I have updated my post with correct values and requirements.. Thanks a lot for the code.

--- Post updated at 12:51 AM ---

Dear vgersh99, I have updated my output file as it was...
4,393
Posted By jiam912
Dear RudiC and rdrtx1 Codes are amazing,...
Dear RudiC and rdrtx1

Codes are amazing, thanks a lot

Please a small request more.

It is possible to set the minimum too. As example minimum = 0.

The the results will show something like...
4,393
Posted By jiam912
Dear vgersh99 , the percentage is calculated...
Dear vgersh99 , the percentage is calculated based in the total sum .
4,393
Posted By jiam912
Create bins with totals and percentage
I would like to create bins to get histogram with totals and percentage, e.g. starting from 0.

If possible to set the minimum and maximum value in the bins ( in my case value min=0 and max=20 )
...
6,478
Posted By jiam912
Dear RudiC, Tks a lot for the code It...
Dear RudiC,

Tks a lot for the code

It is possible to change your code to get in both same values in in a pair's first line, intestead of 0.00 0.00

Now
48047 41513 2 373512.79 ...
6,478
Posted By jiam912
Thank you Gents, both codes works perfectly .....
Thank you Gents, both codes works perfectly .. Many tks
6,478
Posted By jiam912
Add values to file in 2 new columns
Columns 4 and 5 are X and Y coordinates, column 6 is the elevation

I would like to add 2 new columns at the end of the file with values

the distance between first(X)(Y) and last location...
7,354
Posted By jiam912
Many Thanks for the help
Many Thanks for the help
7,354
Posted By jiam912
Compare values in multiple rows in one column using awk
I would like to compare values in column 8, and grep the ones where the different is > 1, columns 1 and 2 are the key for array.

Every 4 rows the records values in columns 1 and 2 changed. Then,...
3,278
Posted By jiam912
Hi RudiC Please can u let me know one of the...
Hi RudiC

Please can u let me know one of the similar problems to check for it

Many Tks
3,278
Posted By jiam912
Create a list from minimum and maximum
Using the input file for each row , using columns 1 (min) and 2 (max) , and with increment of 4 each time I want to create the output file.

Input file

1000 1012 2000 2001
2000 2008 3000 3001
...
5,652
Posted By jiam912
How to get the new columns with conditions?
Using the below input file, I extract the minimum and maximum for column 3, using as key column 2, I get also the total times key in column 2 counts. ( column 4 in output file )

Using output file...
3,827
Posted By jiam912
Hi vgersh99 Appreciate your help :b:
Hi vgersh99
Appreciate your help :b:
Showing results 1 to 25 of 411

 
All times are GMT -4. The time now is 07:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy