The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
how to filter out rows in exampleset by an attribution in these rows containing regular expression
I have a dataset. I want ot filter some rows when the rows match a condition.
For example, the dataset as follow:
word value
rain/C 39
sunny 20
snow/d 10
wind/G 27
cloud 50
I want to filter out some rows, in which word contains letter "/C" or "/G". In fact, the condition should be any "/" + one uppercase letter.
(It is good to use regular experssion to give condition. So I can change based on different requirement)
So the result above should be like:
word value
sunny 20
snow/d 10
cloud 50
Is there anyone who can help me?
Thank you very much.
For example, the dataset as follow:
word value
rain/C 39
sunny 20
snow/d 10
wind/G 27
cloud 50
I want to filter out some rows, in which word contains letter "/C" or "/G". In fact, the condition should be any "/" + one uppercase letter.
(It is good to use regular experssion to give condition. So I can change based on different requirement)
So the result above should be like:
word value
sunny 20
snow/d 10
cloud 50
Is there anyone who can help me?
Thank you very much.
Tagged:
0