automating many column headings in table

조회 수: 1 (최근 30일)
Kitt
Kitt 2025년 1월 30일
댓글: Kitt 2025년 1월 30일
I have a 10000x400 matrix, plotphys, I want to turn into a table and add variable names to. I understand that can be done easily with the array2table function. However adding 400 headings is a lot; luckily I want the headings uniform in that they would be labeled
'phys state at tstep 1', 'phys state at tstep 2', ..., 'phys state at tstep 400'
Is there a way I can basically automate the creation of the headings?
I tried this
head = join("phys state at tstep " + [1:1:400]);
phystable = array2table(plotphys, 'VariableNames', {head});
but that did not work
  댓글 수: 2
Stephen23
Stephen23 2025년 1월 30일
편집: Stephen23 2025년 1월 30일
"but that did not work"
Why did you place the string vector inside a scalar cell array?
H = "phys state at tstep "+(1:4);
T = array2table(rand(3,4), 'VariableNames',H)
T = 3x4 table
phys state at tstep 1 phys state at tstep 2 phys state at tstep 3 phys state at tstep 4 _____________________ _____________________ _____________________ _____________________ 0.76686 0.75948 0.54232 0.41293 0.90409 0.21268 0.53549 0.085162 0.6571 0.58643 0.12335 0.27153
Kitt
Kitt 2025년 1월 30일
I realized soon after posting that mistake.

댓글을 달려면 로그인하십시오.

채택된 답변

Star Strider
Star Strider 2025년 1월 30일
Perhaps something like this —
A = randn(5,10);
T1 = array2table(A, VariableNames=compose('physical state at step %4d',1:size(A,2)))
T1 = 5x10 table
physical state at step 1 physical state at step 2 physical state at step 3 physical state at step 4 physical state at step 5 physical state at step 6 physical state at step 7 physical state at step 8 physical state at step 9 physical state at step 10 ___________________________ ___________________________ ___________________________ ___________________________ ___________________________ ___________________________ ___________________________ ___________________________ ___________________________ ___________________________ 0.31324 -0.19263 -2.0615 1.232 1.6304 0.19888 -0.32731 -0.32365 1.5333 0.053857 -2.0234 0.3876 -0.24662 0.13594 -0.9818 0.42247 0.74257 1.2531 0.61061 0.41824 -0.18386 -0.80418 -0.20084 -0.13171 0.9856 -0.21378 -0.45269 0.65468 0.92563 0.2902 -0.11079 -0.91047 -1.0124 -1.2269 -1.5752 -1.095 1.2228 0.19872 -0.14992 -0.43974 0.33118 0.11423 -0.59569 -1.6067 0.71875 0.81034 -0.16905 -0.55092 1.6094 -0.43537
.
  댓글 수: 2
Walter Roberson
Walter Roberson 2025년 1월 30일
편집: Walter Roberson 2025년 1월 30일
The above uses column names 'physical state at step' followed by a 4 digit number that is right-justified with proceeding spaces -- which is certainly a valid option.
However, if you would prefer to use numbers that have no leading or trailing spaces, then
A = randn(5,10);
T1 = array2table(A, VariableNames="physical state at step "+(1:size(A,2)))
T1 = 5x10 table
physical state at step 1 physical state at step 2 physical state at step 3 physical state at step 4 physical state at step 5 physical state at step 6 physical state at step 7 physical state at step 8 physical state at step 9 physical state at step 10 ________________________ ________________________ ________________________ ________________________ ________________________ ________________________ ________________________ ________________________ ________________________ _________________________ 0.41494 0.89537 0.88637 0.37133 1.5025 -0.23928 0.2796 -0.44267 1.8121 -0.69052 0.62765 -0.29731 -0.76789 0.91972 -0.33827 1.2079 0.75478 0.45772 -0.56342 0.60929 1.6159 0.27437 -1.7607 -0.1301 0.91395 -0.44986 -0.50988 1.0761 -2.3117 -1.326 -1.2961 -1.055 -0.42641 0.51182 -0.45815 -1.1123 -0.54415 1.3361 0.11306 0.82966 -0.75849 -0.42926 0.011669 -0.72911 0.54695 -0.47057 -0.12814 -0.25768 0.59814 1.5258
Kitt
Kitt 2025년 1월 30일
that worked perfectly!!!! Thank you so much :)

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Data Preprocessing에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by