Extract from a table based on a non numerical input

2021 7 15
1 个回答
回答已采纳
更新时间：2021 7 15
4 次查看（30 天）

0 个投票

Hi,
I am simply trying to create a table for each of the machine IDs.
I want to extract all rows in the collumn that have the same machine ID. If it was numerical I would simply use some logic but I am unable to and the ('==') function does not work
I want to extract the rows based on collumn one (SAPID). A screenshot of the table can be seen below. The inputs in collumn one are of the form similiar to XXX01X01.

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

 采纳的回答

Cris LaPierre
Cris LaPierre 2021-7-15
Ran in:

1 个投票

Ran in:
What is the error message you are getting? Please share the full error message (all red text).
If your syntax is correct, it should work. See how to access data in a table page here.
% Set up table
SAPID = ["WDS01A04";"WDS01A04";"WDS01A05"];
TimeStamps = datetime(2019,01,01)+hours(0:2)';
ActPower_Value_mean = [3608;3608;3608];
NacelTmp_Value_mean = [32;32;32];
ConvTmp2_Value_mean = [45.0229;45.1712;45.2676];
dataT = table(SAPID,TimeStamps,ActPower_Value_mean,NacelTmp_Value_mean,ConvTmp2_Value_mean)
dataT = 3×5 table
SAPID TimeStamps ActPower_Value_mean NacelTmp_Value_mean ConvTmp2_Value_mean __________ ____________________ ___________________ ___________________ ___________________ "WDS01A04" 01-Jan-2019 00:00:00 3608 32 45.023 "WDS01A04" 01-Jan-2019 01:00:00 3608 32 45.171 "WDS01A05" 01-Jan-2019 02:00:00 3608 32 45.268
% Extract just rows with SAPID of "WDS01A04"
mchn1 = dataT(dataT.SAPID=="WDS01A04",:)
mchn1 = 2×5 table
SAPID TimeStamps ActPower_Value_mean NacelTmp_Value_mean ConvTmp2_Value_mean __________ ____________________ ___________________ ___________________ ___________________ "WDS01A04" 01-Jan-2019 00:00:00 3608 32 45.023 "WDS01A04" 01-Jan-2019 01:00:00 3608 32 45.171

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Language Support 的更多信息

产品

版本

R2020b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by