Extracting UITable data for statistical analysis in the app designer

8 次查看（过去 30 天）
Mo
Mo 2023-1-15
评论： Mo 2023-1-18
Hi
In my app designer app, I can get my data from pressing a button as a Table and export tha table to excel for each column. If I have multiple attempts by using the same button, I will get raw data for each pressing. I want to calculate average and Standard deviation of each column and desplay it on EditField as a value (from all rows). This is my code:
I used
Ave = mean(app.UITable.Data{1,1});
but I know {1,1} only get the first row of the first column. I also used (:,1) and {:,1} but none of them worked. I appreciate for any help!?
----------------------------------------------------------------------------------------------
%Button Name: Show Data%
% Button pushed function: ShowDataButton
function ShowDataButtonPushed(app, event)
app.UITable.Data; %my UITable with 3 column and rows%
Ave = mean(app.UITable.Data{1,1}); %calcualte mean value of the first column%
app.MeanRTEditField.Value = Ave; %Dispaly the Mean value%

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

回答（1 个）

Cameron
Cameron 2023-1-15
This worked for me
function ButtonPushed(app, event)
app.UITable.Data = rand(200,4);
app.EditField.Value = mean(app.UITable.Data(:,1));
app.EditField2.Value = std(app.UITable.Data(:,1));
end
  5 个评论
显示 3更早的评论
Mo
Mo 2023-1-16
my table data is numeric (1.25, etc.) and time format (HH:mm:SS.mmm) but I want to extract only the numeric column (RT).

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Develop Apps Using App Designer 的更多信息

标签

产品


版本

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by