{"action":"created","comment":{"url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/comments/82202072","pull_request_review_id":3122240,"id":82202072,"diff_hunk":"@@ -99,5 +196,35 @@ carrier flies to/from Houston in the month of July.  Consider the `month()`\n function from the `lubridate` package.\n \n ```{r, echo=FALSE, message=FALSE, fig.width=12, fig.height=6}\n-\n+july <- full_join(flights, airports, by = c(\"dest\"=\"iata\"))\n+july <- full_join(july, states, by=\"state\") %>%\n+  filter(lubridate::month(date) == 07) %>%\n+  select(date, flight, dest, state, region, carrier) \n+\n+regional_sums <- tally(group_by(july, carrier, region))\n+\n+regional_proportions <- regional_sums %>%\n+  group_by(carrier) %>%\n+  mutate(carrier_sum = sum(n)) %>%\n+  mutate(proportion = format(n/carrier_sum, digits=3))\n+regional_proportions %>% knitr::kable()\n+# this table is good except the demoninator in calculating the proportion includes the \"NA\" region.. \n+# there aren't too many missing values, but still.\n+NA_vals <- july %>% filter(is.na(region))","path":"HW-1.Rmd","position":187,"original_position":187,"commit_id":"455b0694f8a2fe8b6c69043fbb64d4bf6905c435","original_commit_id":"455b0694f8a2fe8b6c69043fbb64d4bf6905c435","user":{"login":"rudeboybert","id":4574203,"avatar_url":"https://avatars.githubusercontent.com/u/4574203?v=3","gravatar_id":"","url":"https://api.github.com/users/rudeboybert","html_url":"https://github.com/rudeboybert","followers_url":"https://api.github.com/users/rudeboybert/followers","following_url":"https://api.github.com/users/rudeboybert/following{/other_user}","gists_url":"https://api.github.com/users/rudeboybert/gists{/gist_id}","starred_url":"https://api.github.com/users/rudeboybert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rudeboybert/subscriptions","organizations_url":"https://api.github.com/users/rudeboybert/orgs","repos_url":"https://api.github.com/users/rudeboybert/repos","events_url":"https://api.github.com/users/rudeboybert/events{/privacy}","received_events_url":"https://api.github.com/users/rudeboybert/received_events","type":"User","site_admin":false},"body":"The NA's were due to only two airports not being in `airports`, no? `EKG` and `BCP`. This could be very easily fixed manually!","created_at":"2016-10-06T14:32:12Z","updated_at":"2016-10-06T14:34:52Z","html_url":"https://github.com/2016-09-Middlebury-Data-Science/HW-1/pull/1#discussion_r82202072","pull_request_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/1","_links":{"self":{"href":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/comments/82202072"},"html":{"href":"https://github.com/2016-09-Middlebury-Data-Science/HW-1/pull/1#discussion_r82202072"},"pull_request":{"href":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/1"}}},"pull_request":{"url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/1","id":86520469,"html_url":"https://github.com/2016-09-Middlebury-Data-Science/HW-1/pull/1","diff_url":"https://github.com/2016-09-Middlebury-Data-Science/HW-1/pull/1.diff","patch_url":"https://github.com/2016-09-Middlebury-Data-Science/HW-1/pull/1.patch","issue_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/issues/1","number":1,"state":"open","locked":false,"title":"Nina Sonneborn HW1 Presubmission Sept 23, 2016","user":{"login":"nsonneborn","id":22140033,"avatar_url":"https://avatars.githubusercontent.com/u/22140033?v=3","gravatar_id":"","url":"https://api.github.com/users/nsonneborn","html_url":"https://github.com/nsonneborn","followers_url":"https://api.github.com/users/nsonneborn/followers","following_url":"https://api.github.com/users/nsonneborn/following{/other_user}","gists_url":"https://api.github.com/users/nsonneborn/gists{/gist_id}","starred_url":"https://api.github.com/users/nsonneborn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nsonneborn/subscriptions","organizations_url":"https://api.github.com/users/nsonneborn/orgs","repos_url":"https://api.github.com/users/nsonneborn/repos","events_url":"https://api.github.com/users/nsonneborn/events{/privacy}","received_events_url":"https://api.github.com/users/nsonneborn/received_events","type":"User","site_admin":false},"body":"","created_at":"2016-09-23T14:16:20Z","updated_at":"2016-10-06T14:34:52Z","closed_at":null,"merged_at":null,"merge_commit_sha":"228d34169b64d4b3f8a40f4ec6f7d8c3acc1060e","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/1/commits","review_comments_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/1/comments","review_comment_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/comments{/number}","comments_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/issues/1/comments","statuses_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/statuses/455b0694f8a2fe8b6c69043fbb64d4bf6905c435","head":{"label":"nsonneborn:master","ref":"master","sha":"455b0694f8a2fe8b6c69043fbb64d4bf6905c435","user":{"login":"nsonneborn","id":22140033,"avatar_url":"https://avatars.githubusercontent.com/u/22140033?v=3","gravatar_id":"","url":"https://api.github.com/users/nsonneborn","html_url":"https://github.com/nsonneborn","followers_url":"https://api.github.com/users/nsonneborn/followers","following_url":"https://api.github.com/users/nsonneborn/following{/other_user}","gists_url":"https://api.github.com/users/nsonneborn/gists{/gist_id}","starred_url":"https://api.github.com/users/nsonneborn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nsonneborn/subscriptions","organizations_url":"https://api.github.com/users/nsonneborn/orgs","repos_url":"https://api.github.com/users/nsonneborn/repos","events_url":"https://api.github.com/users/nsonneborn/events{/privacy}","received_events_url":"https://api.github.com/users/nsonneborn/received_events","type":"User","site_admin":false},"repo":{"id":68818633,"name":"HW-1","full_name":"nsonneborn/HW-1","owner":{"login":"nsonneborn","id":22140033,"avatar_url":"https://avatars.githubusercontent.com/u/22140033?v=3","gravatar_id":"","url":"https://api.github.com/users/nsonneborn","html_url":"https://github.com/nsonneborn","followers_url":"https://api.github.com/users/nsonneborn/followers","following_url":"https://api.github.com/users/nsonneborn/following{/other_user}","gists_url":"https://api.github.com/users/nsonneborn/gists{/gist_id}","starred_url":"https://api.github.com/users/nsonneborn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nsonneborn/subscriptions","organizations_url":"https://api.github.com/users/nsonneborn/orgs","repos_url":"https://api.github.com/users/nsonneborn/repos","events_url":"https://api.github.com/users/nsonneborn/events{/privacy}","received_events_url":"https://api.github.com/users/nsonneborn/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/nsonneborn/HW-1","description":"Data manipulation/wrangling with dplyr (and some visualization!)","fork":true,"url":"https://api.github.com/repos/nsonneborn/HW-1","forks_url":"https://api.github.com/repos/nsonneborn/HW-1/forks","keys_url":"https://api.github.com/repos/nsonneborn/HW-1/keys{/key_id}","collaborators_url":"https://api.github.com/repos/nsonneborn/HW-1/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/nsonneborn/HW-1/teams","hooks_url":"https://api.github.com/repos/nsonneborn/HW-1/hooks","issue_events_url":"https://api.github.com/repos/nsonneborn/HW-1/issues/events{/number}","events_url":"https://api.github.com/repos/nsonneborn/HW-1/events","assignees_url":"https://api.github.com/repos/nsonneborn/HW-1/assignees{/user}","branches_url":"https://api.github.com/repos/nsonneborn/HW-1/branches{/branch}","tags_url":"https://api.github.com/repos/nsonneborn/HW-1/tags","blobs_url":"https://api.github.com/repos/nsonneborn/HW-1/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/nsonneborn/HW-1/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/nsonneborn/HW-1/git/refs{/sha}","trees_url":"https://api.github.com/repos/nsonneborn/HW-1/git/trees{/sha}","statuses_url":"https://api.github.com/repos/nsonneborn/HW-1/statuses/{sha}","languages_url":"https://api.github.com/repos/nsonneborn/HW-1/languages","stargazers_url":"https://api.github.com/repos/nsonneborn/HW-1/stargazers","contributors_url":"https://api.github.com/repos/nsonneborn/HW-1/contributors","subscribers_url":"https://api.github.com/repos/nsonneborn/HW-1/subscribers","subscription_url":"https://api.github.com/repos/nsonneborn/HW-1/subscription","commits_url":"https://api.github.com/repos/nsonneborn/HW-1/commits{/sha}","git_commits_url":"https://api.github.com/repos/nsonneborn/HW-1/git/commits{/sha}","comments_url":"https://api.github.com/repos/nsonneborn/HW-1/comments{/number}","issue_comment_url":"https://api.github.com/repos/nsonneborn/HW-1/issues/comments{/number}","contents_url":"https://api.github.com/repos/nsonneborn/HW-1/contents/{+path}","compare_url":"https://api.github.com/repos/nsonneborn/HW-1/compare/{base}...{head}","merges_url":"https://api.github.com/repos/nsonneborn/HW-1/merges","archive_url":"https://api.github.com/repos/nsonneborn/HW-1/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/nsonneborn/HW-1/downloads","issues_url":"https://api.github.com/repos/nsonneborn/HW-1/issues{/number}","pulls_url":"https://api.github.com/repos/nsonneborn/HW-1/pulls{/number}","milestones_url":"https://api.github.com/repos/nsonneborn/HW-1/milestones{/number}","notifications_url":"https://api.github.com/repos/nsonneborn/HW-1/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/nsonneborn/HW-1/labels{/name}","releases_url":"https://api.github.com/repos/nsonneborn/HW-1/releases{/id}","deployments_url":"https://api.github.com/repos/nsonneborn/HW-1/deployments","created_at":"2016-09-21T13:17:47Z","updated_at":"2016-09-21T13:03:46Z","pushed_at":"2016-10-05T13:58:31Z","git_url":"git://github.com/nsonneborn/HW-1.git","ssh_url":"git@github.com:nsonneborn/HW-1.git","clone_url":"https://github.com/nsonneborn/HW-1.git","svn_url":"https://github.com/nsonneborn/HW-1","homepage":"","size":4039,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"2016-09-Middlebury-Data-Science:master","ref":"master","sha":"d9f76b83774dcd81a732d4948b2b1931084b5d4d","user":{"login":"2016-09-Middlebury-Data-Science","id":22043879,"avatar_url":"https://avatars.githubusercontent.com/u/22043879?v=3","gravatar_id":"","url":"https://api.github.com/users/2016-09-Middlebury-Data-Science","html_url":"https://github.com/2016-09-Middlebury-Data-Science","followers_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/followers","following_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/following{/other_user}","gists_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/gists{/gist_id}","starred_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/subscriptions","organizations_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/orgs","repos_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/repos","events_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/events{/privacy}","received_events_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/received_events","type":"Organization","site_admin":false},"repo":{"id":68643501,"name":"HW-1","full_name":"2016-09-Middlebury-Data-Science/HW-1","owner":{"login":"2016-09-Middlebury-Data-Science","id":22043879,"avatar_url":"https://avatars.githubusercontent.com/u/22043879?v=3","gravatar_id":"","url":"https://api.github.com/users/2016-09-Middlebury-Data-Science","html_url":"https://github.com/2016-09-Middlebury-Data-Science","followers_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/followers","following_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/following{/other_user}","gists_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/gists{/gist_id}","starred_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/subscriptions","organizations_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/orgs","repos_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/repos","events_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/events{/privacy}","received_events_url":"https://api.github.com/users/2016-09-Middlebury-Data-Science/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/2016-09-Middlebury-Data-Science/HW-1","description":"Data manipulation/wrangling with dplyr (and some visualization!)","fork":false,"url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1","forks_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/forks","keys_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/keys{/key_id}","collaborators_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/teams","hooks_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/hooks","issue_events_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/issues/events{/number}","events_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/events","assignees_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/assignees{/user}","branches_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/branches{/branch}","tags_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/tags","blobs_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/git/refs{/sha}","trees_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/git/trees{/sha}","statuses_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/statuses/{sha}","languages_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/languages","stargazers_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/stargazers","contributors_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/contributors","subscribers_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/subscribers","subscription_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/subscription","commits_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/commits{/sha}","git_commits_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/git/commits{/sha}","comments_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/comments{/number}","issue_comment_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/issues/comments{/number}","contents_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/contents/{+path}","compare_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/compare/{base}...{head}","merges_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/merges","archive_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/downloads","issues_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/issues{/number}","pulls_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls{/number}","milestones_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/milestones{/number}","notifications_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/labels{/name}","releases_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/releases{/id}","deployments_url":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/deployments","created_at":"2016-09-19T20:26:07Z","updated_at":"2016-09-21T13:03:46Z","pushed_at":"2016-10-05T17:53:24Z","git_url":"git://github.com/2016-09-Middlebury-Data-Science/HW-1.git","ssh_url":"git@github.com:2016-09-Middlebury-Data-Science/HW-1.git","clone_url":"https://github.com/2016-09-Middlebury-Data-Science/HW-1.git","svn_url":"https://github.com/2016-09-Middlebury-Data-Science/HW-1","homepage":"","size":4033,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":15,"mirror_url":null,"open_issues_count":15,"forks":15,"open_issues":15,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/1"},"html":{"href":"https://github.com/2016-09-Middlebury-Data-Science/HW-1/pull/1"},"issue":{"href":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/issues/1"},"comments":{"href":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/issues/1/comments"},"review_comments":{"href":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/1/comments"},"review_comment":{"href":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/pulls/1/commits"},"statuses":{"href":"https://api.github.com/repos/2016-09-Middlebury-Data-Science/HW-1/statuses/455b0694f8a2fe8b6c69043fbb64d4bf6905c435"}}}}
{"actor":{"display_login":"rudeboybert"}}