Using Matlab to randomly split an Excel Sheet -


i have excel sheet containing 1838 records , need randomly split these records 3 excel sheets. trying use matlab quite new , have managed following code:

[xlsn, xlst, raw] = xlsread('data.xls');  numrows = 1838;   randindex = ceil(3*rand(numrows, 1));  raw1 = raw(:,randindex==1); raw2 = raw(:,randindex==2); raw3 = raw(:,randindex==3);

your general procedure read spreadsheet matlab variables, operate on matrices such end 3 thirds , write each third out.

so you've got read covered xlsread, results in 2 matrices xlsnum , xlstxt. suggest using syntax

[~, ~, raw] = xlsread('data.xls');

in xlsread file (you can access typing doc xlsread command window) says 3 output arguments hold numeric cells, text cells , whole lot. because matlab matrix can hold 1 type of value , spreadsheet expected have text or numbers. raw value hold of values in 'cell array' instead, different kind of matlab data type.

so have cell array valled raw. here want 3 things:

  1. work out how many rows have (i assume each record row) using size function , specifying appropriate dimension (again check file see how this)

  2. create index of random numbers between 1 , 3 inclusive, can use mask

    randindex = ceil(3*rand(numrows, 1));

  3. apply mask cell array extract records matching each index

    raw1 = raw(:,randindex==1); % same other 2 index values

  4. write each cell file

    xlswrite('output1.xls', raw1);

you have fettle arguments work way want sure check doc functionname page syntax right. main concern indexing correct - matlab indexes row-first whereas spreadsheets tend column-first (e.g. cell a2 column , row 2, matlab matrix element m(1,2) first row , second column of matrix m, i.e. cell b1).

update: split file evenly surprisingly more trouble: because we're using random numbers index it's not guaranteed split evenly. instead can generate vector of random floats , pick out lowest 33% of them make index 1, highest 33 make index 3 , let rest 2.

randvec = rand(numrows, 1); % float between 0 , 1 pct33 = prctile(randvec,100/3); % value of 33rd percentile pct67 = prctile(randvec,200/3); % value of 67th percentile randindex = ones(numrows,1); randindex(randvec>pct33) = 2; randindex(randvec>pct67) = 3;

it still won't absolutely - 1838 isn't multiple of 3. can see how many members each group has way

numel(find(randindex==1))

Comments

Post a Comment

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

this code i'm using find latitude , longitude of place: function coords($address){ echo $url="http://maps.googleapis.com/maps/api/geocode/json?address=".$address; $json = file_get_contents(urlencode($url)); $data = json_decode($json, true); print_r($data['results'][0]['geometry']['location']['lat']); print_r($data['results'][0]['geometry']['location']['lng']); } however returns warning: failed open stream: http request failed! http/1.0 400 bad request if use above code in simple procedure works fine not in function. note: have tried curl_init()... method produced same result? instead of encoding whole url encode address part. following code work fine $add='jamshoro phase 2'; $url="http://maps.googleapis.com/maps/api/geocode/json?address=".urlencode($add); $json = file_get_contents($url); $data = json_decode($json, true); print_r($data['r...
Read more

command line - Use qwinsta in PowerShell ISE -

i trying use qwinsta , rwinsta powershell code. when try run error "the term 'qwinsta' not recognized name of cmdlet, function, script file, or operable program." need able remotely on several machines without having add .dll's or modules other machines. tried terminal services powershell module, need able put on remote machines , not able that. within powershell ise how run qwinsta? not looking parse information gather it. following code have tried (which had found on site also): function get-tssessions { param( $computername = "localhost" ) qwinsta /server:$computername | #parse output foreach-object { $_.trim() -replace "\s+","," } | #convert objects convertfrom-csv } get-tssessions -computername "localhost" | ft -autosize best have running powershell ise (x86). when run command qwinsta there same error you. of course assuming have 64-bit os. th...
Read more

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more