Deleting rows that do not contain the state code i want.

6 次查看（过去 30 天）
Leulaye Maskal
Leulaye Maskal 2021-11-17
评论： Image Analyst 2021-11-18
I have attached an excel with 3 columns aid, date, and mean. Each aid is code for a US state.
I want to cut out all rows that do not contain the following aid's
aid0045
aid0024
aid0046
aid0019
aid0038
aid0031
aid0041
aid0013
aid0042
aid0043
aid0030

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

采纳的回答

Leulaye Maskal
Leulaye Maskal 2021-11-18
it worked thanks!! I assume I can use it to now pull out individual "aid's" like just 0045??
  1 个评论
Image Analyst
Image Analyst 2021-11-18
Yes you can. Just alter keeperStrings to be whatever you want. Since it worked, can you click the "Accept this Answer" on my Answer (not yours)? Thanks in advance.

请先登录，再进行评论。

更多回答（1 个）

Image Analyst
Image Analyst 2021-11-17
Try this:
% Read data into a table.
t = readtable('NPP_STATES_YRLY_MEAN.xls')
% Define "aid" strings that we want to keep/extract.
keeperStrings = {...
'aid0045'
'aid0024'
'aid0046'
'aid0019'
'aid0038'
'aid0031'
'aid0041'
'aid0013'
'aid0042'
'aid0043'
'aid0030'}
% Find out the rows where the keeper strings live.
rowsToKeep = ismember(t.aid, keeperStrings)
% Extract only those specific rows.
t2 = t(rowsToKeep, :)

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by