Working with table.

1 次查看（过去 30 天）
NinoOK
NinoOK 2019-7-28
评论： NinoOK 2019-7-28
Hello, i Have a question like this. I imported Table, from Excel file.
all i want to do is to rewrite data which is above or equal of 3000 Recommended_Working_Hours. When I rewrite i want also to keep everything, including Titles, Num (i mean whole rows).
I have in Excel file with 300 data, with 5 colomns and a huge amount of rows.
if someone will tell me how to filter this data, it will be very good and Helpful..
Thanks a lot for your Support!! :) (i wrote it by hand, but i want to detect it automatically)
Num Descr. Working_Hours Recommeded_Working_Hours
12 KL 2500 3000
22 IP 3400 3000
30 LO 3050 3000

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

采纳的回答

Stephan
Stephan 2019-7-28
编辑：Stephan 2019-7-28
Your_Table_new = Your_Table(Your_Table.Recommeded_Working_Hours >= 3000,:);
  3 个评论
显示 1更早的评论
Stephan
Stephan 2019-7-28
I corrected my answer - try again if you get an error. If it was useful please accept it.
NinoOK
NinoOK 2019-7-28
I have some error.
All i want to do is to delete some data from my table.
Num Descr. Working_Hours Recommeded_Working_Hours
12 KL 2500 3000 (to delete only first whole raw) which is less than 3000.
22 IP 3400 3000
30 LO 3050 3000
Thank you

请先登录，再进行评论。

更多回答（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!

Translated by