A general question about syntax regarding an Excel file's rows and columns in MATLAB

1 view (last 30 days)
What is the proper syntax to find the mean average of some Excel file columns imported to MATLAB but let it ignore the top row and consider the rest of the columns?
The picture is an example I made, and I called the file "table", I put a box around the specific data I am trying to find the average of.
I know how to start it: tabledata = mean(table(?)), but the question mark is the syntax I am not sure about.
If anybody could give me guidance on this I would greatly appreciate it.

Answers (1)

KSSV
KSSV on 29 Jan 2023
Edited: Steven Lord on 29 Jan 2023
T = readtable(file,'HeaderLines',1) ;
data = table2array(T) ;
m = mean(data)
[SL: fixed typo]
  1 Comment
TehSharkDood
TehSharkDood on 29 Jan 2023
I don't exactly understand what you have wrote.
What I am trying to do is only consider the values under the thousands and take the mean average of those columns.
I thought it could be written as tabledata = mean(table(2:end)) since the values I only want to consider starts in row 2 and then it goes all the way to the end (number 5 in column six), but this syntax does not give me the right answer.
I want to take the mean of all the values starting at 1 under 10000 in column one and ending at the 5 under 60000 in column six
I hope what I am trying to say makes sense.

Sign in to comment.

Products


Release

R2022b

Community Treasure Hunt

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

Start Hunting!