Delete rows with certain values while keeping text in column

1 次查看（过去 30 天）
Rogier Busscher
Rogier Busscher 2017-6-8
评论： KSSV 2017-6-9
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更早的评论
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by