Hi,
I am in stage of post processing some of my results. I wanted to plot the data against the three axis x,y,z. The data file is quite complicated and i have to take the average of x, y,z over different steps of my test. A typical file look like below:
HTML Code:
Time taken:4s
No.of series : 3
Step:1
ID X Y z
1 0.1 0.4 0.45
2 1.2 -1.2 0.25
3 -0.5 -1.2 0.26
3 0.8 -2.1 1.45
1 1.2 -8.2 0.25
2 0.25 1.2 0.25
Time taken:5s
No.of series : 3
Step:2
ID X Y z
3 1.0 0.1 0.5
1 -2.0 -0.2 0.25
2 -0.4 -0.2 -0.60
2 -0.1 -1.1 -0.45
3 0.2 -0.2 0.25
1 1.1 -1.2 0.25
What i wanted to do?
From the above data, i wanted to get the average of values of X , Y , Z (column 2,3,4) along with Column 1 with title as their corresponding step number (i.e) Step.
The thing is that original file is so big that the number of IDs here shown as 3 is actually 600 and the steps are around 25000 which is shown here as two steps.I wanted to delete these following lines (which is displayed inbetween the steps ) while doing this automatically :
HTML Code:
Time taken:5s
No.of series : 3
Expected Output : I am in need of an output as a file, which exactly looks like this:
HTML Code:
Step:1
ID X Y z
1 0.65 -3.9 0.35
2 0.725 0 0.25
3 0.15 -1.65 0.855
Step:2
ID X Y z
1 -0.45 -0.7 0.25
2 -0.25 -0.65 -0.525
3 0.6 -0.05 0.375
I would much thankfull for your immediate inputs on making a script for achieving the above result.