Just a test, really.
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
// First, in my Caspio search result, I don't include the | |
// detail page in the report, but instead create an HTML field that links | |
// to the report and passes two fields: the VenueID, which is used to pull | |
// the right record, and the SVenue, which is the name of the venue that | |
// I need for sharing. | |
<a href="venue.php?VenueID=[@field:VenueID]&Venue=[@field:SVenue]">[@field:SVenue]</a><br /> | |
// This gives me a url like this: |
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
""" | |
This script uses the datatset library to udpate data in a mysql/mariadb database. | |
In this use case, I'm taking the field RaceSex (Example: 'White Male') | |
and updating the Race field with the first letter of the first word | |
and updating the Gender field with the first letter of the last word | |
If RaceSex is null or blank, a 'U' is used. | |
""" | |
import dataset | |
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 agate | |
column_names = ['letter', 'number', 'state', 'city'] | |
column_types = [agate.Text(), agate.Number(), agate.Text(), agate.Text()] | |
rows = [ | |
('a', 1, 'TX', 'Austin'), | |
('b', 2, 'NY', 'Buffalo'), | |
('c', None, 'CA', 'Los Angeles') | |
] |
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
[ | |
{ | |
"op": "core/column-addition", | |
"description": "Create column tract_fix at index 6 based on column census_tract using expression grel:value", | |
"engineConfig": { | |
"mode": "row-based", | |
"facets": [] | |
}, | |
"newColumnName": "tract_fix", | |
"columnInsertIndex": 6, |
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
<script type="text/javascript" src="https://pym.nprapps.org/pym.v1.min.js"></script> | |
<script> | |
var pymChildRoster = new pym.Child(); | |
$(document).ready(function(){ | |
... stuff here ... | |
pymChildRoster.sendHeight(); | |
}); | |
</script> |
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
--- | |
title: "Mixed beverage download" | |
output: html_notebook | |
--- | |
## Setup | |
You might need to install the [RSocrata](https://cran.r-project.org/web/packages/RSocrata/index.html) package (run `install.packages("RSocrata")` in your R Console). [Documentation is here](https://github.com/Chicago/RSocrata). | |
I hereby claim:
- I am critmcdonald on github.
- I am crit (https://keybase.io/crit) on keybase.
- I have a public key ASDGeqjXZCWp2BjnBj0N0FPeFKy156I-3t_iqopGghQTmQo
To claim this, I am signing this object: