필터 지우기
필터 지우기

Error while creating a table from cell

조회 수: 4 (최근 30일)
AL
AL 2023년 4월 11일
댓글: Star Strider 2023년 4월 11일
I have cell containing tables with variables Frequnacy and Mode values, Now i want to create a table where each column represent frequancy and a raw has values of mode for all 48 cells.
something like this.
% Extract frequency values from the first table of Mode_shape
freq_values = Mode_shape{1}.freq;
% Preallocate the output cell array
output_cell = cell(size(freq_values));
% Loop over the frequency values and extract the corresponding Mode values
for i = 1:length(freq_values)
% Find the index of the table that matches the current frequency value
freq_index = find([Mode_shape{:}].freq == freq_values(i), 1);
% Extract the mode values from the matching table
mode_table = Mode_shape{freq_index}.mode;
% Assign the mode table to the output cell array, using the frequency value as the table name
output_cell{i} = array2table(mode_table, 'VariableNames', {'Mode'}, 'RowNames', {'Node 1', 'Node 2', 'Node 3'});
output_cell{i}.Properties.VariableUnits{'Mode'} = 'm';
output_cell{i}.Properties.Description = sprintf('Mode shape for frequency %.2f Hz', freq_values(i));
end

이 질문에 답변하려면 로그인하십시오.

채택된 답변

