Setting min and max values
18 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Cristian Martin
le 23 Juil 2022
Commenté : Cristian Martin
le 23 Juil 2022
Hi there !
I have a csv imported in an SQL table, 3 columns have numeric data's such as min, max and fixed value, I wrote a script wich gather min and max value from all 3 column and display in an edit text boxes.
How can a set the column format for csv or SQL so when i import the table in a uitable in gui where the row is empty to show NaN, otherwise the min value showned in a min edit text box is 0. In this case should be 0.05 based on capture attached.
data = cell2table(data);
max_col5 = max(data{:,5});
max_col6 = max(data{:,6});
max_col7 = max(data{:,7});
max_col567 = max([max_col5; max_col6; max_col7]);
min_col5 = min(data{:,5});
min_col6 = min(data{:,6});
min_col7 = min(data{:,7});
min_col567 = min([min_col5; min_col6; min_col7]);
set(handles.edit13,'string',min_col567);%MIN 1
set(handles.edit14,'string',max_col567);%MAX 1
Thanks
0 commentaires
Réponse acceptée
Matt J
le 23 Juil 2022
Modifié(e) : Matt J
le 23 Juil 2022
data = cell2table(data);
max_col567 = max(data{:,5:7},[],'all');
min_col567 = min(data{:,5:7},[],'all');
fmt=fillmissing(string(A),'constant',"NaN");
set(handles.edit13,'string',fmt( min_col567 ));%MIN 1
set(handles.edit14,'string',fmt( max_col567) );%MAX 1
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Language Fundamentals 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!