How to create parametric table names

Question

Ugur Acar 2019-10-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/486959-how-to-create-parametric-table-names

评论： Ugur Acar 2019-10-23

采纳的回答： Gustavo Liñán Cembrano

在 MATLAB Online 中打开

I have a table 59x7 named as 'all_cities'. (Number of rows may change according to avaible data)

I exract the values according to station name. Second column is the station names(Istasyon_Adi).

names_table=all_cities{:,2}; %exract the column where station names are stored
station_names=unique(names_table); % determine the station names one by one

Then, i create unique table containing all other columns/data for each station seperately.

N_station=size(station_names,1); % Number of stations
for i=1:N_station
station_name=station_names(i,1);% determine the station to consider for current loop
station_data=all_cities(all_cities.Istasyon_Adi==station_name,3:7); %create seperate table for considered station
end

But this loop deletes the previous table.

I need to keep all tables created within this loop seperately. Something like this;

N_station=size(station_names,1); % Number of stations
for i=1:N_station
station_name=station_names(i,1);% determine the station to consider for current loop
station_data(i)=all_cities(all_cities.Istasyon_Adi==station_name,3:7); %create seperate table for considered station
end

After that, i need to save the all tables created in the loop with file names which are the same as station name(station_name.xlsx)

N_station=size(station_names,1); % Number of stations
for i=1:N_station
station_name=station_names(i,1);% determine the station to consider for current loop
station_data(i)=all_cities(all_cities.Istasyon_Adi==station_name,3:7); %create seperate table for considered station
writetable(station_data(i),'station_name.xlsx');% write this table to excel file, assign file names as station name considered for this loop
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2019-10-23

We recommend against that!

http://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval

请先登录，再进行评论。

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

Answer 1

Gustavo Liñán Cembrano 2019-10-23

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/486959-how-to-create-parametric-table-names#answer_397829

在 MATLAB Online 中打开

Have you tried creating a struct for your data?

MyStation=struct('name',[],'data',[]);
for i=1:N_station
MyStation(i).name=station_names(i,1);
MyStation(i).data=all_cities(all_cities.Istasyon_Adi==station_name,3:7); 
MyResultFilename=strcat(MyStation(i).name,'.xlsx');
xlswrite(MyResultFilename,MyStation(i).data);
end

then in the struct, in your workspace you have all the information in a single variable MyStation, which has as N_station elements

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ugur Acar 2019-10-23

在 MATLAB Online 中打开

that seems to work, thank you Gustavo Liñán Cembrano

MyStation=struct('Name',[],'Data',[]);
for i=1:N_station
MyStation(i).Name=station_names(i,1);
MyStation(i).Data=all_cities(all_cities.Istasyon_Adi==MyStation(i).Name,3:7); 
MyResultFilename=char(strcat(cellstr(MyStation(i).Name),'.xlsx'));
xlswrite(MyResultFilename,table2array(MyStation(1).Data));
end