Message Boards

WOLFRAM COMMUNITY

3880 Views

2 Replies

2 Total Likes

View groups...

Follow this post

Share this post:

GROUPS:

Data Science Wolfram Language

Alternatives in selection of dataset rows?

Mike Luntz

Posted 3 years ago

As an example, suppose I have a table such as that is in the form of a Mathematica Dataset. In Excel I can select rows with specifications such as column a >.6 and column d either g or h. I am able to figure out how to use Select to specify rows for which column a>.6 and column d equal to g, but I have not been able to find the syntax to specify the alternative of column d equal to g or h. Can anyone help me with the correct command? Thanks.

POSTED BY: Mike Luntz

2 Replies

Sort By:

Rohit Namjoshi

Posted 3 years ago

Hi Mike, Here is one way SeedRandom[123]; dataset = RandomReal[1, {4, 3}] // MapThread[(Append, {#, {"e", "g", "h", "g"}}] & // Map[AssociationThread[{"a", "b", "c", "d"} -> #] &, #] & // Dataset dataset[Select[#b > 0.3 && MemberQ[{"g", "h"}, #d] &]]

Hi Mike,

Here is one way

SeedRandom[123];
dataset = 
 RandomReal[1, {4, 3}] // 
    MapThread[(Append, {#, {"e", "g", "h", "g"}}] & // 
    Map[AssociationThread[{"a", "b", "c", "d"} -> #] &, #] & // 
    Dataset

dataset[Select[#b > 0.3 && MemberQ[{"g", "h"}, #d] &]]

POSTED BY: Rohit Namjoshi

Mike Luntz

Posted 3 years ago

Thanks Rohit. That was the information I needed.

POSTED BY: Mike Luntz

Reply to this discussion

Reply Preview

Attachments

Remove Add a file to this post

Follow this discussion

or Discard

Group Abstract

Feedback