Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Matlab help.. I have data from xls which is exported and I need to sort the data with respective to column 1. The total data
Matlab help.. I have data from xls which is exported and I need to sort the data with respective to column 1. The total data is 4440*3. The picture below shows the data. I want to sort the data if the col 1 is consecutive then save all data together and do the same for the rest of the data. for ex 302,303,304; 306,307,308,309;311,312... etc. I also want the colums and rows for the consecutive data. The current code for importing of xls is also in the picture.
4440x3 double 1 3 4. 2 4.0941 1 302 -0.5394 1 2 3 2 303 4.0941 4.0597 -0.5394 -113.3370 3 304 4 305 4.0296 -135.9375 -135.9933 5 306 4.0283 6 307 - 135.9561 7 308 4.0277 4.0271 4.0265 8 309 9 4.0262 310 311 10 4.0259 11 312 4.0256 4.0252 C 12 313 13 314 -135.9561 -135.9747 - 135.9561 -135.9933 -136.0119 -135.9747 - 135.9561 -135.9933 -135.9933 -135.9747 -135.9933 -135.9933 -135.9933 14 15 16 4.0246 4.0243 4.0240 4.0240 4.0234 4.0234 4.0231 315 316 317 318 319 320 17 18 19 Command Window Search Documentation VIEW TOR PUBLISH Insert B fx d omment % Indent Run Section Advance Breakpoints Run Run and Advance Run and Time RUN EDI BREAKPOINTS Variables Cap op ) Editor - HPPC. 1 clear cle 5 11 opts - detect ImportOptions('HPPC Report.xls', Sheet,'sheeti', 'Range', 'AA1T45025, PreserveVariables, opts. SelectedVariableNames - opts. SelectedVariableNames [3, 4, 5, 6, 8, 17]); Table_2 - readtable('HPPC Report.xls', opts) 7 8 save HPPC_Test2.mat 9 10 11 12 13 - 14 15 Cap (1,:) Table 2. Var3(Table_2.Var6 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started