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 件のコメント
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 ExchangeTables についてさらに検索

タグ

製品

Community Treasure Hunt

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

Start Hunting!

Translated by