Finding data off excel sheet
显示 更早的评论
In the excel sheet attached, the data is 3 different sensors 0,1 and 2(1st column), their voltage(2nd column) and time of the reading(3rd column). I'm struggling to find a way to seperate the full data set into one set of voltage readings and time readings for each sensor. This is what I have
A = xlsread('forcetest.csv');
idx1 = find(A == 0)
I used xlsread just because I think it is easier. I know I have to used the find function, this code I have so far just finds what rows are the censor 0, how to I get it to give me all those rows with the given voltage and time data? Do I have to use a for-loop?
7 个评论
Bryce Keeler
2016-7-4
编辑：Bryce Keeler
2016-7-4
Not entirely sure what you're asking for, but I think what you mean is you want all the data associated with the "Sensor 0" rows? In that case the the code you are looking for is
idx1 = A(find(A==0),:);
Luke Radcliff
2016-7-4
Luke Radcliff
2016-7-4
Bryce Keeler
2016-7-5
Good to hear! Would you mind accepting it as an answer then?
Image Analyst
2016-7-5
He could if you post it below AS and answer, instead of here as a comment.
Luke Radcliff
2016-7-13
Image Analyst
2016-7-13
Well like I said in my answer it wouldn't have worked anyway since it finds 0's anywhere, not just in column 1.
采纳的回答
Image Analyst
2016-7-5
Try this:
A = xlsread('forcetest.csv');
% Extract column 1 which has the sensor IDs.
col1 = A(:, 1);
% Find which rows have value 0, meaning this row is for sensor #0.
sensor0Rows = find(col1 == 0);
% Extract only those rows for sensor #0.
array0 = A(sensor0Rows, :);
% Get voltage and time separately, in case that's wanted.
voltages = A(sensor0Rows, 2); % From column 2
times = A(sensor0Rows, 3); % From column 3
Note that find(A==0) won't work since it finds 0's anywhere, not just in column 1. So if you had a 1 or 2 in column 1 but a 0 in column 2, then it would pick out this row even though it shouldn't.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
