February 26, 2020 Dataset Open Access

Quebec International Relation and Economy web archive collection derivatives

Ruest, Nick; Gagné, Carole; Mitchell, Dave

Web archive derivatives of the Sites of the Quebec International Relation and Economy collection from the Bibliothèque et Archives nationales du Québec. The derivatives were created with the Archives Unleashed Toolkit. Merci beaucoup BAnQ!

These derivatives are in the Apache Parquet format, which is a columnar storage format. These derivatives are generally small enough to work with on your local machine, and can be easily converted to Pandas DataFrames. See this notebook for examples.

Domains

.webpages().groupBy(ExtractDomainDF($"url").alias("url")).count().sort($"count".desc)

Produces a DataFrame with the following columns:

• domain
• count

Web Pages

.webpages().select($"crawl_date", $"url", $"mime_type_web_server", $"mime_type_tika", RemoveHTMLDF(RemoveHTTPHeaderDF(($"content"))).alias("content"))

Produces a DataFrame with the following columns:

• crawl_date
• url
• mime_type_web_server
• mime_type_tika
• content

Web Graph

.webgraph()

Produces a DataFrame with the following columns:

• crawl_date
• src
• dest
• anchor

Image Links

.imageLinks()

Produces a DataFrame with the following columns:

• src
• image_url

Binary Analysis

• Audio
• Images
• PDFs
• Presentation program files
• Spreadsheets
• Text files
• Videos
• Word processor files