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" function…
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 to…
How to read a xlsx file with multiple…
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 library.…
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 and…
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º Have…