How to read a csv file in R
As data analysts you will need to load data from different sources, for this reason we will show you how to load a CSV file and the different options you have with the “read.csv”...
Category: Data extraction
Getting data from Microsoft Azure with R
Hi, how is it going? Today I want to show you how to take data from Microsoft Azure with R and Rest API method. We have two options to do that, we can use...
How to connect MySql database in R
Today I want to show you an example to connect Rstudio with MySQL server, to do that, yo will need the library RMySQL library(RMySQL) ## Loading required package: DBI First of all, we need...
How to read a xlsx file with multiple Sheets in R?
Hi Everyone, today I want to show you how to read a xlxs file in R, for use this function you must have the library readxl, so the first step is install the readxl...
Web Scraping of tables in R
How to scrape a web table in R? Sometimes we have needed to extract data from Wikipedia or another web page but it is quite uncomfortable to be extracting the data with the keyboard...
Get twitter data with R
Today we will see how to make a query to Twitter using its API and how to store this data in a csv to have them local. For this exercise you will need: 1º...