Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
how to filter out rows in exampleset by an attribution in these rows containing regular expression
Lei
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.
Find more posts tagged with
AI Studio
Operators
Accepted answers
Caperez
Hi
@Lei
,
In this case you can use a regular expression like this ["/]\w
please find attached an example.
Best,
Cesar
regex.rmp
All comments
Caperez
Hi
@Lei
,
In this case you can use a regular expression like this ["/]\w
please find attached an example.
Best,
Cesar
regex.rmp
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups