{"action":"created","comment":{"url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/comments/71957781","id":71957781,"diff_hunk":"@@ -0,0 +1,18 @@\n+require 'csv'\n+\n+namespace :import do\n+\n+  desc \"import rent data from csv\"\n+  task rent: :environment do\n+    filename = File.join Rails.root, \"data/zillow_rent_data.csv\"\n+    CSV.foreach(filename, headers: true) do |row|\n+      next if row[\"City\"] != \"Denver\"\n+      if Neighborhood.find_by(name: row[\"RegionName\"])\n+        neighborhood = Neighborhood.find_by(name: row[\"RegionName\"]) \n+      else\n+        next\n+      end\n+      neighborhood.update_attributes(rent: row[\"Zri\"])","path":"lib/tasks/import.rake","position":15,"original_position":15,"commit_id":"c33156b8c4542c0b1594a4cb4c61f1d591456495","original_commit_id":"c33156b8c4542c0b1594a4cb4c61f1d591456495","user":{"login":"NickyBobby","id":13855453,"avatar_url":"https://avatars.githubusercontent.com/u/13855453?v=3","gravatar_id":"","url":"https://api.github.com/users/NickyBobby","html_url":"https://github.com/NickyBobby","followers_url":"https://api.github.com/users/NickyBobby/followers","following_url":"https://api.github.com/users/NickyBobby/following{/other_user}","gists_url":"https://api.github.com/users/NickyBobby/gists{/gist_id}","starred_url":"https://api.github.com/users/NickyBobby/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NickyBobby/subscriptions","organizations_url":"https://api.github.com/users/NickyBobby/orgs","repos_url":"https://api.github.com/users/NickyBobby/repos","events_url":"https://api.github.com/users/NickyBobby/events{/privacy}","received_events_url":"https://api.github.com/users/NickyBobby/received_events","type":"User","site_admin":false},"body":"Sweet rake task!! 👍 ","created_at":"2016-07-22T23:07:38Z","updated_at":"2016-07-22T23:07:38Z","html_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app/pull/37#discussion_r71957781","pull_request_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/37","_links":{"self":{"href":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/comments/71957781"},"html":{"href":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app/pull/37#discussion_r71957781"},"pull_request":{"href":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/37"}}},"pull_request":{"url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/37","id":78540505,"html_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app/pull/37","diff_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app/pull/37.diff","patch_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app/pull/37.patch","issue_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues/37","number":37,"state":"open","locked":false,"title":"Rent import","user":{"login":"kjs222","id":11400778,"avatar_url":"https://avatars.githubusercontent.com/u/11400778?v=3","gravatar_id":"","url":"https://api.github.com/users/kjs222","html_url":"https://github.com/kjs222","followers_url":"https://api.github.com/users/kjs222/followers","following_url":"https://api.github.com/users/kjs222/following{/other_user}","gists_url":"https://api.github.com/users/kjs222/gists{/gist_id}","starred_url":"https://api.github.com/users/kjs222/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kjs222/subscriptions","organizations_url":"https://api.github.com/users/kjs222/orgs","repos_url":"https://api.github.com/users/kjs222/repos","events_url":"https://api.github.com/users/kjs222/events{/privacy}","received_events_url":"https://api.github.com/users/kjs222/received_events","type":"User","site_admin":false},"body":"***NOTE this PR includes the code from still open PR (the one that refactored neighborhood analyst)\r\n\r\nThis PR adds the following on to that code base.  This is the illustrious work of Ilana, Tommasina and Kerry. \r\n\r\nAdd rent to neighborhood table\r\n- Changed table name to Neighborhood (model name too)\r\n- Add rent column to neighborhood table\r\n- Rake task added to import rents from csv saved locally\r\n- Manually added rents for 3 neighborhood not in csv\r\n- CBD got Union Station rent\r\n- Kenndedy got Hampden rent\r\n- Sun Vally got Lincoln rent","created_at":"2016-07-22T21:07:37Z","updated_at":"2016-07-22T23:07:38Z","closed_at":null,"merged_at":null,"merge_commit_sha":"1081e8ff80745a053221bde2c0c5f8fe9e9e73d3","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/37/commits","review_comments_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/37/comments","review_comment_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/comments{/number}","comments_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues/37/comments","statuses_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/statuses/c33156b8c4542c0b1594a4cb4c61f1d591456495","head":{"label":"Turing-Pahlka-Posse:rent_import","ref":"rent_import","sha":"c33156b8c4542c0b1594a4cb4c61f1d591456495","user":{"login":"Turing-Pahlka-Posse","id":18356491,"avatar_url":"https://avatars.githubusercontent.com/u/18356491?v=3","gravatar_id":"","url":"https://api.github.com/users/Turing-Pahlka-Posse","html_url":"https://github.com/Turing-Pahlka-Posse","followers_url":"https://api.github.com/users/Turing-Pahlka-Posse/followers","following_url":"https://api.github.com/users/Turing-Pahlka-Posse/following{/other_user}","gists_url":"https://api.github.com/users/Turing-Pahlka-Posse/gists{/gist_id}","starred_url":"https://api.github.com/users/Turing-Pahlka-Posse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Turing-Pahlka-Posse/subscriptions","organizations_url":"https://api.github.com/users/Turing-Pahlka-Posse/orgs","repos_url":"https://api.github.com/users/Turing-Pahlka-Posse/repos","events_url":"https://api.github.com/users/Turing-Pahlka-Posse/events{/privacy}","received_events_url":"https://api.github.com/users/Turing-Pahlka-Posse/received_events","type":"Organization","site_admin":false},"repo":{"id":55811011,"name":"affordable_housing_app","full_name":"Turing-Pahlka-Posse/affordable_housing_app","owner":{"login":"Turing-Pahlka-Posse","id":18356491,"avatar_url":"https://avatars.githubusercontent.com/u/18356491?v=3","gravatar_id":"","url":"https://api.github.com/users/Turing-Pahlka-Posse","html_url":"https://github.com/Turing-Pahlka-Posse","followers_url":"https://api.github.com/users/Turing-Pahlka-Posse/followers","following_url":"https://api.github.com/users/Turing-Pahlka-Posse/following{/other_user}","gists_url":"https://api.github.com/users/Turing-Pahlka-Posse/gists{/gist_id}","starred_url":"https://api.github.com/users/Turing-Pahlka-Posse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Turing-Pahlka-Posse/subscriptions","organizations_url":"https://api.github.com/users/Turing-Pahlka-Posse/orgs","repos_url":"https://api.github.com/users/Turing-Pahlka-Posse/repos","events_url":"https://api.github.com/users/Turing-Pahlka-Posse/events{/privacy}","received_events_url":"https://api.github.com/users/Turing-Pahlka-Posse/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app","description":"","fork":false,"url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app","forks_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/forks","keys_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/teams","hooks_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/hooks","issue_events_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues/events{/number}","events_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/events","assignees_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/assignees{/user}","branches_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/branches{/branch}","tags_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/tags","blobs_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/refs{/sha}","trees_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/statuses/{sha}","languages_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/languages","stargazers_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/stargazers","contributors_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/contributors","subscribers_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/subscribers","subscription_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/subscription","commits_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/commits{/sha}","git_commits_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/commits{/sha}","comments_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/comments{/number}","issue_comment_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues/comments{/number}","contents_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/contents/{+path}","compare_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/merges","archive_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/downloads","issues_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues{/number}","pulls_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls{/number}","milestones_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/milestones{/number}","notifications_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/labels{/name}","releases_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/releases{/id}","deployments_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/deployments","created_at":"2016-04-08T21:33:23Z","updated_at":"2016-04-08T21:34:42Z","pushed_at":"2016-07-22T22:36:09Z","git_url":"git://github.com/Turing-Pahlka-Posse/affordable_housing_app.git","ssh_url":"git@github.com:Turing-Pahlka-Posse/affordable_housing_app.git","clone_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app.git","svn_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app","homepage":null,"size":1741,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":25,"forks":0,"open_issues":25,"watchers":0,"default_branch":"master"}},"base":{"label":"Turing-Pahlka-Posse:master","ref":"master","sha":"87b0933c16bcc5029b538c2b62902924ad8f544c","user":{"login":"Turing-Pahlka-Posse","id":18356491,"avatar_url":"https://avatars.githubusercontent.com/u/18356491?v=3","gravatar_id":"","url":"https://api.github.com/users/Turing-Pahlka-Posse","html_url":"https://github.com/Turing-Pahlka-Posse","followers_url":"https://api.github.com/users/Turing-Pahlka-Posse/followers","following_url":"https://api.github.com/users/Turing-Pahlka-Posse/following{/other_user}","gists_url":"https://api.github.com/users/Turing-Pahlka-Posse/gists{/gist_id}","starred_url":"https://api.github.com/users/Turing-Pahlka-Posse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Turing-Pahlka-Posse/subscriptions","organizations_url":"https://api.github.com/users/Turing-Pahlka-Posse/orgs","repos_url":"https://api.github.com/users/Turing-Pahlka-Posse/repos","events_url":"https://api.github.com/users/Turing-Pahlka-Posse/events{/privacy}","received_events_url":"https://api.github.com/users/Turing-Pahlka-Posse/received_events","type":"Organization","site_admin":false},"repo":{"id":55811011,"name":"affordable_housing_app","full_name":"Turing-Pahlka-Posse/affordable_housing_app","owner":{"login":"Turing-Pahlka-Posse","id":18356491,"avatar_url":"https://avatars.githubusercontent.com/u/18356491?v=3","gravatar_id":"","url":"https://api.github.com/users/Turing-Pahlka-Posse","html_url":"https://github.com/Turing-Pahlka-Posse","followers_url":"https://api.github.com/users/Turing-Pahlka-Posse/followers","following_url":"https://api.github.com/users/Turing-Pahlka-Posse/following{/other_user}","gists_url":"https://api.github.com/users/Turing-Pahlka-Posse/gists{/gist_id}","starred_url":"https://api.github.com/users/Turing-Pahlka-Posse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Turing-Pahlka-Posse/subscriptions","organizations_url":"https://api.github.com/users/Turing-Pahlka-Posse/orgs","repos_url":"https://api.github.com/users/Turing-Pahlka-Posse/repos","events_url":"https://api.github.com/users/Turing-Pahlka-Posse/events{/privacy}","received_events_url":"https://api.github.com/users/Turing-Pahlka-Posse/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app","description":"","fork":false,"url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app","forks_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/forks","keys_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/teams","hooks_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/hooks","issue_events_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues/events{/number}","events_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/events","assignees_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/assignees{/user}","branches_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/branches{/branch}","tags_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/tags","blobs_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/refs{/sha}","trees_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/statuses/{sha}","languages_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/languages","stargazers_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/stargazers","contributors_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/contributors","subscribers_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/subscribers","subscription_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/subscription","commits_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/commits{/sha}","git_commits_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/git/commits{/sha}","comments_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/comments{/number}","issue_comment_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues/comments{/number}","contents_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/contents/{+path}","compare_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/merges","archive_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/downloads","issues_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues{/number}","pulls_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls{/number}","milestones_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/milestones{/number}","notifications_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/labels{/name}","releases_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/releases{/id}","deployments_url":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/deployments","created_at":"2016-04-08T21:33:23Z","updated_at":"2016-04-08T21:34:42Z","pushed_at":"2016-07-22T22:36:09Z","git_url":"git://github.com/Turing-Pahlka-Posse/affordable_housing_app.git","ssh_url":"git@github.com:Turing-Pahlka-Posse/affordable_housing_app.git","clone_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app.git","svn_url":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app","homepage":null,"size":1741,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":25,"forks":0,"open_issues":25,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/37"},"html":{"href":"https://github.com/Turing-Pahlka-Posse/affordable_housing_app/pull/37"},"issue":{"href":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues/37"},"comments":{"href":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/issues/37/comments"},"review_comments":{"href":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/37/comments"},"review_comment":{"href":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/pulls/37/commits"},"statuses":{"href":"https://api.github.com/repos/Turing-Pahlka-Posse/affordable_housing_app/statuses/c33156b8c4542c0b1594a4cb4c61f1d591456495"}}}}
{"actor":{"display_login":"NickyBobby"}}