Skip to content

Latest commit

 

History

History
executable file
·
26 lines (21 loc) · 1.14 KB

README.md

File metadata and controls

executable file
·
26 lines (21 loc) · 1.14 KB
Raw

State of the Union Speeches of the United States of America scraper using Python - beautifulsoup4.

Alex John Quijano

Purpose. The scripts on this repository provides an easy way to scrape the state of the union speeches from https://www.presidency.ucsb.edu/documents/presidential-documents-archive-guidebook/annual-messages-congress-the-state-the-union.

Instructions.

  1. Clone repository and install the required Python modules.
git clone https://github.com/stressosaurus/raw-data-state-of-the-union.git
cd raw-data-state-of-the-union/
pip install -r requirements.txt
  1. Start scraping the website for the speeches by using the command below.
python wrangleSotu.py

The above command will create a 'html_files' folder with the html files of the speeches and a separate 'sotu.npy' will be created containing the processed data for easy access. The data is in a pandas DataFrame format containing columns 'year', 'month', 'day', 'president', 'title', and 'text'.

  1. You can open the "sotu.pkl" file by using the pandas module in Python.
import pandas as pd
sotu_df = pd.read_pickle('sotu.pkl')
print(sotu_df)