28 reputation
7
bio website
location
age
visits member for 1 year, 6 months
seen Jul 28 at 11:44

May
19
awarded  Popular Question
Apr
17
awarded  Tumbleweed
Feb
20
accepted AWK for data smoothing
Feb
20
answered AWK for data smoothing
Feb
13
awarded  Commentator
Feb
13
comment AWK for data smoothing
I tried your script in python... Works fine!! Thank you!!! Works fine on the example but fails if there is a different number of column in the input. My input files doesn't have always the same number of column. How Can I calculate the number of culumn and execute the average on column from 4 to last column? The script fails also if one field is empty; Is it possible to consider empty fields as 0? The script in AWK don't work, but maybe I made some mistake... I'll verify
Feb
13
comment AWK for data smoothing
Bonjour @Gilles, I tried you awk script but as reslult I obtain a file that is the copy of the original... no vaerage is made. No errors are showed on terminal. I changed only these two things : FS=OFS=";" RS="\r\n" . Have you tried the script? Is working well with you?
Feb
12
revised AWK for data smoothing
added 1 characters in body
Feb
12
awarded  Custodian
Feb
12
reviewed Approve suggested edit on AWK for data smoothing
Feb
12
asked AWK for data smoothing
Jan
17
revised Data pivot with awk
edited title
Jan
17
awarded  Scholar
Jan
17
comment Data pivot with awk
thank you again
Jan
17
accepted Data pivot with awk
Jan
16
revised Data pivot with awk
added 40 characters in body; edited title
Jan
16
comment Data pivot with awk
Thank you @steve I modified the awk script as you write. It's work very well. I hope this discussion will help other people
Jan
14
comment Data pivot with awk
Update: script fails when numbers are present in this format: 1E-02
Jan
14
comment Data pivot with awk
The script fully work whit the example but I tried on an other file and fails. I tried whit a real file that I must edit whit this script... I don't know why but something goes wrong (unexpected line break after column 2)... What's the difference between my example and this file? Did I something wrong? Here there is the output
Jan
14
comment Data pivot with awk
Perfect works Good!!! Tank you a lot