Facing Issue in changing the data in the columns

[gain_10]

I am trying to change the value in the column in the dataset but its not changing I am attaching the code and the dataset. Please help me out.

library(ggplot2)
library(plotly)
library(dplyr)
library(data.table)
census_data=read.csv("census.csv")
View(census_data)
#column renaming
colnames(census_data)[1:6]=c("Slno","Age","Working Class", "Citizen Score","Education","Education Number")
colnames(census_data)[7:11]=c("Martial Status","Occupation","Relationship","Race","Sex")
colnames(census_data)[12:16]=c("Capital Gain","Capital Loss","Hrs/Week","Native","Avg Salary")
str(census_data)
#frequency Distribution
table(census_data$`Working Class`)

#mean age
tapply(census_data$Age,census_data$`Working Class`, mean)
tapply(census_data$Age,census_data$`Working Class`, min)
tapply(census_data$Age,census_data$`Working Class`, max)

table(census_data$Education)
#Categorise
census_data$Education=as.character(census_data$Education)

census_data$Education[census_data$Education == "1st-4th"]="Primary School"
census_data$Education[census_data$Education == "5th-6th"] ="Primary School"
census_data$Education[census_data$Education == "7th-8th"] ="Secondary School"
census_data$Education[census_data$Education == "9th"] ="Secondary School"
census_data$Education[census_data$Education == "10th"] ="Secondary School"
census_data$Education[census_data$Education == "11th"] ="Higher Secondary School"
census_data$Education[census_data$Education == "12th"] ="Higher Secondary School"
View(census_data)

table(census_data$Education)

dataset link:- https://www.kaggle.com/datasets/palashgain/census-dataset

[FJCC]

You can make it much easier to help you by posting the data here. To do that, run your code down to the line

census_data$Education=as.character(census_data$Education)

Then make a data frame that contains only the Education column and one other column. I'll assume the other column is LastName but you should use whatever column actually exists in the data set.

ForForum <- census_data[1:25, c("LastName", "Education")]

Post the output of

dput(ForForum)

[gain_10]

Sorry Sir I don't get what you have asked for.

[FJCC]

Run this code

census_data=read.csv("census.csv")
View(census_data)
#column renaming
colnames(census_data)[1:6]=c("Slno","Age","Working Class", "Citizen Score","Education","Education Number")
colnames(census_data)[7:11]=c("Martial Status","Occupation","Relationship","Race","Sex")
colnames(census_data)[12:16]=c("Capital Gain","Capital Loss","Hrs/Week","Native","Avg Salary")
str(census_data)
#frequency Distribution
table(census_data$`Working Class`)

#mean age
tapply(census_data$Age,census_data$`Working Class`, mean)
tapply(census_data$Age,census_data$`Working Class`, min)
tapply(census_data$Age,census_data$`Working Class`, max)

table(census_data$Education)
#Categorise
census_data$Education=as.character(census_data$Education)

ForForum <- census_data[1:25, c("Age", "Education")] 
dput(ForForum)

Post the output of dput(ForForum) as a response on this forum thread.

[gain_10]

[nirgrahamuk]

@gain_10

"9th"] ="Secondary School"

i.e. you are checking for "9th" but your data has contents like " 9th"
so you can either directly adjust what you are looking for; or throw in a trimws() around the variable you want to match without whitespace, so that differences in trailing whitespace are ignored.

[gain_10]

I have used trimws also but then also its not working.

[gain_10]

[nirgrahamuk]

The results of your use of trimws were not assigned to anywhere. You sjould be using <- to assign results in the normal way

Also please avoid using screenshots, they are hard to read, and not possible for us to copy and paste etc.

FAQ: How to format your code

Formatting Code: the Basics All code or console output you include in your posts should be formatted properly. Luckily, this is very easy to do! Just use the code formatting button at the top of the post editing box: [image] Select some code Click the </> button! The code formatting button automatically adds special Markdown formatting symbols to whatever you selected. If you check the preview pane to the right of your post, you'll see that the forum software now outputs nicely formatted code . [04] The code formatting button is pretty smart! It can tell the difference between snippets of code that are part of a sentence and blocks of code that stand alone. …

[gain_10]

Thanks for the help I am a beginner in this field.
I appreciate your guidance.