critmcdonald

Keybase proof

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:

critmcdonald

---
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).

critmcdonald

<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>

critmcdonald

[
  {
    "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,

critmcdonald

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')
]

critmcdonald

"""
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

critmcdonald

// 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:

critmcdonald

Just a test, really.