Average every 3 Rows in Single Column in Table

2 次查看(过去 30 天)
I have a column in a table where I want to make a new column of data based on the average of every 3 values in that column. Tried some other solutions here but none seemed to work for me.

采纳的回答

KALYAN ACHARJYA
KALYAN ACHARJYA 2021-2-21
编辑:KALYAN ACHARJYA 2021-2-21
Lets consider one Table Example
LastName = {'A';'B';'C';'D';'E';'F'};
Age = [38;43;38;40;49;50];
T = table(LastName,Age);
Table
T =
6×2 table
LastName Age
_______ ___
{'A'} 38
{'B'} 43
{'C'} 38
{'D'} 40
{'E'} 49
{'F'} 50
Access the particular column, let's say age data
age_col=T.Age
Result:
>> age_col=T.Age
age_col =
38
43
38
40
49
50
Now Average the 3 consecutive rows of the column vector. Easiest way reshape the data then mean
data1=reshape(age_col,[3,2])
%........................^ you can generelize this sizes
Next find the mean and transpose
av_result=mean(data1)'
Result:
av_result =
39.6667
46.3333
  2 个评论
Spencer Ferris
Spencer Ferris 2021-2-21
编辑:Spencer Ferris 2021-2-21
Thanks so much! So this worked perfectly, only thing is my output for one of them was 2.307 when it should have been 2,307. Looks like it divided everything by 1000 for some reason?
Here's exactly what I did. It's giving me the correct values just everything is divided by 1000. I tried multiplying xcoord_divided by 1000 but that didn't seem to do anything.
EDIT: Just realized that it was just how matlab was displaying the values, all set and thank you!
xcoord = practice.x
xcoord_reshaped = reshape(xcoord,[3,length(xcoord)/3])
xcoord_divided= mean(xcoord_reshaped)'

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by