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

• 2023-12-25 01:48:38 - In-place and out-place Numpy functions
• 2023-12-25 00:58:08 - First order ordinary differential equations
• 2023-12-25 00:22:15 - How to increase swap space in Ubuntu
• 2023-12-24 04:03:12 - How to accelerate math calculations with Numba and Cython
• 2023-12-19 00:38:20 - 3 ways of function caching in Python
• 2023-12-19 00:16:55 - Accelerating Python
• 2023-12-16 12:26:55 - BioPython
• 2023-12-02 11:05:34 - Reading FITS files with astropy
• 2023-12-02 05:23:42 - Astropy
• 2023-12-01 00:33:16 - Circle length calculation with the Monte-Carlo method

9 popular artitles

• Python Panda (3443)
• Python NumPy (2979)
• Python DICTionary HowTo (1592)
• Python LIST HowTo (1471)
• Python (1422)
• Python Generators (1281)
• Python: How to make absolute links in BeautifulSoup (1086)
• Programming language (967)
• NumPy: What the difference between mgrid and meshgrid (948)