{"action":"closed","issue":{"url":"https://api.github.com/repos/jj0hns0n/geonode/issues/30","labels_url":"https://api.github.com/repos/jj0hns0n/geonode/issues/30/labels{/name}","comments_url":"https://api.github.com/repos/jj0hns0n/geonode/issues/30/comments","events_url":"https://api.github.com/repos/jj0hns0n/geonode/issues/30/events","html_url":"https://github.com/jj0hns0n/geonode/issues/30","id":57367552,"number":30,"title":"Data Cleaning: Joining on Census Tracts","user":{"login":"raprasad","id":1036060,"avatar_url":"https://avatars.githubusercontent.com/u/1036060?v=3","gravatar_id":"","url":"https://api.github.com/users/raprasad","html_url":"https://github.com/raprasad","followers_url":"https://api.github.com/users/raprasad/followers","following_url":"https://api.github.com/users/raprasad/following{/other_user}","gists_url":"https://api.github.com/users/raprasad/gists{/gist_id}","starred_url":"https://api.github.com/users/raprasad/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raprasad/subscriptions","organizations_url":"https://api.github.com/users/raprasad/orgs","repos_url":"https://api.github.com/users/raprasad/repos","events_url":"https://api.github.com/users/raprasad/events{/privacy}","received_events_url":"https://api.github.com/users/raprasad/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jj0hns0n/geonode/labels/table-join","name":"table-join","color":"0052cc"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-02-11T19:50:21Z","updated_at":"2015-02-18T20:57:12Z","closed_at":"2015-02-18T20:57:12Z","body":"### Data cleaning before API calls\r\n- User specifies census tract column\r\n- Convert census tract column data to 6 digits, left pad values with zeros\r\n     - refererence:  https://www.census.gov/geo/reference/gtc/gtc_ct.html\r\n\r\n### Cleaning steps for Census Tract Column (for each value):\r\n1.  Strip value of decimals\r\n2.  Is value is all digits and non-blank?   (No alphas, no empty strings, no other chars, etc)\r\n    - No: Error row\r\n3.  Zero-Pad value up to six digits.  ```val.zfill(6)```\r\n4.  Make sure column itself is converted to a string column\r\n    - csvkit?\r\n    - pandas? (if on the dataverse side): http://stackoverflow.com/questions/23836277/add-leading-zeros-to-strings-in-pandas-dataframe"}}