splitting a large column into smaller columns
2 次查看(过去 30 天)
显示 更早的评论
Hi there, just a simple question, I want to split a column conatiniing 6600 cell into 7 coulmns. who can give a code to make it automatically?
0 个评论
回答(1 个)
Ayush Modi
2024-8-30
Hi Ahmed,
You can use "reshape" function to reshape array by rearranging existing elements. However, "reshape" function requires the number of total elements in the array to be compatible. To make a column of size 7, total elements should be divisible by 7. As 6600 is not divisible by 7, we will need to append elements in the original array to make it compatible. Here is the code to get you started:
data = num2cell(1:6600)'; % Original array
numRows = ceil(length(data) / 7);
numPadding = numRows * 7 - length(data);
paddedData = [data; num2cell(nan(numPadding, 1))];
size(paddedData)
You can use "reshape" function on the padded data, to get the desired array:
reshapedData = reshape(paddedData, [7, numRows])';
size(reshapedData)
Refer the following MathWorks documentation for more information on "reshape" function:
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Get Started with Optimization Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!