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

1 view (last 30 days)
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

Accepted Answer

ANKUR KUMAR
ANKUR KUMAR on 14 Mar 2021
Edited: ANKUR KUMAR on 14 Mar 2021
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 Comments
nayan
nayan on 22 Mar 2021
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 on 22 Mar 2021
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)

Sign in to comment.

More Answers (1)

nayan
nayan on 24 Mar 2021
Following the instructions, I am getting this error message...?

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!