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

조회 수: 1 (최근 30일)
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.

답변 (1개)

KSSV
KSSV 2023년 1월 29일
편집: Steven Lord 2023년 1월 29일
T = readtable(file,'HeaderLines',1) ;
data = table2array(T) ;
m = mean(data)
[SL: fixed typo]
  댓글 수: 1
TehSharkDood
TehSharkDood 2023년 1월 29일
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.

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by