Objectives of the training
R is a statistical language dedicated to Data Science and is very rich in features. The proposed set of resources is aimed at anyone who wants to learn how to extract data from various sources (CSV, Excel, SQL database, Web API) with this language and then be able to manipulate and organize them. You will learn how to filter, sort, group, summarize, merge or clean data using different packages.Targeted audience
Computer scientistsPrerequisite
None.Trainers
Course architecture
• Presentation of R
• Installation and resources
• The package system
• RStudio IDE and creating a first script
• Variables and types
• Formats: vectors
• Formats: matrices
• Formats: DataFrame
• Formats: lists
• Conditions (if ... else)
• The loops
• The functions
• The apply functions
• Retrieving data from a CSV file
• Retrieving other data formats: Excel, SQL, API
Statistical analysis and first graphs
• Analysis of numerical variables
• Analysis of categorical variables
• Other statistical analysis methods
Rendering results: overview of possibilities
• Graphs
R language - Access all your data types
• Why R ?
• Installation of the environment
• Resources related to R
• Accessing data in CSV format
• Putting it into practice - Data Visualization: bar chart
• Accessing data in Excel format
• Practical Guide - Data Visualization: Scatterplot
• Accessing data from an SQL database
• Practical Guide - Data Visualization: Word Cloud
• Accessing data from an API
• Data Visualization Practice: Dynamic Bar Chart for the Web
• Accessing data from a NoSQL database
• Putting it into practice - Data Visualization: dynamic bar chart for the web
R language - Manipulate your data with the dplyr and tidyr packages
• Access to data in CSV format
• Access to other data formats (Excel, SQL databases, API...)
• Introduction to the "dplyr" package: syntax and pipe
• Manipulation of observations (rows)
• Manipulation of variables (columns)
• Creation of summary data tables
• Data joins
• Reshaping data
• Completing missing values
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quotePrivate or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote