Scraping table from web link

user_7662939 0
Viewed 625

I want to extract the Holdings table from Here I have the following code:

 library(rvest)

 turl = 'https://whalewisdom.com/stock/spy'
 test_html = read_html(turl) 
 df<-html_table(test_html)

However on running it i get the following error:

Error in matrix(NA_character_, nrow = n, ncol = maxp) : invalid 'ncol' value (too large or NA) In addition: Warning messages: 1: In max(p) : no non-missing arguments to max; returning -Inf 2: In matrix(NA_character_, nrow = n, ncol = maxp) : NAs introduced by coercion to integer range

rvest web-scraping html-table r
2 Answers

Hi I came across the same situation, through searching around I came across a solution to this at R Studio Community

I hope this will be helpful to you too.

user_102391510

Index for the table of interest or simply grab the appropriate table node and use fill=True then do a little tidying on contents

library(rvest)
library(magrittr)

t <- (read_html('https://whalewisdom.com/stock/spy') %>%
          html_node('form + .table') %>%
          html_table(fill=T))
user_62412350
Related