5: Tidy Data

Data Wrangling and Visualization

Author

Prof. Jack Reilly

Published

Fall 2026

Before attempting this assignment, be sure to follow the instructions noted in Week 4 page under โ€œCourse Contentโ€.

Data Work

  1. Use the Cooperative Congressional Election Study/Cooperative Election Study (CCES/CES) Cumulative file.

  2. Use only the 2024 data. Recode the 5 category ideology variable to a three category variable: liberal, moderate, conservative.

  3. Recode the presidential vote variable to look just at two party vote (in other words, recode vote so that respondents who reported voting for candidates other than Trump or Harris are โ€œmissingโ€).

  4. Create a table. What proportion of respondents who are liberal voted for Trump? What proportion of respondents who are conservative voted for Harris?

  5. Find the variable that refers to whether people own or rent their home. Recode the variable so that โ€œotherโ€ is missing.

  6. Create a table. What portion of people who own their homes voted for Trump? Harris? What portion of people who rented voted for Trump? Harris?

  7. Finally, locate the education variable. Recode the variable so that those with a high school degree or less are in one category, those with some college but less than a four year degree are in a second, those with a college degree are in a third, and those with a post-grad degree are in a fourth.

  8. Create a table. What does education tell us about vote in the 2024 election?

Submission

This assignment is due in class Week 5 (Thursday, September 24). We will go over it together in class that day.