Table variable comparison.

3 次查看（过去 30 天）
Amritpal Kaur
Amritpal Kaur 2016-4-22
回答： Guillaume 2016-4-22
So I have a table ( lq is the variable name) with a lot of data. The first 2 columns are ip addresses and the next 2 rows are some data related to that. the column names are like:
ip neighbour blah blah2
So I need to make subtables from certain data in this table, I wrote:
T1 = table(lq.ip=='192.168.2.101',lq.neighbor=='192.168.2.102', timestamp,lq);
Which sadly, doesn't create a new table with all the datapoints for ip value and neighbour value as shown. Where have I mistaken?
Thanks.

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

采纳的回答

Guillaume
Guillaume 2016-4-22
1) Do not use == to compare strings, use strcmp
2) This is not how you index tables at all
%if you want all the columns for the matching rows:
newtable = lq(strcmp(lq.ip, '192.168.2.101') & strcmp(lq.neighbor, '192.168.2.102'), :)
%if you just want the timestamp column:
newtable = lq(strcmp(lq.ip, '192.168.2.101') & strcmp(lq.neighbor, '192.168.2.102'), lq.timestamp)

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by