Publications by Guillaume Pressiat
A duck. Giving a look at DuckDB since MonetDBLite was removed from CRAN
You may know that MonetDBLite was removed from CRAN. DuckDB comming up. Breaking change > install.packages('MonetDBLite') Warning in install.packages : package ‘MonetDBLite’ is not available (for R version 3.6.1) People who based their works on MonetDBLite may ask what happened, what to do. Not to play a risky game with database and tools ...
4554 sym R (8639 sym/24 pcs) 2 img
dplyr and Oracle database with odbc on windows
RStudio makes Oracle accessibility from R easier via odbc and connections Pane1. Personally, I find it’s not so easy. As it finally works for me, I will detail some snippets here. After tens of try it seems good to share some tricks2. This blog post is also a notepad for me. Oracle and R configuration is a step where we potentially waste a lo...
2695 sym R (1383 sym/10 pcs) 4 img
dplyr and Oracle database with odbc on windows
RStudio makes Oracle accessibility from R easier via odbc and connections Pane1. Personally, I find it’s not so easy. As it finally works for me, I will detail some snippets here. After tens of try it seems good to share some tricks2. This blog post is also a notepad for me. Oracle and R configuration is a step where we potentially waste a lo...
2695 sym R (1383 sym/10 pcs) 4 img
Eyes on first wave with french open data — COVID-19
Covidfrance app was first developped beginning of April for family, friends (and myself) to automatically know every day how many cases there are in each department where they live, daily along this crisis. This app download daily csv file from french site data.gouv.fr via its api and build the map updated with last day data. Scientific colour m...
1853 sym 16 img
Eyes on first wave with french open data — COVID-19
Covidfrance app was first developped beginning of April for family, friends (and myself) to automatically know every day how many cases there are in each department where they live, daily along this crisis. This app download daily csv file from french site data.gouv.fr via its api and build the map updated with last day data. Scientific colour m...
1853 sym 16 img
Eyes on PCR tests with french open data — COVID-19
Link for the app: https://guillaumepressiat.shinyapps.io/covid-si-dep This app download daily csv file from french site data.gouv.fr via its api and build heatmaps updated with last day data available. ggplot2 with geom_tile to plot heatmaps and interactivity with plotly shinywidgets with pickerInput to let user choose its departments by tweekin...
1931 sym 4 img
Creative commons in the meantime
Just a little post about sharing code and skills with the unknown. After posting about covidfrance app, I exchanged with github users wanting to reproduce the app for their country.. I just want to say here that it was really a pleasure to exchange with people around the world like this. It was nice to share skills and to learn new things with...
991 sym 2 img
Eyes on RT-PCR tests with echarts and french open data — COVID-19
Data on COVID-19 screening tests for France ; a shared dashboard with calendar and other heatmaps Link for the app: https://guillaumepressiat.shinyapps.io/covid-si-dep This app download daily csv file from french site data.gouv.fr via its api and build heatmaps updated with last day data available. I have moved from ggplotly to echarts4r packag...
1518 sym 4 img
Using RSelenium to scrape a paginated HTML table
Trying to answer this question on stackoverflow about understat.com scraping I was interested to take RSelenium for a spin. Few years ago, Selenium and R weren’t particularly friends (Python+Selenium were more used for instance) but it seems to have changed. Package author and rOpenSci works and documentation did it. After few tries with xpat...
2035 sym R (2462 sym/1 pcs) 2 img
Using RSelenium to scrape a paginated HTML table
Trying to answer this question on stackoverflow about understat.com scraping I was interested to take RSelenium for a spin. Few years ago, Selenium and R weren’t particularly friends (Python+Selenium were more used for instance) but it seems to have changed. Package author and rOpenSci works and documentation did it. After few tries with xpat...
2037 sym R (2462 sym/1 pcs) 2 img