Why is my table displaying "1 x 1 table" instead of the actual values

54 views (last 30 days)
Hi guys,
I have a matrix with 400 rows and 6 columns, let's call it "matrix 1".
I want to create a table from "matrix 1" but I want each column of my new table to be the values of 20 rows of column 4 of "matrix 1" (row 1 to 20 in the 1st column; row 21 to 40 in the 2nd column etc), I used this code :
table_matrix1=table(matrix1(1:20, 4),matrix1(21:40, 4),matrix1(41:60, 4))
As a result I get a table which is only displaying "1 x 1 table" in each cell and not the actual values of these cells, and I'd like to create an excel file from this output which is not working... Do you have an idea of what I could do differently to obtain a table with the actual numeric values?
Thanks a lot!
  1 Comment
Ive J
Ive J on 21 Mar 2022
Share your matrix and script you're using. I cannot replicate this behavior:
x = rand(400, 6);
tab = table(x(1:20, 4), x(21:40, 4),x(41:60, 4));
head(tab)
ans = 8×3 table
Var1 Var2 Var3 _________ _______ _________ 0.79904 0.66279 0.62041 0.92164 0.34129 0.78888 0.87002 0.14161 0.62366 0.4431 0.53345 0.89308 0.0011616 0.30561 0.0031691 0.00593 0.59151 0.096618 0.36428 0.30117 0.033949 0.061849 0.55831 0.748

Sign in to comment.

Answers (1)

Peter Perkins
Peter Perkins on 24 Mar 2022
It may be that your matrix1 is not a numeric matrix, but rather is itself a table. You have not provide enough information for anyone to help you.

Categories

Find more on Tables 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!