Read data with repeat counts
Show older comments
I have a data file containing numbers with repeat counts denoted by asterisk of the following format: 750.013 2*748.943 2*748.221 ... which is equivalent to 750.013 748.943 748.943 748.221 748.221 ... How can I read this data into a vector? That is, how can I take into account the repeat count operator (*) while reading the data?
Accepted Answer
More Answers (2)
hello
maybe this ?
data_string = "750.013 2*748.943 2*748.221"; % data imported as string array
data_string2 = split(data_string,' ');
%% main loop
store_value = [];
for k = 1:numel(data_string2)
tmp = char(data_string2(k));
ind = strfind(tmp,"*");
if ~isempty(ind) % we have 2*748.943 data (or alike
factor = str2num(tmp(1:ind-1));
value = str2num(tmp(ind+1:end));
value_all = repmat(value,[factor 1]);
store_value = [store_value;value_all];
else % we have a single value
store_value = [store_value;str2num(tmp)];
end
end
store_value
1 Comment
Dyuman Joshi
on 6 Oct 2023
@Mathieu NOE, rather than growing the output dynamically, a better approach would be to preallocate according to the size of data_string2, find and store the number before asterisk for each element (if it does not exist, assign 1) and then use repelem on the unique elements.
Here is one approach.
data_strings = ["750.013"; "2*748.943"; "2*748.221"] % sample input data
iData = 1;
for iStr = 1:numel(data_strings)
if contains(data_strings(iStr), "*")
tmp = split(data_strings(iStr), "*");
rpt = str2double(tmp(1));
data(iData:(iData + rpt - 1)) = str2double(tmp(2));
else
rpt = 1;
data(iData) = str2double(data_strings(iStr));
end
iData = iData + rpt;
end
disp(data)
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!