Selecting a portion of the tables
9 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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.
0 commentaires
Réponse acceptée
Adam Danz
le 16 Jan 2020
% 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 commentaires
Adam Danz
le 16 Jan 2020
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).';
% ^^^^^^^^^^^^^^
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!