Split an address separated by comma

Question

I have a data.frame of house sale transactions. At the moment the Address is in format.

  1 Accacia Avenue,This Town,This City,A10 1AA.

Is there a way I can split this into different columns in the data.frame removing the , at the same time?

I have created a separate vector for now just containing addresses.

The Address in stored in the Address column of the Dataframe - data.

head(data$Address)
[1] 22 Amesbury Road, Feltham (TW13 5HJ)
[2]Flat 11, Gloucester Court, Links Road, London (W3 0EW)

I need to split this into

"Address1", "Address2", "Address3"

and I also need to remove the postcode within () as I already have this in a separate field.

Answer 1

library(tidyr)
df <- data.frame(address = c("1 Accacia Avenue,This Town,This City,A10 1AA"))
separate(df , address , c("country" , "town" , "city" , "street") , ",")



# country             town      city      street
# 1 Accacia Avenue This Town This City   A10 1AA

these are dummy columns you can change column names as per your address