How to extract multiple matches into separate rows?

1 次查看（过去 30 天）
Nadeera Gunartna
Nadeera Gunartna 2017-7-19
评论： Nadeera Gunartna 2017-7-19
I have a CSV file (see attached), from the file i want to extract values in the column M (Cab/100kg=f) related to each group (x, y, z) and then plot the plot the frequency of column f against the value in f, related to each group and predict lognormal distribution. and then need to calculate variance. I appreciate if anybody can help with this.
Thanks in advance.

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

回答（1 个）

Andrei Bobrov
Andrei Bobrov 2017-7-19
编辑：Andrei Bobrov 2017-7-19
T = readtable('test sheet.csv');
T_variance = varfun(@var,T(:,[1,end]),'G','Groups');
for plotted
For_plot = accumarray(findgroups(T.Groups),T{:,'Cab_100kg'},[],@(x){x});
y = [cellfun(@(x)(1:numel(x))',For_plot,'un',0),For_plot]';
plot(y{:});
  1 个评论
Nadeera Gunartna
Nadeera Gunartna 2017-7-19
Many Thanks. first two lines gives the answer for variance. But before get the answer I have to check the data fit with lognormal distribution, if it only fits, then have to calculate. Thanks again.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Lognormal Distribution 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by