Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- How do I select columns by data type?

News

On June 1, we’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Oct 3, 2017 11:04 AM
(4025 views)

**Is there a way to select columns by data type, quickly?** For example, I have a mixture of continuous and nominal columns in my data table and would like to make 2 subsets of this data table. One subset containing all continuous columns, and the other containing all nominal columns. I've managed to do this using “Columns Viewer” by selecting all columns, retrieving summary statistics, sorting by standard deviation, and selecting all columns with a standard deviation value that indicates they're continuous. It would be nice if there was a ‘Data Type’ section listed under “Find Columns with Properties” in “Columns Viewer.” I’m looking for an easier approach. An interactive approach, preferrably.

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

In the interactive world, you can use the Column Viewer and under the red triangle, you will find the ability to select columns based upon Modeling Type. Just select the modeling types you want, and then just click on Subset

Here is one way, and the easiest way I know of in JSL:

```
nomdata = Current Data Table() << get column names( nominal );
condata = Current Data Table() << get column names( continuous );
```

Jim

2 REPLIES 2

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

In the interactive world, you can use the Column Viewer and under the red triangle, you will find the ability to select columns based upon Modeling Type. Just select the modeling types you want, and then just click on Subset

Here is one way, and the easiest way I know of in JSL:

```
nomdata = Current Data Table() << get column names( nominal );
condata = Current Data Table() << get column names( continuous );
```

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How do I select columns by data type?

I see, thank you! Much easier than I thought, glad I asked before continuing further.