AvgTb=Tb{1};
AvgTb{1}{:,:}=(Tb{1}{:,:}+Tb{2}{:,:}+Tb{3}{:,:})/3;
You are now following this question
- You will see updates in your followed content feed.
- You may receive emails, depending on your communication preferences.
How to average across tables in a cell
3 views (last 30 days)
Show older comments
I have a Cell containing a n number of tables (in this case 3 tables (2500x44)) and I'm trying output just one table being the average of each cell within each table across all 3 tables. This is likely a silly question but can't seem to figure it out.
Accepted Answer
Matt J
on 20 Aug 2024
Edited: Matt J
on 20 Aug 2024
7 Comments
Voss
on 20 Aug 2024
% a cell array of random tables:
Tb = {array2table(rand(2500,44)),array2table(rand(2500,44)),array2table(rand(2500,44))}
Tb = 1x3 cell array
{2500x44 table} {2500x44 table} {2500x44 table}
% works for 3 tables:
AvgTb = Tb{1};
AvgTb{:,:} = (Tb{1}{:,:}+Tb{2}{:,:}+Tb{3}{:,:})/3
AvgTb = 2500x44 table
Var1 Var2 Var3 Var4 Var5 Var6 Var7 Var8 Var9 Var10 Var11 Var12 Var13 Var14 Var15 Var16 Var17 Var18 Var19 Var20 Var21 Var22 Var23 Var24 Var25 Var26 Var27 Var28 Var29 Var30 Var31 Var32 Var33 Var34 Var35 Var36 Var37 Var38 Var39 Var40 Var41 Var42 Var43 Var44
_______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ ________ _______ _______ _______ _______ ________ _______ _______ ________ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______
0.41018 0.73942 0.75333 0.37089 0.65434 0.53177 0.39299 0.22851 0.4474 0.3598 0.36524 0.36684 0.40242 0.57789 0.39719 0.68968 0.45027 0.64765 0.56051 0.41959 0.94093 0.58909 0.32647 0.6472 0.73271 0.55547 0.6697 0.69246 0.53041 0.4972 0.42411 0.5844 0.51137 0.47417 0.53614 0.4104 0.14948 0.5647 0.42496 0.48552 0.40118 0.59917 0.71337 0.52427
0.14625 0.62049 0.38215 0.61192 0.9119 0.16877 0.36206 0.75736 0.72875 0.65142 0.47544 0.30371 0.63133 0.25987 0.4659 0.71896 0.31596 0.62471 0.33404 0.55204 0.54006 0.59033 0.32402 0.26969 0.26417 0.45824 0.5535 0.44065 0.74227 0.47639 0.031314 0.31105 0.53081 0.50334 0.33234 0.61398 0.42435 0.5107 0.46942 0.51748 0.61489 0.72241 0.5352 0.68471
0.61117 0.55554 0.40714 0.69957 0.5719 0.2332 0.85054 0.63705 0.7635 0.26659 0.68455 0.37591 0.34929 0.52516 0.8473 0.3936 0.41448 0.34484 0.39946 0.51605 0.49188 0.34155 0.21404 0.81639 0.40714 0.19573 0.2826 0.26088 0.89449 0.77309 0.52789 0.55141 0.57312 0.36962 0.46113 0.57864 0.52626 0.6903 0.3979 0.5064 0.281 0.60981 0.38757 0.23151
0.80655 0.86216 0.61069 0.58464 0.56806 0.41743 0.39325 0.47526 0.45946 0.70663 0.38321 0.57171 0.35962 0.71325 0.36677 0.55735 0.54702 0.53974 0.33629 0.75002 0.50512 0.63104 0.45831 0.41343 0.24314 0.52055 0.55302 0.59641 0.51422 0.49438 0.30398 0.28199 0.4279 0.48247 0.46489 0.56095 0.42096 0.55489 0.45032 0.41091 0.6491 0.29014 0.26764 0.59205
0.5263 0.43493 0.54389 0.59291 0.48323 0.56195 0.88921 0.48622 0.36411 0.47256 0.52689 0.61859 0.32796 0.24255 0.35782 0.60564 0.40841 0.17112 0.56976 0.64655 0.5432 0.57277 0.61281 0.53251 0.66733 0.74055 0.31459 0.27146 0.49731 0.58267 0.76865 0.5442 0.54347 0.47073 0.53649 0.22501 0.53596 0.64551 0.76294 0.69777 0.23219 0.6809 0.22819 0.23632
0.62511 0.28488 0.23453 0.51797 0.30586 0.18732 0.35036 0.40713 0.34849 0.60591 0.6632 0.43047 0.69114 0.53629 0.32526 0.1568 0.34281 0.61046 0.47903 0.56441 0.36015 0.4012 0.28072 0.51984 0.74308 0.62125 0.63582 0.6332 0.54465 0.24939 0.40346 0.77085 0.4084 0.077406 0.52711 0.81296 0.60907 0.70195 0.61769 0.65101 0.49828 0.59644 0.50652 0.48286
0.51142 0.52435 0.57926 0.72648 0.49766 0.19274 0.27058 0.69889 0.78285 0.52241 0.51937 0.3901 0.36143 0.24075 0.59402 0.78392 0.17481 0.63167 0.67103 0.43562 0.41065 0.59386 0.20078 0.32767 0.62495 0.091331 0.40606 0.24044 0.56327 0.2433 0.48813 0.57734 0.23297 0.69404 0.49353 0.58204 0.32504 0.35426 0.66283 0.70051 0.78428 0.68649 0.61056 0.60774
0.2995 0.29105 0.44389 0.57486 0.49818 0.27361 0.82277 0.51306 0.6676 0.48763 0.33202 0.74754 0.43694 0.70606 0.76264 0.76668 0.42364 0.29358 0.6392 0.38075 0.58578 0.52549 0.56604 0.58609 0.34195 0.488 0.63713 0.67388 0.56812 0.34503 0.44394 0.19983 0.1842 0.61503 0.60597 0.40281 0.85872 0.44729 0.63509 0.50016 0.582 0.47943 0.19885 0.66562
0.34611 0.55968 0.40529 0.34645 0.61733 0.4991 0.54221 0.2185 0.47353 0.67039 0.59399 0.1841 0.66891 0.62888 0.66595 0.52772 0.58111 0.52604 0.41952 0.65328 0.49517 0.48237 0.43414 0.69885 0.30331 0.87899 0.39856 0.30253 0.32574 0.41372 0.61035 0.38418 0.52432 0.65296 0.42368 0.64212 0.47178 0.75127 0.21092 0.42787 0.41374 0.42477 0.54195 0.36743
0.34778 0.52862 0.52181 0.38321 0.58509 0.69441 0.44666 0.52103 0.63872 0.50766 0.69584 0.64504 0.44081 0.53274 0.45652 0.69224 0.31982 0.6544 0.27914 0.58148 0.59631 0.60967 0.88632 0.31471 0.59544 0.67917 0.2295 0.56721 0.51682 0.75379 0.34803 0.67598 0.60874 0.44662 0.61858 0.30958 0.45834 0.28833 0.48246 0.50508 0.36907 0.61835 0.46105 0.4191
0.59221 0.33425 0.65125 0.67478 0.4853 0.58019 0.66257 0.47645 0.47737 0.42759 0.58587 0.57074 0.52196 0.47703 0.56496 0.51824 0.44556 0.37325 0.64011 0.71505 0.45664 0.66861 0.49065 0.64353 0.5028 0.63506 0.4021 0.63628 0.73849 0.40156 0.5315 0.6206 0.48963 0.50556 0.49974 0.44193 0.63169 0.65845 0.63364 0.55791 0.52484 0.40741 0.4524 0.72361
0.50846 0.55697 0.438 0.71525 0.69028 0.65926 0.51628 0.55503 0.6258 0.73259 0.37386 0.65199 0.48715 0.3159 0.41424 0.43154 0.6881 0.79485 0.48753 0.14726 0.64054 0.60373 0.78254 0.72724 0.51263 0.65096 0.63688 0.60903 0.64775 0.31038 0.4911 0.41608 0.89316 0.38326 0.8915 0.40023 0.41579 0.5166 0.47783 0.43703 0.28541 0.55792 0.58423 0.74376
0.45525 0.58454 0.60338 0.74892 0.36026 0.89681 0.62396 0.51441 0.72619 0.84931 0.79881 0.64561 0.49029 0.54177 0.1488 0.19132 0.59873 0.31446 0.2433 0.54041 0.61139 0.30796 0.60919 0.56347 0.21933 0.48112 0.33004 0.34764 0.65427 0.88379 0.42359 0.85694 0.34943 0.74519 0.18742 0.40912 0.63561 0.69598 0.64795 0.33223 0.38946 0.57092 0.1982 0.18203
0.40297 0.53641 0.3893 0.2399 0.5897 0.59911 0.41139 0.2412 0.59667 0.43732 0.62795 0.26621 0.63151 0.41368 0.39882 0.78034 0.35524 0.57698 0.51876 0.34254 0.16938 0.43085 0.54164 0.71272 0.41585 0.40892 0.74227 0.71813 0.81753 0.46684 0.6166 0.55242 0.34844 0.63201 0.48164 0.50998 0.6269 0.17157 0.569 0.54441 0.46177 0.52922 0.44846 0.65083
0.46006 0.58045 0.76546 0.36849 0.16878 0.66709 0.29535 0.46633 0.2181 0.44468 0.49084 0.5505 0.28021 0.47382 0.46438 0.25973 0.58692 0.371 0.44672 0.47217 0.66126 0.47245 0.35134 0.52458 0.56202 0.65401 0.6475 0.48807 0.52398 0.46846 0.6874 0.49188 0.57354 0.44025 0.82396 0.4306 0.50339 0.37188 0.36597 0.47472 0.46956 0.77883 0.47229 0.70808
0.3829 0.26393 0.35905 0.51691 0.41563 0.52623 0.46331 0.4985 0.49866 0.63182 0.69798 0.68671 0.38473 0.12898 0.48083 0.58709 0.76036 0.49661 0.46583 0.73471 0.32702 0.50869 0.27947 0.69192 0.2006 0.47381 0.48907 0.48891 0.45724 0.34809 0.29188 0.24242 0.4348 0.29123 0.70982 0.25039 0.5995 0.383 0.49347 0.60466 0.33618 0.32151 0.42863 0.35373
% works for any number of tables > 0
AvgTb = Tb{1};
tmp = cellfun(@(t)t{:,:},Tb,'UniformOutput',false);
AvgTb{:,:} = mean(cat(3,tmp{:}),3)
AvgTb = 2500x44 table
Var1 Var2 Var3 Var4 Var5 Var6 Var7 Var8 Var9 Var10 Var11 Var12 Var13 Var14 Var15 Var16 Var17 Var18 Var19 Var20 Var21 Var22 Var23 Var24 Var25 Var26 Var27 Var28 Var29 Var30 Var31 Var32 Var33 Var34 Var35 Var36 Var37 Var38 Var39 Var40 Var41 Var42 Var43 Var44
_______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ ________ _______ _______ _______ _______ ________ _______ _______ ________ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______
0.41018 0.73942 0.75333 0.37089 0.65434 0.53177 0.39299 0.22851 0.4474 0.3598 0.36524 0.36684 0.40242 0.57789 0.39719 0.68968 0.45027 0.64765 0.56051 0.41959 0.94093 0.58909 0.32647 0.6472 0.73271 0.55547 0.6697 0.69246 0.53041 0.4972 0.42411 0.5844 0.51137 0.47417 0.53614 0.4104 0.14948 0.5647 0.42496 0.48552 0.40118 0.59917 0.71337 0.52427
0.14625 0.62049 0.38215 0.61192 0.9119 0.16877 0.36206 0.75736 0.72875 0.65142 0.47544 0.30371 0.63133 0.25987 0.4659 0.71896 0.31596 0.62471 0.33404 0.55204 0.54006 0.59033 0.32402 0.26969 0.26417 0.45824 0.5535 0.44065 0.74227 0.47639 0.031314 0.31105 0.53081 0.50334 0.33234 0.61398 0.42435 0.5107 0.46942 0.51748 0.61489 0.72241 0.5352 0.68471
0.61117 0.55554 0.40714 0.69957 0.5719 0.2332 0.85054 0.63705 0.7635 0.26659 0.68455 0.37591 0.34929 0.52516 0.8473 0.3936 0.41448 0.34484 0.39946 0.51605 0.49188 0.34155 0.21404 0.81639 0.40714 0.19573 0.2826 0.26088 0.89449 0.77309 0.52789 0.55141 0.57312 0.36962 0.46113 0.57864 0.52626 0.6903 0.3979 0.5064 0.281 0.60981 0.38757 0.23151
0.80655 0.86216 0.61069 0.58464 0.56806 0.41743 0.39325 0.47526 0.45946 0.70663 0.38321 0.57171 0.35962 0.71325 0.36677 0.55735 0.54702 0.53974 0.33629 0.75002 0.50512 0.63104 0.45831 0.41343 0.24314 0.52055 0.55302 0.59641 0.51422 0.49438 0.30398 0.28199 0.4279 0.48247 0.46489 0.56095 0.42096 0.55489 0.45032 0.41091 0.6491 0.29014 0.26764 0.59205
0.5263 0.43493 0.54389 0.59291 0.48323 0.56195 0.88921 0.48622 0.36411 0.47256 0.52689 0.61859 0.32796 0.24255 0.35782 0.60564 0.40841 0.17112 0.56976 0.64655 0.5432 0.57277 0.61281 0.53251 0.66733 0.74055 0.31459 0.27146 0.49731 0.58267 0.76865 0.5442 0.54347 0.47073 0.53649 0.22501 0.53596 0.64551 0.76294 0.69777 0.23219 0.6809 0.22819 0.23632
0.62511 0.28488 0.23453 0.51797 0.30586 0.18732 0.35036 0.40713 0.34849 0.60591 0.6632 0.43047 0.69114 0.53629 0.32526 0.1568 0.34281 0.61046 0.47903 0.56441 0.36015 0.4012 0.28072 0.51984 0.74308 0.62125 0.63582 0.6332 0.54465 0.24939 0.40346 0.77085 0.4084 0.077406 0.52711 0.81296 0.60907 0.70195 0.61769 0.65101 0.49828 0.59644 0.50652 0.48286
0.51142 0.52435 0.57926 0.72648 0.49766 0.19274 0.27058 0.69889 0.78285 0.52241 0.51937 0.3901 0.36143 0.24075 0.59402 0.78392 0.17481 0.63167 0.67103 0.43562 0.41065 0.59386 0.20078 0.32767 0.62495 0.091331 0.40606 0.24044 0.56327 0.2433 0.48813 0.57734 0.23297 0.69404 0.49353 0.58204 0.32504 0.35426 0.66283 0.70051 0.78428 0.68649 0.61056 0.60774
0.2995 0.29105 0.44389 0.57486 0.49818 0.27361 0.82277 0.51306 0.6676 0.48763 0.33202 0.74754 0.43694 0.70606 0.76264 0.76668 0.42364 0.29358 0.6392 0.38075 0.58578 0.52549 0.56604 0.58609 0.34195 0.488 0.63713 0.67388 0.56812 0.34503 0.44394 0.19983 0.1842 0.61503 0.60597 0.40281 0.85872 0.44729 0.63509 0.50016 0.582 0.47943 0.19885 0.66562
0.34611 0.55968 0.40529 0.34645 0.61733 0.4991 0.54221 0.2185 0.47353 0.67039 0.59399 0.1841 0.66891 0.62888 0.66595 0.52772 0.58111 0.52604 0.41952 0.65328 0.49517 0.48237 0.43414 0.69885 0.30331 0.87899 0.39856 0.30253 0.32574 0.41372 0.61035 0.38418 0.52432 0.65296 0.42368 0.64212 0.47178 0.75127 0.21092 0.42787 0.41374 0.42477 0.54195 0.36743
0.34778 0.52862 0.52181 0.38321 0.58509 0.69441 0.44666 0.52103 0.63872 0.50766 0.69584 0.64504 0.44081 0.53274 0.45652 0.69224 0.31982 0.6544 0.27914 0.58148 0.59631 0.60967 0.88632 0.31471 0.59544 0.67917 0.2295 0.56721 0.51682 0.75379 0.34803 0.67598 0.60874 0.44662 0.61858 0.30958 0.45834 0.28833 0.48246 0.50508 0.36907 0.61835 0.46105 0.4191
0.59221 0.33425 0.65125 0.67478 0.4853 0.58019 0.66257 0.47645 0.47737 0.42759 0.58587 0.57074 0.52196 0.47703 0.56496 0.51824 0.44556 0.37325 0.64011 0.71505 0.45664 0.66861 0.49065 0.64353 0.5028 0.63506 0.4021 0.63628 0.73849 0.40156 0.5315 0.6206 0.48963 0.50556 0.49974 0.44193 0.63169 0.65845 0.63364 0.55791 0.52484 0.40741 0.4524 0.72361
0.50846 0.55697 0.438 0.71525 0.69028 0.65926 0.51628 0.55503 0.6258 0.73259 0.37386 0.65199 0.48715 0.3159 0.41424 0.43154 0.6881 0.79485 0.48753 0.14726 0.64054 0.60373 0.78254 0.72724 0.51263 0.65096 0.63688 0.60903 0.64775 0.31038 0.4911 0.41608 0.89316 0.38326 0.8915 0.40023 0.41579 0.5166 0.47783 0.43703 0.28541 0.55792 0.58423 0.74376
0.45525 0.58454 0.60338 0.74892 0.36026 0.89681 0.62396 0.51441 0.72619 0.84931 0.79881 0.64561 0.49029 0.54177 0.1488 0.19132 0.59873 0.31446 0.2433 0.54041 0.61139 0.30796 0.60919 0.56347 0.21933 0.48112 0.33004 0.34764 0.65427 0.88379 0.42359 0.85694 0.34943 0.74519 0.18742 0.40912 0.63561 0.69598 0.64795 0.33223 0.38946 0.57092 0.1982 0.18203
0.40297 0.53641 0.3893 0.2399 0.5897 0.59911 0.41139 0.2412 0.59667 0.43732 0.62795 0.26621 0.63151 0.41368 0.39882 0.78034 0.35524 0.57698 0.51876 0.34254 0.16938 0.43085 0.54164 0.71272 0.41585 0.40892 0.74227 0.71813 0.81753 0.46684 0.6166 0.55242 0.34844 0.63201 0.48164 0.50998 0.6269 0.17157 0.569 0.54441 0.46177 0.52922 0.44846 0.65083
0.46006 0.58045 0.76546 0.36849 0.16878 0.66709 0.29535 0.46633 0.2181 0.44468 0.49084 0.5505 0.28021 0.47382 0.46438 0.25973 0.58692 0.371 0.44672 0.47217 0.66126 0.47245 0.35134 0.52458 0.56202 0.65401 0.6475 0.48807 0.52398 0.46846 0.6874 0.49188 0.57354 0.44025 0.82396 0.4306 0.50339 0.37188 0.36597 0.47472 0.46956 0.77883 0.47229 0.70808
0.3829 0.26393 0.35905 0.51691 0.41563 0.52623 0.46331 0.4985 0.49866 0.63182 0.69798 0.68671 0.38473 0.12898 0.48083 0.58709 0.76036 0.49661 0.46583 0.73471 0.32702 0.50869 0.27947 0.69192 0.2006 0.47381 0.48907 0.48891 0.45724 0.34809 0.29188 0.24242 0.4348 0.29123 0.70982 0.25039 0.5995 0.383 0.49347 0.60466 0.33618 0.32151 0.42863 0.35373
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Tags
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!An Error Occurred
Unable to complete the action because of changes made to the page. Reload the page to see its updated state.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom(English)
Asia Pacific
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)