This course is designed to work on data extraction and storage, using R, students will learn to connect to data sources, whether flat files with read_csv, read_excel, or to connect to databases such as Access, SQL Server, etc… with RODBC, DBI or dplyr. Perform the necessary manipulations and calculations to finally save the data obtained.

Objectiu de l'acte

• Learn to install the necessary R packages
• Learn to read flat files with read()
• Learn to read data from a database
• Learn to read several files at once
• Learn to save with write()
• Learn how to create and update tables in a database

T'interessa si ets...

If you want to work on data extraction and storage, using R.