Delete rows with certain values while keeping text in column

2017 6 8
0 个回答
更新时间：2017 6 9
5 次查看（30 天）

0 个投票

I have a large table with data on traffic times and modes. A sample is given below:
Now I would like to remove all rows with a zero. This would be easy to perform on a matrix with something like this:
rows_to_remove = any(data==0, 2);
data(rows_to_remove,:) = [];
However, when I load this table as a matrix, the text data on the travel mode is converted into a numerical value that has no meaning.
How do I remove all rows with a zero while keeping the text in the 5th and 7th column?

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Rogier Busscher
Rogier Busscher 2017-6-8
Made a more or less temporary solution by adding 'class numbers' for each possible content of the text column, so that i can later re-add them with something of an ismember function.
However, a less long-winded solution would still be much appreciated.
Image Analyst
Image Analyst 2017-6-8
"...load this table as a matrix..."??? What exactly did you do? Why not load it as a table with readtable()? And I'm not seeing any 0's in columns 5 and 7, just long strings with BIKE or GTC in them.
Rogier Busscher
Rogier Busscher 2017-6-8
编辑：Rogier Busscher 2017-6-8
Maybe I should have been more clear.
I want to delete any row with any zero. On a matrix this can be done with the code i put above. On a table, such a command gives an error.
However, I can't use the import data tool and load the data with 'numeric matrix' as output type, because it converts the text into NaN or just a number.
So how do I do this.
Image Analyst
Image Analyst 2017-6-8
Are those two numbers separated by a comma a string? Or is that like some European countries that use a comma instead of a decimal point so they are really numbers, not strings? Can you attach your data file?
KSSV
KSSV 2017-6-9
Attaching a snapshot of file, wont help. To get full help, attach the file.

请先登录，再进行评论。

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

回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by