A table in human readable format Part III Last two times I showed you how easily you can extract information from EPPO SQLite database, put it into easily understandable table and how to make use of EPPO REST API. Below I show you I will show you how to download files straight into list and use to expand table. Lets prepare our workflow by defining some variables e.g. EPPOcodes.
Continue reading
A table in human readable format Part II Last time i showed you how easily you can extract information from EPPO SQLite database and put it into easily understandable table. Now, I will show you how to expand this table with data obtained from EPPO REST API. But first lets recall one thing we did last time. We defined variable EPPOcodes, which we will use in this part.
#query sql for codeid and eppocode sqlEppo %>% dbGetQuery(paste0('SELECT codeid, eppocode FROM t_codes WHERE codeid IN (', paste0(codeIdDB, collapse = ', '),')')) %>% arrange(eppocode) -> EPPOcodes We also need to set some constant variables to build up list of URL links for our REST queries.
Continue reading
A table in human readable format OK, time to run new blog have come. So, for the first post, I decided to write about something more meaningful than just ‘Look on what have I found on the Net…’. And first thing that came into my mind was ‘The Table’. It is actually thing that I made recently, to solve some time consuming issue in my work. I needed to merge data from different data structures in R into one table in human readable format.
Continue reading