This session uses a case study on Medical Treatment Types to show how you examine your data, determine a goal for the analysis, and then prepare the data table to accomplish that goal.
See how to:
- Examine data from three different tables
- Table 1: Morning Results for April and May
- Table 2: Afternoon Results for April and May
- Table 3: All June Results
- Join Tables(Tables>Join) and select common Variable ID and an inner join to capture overlapping/common data from both tables
- Apply Modeling Types
- Standardize Attributes (Cols>Standardize Attributes>Column Properties)
- Stack Table (Tables>Stack)
- Concatenate Tables (Tables>Concatenate)
- Use Text to Columns
- Add a Formula Column
- Recode
- Use Value Ordering to define order of variables on all charts
- Hide Rows
- When you Hide rows, they are hidden in all plots, including all open plots
- Hiding rows does not exclude them from calculations and analyses
- Exclude Columns
- Excluded columns are not considered in your analysis
- Excluded columns remain visible in the data grid
Tip: When preparing JMP data (join, concatenate, stack, split, etc.) check Keep Dialog Open. If you want to check your work, check Create Source Column to give info to help you during checking. You can delete the Source Column from final table later.
Check Create Source Column to add column to table; check Keep Dialog Open in case you want to check your work.Check Create Source Column to add column to table; check Keep Dialog Open in case you want to check your work.
Final Prepared Data TableFinal Prepared Data Table
Questions answered by Alisa @alisa_h_lowery and Olivia @O_Lippincott during the live webinar:
Q: If you merge columns with the same name and their contents are different, will the resulting column just have a comma between the two values and treat it as unstructured text?
A: In the example, she created a column ID and joined by the column ID. Basic joining by columns will not merge text from two different tables into the same column.
Q: Does fixed decimal change the values, or just change the way the values are displayed in the table?
A: Just the way it is displayed on the table. If you have lots of values after the decimal, they will be retained and when you change the FIXED DEC>WIDTH DEC value you to a larger number you will see more decimal places.
Q: If we use Join, does is join columns side by side, compared to Concatenate?
A: Joining is adding columns, concatenate is adding rows.
Q: Is there a way to hide data columns that have been delimited/separated already and aren't going to be used anymore? Hide rather than delete.
A: Yes, you can hide columns from the columns panel. Start by r-clicking the column name.
Q: How did you split Column name split (Date/Time) into 2 columns?
A: Utilities>Text to Column
Q: Could you change model type from continuous to discrete? Could you change it if one instance would round up or down and another instance the discrete values should just drop the decimal place entirely and not round up?
A: Not in the data & model types. You can use a formula to round up or round down.
Q: Will you go over some other recode options?
A: See shor video:
Resources
