brew install libspatialite
geojson-to-sqlite toxmap.db hotspots hotspot_perimeters_for_data_store.geojson --spatialite
datasette toxmap.db --load-extension=spatialite
Derek Willis dwillis
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import os | |
| import csv | |
| from dateutil.parser import parse | |
| from slack import WebClient | |
| from slack.errors import SlackApiError | |
| slack_token = os.environ["SLACK_API_TOKEN"] | |
| client = WebClient(token=slack_token) | |
| march_27 = parse('3/27/2022').date() |
dwillis
/ group2_question_1.Rmd
Last active
March 7, 2022 20:07
Calculating police shootings' gender percentage with guns
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # create dataframe of all shootings by gender | |
| all_police_shootings_by_gender <- fatal_police_shootings %>% | |
| group_by(gender) %>% | |
| summarise(count=n()) %>% | |
| arrange(desc(count)) | |
| # create separate dataframes for each gender | |
| all_shootings_men <- all_police_shootings_by_gender %>% | |
| filter(gender == 'M') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Sample template for basic filtering, mutate and group_by with count | |
| ```{r} | |
| my_result <- original_data %>% | |
| filter(some_column == "some value") %>% | |
| mutate(some_column=str_to_title(some_column)) %>% | |
| group_by(some_column) %>% | |
| summarise(new_aggregate = n()) %>% | |
| arrange(desc(new_aggregate)) |
dwillis
/ gist:661b28924b1b3c212c11485a2948ec20
Created
November 22, 2021 18:43
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| F3XN C00694323 WINRED PO BOX 9891 ARLINGTON VA 22219 MY P2022 20210101 20210630 Ottenhoff Benjamin 20210728 506.45 258275844.90 258276351.35 258275634.48 716.87 0.00 105821.00 228991233.65 826.00 228992059.65 0.00 98300.00 229090359.65 0.00 0.00 0.00 0.00 29185485.25 0.00 0.00 0.00 0.00 258275844.90 258275844.90 0.00 0.00 615.58 615.58 0.00 229061108.65 0.00 0.00 0.00 0.00 29185485.25 0.00 0.00 29185485.25 28425.00 0.00 0.00 0.00 0.00 258275634.48 258275634.48 229090359.65 29185485.25 199904874.40 615.58 0.00 615.58 506.45 2021 258275844.90 258276351.35 258275634.48 716.87 228991233.65 826.00 228992059.65 0.00 98300.00 229090359.65 0.00 0.00 0.00 0.00 29185485.25 0.00 0.00 0.00 0.00 258275844.90 258275844.90 0.00 0.00 615.58 615.58 0.00 229061108.65 0.00 0.00 0.00 0.00 29185485.25 0.00 0.00 29185485.25 28425.00 0.00 0.00 0.00 0.00 258275634.48 258275634.48 229090359.65 29185485.25 199904874.40 615.58 0.00 615.58 |
dwillis
/ allegany.r
Created
October 12, 2021 16:45
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| allegany_sums_all <- allegany_athletics %>% | |
| group_by(county, year) %>% | |
| summarise(boys_total = sum(boys_participants), girls_total = sum(girls_participants)) %>% | |
| select(county, year, boys_total, girls_total) | |
| allegany_sums_without_cau <- allegany_athletics %>% | |
| filter(is.na(type)) %>% | |
| group_by(county, year) %>% | |
| summarise(boys_without_cs = sum(boys_participants), girls_without_cs = sum(girls_participants)) %>% | |
| select(county, year, boys_without_cs, girls_without_cs) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| html <- read_html("https://merrill.umd.edu/about/faculty-and-staff") | |
| # get faculty/staff names | |
| names <- html %>% html_nodes(".card-title") %>% html_text() | |
| length(faculty_staff) | |
| faculty_staff[1] | |
| # get titles |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| my_data %>% | |
| mutate( | |
| category = case_when( | |
| amount < 10000 ~ 'under_10k', | |
| amount < 50000 ~ '10k_50k', | |
| amount < 100000 ~ '50k_100k', | |
| amount < 500000 ~ '100k_500k', | |
| amount < 1000000 ~ '500k_1m', | |
| amount > 1000000 ~ '1m_plus' | |
| ) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| library(tidyverse) | |
| library(stringr) | |
| library(fs) | |
| results <- data.frame() | |
| years <- c('2021','2020') | |
| for (year in years) { | |
| data_dir <- str_c("/Users/dwillis/code/wbb/fiba/", year) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import csv | |
| source = 'greene.txt' | |
| offices = ['PRESIDENT AND VICE PRESIDENT', 'LIEUTENANT GOVERNOR FED-INTRA', 'GOVERNOR FED-INTRA', 'US Representative, District 34', 'SECRETARY OF STATE FED-INTRA', 'STATE TREASURER FED-INTRA', | |
| 'ATTORNEY GENERAL FED-INTRA', 'US REPRESENTATIVE - DISTRICT 7 FED-INTRA', 'STATE REPRESENTATIVE - 135 DST 135', 'COMMISSIONER - DISTRICT 2 DST 2', 'SHERIFF GREENE', 'ASSESSOR GREENE', | |
| 'TREASURER GREENE', 'PUBLIC ADMINISTRATOR GREENE', 'Constitutional Amendment No. 1 FED-INTRA', 'Constitutional Amendment No. 3 FED-INTRA', 'Supreme Court Judge - Patricia Breckenridge GREENE', | |
| 'Court of Appeals Judge, Southern District - Gary W.', '31st Judicial Circuit Div. No. 2 - Jones GREENE', '31st Judicial Circuit Div. No. 6 - Borthwick GREENE', 'Associate - 31st Circuit Div. No. 23 - Hosmer GREENE', | |
| 'Associate - 31st Circuit Div. No. 26 - Carrier GREENE', 'STATE REPRESENTATIVE - 134 DST 134', 'STATE REPRESENTATIVE - 132 DST 132', 'COMMISSIONER - DISTRICT 1 DST 1', 'STATE REPRESENTATIVE - 133 DST 133 |
NewerOlder