フィルターのクリア

Deleting the same empty row in 2 different column vectors - then searching a value giving the other column vector result

1 回表示 (過去 30 日間)
Quite easy for some more experanced then me, still learning Matlab.
Hoping someone could help.
From the file attached, I am trying to do the following......
  1. From row DTCs I would like to delete the rows with [ ] and delete the corresponding rows in FlowID
2.Then, lets say I wanted to search for "P22D5-37" in DTCs, I would like the program to give me all the values from FlowID values

採用された回答

ANKUR KUMAR
ANKUR KUMAR 2021 年 3 月 14 日
編集済み: ANKUR KUMAR 2021 年 3 月 14 日
load_mapping_csv
Mapping_refine=Mapping(~strcmp(Mapping(:,3),'[]'),[1:3]);
The script of load_mapping_csv is attached, and has been prepared using matlab automatic script to load data from csv files: Home > Import Data
If you have only one search query, you can use this
search_query='P22D5-37';
Mapping_refine(contains(Mapping_refine(:,3),search_query),:)
If you have multiple queries, you can use cellfun function to iterate over all cell elements.
One can use Mapping_search_query or Mapping_search_query_merged to see the results from different perspective.
search_queries={'P22D5-37','U0064-88'}
Mapping_search_query=cellfun(@(x) Mapping_refine(contains(Mapping_refine(:,3),x),:), search_queries,'uni',0)
cat(1,Mapping_search_query{:})
  14 件のコメント
nayan
nayan 2021 年 3 月 22 日
Hey,
wondering if you could help alittle more - wanted to further this work by taking in a second file (attached).
I would like to use the numbers on the LEFT (unique_vals) and compare them to the case numbers on the RIGHT. Any number which doesnt match the RIGHT then numbers on the LEFT (nique_vals) are deleted.
ANKUR KUMAR
ANKUR KUMAR 2021 年 3 月 22 日
Attached is the script of load_compare_csv.m, which has been Auto-generated by MATLAB.
load_compare_csv
CompareCasevals=cell2mat(CompareCase);
new_unique_vals=unique_vals(cellfun(@length, arrayfun(@(x) find(CompareCasevals==x),unique_vals,'uni',0))~=0)

サインインしてコメントする。

その他の回答 (1 件)

nayan
nayan 2021 年 3 月 24 日
Following the instructions, I am getting this error message...?
  1 件のコメント
nayan
nayan 2021 年 3 月 26 日
Figured it out, I just uploaded the table myself and used the code you provided...THANK YOU mate, your work help me loads!

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeMatrix Indexing についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by