R: HTML data

Preparation R for using HTML data

R can read exel spreadsheets . To read exel files it is necessary to use function read_exel(filename)

Before this function will be available in R, it is necessary to install proper dependencies for linux:

sudo apt-get install -y libxml2-dev libcurl4-openssl-dev libssl-dev

and also install this package with the R environment

install.packages("tidyverse")
install.packages("xtable")

Reading HTML from WEB

it is possible to read HTML file from the WEB

html_data <- read_html("URL") # read html from WEB
extracted_tables <- html_table(html_data) # extract all tables to list
length(extracted_tables) # check number of extracted tables
df <- extracted_tables[1] # use first table
str(df) # check our data

Exporting to HTML

We will write to HTML internal dataset mtcars. To do so we need to redirect our print to a html file with function sink(), then print it and then finish this redirection

> library(xtable)

> sink("mtcars.html")
> print(xtable(mtcars), type="html")
> sink()

Published: 2021-11-11 03:57:32
Updated: 2021-11-17 01:15:06

Last 10 artitles

• 2024-11-29 16:38:37 - Estimating super-sonic missile velocity in the atmosphere
• 2024-11-27 19:16:02 - YouTube manipulations
• 2024-10-31 19:17:21 - Hydrogen (H) electron density
• 2024-10-31 16:09:56 - Period 1 element
• 2024-10-31 12:46:28 - Atom electron clouds
• 2024-10-31 12:04:50 - Ephemerides
• 2024-10-19 14:46:49 - Polynomial fit with Numpy polyfit
• 2024-10-15 12:09:28 - Astronomy and Python
• 2024-07-24 10:19:17 - Calendar
• 2024-07-24 09:32:51 - Faker

9 popular artitles

• Python Panda (1475)
• Python NumPy (1025)
• Python: How to make absolute links in BeautifulSoup (774)
• In-place and out-place Numpy functions (724)
• Python: How to make video from images (721)
• Linear first order ODE (655)
• NumPy: What the difference between mgrid and meshgrid (637)
• Plotting of Interactive Electric field due to point charges with Matplotlib (568)
• How to reduce size of the numpy array (502)