Skip to content

Instantly share code, notes, and snippets.

View jalbertbowden's full-sized avatar

albert jalbertbowden

180 followers · 598 following
View GitHub Profile
@jalbertbowden
jalbertbowden / scrape-docx.py
Created February 12, 2021 21:17
Scrape .docx with python-docx library.
from docx import Document
document = Document('form_example.docx')
document.save('form_example.docx')
for table in document.tables:
for row in table.rows:
for cell in row.cells:
for para in cell.paragraphs:
print(para.text)
@jalbertbowden
jalbertbowden / covid-19-virginia-ltcf-data.py
Last active February 9, 2021 01:57
COVID-19 Virginia LTCF Dataops - Python script for cleaning up Virginia LTCF COVID-19 data.
from csv import DictReader, DictWriter
import csv
file_name_base = 'vdh-covid-19-public-use-dataset-outbreaks-in-selected-exposure-settings-'
file_date = '2021-01-29'
file_row_report_date = '01/29/2021'
file_format = '.csv'
file_dataset = '-ltcf'
file_step_1 = '-fixed'
file_step_2 = '-updated'
@jalbertbowden
jalbertbowden / map.geojson
Created January 18, 2021 03:52
Virginia Trail Guide Map - https://virginiatrailguide.com/trail-list/
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jalbertbowden
jalbertbowden / longwood-covid-19.csv
Last active December 16, 2020 18:16
scrape longwood covid data
Active Cases Total Cumulative Cases Total Students Total Faculty Date
@jalbertbowden
jalbertbowden / index.js
Created November 27, 2020 07:36 — forked from bcks/index.js
tableau-covid-scraping
// Works with Node v12.0 and puppeteer 4.0
const URL = 'https://public.tableau.com/views/PPV_15924847800480/ppv_db?%3Aembed=y&%3AshowVizHome=no&%3Adisplay_count=y&%3Adisplay_static_image=n&%3AbootstrapWhenNotified=true&%3Alanguage=en&:embed=y&:showVizHome=n&:apiID=host0';
const puppeteer = require('puppeteer');
function parseDataDictionary(jsonParsed) {
@jalbertbowden
jalbertbowden / nevada-facilities-bi.json
Created November 20, 2020 07:06
Nevada Facilities with Reported COVID-19 Cases Power BI Dashboard CURL export
{
"models": [
{
"id": 274097,
"vsName": "sobe_wowvirtualserver",
"dbName": "10a1e28c-bfcb-4358-bb18-0cb39b08a031",
"currentRefreshStartingTime": "",
"refreshSchedule": {
"importAndRefreshBehavior": 0,
"executionTime": null,
@jalbertbowden
jalbertbowden / get-cms-nursing.py
Created November 14, 2020 22:50
get-cms-nursing.py - automating accessing cms.gov's weekly nursing home dataset and chopping it up into digestable csvs: by state, and by state + date.
import requests
import os
import csv
nursing_home_dataset_csv_url = 'https://data.cms.gov/api/views/s2uc-8wxp/rows.csv?accessType=DOWNLOAD'
nursing_home_dataset_csv_file = 'COVID-19_Nursing_Home_Dataset.csv'
@jalbertbowden
jalbertbowden / map.geojson
Last active November 12, 2020 06:10
Hurricane Harvey - Points - https://www.ncei.noaa.gov/data/international-best-track-archive-for-climate-stewardship-ibtracs/v04r00/access/shapefile/
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jalbertbowden
jalbertbowden / map.geojson
Last active November 12, 2020 06:09
Hurricane Harvey - Lines - https://www.ncei.noaa.gov/data/international-best-track-archive-for-climate-stewardship-ibtracs/v04r00/access/shapefile/
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jalbertbowden
jalbertbowden / map.geojson
Last active October 17, 2020 07:31
Voter Precincts - Richmond, VA
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.