How to recode ordinal variable?

Varuna99 Published at Dev

Varuna99

I am using survey data from the World Values Survey, I used the code below to change my variable from a numeric to an ordered variable

renameddata$Education= ordered(renameddata$Education, levels =c(-2,-1,840001,840002,840003,
                                         840004,840005,840006,840007,
                                         840008,840009),
        labels = c("NA","NA","LessHighSchool","SomeHighSchool",
                   "GED","SomeCollege","Associates","Bachelors",
                   "Masters","Professional","Doctorate"))

However, now I want to recode the education variable so that LessHighSchool and SomeHighSchool become one e.g "NO GED", and so that SomeCollege, Associates and Bachelors become "Undergraduate" etc.

deschen

Alternatively, if you want to recode the created factor variable, you can use fct_collapse from the forcats package:

Input:

renameddata <- data.frame(Education = c(-2, -1, 840001, 840002, 840003, 840004, 840005, 840006, 840007, 840008, 840009))

renameddata$Education = ordered(renameddata$Education,
                                levels = c(-2, -1, 840001, 840002, 840003, 840004, 840005, 840006, 840007, 840008, 840009),
                                labels = c("NA", "NA", "LessHighSchool", "SomeHighSchool", "GED", "SomeCollege", "Associates", "Bachelors", "Masters", "Professional", "Doctorate"))

Recoding:

library(forcats)
renameddata$Education <- fct_collapse(renameddata$Education,
                                      "NO GED" = c("LessHighSchool", "SomeHighSchool"),
                                      "Undergraduate" = c("SomeCollege", "Associates", "Bachelors"))

gives:

       Education
1             NA
2             NA
3         NO GED
4         NO GED
5            GED
6  Undergraduate
7  Undergraduate
8  Undergraduate
9        Masters
10  Professional
11     Doctorate

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-01-16

Comments

0 comments

How to recode numerical variable into categorical?

How to recode this string variable into a new variable?

How to recode a variable programmatically using quasiquotation?

How to recode ordinal variable?

How to recode ordinal variable?

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Inner Loop design for webscrapping

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)

Removed zsh, but forgot to change shell back to bash, and now Ubuntu crashes (wsl)

ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

How to run blender on webserver?

Resetting Value of <input type="time"> in Firefox

Converting a class method to a property with a backing field

Ambiguous use of 'init' with CFStringTransform and Swift 3

Execute ./script.sh with a crontab

How to set tab order for array of cluster,where cluster elements have different data types in LabVIEW?

How to pass data to the ng2-bs3-modal?

Retrieve Element Tag Value XML Using Bash

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

SQL Server : need add a dot before two last character

Making Array From Page Elements in jQuery

Laravel's ORM sync with timestamps doesn't update timestamps

Do animations stop css changes after animation completion?