A data processing problem

3 Ansichten (letzte 30 Tage)
QIAO WANG
QIAO WANG am 11 Nov. 2019
Kommentiert: Adam Danz am 12 Nov. 2019
Hi guys.
I've got another data processing problema . Hope to get some ideas from you.
I'm dealing with a table and it looks like Table I. I've shortened it a bit to show here. Now, based on Table I, I'm going to get the first row when a BSid first appeared and the last row when the same BSid lastly appeared. For example, I'd like to obtain a table which looks like Table II. I've been thinking about this for a while but unfortunately, no good idea has come into my mind.
Any good idea is welcom and thank you in advance.
Table I:
ID Time BSid
59 08:47:31 19
59 08:47:32 19
59 08:47:33 19
59 08:47:34 19
59 08:47:35 22
59 08:47:36 22
59 08:47:37 22
59 08:47:38 22
59 08:47:39 22
59 08:47:45 24
59 08:47:46 24
59 08:47:47 24
59 08:47:48 24
59 08:47:49 24
59 08:47:50 22
59 08:47:51 22
59 08:47:52 22
59 08:48:00 22
59 08:48:01 24
59 08:48:02 24
59 08:48:03 24
59 08:48:04 24
59 08:48:05 24
Table II:
ID Time BSid
59 08:47:31 19
59 08:47:34 19
59 08:47:35 22
59 08:47:39 22
59 08:47:45 24
59 08:47:49 24
59 08:47:50 22
59 08:48:00 22
59 08:48:01 24
59 08:48:05 24

Akzeptierte Antwort

Adam Danz
Adam Danz am 11 Nov. 2019
Bearbeitet: Adam Danz am 12 Nov. 2019
% Determine where BSid values change
deltaBSid = diff(I.BSid)~=0;
% Create a logical vector identifying the first and last row of each
% consecutive BSid
rowIdx =[true; deltaBSid] | [deltaBSid; true];
% Extract desired rows from table
I(rowIdx,:)
  3 Kommentare
QIAO WANG
QIAO WANG am 12 Nov. 2019
Really appreciate your idea. It worked perfectly. Thank you for helping me out.
Adam Danz
Adam Danz am 12 Nov. 2019
Glad I could help!

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Produkte


Version

R2018a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by