CODEWITHSUNDEEP
rtrim
rprogrammer
rprogrammer

Reputation: 1

Trim spaces in a column

I want to write a query to take count from a Datatable called "singapore" for a particular condition

NAME   COUNTRY     GENDER  OWNHOUSE  NO of houses
X1     SINGAPORE    M       Y        1
X2     SINGAPORE    F       N        0
X3     SINGAPORE    M       N        0

Now when I try to take counts from this Dataframe for Gender="F" and ownhouse="Y" it does not take correct count as at some places Gender is written as gender="M ". I want to trim only the column GENDER.

Currently I am using below command but it trims all the columns

Singapore<- data.frame(lapply(Singapore, trimws), stringsAsFactors = FALSE)

Upvotes: 1

Views: 173

Answers (2)

s_baldur
s_baldur

Reputation: 33548

To trim only the column GENDER but keep the data.frame otherwise intact:

Singapore$GENDER <- trimws(Singapore$GENDER)

Upvotes: 1

Ric S
Ric S

Reputation: 9267

To trim only a single column just use the function trimws on that column only

Singapore$GENDER <- trimws(Singapore$GENDER)

Upvotes: 0

Related Questions