Dear all, I have had difficulties copying the word "alcohol" in the "vehicle" column to replace the string in the column "accident_type". It is a huge list but I have prepared a workable and simple example below and the desired output. I am sure you guys can give me some advice on how to deal with this.
sapply( all_files, function(x) dim(x)) [,1] [,2] [,3] [,4] [1,] 89563 69295 67446 39709 [2,] 33 33 33 33 ###Simple List A= data.frame(c("1", "2", "3", "4"),c(4:7),c("car", "byke", "alcohol", "motocycle"), c("alcohol", "cell_phone", "some_string", "fog")) colnames(A) <- c("id", "km","vehicle","accident_cause") A B= data.frame(c("1", "2", "3", "4"),c(4:7),c("car", "alcohol", "car", "motocycle"), c("alcohol", "some_string", "rain", "fog")) colnames(B) <- c("id", "km", "vehicle", "accident_type") B C= data.frame(c("1", "2", "3", "4"),c(4:7),c("car", "alcohol", "car", "alcohol"), c("alcohol", "some_string", "rain", "some_string")) colnames(C) <- c("id", "km", "vehicle", "accident_type") C mylist <- list(A=A,B=B,C=C) mylist ###Desired output A= data.frame(c("1", "2", "3", "4"),c(4:7),c("car", "byke", "alcohol", "motocycle"), c("alcohol", "cell_phone", "alcohol", "fog")) colnames(A) <- c("id", "km","vehicle","accident_cause") A B= data.frame(c("1", "2", "3", "4"),c(4:7),c("car", "alcohol", "car", "motocycle"), c("alcohol", "alcohol", "rain", "fog")) colnames(B) <- c("id", "km", "vehicle", "accident_type") B C= data.frame(c("1", "2", "3", "4"),c(4:7),c("car", "alcohol", "car", "alcohol"), c("alcohol", "alcohol", "rain", "alcohol")) colnames(C) <- c("id", "km", "vehicle", "accident_type") C mylist <- list(A=A,B=B,C=C) mylist ##Thank you very much, -- Andre [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.