Danny S. nygeog

## socrata-extract-latitude-longitude-w-pandas.py
import pandas as pd
#https://data.medicare.gov/Hospital-Compare/Readmissions-and-Deaths-Hospital/ynj2-r877

inCSV = 'Readmissions_and_Deaths_-_Hospital.csv'

df = pd.read_csv(inCSV)

df.head(10)

df['latitude']  = (df.Location.str.split('(',1).str[1]).str.split(',',1).str[0]

## 01-import-data.py
import os
import zipfile
import glob

#EDIT ONLY THESE TWO VARIABLES
cdbU = <cartoDBusername>
cdbK = <cartoDBapikey>

shpFolder  = 'data'

## nearJoin.py

def nearJoin(inFeature,nearFeature,nearDistance,outFileLocation,outFeature):
    ### Normal Near Function doesn't carry over all the attributes of inFeature or nearFeature.
    ### To Do:
    ### Error handling in try: except: should handle OBJECTID vs. FID issues.
    ### Example:
    ### inF = wd+"input/fulcrum.gdb/street_segment_questions_v2_prj"
    ### nrF = wd+"processing/gar.gdb/gar_roads_ftl"
    ### nrD = "20 Meters"
    ### ouL = wd+"processing/fulcrum.gdb"

## cartodb-install-ubuntu-1204.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                nygeog
                / cartodb-install-ubuntu-1204.md
            
            
              Last active
              August 29, 2015 14:21
                — forked from arjendk/cartodb-install-ubuntu-1204.md
            
          
    Installing CartoDB on Ubuntu Server 12.04

Get CartoDB Rails application source

sudo apt-get update

sudo apt-get install git

cd ~

git clone --recursive https://github.com/CartoDB/cartodb20.git

  
## test.js
var test = 5;

## index.html
<!DOCTYPE html>
<meta charset="utf-8">
<style>

.states {
  fill: none;
  stroke: #fff;
  stroke-linejoin: round;
}

## README.md

      
              4 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                nygeog
                / README.md
            
            
              Created
              August 15, 2014 23:51
                — forked from mbostock/.block
            
          
    This line chart is constructed from a TSV file storing the daily average temperatures of New York, San Francisco and Austin over the last year. The chart employs conventional margins and a number of D3 features:

d3.tsv - load and parse data
d3.time.format - parse dates
d3.time.scale - x-position encoding
d3.scale.linear - y-position encoding
d3.scale.category10, a d3.scale.ordinal - color encoding
d3.extent, d3.min and d3.max - compute domains
[d3.k


## index.html
<!DOCTYPE html>
<meta charset="utf-8">
<style>

.counties {
  fill:   none;
  stroke: black;
  opacity:0.2;
}

## pandas_slice_column.py
geoidCalc = df['UID'].str[2:]
df['geoid'] = geoidCalc

## installpandasmacports
sudo port install py27-pandas
	import pandas as pd
	#https://data.medicare.gov/Hospital-Compare/Readmissions-and-Deaths-Hospital/ynj2-r877

	inCSV = 'Readmissions_and_Deaths_-_Hospital.csv'

	df = pd.read_csv(inCSV)

	df.head(10)

	df['latitude'] = (df.Location.str.split('(',1).str[1]).str.split(',',1).str[0]
	import os
	import zipfile
	import glob

	#EDIT ONLY THESE TWO VARIABLES
	cdbU = <cartoDBusername>
	cdbK = <cartoDBapikey>

	shpFolder = 'data'

	def nearJoin(inFeature,nearFeature,nearDistance,outFileLocation,outFeature):
	### Normal Near Function doesn't carry over all the attributes of inFeature or nearFeature.
	### To Do:
	### Error handling in try: except: should handle OBJECTID vs. FID issues.
	### Example:
	### inF = wd+"input/fulcrum.gdb/street_segment_questions_v2_prj"
	### nrF = wd+"processing/gar.gdb/gar_roads_ftl"
	### nrD = "20 Meters"
	### ouL = wd+"processing/fulcrum.gdb"
	<!DOCTYPE html>
	<meta charset="utf-8">
	<style>

	.states {
	fill: none;
	stroke: #fff;
	stroke-linejoin: round;
	}