Setting min and max values

13 views (last 30 days)
Cristian Martin
Cristian Martin on 23 Jul 2022
Commented: Cristian Martin on 23 Jul 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

Accepted Answer

Matt J
Matt J on 23 Jul 2022
Edited: Matt J on 23 Jul 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

More Answers (0)

Products


Release

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by