Converting the characters of strings in a single column into lowercase and getting the updated dataframe with all columns

Question

I have a dataframe with multiple columns out of which one column has city names with first letter in uppercase. I want to see the all city names in this particular with lowercase letters and an updated data frame with all the existing columns.

Ex-

colA,colB,colC
Australia,Albany,23
Australia,Sydney,56
India,Delhi,67
India,Guntur,89

I want output as

colA,colB,colC
Australia,albany,23
Australia,sydney,56
India,delhi,67
India,guntur,89

I tried using 'dplyr::mutate_each' function but ended up like following

colB
albany   
sydney   
delhi    
guntur

@Sotos, @Japp; Apologies if I didn't convyed my question properly. Ms Jess has suggested the right code for which I got the exact result I am looking for. — vamC, Mar 23 '17 at 15:49

score 4 · Accepted Answer · answered Mar 21 '17 at 15:25

4

The tolower function should do the trick like so:

df <- df %>% 
      mutate(colB = tolower(colB)

answered Mar 21 '17 at 15:25

jess

514
2
7

Yeah, This helped me. Thank you so much @jess – vamC Mar 23 '17 at 15:47

score 2 · Answer 2 · answered Mar 21 '17 at 15:26

2

dataframe$column<-sapply(dataframe$column, tolower)

answered Mar 21 '17 at 15:26

Clarius

918
8
7

it worked for me thanks! – N0rA May 07 '17 at 20:06

Converting the characters of strings in a single column into lowercase and getting the updated dataframe with all columns

2 Answers2