Data Parsing

Question

Robbie 2012-2-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/30197-data-parsing

回答： Sushranth 2021-6-24

I have some data in the following format:

100000000000000  0.750000000000000  0.229230000000000
200000000000000  0.750000000000000  0.249220000000000
200000000000000  0.760000000000000  0.257400000000000
200000000000000  0.770000000000000  0.266600000000000
200000000000000  0.780000000000000  0.277160000000000
200000000000000  0.790000000000000  0.289840000000000
200000000000000  0.800000000000000  0.307550000000000
400000000000000  0.750000000000000  0.289260000000000
400000000000000  0.760000000000000  0.299330000000000
400000000000000  0.770000000000000  0.310670000000000
400000000000000  0.780000000000000  0.325160000000000
400000000000000  0.790000000000000  0.339120000000000
400000000000000  0.800000000000000  0.356690000000000
600000000000000  0.740000000000000  0.319580000000000
600000000000000  0.750000000000000  0.329360000000000
600000000000000  0.760000000000000  0.341200000000000
600000000000000  0.770000000000000  0.355150000000000
600000000000000  0.780000000000000  0.370290000000000
600000000000000  0.790000000000000  0.389880000000000
600000000000000  0.800000000000000  0.409590000000000
800000000000000  0.740000000000000  0.358500000000000
800000000000000  0.750000000000000  0.370750000000000
800000000000000  0.760000000000000  0.384590000000000
800000000000000  0.770000000000000  0.400020000000000
800000000000000  0.780000000000000  0.420100000000000
800000000000000  0.790000000000000  0.433160000000000
800000000000000  0.800000000000000  0.456660000000000
What I want to be able to do is split this data in a 'row-wise' sense by putting it into a struct. There are multiple occurences of values in the first column and I want to extract them and the other data associated with those in the other columns. For example I want:

Output.'0.1' Output.'0.2' etc....

In Output.'0.2' then for example I would get the following data:

200000000000000  0.750000000000000  0.249220000000000
200000000000000  0.760000000000000  0.257400000000000
200000000000000  0.770000000000000  0.266600000000000
200000000000000  0.780000000000000  0.277160000000000
200000000000000  0.790000000000000  0.289840000000000
200000000000000  0.800000000000000  0.307550000000000

Any suggestions are greatly appreciated.

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Sushranth 2021-6-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/30197-data-parsing#answer_732405

It is my understanding that you want to establish a key - value relationship in your dataset where the first column corresponds to the keys. A Map container might be better suited for your use case than a struct.

I will assume that the dataset is stored as a matrix.

%Let t be a matrix that contains the data.
keys = unique(t(:,1)); %Extract unique values from the first column
values = {};
for k=1:length(keys) %Iterate over all the keys
    key = keys(k);
    row_idx = (t(:,1) == key); %Find the row index in the data that corresponds to the key.
    values{k} = t(row_idx,:); % Extract those rows from the data and add it to the values cell array.
end
M = containers.Map(keys,values); % Use the keys and values to create a Map 