url disappears after merging xlsx files using readxl package
Usually, I ask questions using a reproducible sample. However, due to the nature of the question, I am unable to provide a producible script.
I have a folder containing a list of .xlsx files and have merged the files together into one data frame using the readxl package. However, the url s in one column are no longer there.
How can I merge .xlsx files while preserving the url s? If it helps, here is the script that I used to merge the .xlsx files:
data.files = list.files()
df <- readxl::read_excel(data.files[1], sheet=1, skip=1) #reading the first file of list
for (file in data.files[-1]){
newFile <- readxl::read_excel(file, sheet=1, skip = 1) ## Drops the first row
df <- merge(df, newFile, all=T)
}
I would like to keep using the readxl package.
链接地址: http://www.djcxy.com/p/24806.html