Finding a variable in a large table
조회 수: 1 (최근 30일)
이전 댓글 표시
I'm quite a novice to MATLAB so apologies for any language I may use which may be confusing
I have a 2570x16 sized table, which relates to data about every UK train station, i.e. usage statistics, I have written a menu function which allows the selected station to become a string, what do I need to do so that the Station can be found in the name column, and then this can be used to recall the other 15 parts of data about the station?
Many thanks
댓글 수: 0
채택된 답변
Voss
2022년 12월 8일
% a table with station names and other info:
t = table(["Picadilly Circus"; "St. John's Wood"; "Cockfosters"],rand(3,1),rand(3,1), ...
'VariableNames',{'name' 'other info 1' 'other info 2'})
% the station you want to know about:
station = "Cockfosters";
% get all the info about that station:
result = t(strcmp(t.name,station),:) % result is a table with one row
% and/or get just the "other info" for that station:
% (this assumes 'name' is the first column of the table)
result = t{strcmp(t.name,station),2:end} % result is a numeric array in this case
추가 답변 (2개)
Jon
2022년 12월 8일
편집: Jon
2022년 12월 8일
Here's a simple example, which I think you could extend to your situation
% make an example table
name = {'fish','cat','dog','cat','mouse','mouse','fish','cat'}'
weight = [0.8, 1.3, 2.2, 1.1, 0.2, 0.3, 0.9, 1.4]'
bodyLength = [102,503,608, 429,15,18, 154,496]'
T = table(name,weight,bodyLength)
% get the weights and lengths of all of the cats
idl = strcmp('cat',T.name);
Tcat = T(idl,:) % a table with just cat data
% or if you just want the weight of the fish
idl = strcmp('fish',T.name);
wFish = T.weight(idl)
댓글 수: 0
Bora Eryilmaz
2022년 12월 8일
편집: Bora Eryilmaz
2022년 12월 8일
% Create a table
T = table;
T.Name = ["London"; "Paris"];
T.Data1 = {15; 20};
T.Data2 = {-1; 2};
T
% Find index of Name
I = strcmp(T.Name, 'Paris');
% Find data for that Name
T{I,:}
% or, extract data as its own 1-row table
T(I,:)
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!