Clear Filters
Clear Filters

splitting a large column into smaller columns

1 view (last 30 days)
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?

Answers (1)

Ayush Modi
Ayush Modi on 30 Aug 2024
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:

Categories

Find more on Get Started with Optimization Toolbox in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!