nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Recode numerical days into Monday, Tuesday, Wednesday etc

Madwolf

Hi, I have a column that is indicated as days, in ordinal data.

How can I recode it, such that they are (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)?

Currently:

1 = Wednesday

2 = Thursday

3 = Friday

4 = Saturday

5 = Sunday

6 = Monday

7 = Tuesday

9 =Wednesday

.....

416 = Friday

417 = Saturday

418 = Sunday

Is there a way to recode it without me having to type Mon - Sun all the way from 1 to 418?

Accepted answers

Jeff_Perkinson

Building on @txnelson's solution, you can use a Formula column with the Modulo() function that he showed, along with the Value Labels property.

2021-01-27_09-16-23.770.png

The attached data table has this example.

Community353237 day of week.jmp

All comments

txnelson

Here is an example of a script that will create a new column with the desired values

Names Default To Here( 1 );

// Create an Example data table
dt = New Table( "Example", add rows( 418 ), New Column( "weekday", set each value( Row() ) ) );

// Create a new column Using a script
dt << New Column( "Weekday 2",
	character,
	set each value(
		theList = {"Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday", "Monday"};
		theList[Mod( :weekday, 7 ) + 1];
	)
);

Madwolf

Thank you so much. However, if I may ask, how do I do it, such that the new column is inside my existing table?

For instance, my existing table name is transaction_data.

Which are the field that I needed to change to "transaction_data" above, without the need to create a new table?

Jeff_Perkinson

Building on @txnelson's solution, you can use a Formula column with the Modulo() function that he showed, along with the Value Labels property.

2021-01-27_09-16-23.770.png

The attached data table has this example.

Community353237 day of week.jmp

Mark_Bailey

Select the column with the current values (1..7). Select Cols > Column Info. Select Column Properties > Value Labels. Define the character string label for each data value.

Madwolf

Thank you so much!!