Delete Table Rows based of certain characters in a row
조회 수: 33 (최근 30일)
이전 댓글 표시
i imported data from a .txt file into a table that is approximately of size (96,000x26), im looking to delete rows based off of a string of characters contained in the first column of that data, then export the updated table to a .csv file
댓글 수: 1
the cyclist
2023년 10월 17일
Can you upload the data (or a small, representative sample)? You can use the paper clip icon in the INSERT section of the toolbar. It will then be much easier to make sure our code works for your example. (For example, the syntax will depend on whether the first column is a string, or a character array.)
채택된 답변
Jon
2023년 10월 17일
I think this is a simple example of what you want to do
name = {'cat','dog','fish','bear'}'
weight = [3,25,8,300]'
T = table(name,weight)
% remove rows with names that contain an a
idl = contains(T.name,'a');
T = T(~idl,:)
% Write to .csv'
writetable(T,'myfile.csv')
댓글 수: 3
Jon
2023년 10월 17일
So if I only wanted to keep rows where the name was "fish", I could use
name = {'cat','dog','fish','bear','fish'}'
weight = [3,25,8,300,19]'
T = table(name,weight)
% keep only rows whose name is 'fish'
idl = strcmp(T.name,'fish');
T = T(idl,:)
% Write to .csv'
writetable(T,'myfile.csv')
Jon
2023년 10월 17일
Or maybe this is what you are asking (if not please provide an example). Let's keep all the rows whose names include goose
name = {'cat','dog','goose','fish','mongoose','bear'}'
weight = [3,25,4,8,16,300]'
T = table(name,weight)
% Keep rows that contain 'goose'
idl = contains(T.name,'goose');
T = T(idl,:)
추가 답변 (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!