MATLAB Answers

Complicated Matrix Data filtering

Asked by Hello kity on 25 Jan 2013


I need to 'filter' out some data out of a large spreadsheet. The spreadsheet consists of three colomns, X Y Z , and Device name. Those values are matched with a reference, the reference is found at the end of every 'group' of data.

What I want is (for example): if device B is found in the group (this is not always the case), then do reference minus data (Xref-X , Yref-Y Zref-Z).

I select the data with:

[filename, pathname] = uigetfile({'*.xls'},'File Selector');
[num, txt]=xlsread(filename);
		X	Y	Z	Device
		-11.2	151.9	0.3	A
		-11.3	150.2	-0.3	A
		-11.4	151.8	1.5	B
		-11	151.7	0	B
		-11.4	149.9	0.1	C
		-11.8	151.7	1.7	D
reference	-11.6	150.6	-0.2	
		X	Y	Z	Device
		-9.5	154.2	-0.3	A
		-9.1	155.5	-1.1	A
		-9.4	155.6	0.5	B
		-9.4	156.5	1.2	C
		-9.2	156.4	-0.2	C
reference	-9.1	155.1	0.1	



No products are associated with this question.

2 Answers

Answer by per isakson
on 26 Jan 2013
Edited by per isakson
on 26 Jan 2013


    [~,~,raw] = xlsread( fullfile( pathname, filename ) );


Answer by Image Analyst
on 26 Jan 2013

Beware that num and txt are not aligned! I'd recommend you use raw. Then use ismember() on the third column to find the desired letter, and do the math.

  1 Comment

Hello kity on 29 Jan 2013

I noticed that. I am using raw now. I can find the desired letter with strcmp. But I am having troubles how I can sort the data in groups. So DEvice A with all its (individual) values and references.

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply today