Grouping Data by Rows in JMP Pro 18I am currently working on a JMP Pro data file (attached), which contains 150 observations covering the years 2015 to 2024. The dataset comprises four columns: “YEAR”, “Location”, “ENT CAP”, and “NEP”.
I would like to organize the data by grouping all rows according to the values in the YEAR column. For example, all 16 rows corresponding to 2015 should be grouped under the label “Y2015”, and similarly for subsequent years—“Y2016”, “Y2017”, up to “Y2024”.
In addition, I would like to group the data based on the Location column. This should result in separate groups such as “Europe”, “America”, “Asia”, “Africa”, etc., depending on the regions represented in the data.
Could you please advise on how to perform both the year-wise and location-wise grouping in JMP Pro 18?
Basic Data Analysis and ModelingData Blending and CleanupRe: Grouping Data by Rows in JMP Pro 18What do you mean by grouping in this case as you already have the grouping in your data table?
Re: Grouping Data by Rows in JMP Pro 18I do not understand what grouping means. The data can easily be addressed by referencing the column Year or Location already..
Could you please provide an example of what your idea of groupings would be.
Take a look at using a By column for grouping in JMP platforms,
or
Using a data filter when running a JMP platform.
Re: Grouping Data by Rows in JMP Pro 18Hi Jarmo, apologies for the confusion. Please find the extended version of the dataset attached. Here I have organized the data into three groups based on columns.
However, I would now like to rearrange the data by rows using the “YEAR” field. The dataset contains 100 rows, and I’d like to divide them into 10 groups. Each group should correspond to a specific year, for example, Group Y2015 should include all data from 2015 (see Column "Year"), Group Y2016 should contain all data for 2016, and so on.
I hope this provides better clarity.
Re: Grouping Data by Rows in JMP Pro 18Hi Jim. Apologies for the confusion. Please find the extended version of the dataset attached. Here I have organized the data into three groups based on columns.
However, I would now like to rearrange the data by rows using the “YEAR” field. The dataset contains 100 rows, and I’d like to divide them into 10 groups. Each group should correspond to a specific year, for example, Group Y2015 should include all data from 2015 (see Column "Year"), Group Y2016 should contain all data for 2016, and so on.
I hope this provides better clarity.
Re: Grouping Data by Rows in JMP Pro 18I'm still not sure what you mean by group as you already have your data grouped? Do you wish to sort your data? Or do you wish to have separate columns for each of the groups? Or do you wish to have separate data table for each of the groups?
You can sort your data using right click
or using Tables > Sort
Re: Grouping Data by Rows in JMP Pro 18If you use
Tables=>Sort
you can sort the rows in your data table by your Year and Location and the table will go from 2015 to 2025 for America, then 2015 to 2024 for Asia, and then for Europe.
6
Is this the ordering you are looking for?
I don't totally understand your data. Your data has 6 rows where the Year is 2015 and the Location is Europe. I do not see any obvious way of figuring out how to differentiate between them.
Re: Grouping Data by Rows in JMP Pro 18Hi Jarmo, apologies again for the earlier confusion. I’ve attached the partial dataset in Excel, where the data has been organized by year. My goal is to restructure it into distinct year-based groups. Specifically, I’d like Group 1 to contain all sixteen rows of 2015 data, Group 2 to include all sixteen rows of 2016 data, and so on—up to Group 10, which would include all sixteen rows for 2024.
How to achieve this type of row-wise grouping in JMP Pro 18?
Re: Grouping Data by Rows in JMP Pro 18Hi Jim. It is not about shorting but it is grouping. I’ve attached the partial dataset in Excel, where the data has been organized by year. My goal is to restructure it into distinct year-based groups. Specifically, I’d like Group 1 to contain all sixteen rows of 2015 data, Group 2 to include all sixteen rows of 2016 data, and so on—up to Group 10, which would include all sixteen rows for 2024.
How to achieve this type of row-wise grouping in JMP Pro 18?
Re: Grouping Data by Rows in JMP Pro 18If I am understanding you correctly, is what you want is for displaying of your data table, you want to change it into a JMP data table that looks like:
Is this correct?
Do you want to do this interactively or do you want to have a JMP script modify your table to a form like this?
It appears that you are attempting to use JMP as if it is Excel. An Excel Worksheet is a cell based table. JMP data table is an analytical column based table. They each have their advantages, and their limitations.
If you can specify what the purpose of your proposed format is, I believe the Community will be able to suggest or show you a way to achieve your needs
Re: Grouping Data by Rows in JMP Pro 18Hello Jim. Thank you for your comments. However, I’d prefer not to have “Group 1,” “Group 2,” etc. appear as column entries. Instead, I’d like these groupings to be shown in the side panel. In your current illustration, the data are grouped by columns labeled “Location,” “RTBA,” and “CASH.” What I’m aiming for is a grouping where “Group 1,” “Group 2,” etc. are displayed in the side panel—organized by rows rather than columns.
Re: Grouping Data by Rows in JMP Pro 18
Here’s a clearer and more concise version of your message with a professional tone and refined flow:
Hi Jim,
I don’t see Group 1, Group 2, etc. listed in any column. I’d like these group labels to appear in the left side panel. In the screenshot you provided, the panel shows column-wise grouping—Location, RFBA, and CASH. Instead, I’m looking to group the data row-wise, where:
- Group 1 includes all 2015 entries (16 rows)
- Group 2 covers all 2016 entries
- …and so on, up to 2024
Is it possible to configure JMP Pro 18 to display this kind of row-wise grouping in the panel?
Re: Grouping Data by Rows in JMP Pro 18The column panel on the left side of the data table only groups columns, not rows. However, one can use a Data Filter to allow for the grouping of rows. In my example I created a column called Group which had a value for each row....Group 1 for 2015, etc. I subsequently hid the column. The data filter was then created, selecting upon column Group
.
Re: Grouping Data by Rows in JMP Pro 18Hi Jim, I think your idea might just do the trick! I’ll test out the data filter you mentioned. Appreciate it!
