Hi thank you for the tutorial It was very helpful, quick question, how would this work if one of the excel say "file 2" had multiple sheets of data within it?
Thank you, very helpful video. Is there a reason why you broke out the concat into a different step instead of using the 'full.names = TRUE' argument for list.files?
Hello i got an error at the moment to upload the data into R. This mentions that there is an error in Error in utils::unzip(zip_path, list = TRUE). The source is xlsx.
Great video thank you! Quick question, if my files are UTF-8, how can i tell it the character encoding? I have a bunch of UTF-8 CSVs and I cannot find the answer anywhere...
It is possible. I manually typed the file names vector as an example. You can replace this step with a way to retrieve the file names that you have and then assign it to the files using the names(files) as I show with the file names that you retrieved.
Hi, if you have a lot of processes running, then closing some of those might help. Can you try doing garbage collection before you run the code that I showed? Just execute the following command: gc( ) Also, you can check the memory limit that R is allowed to handle using the following command: memory.limit() If possible, increase it as such: memory.limit(size = 1800)
Hi thank you for the tutorial It was very helpful, quick question, how would this work if one of the excel say "file 2" had multiple sheets of data within it?
Thank you, very helpful video. Is there a reason why you broke out the concat into a different step instead of using the 'full.names = TRUE' argument for list.files?
Admittedly, I did it in a less efficient way. Good recommendation.
Hello i got an error at the moment to upload the data into R. This mentions that there is an error in Error in utils::unzip(zip_path, list = TRUE). The source is xlsx.
Great video thank you!
Quick question, if my files are UTF-8, how can i tell it the character encoding? I have a bunch of UTF-8 CSVs and I cannot find the answer anywhere...
You can specify the encoding as shown below. Hope this helps.
map_df(files, read_csv, locale = locale(encoding = 'UTF-8'))
Great video! I have a question: how can I create the data_source column with the name of each file (instead of file1, file2, etc)?
It is possible. I manually typed the file names vector as an example. You can replace this step with a way to retrieve the file names that you have and then assign it to the files using the names(files) as I show with the file names that you retrieved.
great video ! but my code runs into an error :cannot allocate vector of size 10.1 mb
Hi, if you have a lot of processes running, then closing some of those might help. Can you try doing garbage collection before you run the code that I showed?
Just execute the following command:
gc( )
Also, you can check the memory limit that R is allowed to handle using the following command:
memory.limit()
If possible, increase it as such:
memory.limit(size = 1800)
Hi Sir got my data loaded but is it same as data framing?
Not sure that I understand but the output is a dataframe of the multiple files.