create a struct based on user id

3 次查看（过去 30 天）
elisa ewin
elisa ewin 2016-5-30
评论： Andrei Bobrov 2016-5-30
Hi! I have a set of location records called LocationRecords = [usersID, years month, day, hour, minuts, seconds, latitude, longitude, regionID], attached. I want to create a struct of data in which I can put the date associated to every user id. E.g If I have
LocationRecords=[14 2009 3 17 16 14 2 0.528229037988558 -1.70585947774536 9247;14 2009 3 17 2 33 10 0.528288412470045 -1.70598280759199 9465;14 2009 3 17 2 32 24 0.528288412470045 -1.70598280759199 9313;62 2009 3 15 19 17 34 0.528256895934005 -1.70598404814585 9223;89 2009 3 15 17 41 20 0.528261141300802 -1.70596368432656 9250]
I will obtain a struct 1x3 in which put the data associated to user with id=14, id=62 and id=89, can you help me?
  2 个评论
Stephen23
Stephen23 2016-5-30
编辑：Stephen23 2016-5-30
@elisa ewin: how do you want repeated IDs handled? Most of the IDs occur on multiple lines.
elisa ewin
elisa ewin 2016-5-30
I want to repeated IDs in every row; example
struct<1,1>=[14 2009 3 17 16 14 2 0.528229037988558 -1.70585947774536 9247;14 2009 3 17 2 33 10 0.528288412470045 -1.70598280759199 9465;14 2009 3 17 2 32 24 0.528288412470045 -1.70598280759199 9313]
struct<1,2>=[62 2009 3 15 19 17 34 0.528256895934005 -1.70598404814585 9223]
struct<1,3>=[89 2009 3 15 17 41 20 0.528261141300802 -1.70596368432656 9250]

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2016-5-30
编辑：Andrei Bobrov 2016-5-30
[a,~,b] = unique(LocationRecords(:,1));
x = cellfun(@(x)sprintf('id_%d',x),num2cell(a),'un',0);
y = accumarray(b,(1:numel(b))',[],@(x){LocationRecords(x,2:end)});
C = cell2struct(y,x,1);
  2 个评论
elisa ewin
elisa ewin 2016-5-30
it run, but give an error in code row
C = cell2struct(y,x,1);
Error using cell2struct
Invalid field name "14"

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by