Search Results

Dear RudiC and everyone,

Thank you. this solution works and does exactly what I really needed. The interpolation is just alright. As you can see this is time series data for some quantity that...

Dear Don,

Thank you for your reply. I have read and seen several "almost similar issues" including the "XY interpolation by time in awk" you have referred to. I have spent several days trying to...

Dear all,

I am kindly seeking assistance on the following issue.

I am working with data that is sampled every 0.05 hours (that is 3 minutes intervals) here is a sample data from the file
...

Thank you Shamrock, It works right now. This is what I needed and your advice to read up truely sent me reading a lot about arrays in awk and I must say that I have learned a lot from this.

Thanks!

Shamrock please help me learn something. What does this line
val[$1] = (val[$1] ? val[$1] "," $2 : $2)
do exactly in this code! Am sure once I understand this, I would be able to see where the...

Thank you for your suggestion, but interestingly it suggestion for a small file, when I run this on a big file it complains about attempted division by 0. Let me attach a large file and you see what...

Yes please, In this case, in the little code, for each segment, I am removing the rows where the second column element has more than 30% divergence from the average, then I consider such to be an...

I have data files that look like this, say data.txt

0.00833 6.34
0.00833 6.95
0.00833 7.08
0.00833 8.07
0.00833 8.12
0.00833 8.26
0.00833 8.70
0.00833 9.36
0.01667 20.53
0.01667 6.35...

Thank you Bakunin and SriniShoo,

I have tried your solution SriniShoo and I am trying it again to be absolutely sure it is doing the right thing

Thank you
malandisa

---------- Post updated...

I have several files which look like this. The files are much longer than this, I have just cut out the data and there are hundreds of these files

file 1
0.00 5.905
0.05 5.740
0.10 ...

Hi SriniShoo, and all,

Thank you very much for your reply and it is taking me somewhere. I have taken time to come back and say thanks cause I have been trying to digest your solution. The first...

I have some time series data that I need to resample or downsample at some specific time intervals. The firs column is time in decimal hours. I am tryiong to resample this data every 3 minutse. So I...

Thank you again everyone especially Don for your assistance. This has worked perfectly, and finally here is my script that plots the data the way I want

#! /bin/bash
#
# read each block and...

Don! Thank you.

This works, it does the job for sure, and yes you are right I had a mistake in the data for the first block, its suppossed to be 14 lines in the first block, and the header is...

Thank you vry much for all your advices, I am now working on ta script to use this method and I will report back just now to let you know the result. I want to plot the data once I have read it. and...

I dont even have a sample script cause I dont know where to start from. My data lookes like this
> sat#16 #data: 15 site:UNZA baseline: 205.9151
0.008 -165.2465 35.8109 40.6685 ...

Hi kevintse,

Thank you for that explanation and the time you have taken to help. Much appreciated. I am still figuring out how I will add another column there. One way I am thinking is if it is...

Hi kevintse,

Thank you! That indeed does what I need. I don't fully understand what the fine detail of how this line does the job.

I have one extra question, what if I want to add another...

I need some help. I have a list of files (thousands) and would like to extract some variables from the file name and save that to a file

The list of files look like:
I am trying to write the...

Thank you Chubler_XL (https://www.unix.com/members/302085178.html)! it works perfectly. I thought I had understood this command but I realize I have not fully understood what the command really does....

Hi vgersh99 and all,

Thank you for your help. The solution you gave works well, just a small problem I am not able to solve and have tried to do this by mysellf as a way to learn more how to use...

Oh! wow!

Works exactly what I needed! I surely need to have a manual/book for awk/nawk

Thanks you so much ..vgersh99

Hi all,

I have a file that looks like shown below. I want to find places where the value in column 2 change from negative to positive and vice versa and return the value on column 1 at that point....

Wow!... this is great! Thanks you all! this works perfectly.

I very much appreciate your help!

thanks

vbe,

I appreciate your advice, I am very new to forums and I see people post things here in nicer ways but I had no idea how to do that. Just now after your reply I am looking through here and I...