Skip to main content

Working with Databases in R – Video Presentation from NairobiR and R-Ladies Nairobi

By June 24, 2021Blog, Events

During this Working with Databases in R online presentation, Christopher Maronga shares his years of practical experience in accessing and working with Databases in R. R Consortium assisted by providing access to Pro as a platform for information sharing

John Mutiso, a statistician and member of Nairobi R, introduces the presentation on Working with Databases in R and points to the support of the R-Ladies Nairobi Organizers and NairobiR Organizers. 

Christopher Maronga, a data manager, then shares his practically gained experience on how we can turn R into a powerful tool for accessing MySQL databases and writing SQL code, pulling and querying data from within the R environment.

Maronga structured this session to be mainly hands-on learning by using coding examples and implementations. In his presentation he teaches how to efficiently connect R to RDBMS, query data stored in the RDBMS via R, connect and export data from REDCap and API security. He introduces what RDBMS is and how it is used for storage and management of data. He then goes on to explain REDCap and how it is a secure web application for building and maintaining online surveys and databases. Maronga then jumps into practical examples illustrated through the use of a local SQL database.

In the concluding section, it is emphasized that just knowing how to get data into R efficiently is half the battle in the path towards using R in data science. The speaker ended the session on the note that we should expect to see many more collaborations between R-Ladies Nairobi Organizers and NairobiR Organizers in the future.

We’re looking forward to it!

Full video here

By section: