averaging columns in a table based on two other columns
4 views (last 30 days)
Show older comments
I am importing data from many csv files in a cell and they are tables. each table has 9 columns. They look like this:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1031370/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1031375/image.png)
Now, I want to average the displacement_pixel_ column for the values that have same y coordinate but move horizontally/ x pixels varying. For example I want to average the displacements for (x,y) = (168,40),(184,40)......(344,40) which will be mean(0.0843,0.01028,........0.3619).
That way I get a one column vector of all displcaemnt averaged over horizonatal direction. It's a 16*16 grid. Would anyone please be able to recommend something?
Thanks.
0 Comments
Answers (1)
Peter Perkins
on 14 Jun 2022
This should be straight-forward using either groupsummary, or varfun with displacement_pixel as the input/data variable and x_pixel as the grouping variable. I don't know where 16*16 figures into this, I don't know what you want to do across tables.
0 Comments
See Also
Categories
Find more on Assembly in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!