Error while creating a table from cell

1 visualizzazione (ultimi 30 giorni)
AL
AL il 11 Apr 2023
Commentato: Star Strider il 11 Apr 2023
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

Accedi per rispondere a questa domanda.

Risposta accettata

Star Strider
Star Strider il 11 Apr 2023
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 Commenti
AL
AL il 11 Apr 2023
Worked perfectly! Thank you so much @Star Strider
Star Strider
Star Strider il 11 Apr 2023
As always, my pleasure!

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Logical in Help Center e File Exchange

Tag

Prodotti


Release

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by