Convert 1x1 cell array to double

5 次查看（过去 30 天）
Pablo
Pablo 2023-8-2
评论： Pablo 2023-8-2
Hi all,
I am trying to extract some data for plotting from a .csv file (find attached obtained from a simulation program. The problem is, when I import the data as a table, then the values I want to extract have the following form:
1x1 cell array : {'0.000202796 0.000207569 0.000211678 0.001893233 0.001898714 0.001899608 0.008668105 ... '}
I manage to extract the data succesfully (rttTime double vector) , but I am not sure if there is a more efficient way of doing it:
It would be great to have suggestions, how to improve it, also I am open for suggestions concerning the import of data from the .csv file.
Kind regards,
Pablo
% read data with all stats vector
statsTable = readtable("stats_1-trace_vector_example.csv", 'PreserveVariableNames', true);
% Extract index of row containing RTT
rttIdx = statsTable.name == "rtt:vector" & statsTable.attrname == "";
rttTable = statsTable(rttIdx,:);
rttTime = str2double(strsplit(cell2mat(rttTable.vectime)));
rttValues = str2double(strsplit(cell2mat(rttTable.vecvalue)));
plot(rttTime,rttValues);
  2 个评论
Stephen23
Stephen23 2023-8-2
编辑：Stephen23 2023-8-2
Given that rather unfortunate file format (storing vectors of numeric data in quoted strings), your approach seems reasonable and understandable. Of course if efficiency is really the goal then you should replace CELL2MAT with some basic indexing into that cell array. SSCANF might be the fastest approach.
Pablo
Pablo 2023-8-2
All right thank you very much Stephen23! Yes efficiency and specially code cleanness is the goal, that's why I find your approach quite nice, since I don't need the intermediate table.
Yes I know the file format is not the best, it was generated from results of OMNET++ using scavetool. I might have a look how to improve it...

请先登录，再进行评论。

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

回答（2 个）

Stephen23
Stephen23 2023-8-2
编辑：Stephen23 2023-8-2
Ran in:
Here with no intermediate table:
statsTable = readtable("stats_1-trace_vector_example.csv", 'PreserveVariableNames', true);
rttIdx = statsTable.name == "rtt:vector" & statsTable.attrname == "";
rttTime = sscanf(statsTable{rttIdx,'vectime'}{1},'%f',[1,Inf]);
rttValues = sscanf(statsTable{rttIdx,'vecvalue'}{1},'%f',[1,Inf]);
plot(rttTime,rttValues);
rttTable = statsTable(rttIdx,:);
timeit(@() str2double(strsplit(cell2mat(rttTable.vectime))))
ans = 7.0269e-04
timeit(@() str2double(strsplit(rttTable.vectime{1})))
ans = 6.3669e-04
timeit(@() str2num(rttTable.vectime{1}))
ans = 4.0264e-05
timeit(@() sscanf(rttTable.vectime{1},'%f',[1,Inf]))
ans = 3.7764e-05
Bruno Luong
Bruno Luong 2023-8-2
Not sure if it's more efficient but it's shorter
rttTime = str2num(rttTable.vectime{1})
  2 个评论
Bruno Luong
Bruno Luong 2023-8-2
Ran in:
Yes it's more efficient as well
statsTable = webread('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1448087/stats_1-trace_vector_example.csv');
rttIdx = statsTable.name == "rtt:vector" & statsTable.attrname == "";
rttTable = statsTable(rttIdx,:);
rttTime = str2double(strsplit(cell2mat(rttTable.vectime)));
timeit(@() str2double(strsplit(cell2mat(rttTable.vectime))))
ans = 6.3177e-04
timeit(@() str2num(rttTable.vectime{1}))
ans = 4.2768e-05
Pablo
Pablo 2023-8-2
Thank you very much Bruno for your answer!

请先登录，再进行评论。

类别

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

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by