Remove matrix from cell array that doesn't fit required matrix size

Question

Killian Flynn 2022-12-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1868453-remove-matrix-from-cell-array-that-doesn-t-fit-required-matrix-size

回答： Mathieu NOE 2022-12-1

EURUSD=X.csv

Hello. I am trying to make a cell array which splits the data into sets of 20 days. This nearly works but for the last set which is DataE20(14) I get a 4x2 array instead of the wanted 4x20. Is there any way to remove this to only get 4x20?

data =readtable('EURUSD=X.csv')
Open = data(:,2);
High= data(:,3);
Low = data(:,4);
Close = data(:,5);
%Store the data Open,High, Low and Close for every 20 days in the variable
%DataE20
G = floor((0:height(data)-1)/20).' + 1;
DataE20 = splitapply(@(Date,Open,High,Low,Close,AdjClose,Volume) {[Open,High,Low,Close].'}, data, G)
celldisp(DataE20(14))

Any help would be greatly appreciated. Thank you.

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

请先登录，再进行评论。

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

Answer 1

Mathieu NOE 2022-12-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1868453-remove-matrix-from-cell-array-that-doesn-t-fit-required-matrix-size#answer_1117413

在 MATLAB Online 中打开

hello

this will remove the unwanted trailing data

data =readtable('EURUSD=X.csv')
[m,n] = size(data);
k = floor(m/20)*20; % gives me exact number of rows of data for 20 days period
data = data(1:k,:); % removes extra unwanted trailing data
Open = data(:,2);
High= data(:,3);
Low = data(:,4);
Close = data(:,5);
%Store the data Open,High, Low and Close for every 20 days in the variable
%DataE20
G = floor((0:height(data)-1)/20).' + 1;
DataE20 = splitapply(@(Date,Open,High,Low,Close,AdjClose,Volume) {[Open,High,Low,Close].'}, data, G)