grouping, aggregating data in MatLab.
1 view (last 30 days)
Show older comments
Hello everyone, I have a large data set/ Matrix that has about 15000 rows.I need to aggregate this data set by a unique variable from one of columns in this matrix. so basically the output matrix will be much smaller in rows count. Example: fips_blkgrp FIPS D E F G H I 4.712e+11 47123 -11.584346 -10.07945 -7.1780256 -2.6858628 3.3706902 10.312981 4.712e+11 47123 -12.00541 -9.8563267 -6.4562942 -3.1759443 -.94757033 .21481607 4.712e+11 47123 -20.057433 -17.800008 -13.351936 -7.2696727 -.95978707 4.0782249 4.712e+11 47123 -12.999934 -11.585924 -8.936135 -4.7638609 1.2660365 9.0080125 4.712e+11 47123 -21.443385 -18.609881 -13.299678 -6.7836897 -1.0418698 2.8018057 4.712e+11 47123 -7.1070823 -5.4806812 -3.0137752 -.75519104 .70738883 1.4407552 4.712e+11 47123 -15.422121 -13.187263 -8.9353662 -3.3867106 2.2245624 6.8419238 4.712e+11 47123 -17.84071 -15.823746 -11.649713 -5.2884233 2.627514 10.550759 4.712e+11 47123 -22.952984 -20.867834 -16.470138 -9.6939436 -1.3906679 6.5917377 4.712e+11 47123 -19.435712 -16.360458 -11.100838 -5.5329737 -1.4896058 .63286027 4.712e+11 47123 -26.831252 -24.242572 -19.129545 -12.30135 -5.754132 -1.4678411 4.712e+11 47123 -26.148467 -22.037834 -14.481806 -5.4051246 2.4308043 7.5238108 4.712e+11 47123 -17.307711 -15.366532 -11.330608 -5.1586246 2.4848583 10.145997 4.712e+11 47123 -24.434183 -21.05872 -14.928325 -7.9606946 -2.6907324 -.00157565 4.712e+11 47123 -17.709645 -14.766697 -9.7966051 -4.6341523 -.98012277 .884774 I need to aggregate this data set by "fips_blkgrp" Anyone has any suggestions! Please help
1 Comment
Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!