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?

回答(1 个)

Ayush Modi
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)
ans = 1x2
6601 1
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
You can use "reshape" function on the padded data, to get the desired array:
reshapedData = reshape(paddedData, [7, numRows])';
size(reshapedData)
ans = 1x2
943 7
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
Refer the following MathWorks documentation for more information on "reshape" function:

类别

Help CenterFile 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!

Translated by