We chose to reduce the amount of max passes from 9 to 5 in the Shenandoah dataset. This means that there needs to be 5 passes for all of the rest of the datasets in order to bind the rows all together, which may be more difficult than worth it. For the Capitals data it is easy because the data has already been spread in the original dataset, so you can just add another column. However, for the Canaan and WMaryland datasets, the visit/pass data is in long form. This means that the 5th pass would need to be added to this long form column before it is expanded and then spread so that there will be the correct amount rows.
Would it be worth it to try to add the 5th pass to the long format columns; and if so, how would you do that? OR should we just clip the Shenandoah's max pass to 4 passes??
We chose to reduce the amount of max passes from 9 to 5 in the Shenandoah dataset. This means that there needs to be 5 passes for all of the rest of the datasets in order to bind the rows all together, which may be more difficult than worth it. For the Capitals data it is easy because the data has already been spread in the original dataset, so you can just add another column. However, for the Canaan and WMaryland datasets, the visit/pass data is in long form. This means that the 5th pass would need to be added to this long form column before it is expanded and then spread so that there will be the correct amount rows.
Would it be worth it to try to add the 5th pass to the long format columns; and if so, how would you do that? OR should we just clip the Shenandoah's max pass to 4 passes??