Star Strider
Star Strider 2023년 4월 11일
Ran in:
Perhaps this —
LD = load('Mode_shape.mat')
LD = struct with fields:
Mode_shape: {1×48 cell} data_cell: {1×48 cell} output_cell: {1×48 cell}
Mode_shape = (LD.Mode_shape);
freq = Mode_shape{1}.freq;
mode = cellfun(@(x)x.mode, Mode_shape, 'Unif',0);
VN = compose('%g',freq);
Mode_table = array2table(cell2mat(mode).', 'VariableNames',VN)
Mode_table = 48×43 table
5 7.5 13.75 18.75 22.5 27.5 32.5 36.25 42.5 45 48.75 51.25 56.25 60 62.5 66.25 68.75 72.5 82.5 90 93.75 100 102.5 108.75 113.75 116.25 120 125 127.5 130 133.75 136.25 140 146.25 153.75 157.5 162.5 170 181.25 185 190 192.5 196.25 ___________ ___________ ___________ ___________ ___________ __________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ __________ __________ ___________ ___________ ___________ __________ ___________ ___________ ___________ ___________ __________ __________ __________ __________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ ___________ -0.00022306 -0.0016559 8.7761e-05 0.00015143 -0.00037047 0.0012073 -6.5725e-05 -0.00066836 -0.00032238 -0.00023063 0.00019979 -0.00033541 0.00012908 -0.00011987 0.0030057 0.00070089 -0.0011947 0.0046722 -0.00073056 -0.000445 0.0008882 -0.0065965 -0.00013824 0.00013091 -0.00015059 0.00068167 0.00030093 0.00067519 -0.012468 0.00075823 0.00020806 0.00020595 0.0001513 -8.4978e-05 5.4239e-05 0.00016389 -0.00030113 0.00015752 0.00088649 0.0002888 0.00029925 0.00035816 0.00035556 0.0010585 -0.00045931 -0.00034242 -0.00020505 -0.00025865 0.00010493 -0.00012892 0.00029278 0.00024352 0.00020516 -0.0022649 -0.0022255 0.00014703 -0.00024902 -0.00090294 0.00035851 0.0007015 0.0055156 0.00052696 -0.00048931 -0.00011389 -0.0050822 9.9918e-05 -0.00010489 -0.00019023 -0.00025328 0.00036361 0.0006332 0.0011313 0.00035317 0.0001357 0.00023074 -0.00020601 0.00022568 8.46e-05 -0.00017713 0.00020139 -0.00029048 -0.00053927 -6.2872e-05 -0.00039034 -0.00039947 0.00046579 0.00073099 0.00032569 -0.00051451 0.0004379 -0.00049416 0.00065033 -0.00016813 0.00056885 0.00042667 0.00041487 -0.00059831 -0.0011214 0.00018872 -0.00095127 -0.0020558 0.0003641 0.00093098 0.0068808 0.00063007 -0.00038808 -0.00044659 0.010847 -0.00029491 -0.00013172 -0.00024745 -0.00031301 0.00046444 0.0007924 0.0015036 0.00043493 0.00013969 0.00019531 0.00026906 0.00030716 0.00011169 -0.00024536 -0.00024983 -0.00035367 -0.00067386 -9.2256e-06 -0.00047333 -0.00043334 0.00054685 0.0015792 0.00041172 -0.00093045 0.00079979 -0.00083817 -0.0010547 -0.00021891 0.0010594 0.00093066 0.00094482 0.0025914 -0.0010534 0.0005142 -0.002352 -0.0034111 0.00038496 0.0013851 0.0079079 0.0012036 -0.00058883 0.00093542 -0.016487 -0.00014497 0.00030468 -0.00020027 -0.00031949 0.00058314 0.00090599 0.0019296 0.0011887 -0.00026586 -0.00024412 -0.0007468 0.00049927 3.1293e-05 -0.00023005 -0.00020065 -0.00030402 -0.00078892 -0.00016859 0.00042184 -0.00028381 0.00047687 0.049654 0.014588 -0.024494 0.021895 0.026002 -0.029692 -0.011238 0.02852 0.024516 0.018375 0.036053 -0.039409 0.033256 -0.039734 0.051033 0.0022463 0.014443 -0.10791 0.022548 -0.032066 0.012914 0.042066 -0.0013377 0.0048018 -0.0055327 -0.0021 0.0017853 -0.015579 -0.022238 -0.013003 -0.011262 -0.014042 -0.014085 0.011083 0.0021498 -0.001693 -0.0030843 -0.0076203 0.010766 0.014158 -0.0034755 -0.011024 -0.0060864 -0.0016825 -0.0039596 -0.0031245 -0.00043814 0.00072298 0.0025337 -0.0098518 -0.0041742 -0.0073536 0.0095366 -0.012729 0.016217 -0.026781 -0.097062 0.19984 -0.011722 -0.034372 -0.4591 -0.020268 -0.048272 -0.024357 -0.016068 -0.012065 0.0080391 -0.0074696 -0.011387 -0.020817 -0.0566 -0.11111 -0.053676 -0.026422 -0.025208 -0.023551 0.0011385 -0.0017844 0.0054547 -0.0098018 -0.018485 0.044829 0.031039 0.017287 -0.021324 -0.024105 0.01606 0.14479 -0.0081702 -0.015032 0.041272 -0.096148 -0.011013 0.046411 -0.026144 0.012076 -0.011502 0.033057 -0.028035 0.052613 0.67397 0.025084 0.063906 -0.51971 0.04996 -0.080176 -0.062208 0.020247 0.0064773 -0.0089061 0.011329 -0.047814 -0.015016 -0.092564 2.7413 -0.13309 -0.047723 -0.029918 0.017482 0.019349 -0.014982 -0.011023 0.0066894 -0.0035687 -0.18135 -0.021132 -0.0085878 -0.0027621 -0.0014435 0.0021447 -0.0045491 -7.043e-05 -0.00088418 0.0016698 0.0036982 -0.017088 -0.0034012 0.0095038 -0.012046 -0.016785 0.020842 -0.037072 0.075055 0.34792 -0.013679 -0.041446 -0.66534 -0.029598 -0.071883 -0.037429 -0.027102 -0.021051 -0.0094996 -0.0034545 -0.0037658 -0.016968 -0.068227 -0.14344 -0.096095 -0.048334 -0.042912 -0.030694 0.016462 -0.01333 -0.0090746 -0.0052538 -0.0040158 0.040318 0.071052 -0.0049818 -0.0012494 -0.0025502 0.00062942 0.021186 -0.0075448 -0.00049322 0.0028289 0.0059789 -0.018503 0.0041889 -0.0116 0.012399 0.016807 0.018877 -0.039794 0.09137 0.86159 0.060013 0.020822 -0.61524 -0.039953 -0.10424 -0.041058 -0.029163 -0.022595 0.024088 0.0045453 -0.0058237 -0.017845 -0.12464 3.0464 -0.12842 -0.054142 -0.042993 -0.04794 0.021813 -0.015475 0.012561 -0.016895 0.00020545 -0.24706 -0.029052 -0.014875 -0.009154 -0.0048909 0.0040029 -0.0058327 -0.0016759 -0.00073156 0.0017538 0.0040849 -0.013795 0.001594 0.0040187 -0.0050266 -0.0083904 -0.0095197 -0.019817 0.02536 0.21314 -0.010331 -0.018253 -0.31408 -0.015018 -0.041084 -0.021747 -0.024228 -0.01322 -0.0109 -0.0082001 -0.0043215 -0.0026221 -0.030885 -0.073215 -0.062776 -0.033568 -0.028766 0.021879 -0.016635 0.015227 -0.013405 -0.011529 0.008504 0.015412 0.053276 0.017246 -0.016954 -0.013869 0.0001297 9.6712e-05 6.889e-05 -4.5405e-05 -4.6137e-05 2.9893e-05 0.00015408 5.4078e-05 -0.00018661 8.925e-05 -0.0001851 -0.00037772 -0.00022679 0.00039548 -0.0028305 9.7705e-05 0.0002869 0.0039924 0.00028217 0.00057842 -0.00037434 0.0062474 0.00074632 0.00014178 -0.00010867 -4.5402e-05 5.5657e-05 0.00036287 0.00089044 0.00071485 0.00040177 0.00037901 -0.00023861 -0.00027746 0.00019773 -0.00018939 -0.00017293 -0.00010665 -0.00016973 -0.00060886 -0.00022983 -0.00014129 0.00019134 0.0032726 -0.00359 0.00071411 -0.00064172 -0.0011413 0.0012236 -0.0095464 0.00077788 -0.0026177 -0.0035969 -0.006593 -0.0067027 -0.013044 0.01477 0.14526 -0.0070539 -0.01255 -0.20578 -0.010377 -0.032306 -0.017334 0.01942 -0.01199 0.0093088 -0.0042216 -0.0028233 -0.0010194 -0.020731 -0.048856 -0.031819 -0.021031 -0.019443 -0.018659 -0.011498 0.010459 -0.009546 -0.0087731 -0.0071331 0.0079838 0.035258 -0.013386 -0.012278 0.011152 0.0056292 0.074674 0.011037 0.004814 0.0034389 -0.026014 0.082408 0.023466 -0.0076986 -0.009262 -0.005851 -0.0088993 -0.010589 0.01939 -0.074393 -0.0088835 0.0090311 -0.36985 -0.025436 -0.079058 -0.046376 0.055077 0.065663 0.20845 -0.051098 -0.34384 0.63685 0.26339 0.7284 -0.16726 0.079314 -0.074224 -0.21373 0.018532 -0.029065 0.033475 -0.03677 -0.086267 0.43882 -0.084361 -0.052197 -0.041538 -0.032404 0.0038941 0.065604 -0.0089704 0.0056951 0.0084221 -0.026489 0.083795 0.016098 -0.003853 -0.0029816 -0.003797 -0.0010269 0.0082151 -0.032731 -0.40723 -0.044616 -0.02084 -0.0039305 0.012758 0.052522 0.024987 0.031371 -0.03412 -0.14462 0.0067964 -0.017267 -0.017616 0.026847 -1.9074 -0.24034 0.032976 0.010718 -0.12205 0.0052314 -0.0094538 0.01378 -0.027159 -0.074479 0.42095 -0.10222 -0.069364 -0.057824 -0.04787 0.0030391 -0.019903 -0.0029086 0.0070488 0.0096886 -0.022375 -0.12382 0.015516 0.00089288 0.0038582 0.012714 0.016497 0.032962 -0.038188 -0.52942 0.033372 0.032976 0.53613 0.048457 0.20114 -0.16711 0.21934 0.52231 -0.065367 -0.027414 -0.077638 -0.27113 -0.33399 -0.17011 -0.10137 -0.074709 -0.070932 0.039059 -0.035192 -0.027706 -0.021493 -0.013789 -0.011271 -0.26063 0.10475 -0.063921 -0.055963 -0.051732 8.017e-05 -0.0011781 0.00032811 -0.00010305 -2.0462e-05 0.00018385 -0.0020468 0.00046982 -9.4929e-05 0.00017416 -0.002814 -0.0018619 0.00053104 -0.0012077 -0.0096924 -0.00083249 0.00018123 0.0095819 0.00075802 0.0029723 0.0016215 0.0066568 -0.0030002 -0.0042755 -0.00036214 0.003495 -0.0048329 -0.010373 0.0043951 0.0023154 -0.001351 -0.0012171 -0.0017774 0.00057074 -0.00042307 0.00036126 -0.00029641 0.00011822 -0.010197 -0.0011368 -0.0007683 -0.00063554 -0.00052968
.
  댓글 수: 2
AL
AL 2023년 4월 11일
Worked perfectly! Thank you so much @Star Strider
Star Strider
Star Strider 2023년 4월 11일
As always, my pleasure!

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

추가 답변 (0개)

카테고리

Help Center 및 File Exchange에서 Loops and Conditional Statements에 대해 자세히 알아보기

태그

제품


릴리스

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by