{"action":"created","issue":{"url":"https://api.github.com/repos/pdxrlang/aggregate/issues/13","repository_url":"https://api.github.com/repos/pdxrlang/aggregate","labels_url":"https://api.github.com/repos/pdxrlang/aggregate/issues/13/labels{/name}","comments_url":"https://api.github.com/repos/pdxrlang/aggregate/issues/13/comments","events_url":"https://api.github.com/repos/pdxrlang/aggregate/issues/13/events","html_url":"https://github.com/pdxrlang/aggregate/issues/13","id":235986983,"number":13,"title":"Basic data massaging-Open to better ideas","user":{"login":"AxisMeetsWorld","id":29417743,"avatar_url":"https://avatars1.githubusercontent.com/u/29417743?v=3","gravatar_id":"","url":"https://api.github.com/users/AxisMeetsWorld","html_url":"https://github.com/AxisMeetsWorld","followers_url":"https://api.github.com/users/AxisMeetsWorld/followers","following_url":"https://api.github.com/users/AxisMeetsWorld/following{/other_user}","gists_url":"https://api.github.com/users/AxisMeetsWorld/gists{/gist_id}","starred_url":"https://api.github.com/users/AxisMeetsWorld/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AxisMeetsWorld/subscriptions","organizations_url":"https://api.github.com/users/AxisMeetsWorld/orgs","repos_url":"https://api.github.com/users/AxisMeetsWorld/repos","events_url":"https://api.github.com/users/AxisMeetsWorld/events{/privacy}","received_events_url":"https://api.github.com/users/AxisMeetsWorld/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-06-14T19:36:29Z","updated_at":"2017-06-14T20:54:55Z","closed_at":null,"body":"I am trying to input data on various employment statistics from Universities around the nation. Problem is that one data source might write a university with an abbreviation, while another might not _(IE \"Oregon State\" vs \"Oregon St.\")_. When I import new data in from a new source I use the **setdiff()** function to find the school representations that aren't found in the names I have decided on for them. I then keep a dataframe (call it convert dataframe) of representations I find in the new set and what I would like them to be converted to for consistency. I have a user-defined function that allows me to type in what I had, and the converted representation. This updates the convert dataframe with the new values. I finally have one more function that I can use to run through a new dataframe that has these discrepancies and look at the convert dataframe so that the newly imported information is consistent with university representations already stored. I am just wondering if this is the easiest way, or if there might be something else I should try. I will be at the R user-group tomorrow so I can show if necessary. Thanks!"},"comment":{"url":"https://api.github.com/repos/pdxrlang/aggregate/issues/comments/308555310","html_url":"https://github.com/pdxrlang/aggregate/issues/13#issuecomment-308555310","issue_url":"https://api.github.com/repos/pdxrlang/aggregate/issues/13","id":308555310,"user":{"login":"sckott","id":577668,"avatar_url":"https://avatars2.githubusercontent.com/u/577668?v=3","gravatar_id":"","url":"https://api.github.com/users/sckott","html_url":"https://github.com/sckott","followers_url":"https://api.github.com/users/sckott/followers","following_url":"https://api.github.com/users/sckott/following{/other_user}","gists_url":"https://api.github.com/users/sckott/gists{/gist_id}","starred_url":"https://api.github.com/users/sckott/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sckott/subscriptions","organizations_url":"https://api.github.com/users/sckott/orgs","repos_url":"https://api.github.com/users/sckott/repos","events_url":"https://api.github.com/users/sckott/events{/privacy}","received_events_url":"https://api.github.com/users/sckott/received_events","type":"User","site_admin":false},"created_at":"2017-06-14T20:54:55Z","updated_at":"2017-06-14T20:54:55Z","body":"thanks @AxisMeetsWorld - will add this to the agenda for tomorrow"}}
{"actor":{"display_login":"sckott"}}