How to plot temporal changes in batches of data?

2 次查看（过去 30 天）
David Crowe
David Crowe 2018-6-12
评论： David Crowe 2018-6-13
Hello! I have a CSV file with the following example content:
SSID,RSS,Unit,Time,Batch
AP1,-40,dBm,11:11:11,0
AP2,-44,dBm,11:11:11,0
AP3,-90,dBm,11:11:11,0
AP1,-50,dBm,13:30:00,1
AP2,-66,dBm,13:30:00,1
AP3,-20,dBm,13:30:00,1
AP1,-2,dBm,15:00:00,2
AP2,-30,dBm,15:00:00,2
AP3,-40,dBm,15:00:00,2
And I'm wanting to plot each of the SSIDs with their RSS (received signal strength) with respect to its batch.
So far, I've tried plotting each of the RSS for each batch and get the following figure:
However, my goal is to connect these lines in a distinct way to show their temporal trend, like so:
Any pointers on how this might be done?

请先登录，再回答此问题。

采纳的回答

dpb
dpb 2018-6-13
编辑：dpb 2018-6-13
t=readtable('crowe.csv');
t.SSID=categorical(t.SSID);
t.Time=datetime(t.Time);
figure,hold on
[g,ids]=findgroups(t.SSID);
splitapply(@(x,y) plot(x,y,'o-'),t.Time,t.RSS,g);
legend(categories(ids),'location','best')
gives
  1 个评论
David Crowe
David Crowe 2018-6-13
This is perfect, dpb! I appreciate using the time data as well. Many thanks for your timely response.

请先登录，再进行评论。

更多回答（1 个）

Kelly Kearney
Kelly Kearney 2018-6-12
Assuming your file is read into a table array, I think the quickest way to do this is to unstack the SSID data and then plot:
tbl = readtable('data.csv');
tblu = unstack(tbl, 'RSS', 'SSID');
plot(tblu.Batch, [tblu.AP1 tblu.AP2 tblu.AP3]);
Depending on the number of unique SSIDs, you may prefer to concatenate the unstacked values programmatically, but here I simply typed it manually.

类别

在 Help Center 和 File Exchange 中查找有关 Axis Labels 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by