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

 Réponse acceptée

Stephan
Stephan le 28 Juil 2019
Modifié(e) : Stephan le 28 Juil 2019

0 votes

Your_Table_new = Your_Table(Your_Table.Recommeded_Working_Hours >= 3000,:);

3 commentaires

NinoOK
NinoOK le 28 Juil 2019
THANK YOU
Stephan
Stephan le 28 Juil 2019
I corrected my answer - try again if you get an error. If it was useful please accept it.
NinoOK
NinoOK le 28 Juil 2019
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

Connectez-vous pour commenter.

Plus de réponses (0)

Produits

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by