I'd like to remove variables (columns) containing specifc name
조회 수: 17 (최근 30일)
이전 댓글 표시
Hello,
I have a kind of big data table (eg. 300 variables) and I'd like to sort out the table by removing variables.
I imported csv file and it has variable names showing the pattern such as xxxx_A or yyyy_B
So I tried to use removevars function to remove all columns containing '_B' but failed
Actually I am not sure how to determine specific variables
I'd appreciate if anyone can help to sort out the table by specific column name
Thanks
댓글 수: 0
답변 (2개)
Image Analyst
2023년 5월 17일
Try this:
% Create sample table.
rows = 5;
xxxx_A = 1:rows;
yyyy_B = rand(rows, 1);
col3 = rand(rows, 1);
t = table(xxxx_A(:), yyyy_B(:), col3, 'VariableNames', {'xxxx_A', 'yyyy_B', 'col3'})
% Now remove the column called "yyyy_B"
t = removevars(t, 'yyyy_B')
댓글 수: 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!