Closed pitmonticone closed 3 years ago
Hello @pitmonticone ,
By reading the Table methods implementations, I found one may convert your Table object in a DataFrame this way:
# Import Modules
using DataFrames, HTTP, TableScraper
# Scrape Table
table = scrape_tables("https://www.agenas.gov.it/covid19/web/index.php?r=site%2Fprovvedimento&q=010")[1]
# check length of table (it will be the number of rows of the resulting DataFrame)
length(table)
# get number of necessary columns
length(Tables.getcolumn(table,1)[1])
# construct output dataframe
df = DataFrame(date = String[], document = String[], content_1 = String[], content_2 = String[], dpgr_number = String[], void = String[] )
# fill the dataframe
for vect in Tables.getcolumn(table,1)
push!(df, vect)
end
# print result
df
Another way you could do it is by appending columns instead of rows.
Note that I am not a developer of this package, so this may not be the optimal solution.
@ClaudMor Thanks.
@pitmonticone I've made a fix in the code. It should work now. In the latest version. Should be available in a few hours.
Hi,
I'm trying to scrape the table embedded in this website with the following code:
Unfortunately it doesn't seem to be able to correctly covert a
TableScraper.Table
to aDataFrame
object:What am I doing wrong here? Do you know a way to fix this problem?
Thank you very much for the development and maintenance of this useful package!