Grouping Data by Rows in JMP Pro 18

[#1]

I 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?

[#2]

What do you mean by grouping in this case as you already have the grouping in your data table?

[#3]

Hi 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.

[#4]

I'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

[#5]

Hi 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?

[#6]

I 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.

[#7]

Hi 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.

[#8]

If 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.

[#9]

Hi 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?

[#10]

If 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