Adding single quotes to column in data frame

Question

I have a df with multiple columns that have many rows. I want to take one column and add single quotes around the values and a comma afterwards.

Column x
111111
222222
333333
444444

What I wanted it to look like:

Column x
'111111',
'222222',
'333333',
'444444',

Answer 1

For a single quote, sQuote can be used.

df1[,1] <- sQuote(df1[,1])

Or we can use sprintf to include the ' and the , afterwards

df1[,1] <- sprintf("'%d',", df1[,1])

Answer 2

If your column is df$x you would do:

df$x <- paste0("'", df$x, "',")