CSE 6040 - 7.3 - Basic tidying transformations: melting & casting - Code

Question 1

When Values appear as columns what can you do to tidy up the table?

Answer 1

Peform the Melting operation.

Question 2

What are the two steps to perform the melting operation on a table?

Answer 2

To melt the table, you need to do the following.

1. Extract the column values into a new variable.
2. Convert the values associated with the column values into a new variable as well.

Question 3

If an observation is split across multiple rows what method can we use to tidy the table?

Answer 3

We can use the Casting method.