Selecting a portion of the tables

10 次查看（过去 30 天）
BN
BN 2020-1-16
评论： Adam Danz 2020-1-16
I have C.mat which includes 125 tables. I need to list only the first row of each 125 tables and put them under each other. I want only station_name, lat, and lon columns.
something like this:
station_name lat lon
Abadan 30.37 48.21
Abadeh 31.19 52.61
Abali 35.75 51.88
... ... ...
I was attached C.mat for you.

请先登录，再回答此问题。

采纳的回答

Adam Danz
Adam Danz 2020-1-16
% extract row 1 of each table stored in cell array C
firstRows = cellfun(@(m)m(1,:),C,'UniformOutput',false).';
% Vertically concatenate the first-rows into new table
T = vertcat(firstRows{:});
  2 个评论
BN
BN 2020-1-16
Thank you. I didn't know that. Then I simply use this to remove unwanted columns:
T = removevars(T,{'station_id','region_id', 'station_elevation', 'data', 'tmax_m', 'tmin_m', 'rrr24', 'tm_m'});
Adam Danz
Adam Danz 2020-1-16
Or, if you know the column numbers and you know that all tables have the same column order, you could specify a vector of column numbers here
firstRows = cellfun(@(m)m(1,COLUMN_NUMBERS),C,'UniformOutput',false).';
% ^^^^^^^^^^^^^^

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by