search for: import_list

...t to a sufficiently large number (a number >= to the total amount of the full merged dataset). I want to automate the merging of the N number of Excel sheets so that I don't have to be manually doing it. Unless there is a way to accomplish something similar to what rio's package function import_list does, that is able to keep the field's numeric data type nature. Cheers, Paul El mar, 30 ene 2024 a las 12:23, Duncan Murdoch (<murdoch.duncan at gmail.com>) escribi?: > On 30/01/2024 11:10 a.m., Paul Bernal wrote: > > Dear friends, > > > > Hope you are doing well....

...unt of the full >>> merged dataset). I want to automate the merging of the N number of Excel >>> sheets so that I don't have to be manually doing it. Unless there is a >>> way >>> to accomplish something similar to what rio's package function >>> import_list >>> does, that is able to keep the field's numeric data type nature. >>> >>> Cheers, >>> Paul >>> >>> El mar, 30 ene 2024 a las 12:23, Duncan Murdoch (< >>> murdoch.duncan at gmail.com>) >>> escribi?: >>> &gt...

...e number (a number >= to the total amount of the full > merged dataset). I want to automate the merging of the N number of Excel > sheets so that I don't have to be manually doing it. Unless there is a > way to accomplish something similar to what rio's package function > import_list does, that is able to keep the field's numeric data type nature. > > Cheers, > Paul > > El mar, 30 ene 2024 a las 12:23, Duncan Murdoch > (<murdoch.duncan at gmail.com <mailto:murdoch.duncan at gmail.com>>) escribi?: > > On 30/01/2024 11:10 a.m., Paul...

..._max = 100000). > Now, when you have so many sheets (46 in my case) in an Excel file, the rio > methodology is more practical. > > This is what I did: > path = > "C:/Users/myuser/Documents/DataScienceF/Forecast_and_Econometric_Analysis_FIGI > (4).xlsx" > figidat = import_list(path, rbind = TRUE) #here figidat refers to my dataset > > Now, it successfully imports and merges all records, however, some fields > (despite being numeric), R interprets as a boolean field. > > Here is the structure of the field that is causing me problems (I apologize > for...

...umber (a number >= to the total amount of the full >> merged dataset). I want to automate the merging of the N number of Excel >> sheets so that I don't have to be manually doing it. Unless there is a way >> to accomplish something similar to what rio's package function import_list >> does, that is able to keep the field's numeric data type nature. >> >> Cheers, >> Paul >> >> El mar, 30 ene 2024 a las 12:23, Duncan Murdoch (< >> murdoch.duncan at gmail.com>) >> escribi?: >> >> > On 30/01/2024 11:10 a.m.,...

...th = filepath, sheet = sheet_name, guess_max = 100000). Now, when you have so many sheets (46 in my case) in an Excel file, the rio methodology is more practical. This is what I did: path = "C:/Users/myuser/Documents/DataScienceF/Forecast_and_Econometric_Analysis_FIGI (4).xlsx" figidat = import_list(path, rbind = TRUE) #here figidat refers to my dataset Now, it successfully imports and merges all records, however, some fields (despite being numeric), R interprets as a boolean field. Here is the structure of the field that is causing me problems (I apologize for the length): structure(list(St...