Splitting one column into multiple arrays

Question

Ali 2019-9-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/482681-splitting-one-column-into-multiple-arrays

编辑： Ali 2019-9-30

采纳的回答： Ajay Kumar

data.csv

在 MATLAB Online 中打开

I have a table P= 22952x 48. The rows contains data of 25 houses (groups).

I want to split data of each specific group(house) into sperate arrays.

I tried 'splitapply' function but i gives an error.

The data(.CSV) is also attached.

For example:

Home_1= 730x 48
Home_2= 830x 48
.
.
.
.
.
Home_25=198x48
-----------------
Total = 22952 x 48
------------------

2 个评论
显示无隐藏无

dpb 2019-9-29

We don't know how to interpret the data in the file, sorry...what's what in all those rows and columns and what, specifically, are you trying to do?

Also, attach the code you did try and the error text...just paste into the Answer additional info or add as Comment...

Ali 2019-9-29

在 MATLAB Online 中打开

The first Coloumn represents the group ID. There are total 25 groups in first colomns.while the rows are showing their data.I want to split these group id seperately into new tables.

G = findgroups(data.id);

请先登录，再进行评论。

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

Answer 1

Ajay Kumar 2019-9-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/482681-splitting-one-column-into-multiple-arrays#answer_394000

在 MATLAB Online 中打开

z=xlsread('data.csv');
ids = unique(z(:,1),'stable');
houses = cell(length(ids),1);
house = struct();
for i = 1 : length(ids)
    houses{i,1} =  [ 'house' num2str(i) ];
    house.houses{i,1} = z(find(z(:,1)==ids(i)),:);
end

The data of all houses are stored in struct house.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Ajay Kumar 2019-9-29

"all houses data in 1 table?"

You mean like in csv file?

Ali 2019-9-30

编辑：Ali 2019-9-30

在 MATLAB Online 中打开

7016374391872188638.jpg

I want to arrange data in following way:

1). Group each categaries seprately and store in array/cell.

2).Generate artificial dates starting from

01-april-2012 00:00 % 30 minutes interval for 24hrs

to

31-March-2014 23:30

3). Store each house data in single column along the time series as shown in attached figure.

4.) Store all data in one table like:

% Form table
Col 1                 Col 2             Col 3         ...................... Col 26
Date and time         House A (data)      House b (data).................... House z data         