{"action":"created","comment":{"url":"https://api.github.com/repos/tldr-pages/tldr/pulls/comments/50632557","id":50632557,"diff_hunk":"@@ -0,0 +1,12 @@\n+# csvclean\n+\n+> Finds and cleans common syntax errors in CSV files.\n+> Included in csvkit.","path":"pages/common/csvclean.md","position":4,"original_position":4,"commit_id":"5676e5892d86ce67acec5a1712e6012440dd4b6c","original_commit_id":"5676e5892d86ce67acec5a1712e6012440dd4b6c","user":{"login":"waldyrious","id":478237,"avatar_url":"https://avatars.githubusercontent.com/u/478237?v=3","gravatar_id":"","url":"https://api.github.com/users/waldyrious","html_url":"https://github.com/waldyrious","followers_url":"https://api.github.com/users/waldyrious/followers","following_url":"https://api.github.com/users/waldyrious/following{/other_user}","gists_url":"https://api.github.com/users/waldyrious/gists{/gist_id}","starred_url":"https://api.github.com/users/waldyrious/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/waldyrious/subscriptions","organizations_url":"https://api.github.com/users/waldyrious/orgs","repos_url":"https://api.github.com/users/waldyrious/repos","events_url":"https://api.github.com/users/waldyrious/events{/privacy}","received_events_url":"https://api.github.com/users/waldyrious/received_events","type":"User","site_admin":false},"body":"This may be misread as \"including [errors] in csvkit.\" by an inattentive reader (e.g. me). How about making it explicit, i.e. \"This command is included in csvkit\"? Or is that overkill?","created_at":"2016-01-24T09:10:14Z","updated_at":"2016-01-24T09:10:14Z","html_url":"https://github.com/tldr-pages/tldr/pull/702#discussion_r50632557","pull_request_url":"https://api.github.com/repos/tldr-pages/tldr/pulls/702","_links":{"self":{"href":"https://api.github.com/repos/tldr-pages/tldr/pulls/comments/50632557"},"html":{"href":"https://github.com/tldr-pages/tldr/pull/702#discussion_r50632557"},"pull_request":{"href":"https://api.github.com/repos/tldr-pages/tldr/pulls/702"}}},"pull_request":{"url":"https://api.github.com/repos/tldr-pages/tldr/pulls/702","id":56823649,"html_url":"https://github.com/tldr-pages/tldr/pull/702","diff_url":"https://github.com/tldr-pages/tldr/pull/702.diff","patch_url":"https://github.com/tldr-pages/tldr/pull/702.patch","issue_url":"https://api.github.com/repos/tldr-pages/tldr/issues/702","number":702,"state":"open","locked":false,"title":"Added most of csvkit","user":{"login":"oxguy3","id":796881,"avatar_url":"https://avatars.githubusercontent.com/u/796881?v=3","gravatar_id":"","url":"https://api.github.com/users/oxguy3","html_url":"https://github.com/oxguy3","followers_url":"https://api.github.com/users/oxguy3/followers","following_url":"https://api.github.com/users/oxguy3/following{/other_user}","gists_url":"https://api.github.com/users/oxguy3/gists{/gist_id}","starred_url":"https://api.github.com/users/oxguy3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oxguy3/subscriptions","organizations_url":"https://api.github.com/users/oxguy3/orgs","repos_url":"https://api.github.com/users/oxguy3/repos","events_url":"https://api.github.com/users/oxguy3/events{/privacy}","received_events_url":"https://api.github.com/users/oxguy3/received_events","type":"User","site_admin":false},"body":"Added most of the tools from [csvkit](https://csvkit.readthedocs.org), a command-line toolbelt for dealing with CSVs and other tabular data formats. Specifically, I added:\r\n\r\n* csvclean\r\n* csvcut\r\n* csvformat\r\n* csvgrep\r\n* csvlook\r\n* csvpy\r\n* csvsort\r\n* csvstat\r\n* in2csv\r\n\r\n(still missing from csvkit: csvstack, csvjson, csvsql, sql2csv)","created_at":"2016-01-21T23:06:26Z","updated_at":"2016-01-24T09:10:14Z","closed_at":null,"merged_at":null,"merge_commit_sha":"b5a3cb517ec148382956b03df89ff4c3db25e438","assignee":{"login":"igorshubovych","id":93907,"avatar_url":"https://avatars.githubusercontent.com/u/93907?v=3","gravatar_id":"","url":"https://api.github.com/users/igorshubovych","html_url":"https://github.com/igorshubovych","followers_url":"https://api.github.com/users/igorshubovych/followers","following_url":"https://api.github.com/users/igorshubovych/following{/other_user}","gists_url":"https://api.github.com/users/igorshubovych/gists{/gist_id}","starred_url":"https://api.github.com/users/igorshubovych/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/igorshubovych/subscriptions","organizations_url":"https://api.github.com/users/igorshubovych/orgs","repos_url":"https://api.github.com/users/igorshubovych/repos","events_url":"https://api.github.com/users/igorshubovych/events{/privacy}","received_events_url":"https://api.github.com/users/igorshubovych/received_events","type":"User","site_admin":false},"milestone":null,"commits_url":"https://api.github.com/repos/tldr-pages/tldr/pulls/702/commits","review_comments_url":"https://api.github.com/repos/tldr-pages/tldr/pulls/702/comments","review_comment_url":"https://api.github.com/repos/tldr-pages/tldr/pulls/comments{/number}","comments_url":"https://api.github.com/repos/tldr-pages/tldr/issues/702/comments","statuses_url":"https://api.github.com/repos/tldr-pages/tldr/statuses/5676e5892d86ce67acec5a1712e6012440dd4b6c","head":{"label":"oxguy3:csvkit","ref":"csvkit","sha":"5676e5892d86ce67acec5a1712e6012440dd4b6c","user":{"login":"oxguy3","id":796881,"avatar_url":"https://avatars.githubusercontent.com/u/796881?v=3","gravatar_id":"","url":"https://api.github.com/users/oxguy3","html_url":"https://github.com/oxguy3","followers_url":"https://api.github.com/users/oxguy3/followers","following_url":"https://api.github.com/users/oxguy3/following{/other_user}","gists_url":"https://api.github.com/users/oxguy3/gists{/gist_id}","starred_url":"https://api.github.com/users/oxguy3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oxguy3/subscriptions","organizations_url":"https://api.github.com/users/oxguy3/orgs","repos_url":"https://api.github.com/users/oxguy3/repos","events_url":"https://api.github.com/users/oxguy3/events{/privacy}","received_events_url":"https://api.github.com/users/oxguy3/received_events","type":"User","site_admin":false},"repo":{"id":50142689,"name":"tldr","full_name":"oxguy3/tldr","owner":{"login":"oxguy3","id":796881,"avatar_url":"https://avatars.githubusercontent.com/u/796881?v=3","gravatar_id":"","url":"https://api.github.com/users/oxguy3","html_url":"https://github.com/oxguy3","followers_url":"https://api.github.com/users/oxguy3/followers","following_url":"https://api.github.com/users/oxguy3/following{/other_user}","gists_url":"https://api.github.com/users/oxguy3/gists{/gist_id}","starred_url":"https://api.github.com/users/oxguy3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oxguy3/subscriptions","organizations_url":"https://api.github.com/users/oxguy3/orgs","repos_url":"https://api.github.com/users/oxguy3/repos","events_url":"https://api.github.com/users/oxguy3/events{/privacy}","received_events_url":"https://api.github.com/users/oxguy3/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/oxguy3/tldr","description":"Simplified and community-driven man pages","fork":true,"url":"https://api.github.com/repos/oxguy3/tldr","forks_url":"https://api.github.com/repos/oxguy3/tldr/forks","keys_url":"https://api.github.com/repos/oxguy3/tldr/keys{/key_id}","collaborators_url":"https://api.github.com/repos/oxguy3/tldr/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/oxguy3/tldr/teams","hooks_url":"https://api.github.com/repos/oxguy3/tldr/hooks","issue_events_url":"https://api.github.com/repos/oxguy3/tldr/issues/events{/number}","events_url":"https://api.github.com/repos/oxguy3/tldr/events","assignees_url":"https://api.github.com/repos/oxguy3/tldr/assignees{/user}","branches_url":"https://api.github.com/repos/oxguy3/tldr/branches{/branch}","tags_url":"https://api.github.com/repos/oxguy3/tldr/tags","blobs_url":"https://api.github.com/repos/oxguy3/tldr/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/oxguy3/tldr/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/oxguy3/tldr/git/refs{/sha}","trees_url":"https://api.github.com/repos/oxguy3/tldr/git/trees{/sha}","statuses_url":"https://api.github.com/repos/oxguy3/tldr/statuses/{sha}","languages_url":"https://api.github.com/repos/oxguy3/tldr/languages","stargazers_url":"https://api.github.com/repos/oxguy3/tldr/stargazers","contributors_url":"https://api.github.com/repos/oxguy3/tldr/contributors","subscribers_url":"https://api.github.com/repos/oxguy3/tldr/subscribers","subscription_url":"https://api.github.com/repos/oxguy3/tldr/subscription","commits_url":"https://api.github.com/repos/oxguy3/tldr/commits{/sha}","git_commits_url":"https://api.github.com/repos/oxguy3/tldr/git/commits{/sha}","comments_url":"https://api.github.com/repos/oxguy3/tldr/comments{/number}","issue_comment_url":"https://api.github.com/repos/oxguy3/tldr/issues/comments{/number}","contents_url":"https://api.github.com/repos/oxguy3/tldr/contents/{+path}","compare_url":"https://api.github.com/repos/oxguy3/tldr/compare/{base}...{head}","merges_url":"https://api.github.com/repos/oxguy3/tldr/merges","archive_url":"https://api.github.com/repos/oxguy3/tldr/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/oxguy3/tldr/downloads","issues_url":"https://api.github.com/repos/oxguy3/tldr/issues{/number}","pulls_url":"https://api.github.com/repos/oxguy3/tldr/pulls{/number}","milestones_url":"https://api.github.com/repos/oxguy3/tldr/milestones{/number}","notifications_url":"https://api.github.com/repos/oxguy3/tldr/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/oxguy3/tldr/labels{/name}","releases_url":"https://api.github.com/repos/oxguy3/tldr/releases{/id}","deployments_url":"https://api.github.com/repos/oxguy3/tldr/deployments","created_at":"2016-01-21T23:01:37Z","updated_at":"2016-01-21T23:01:37Z","pushed_at":"2016-01-24T07:10:40Z","git_url":"git://github.com/oxguy3/tldr.git","ssh_url":"git@github.com:oxguy3/tldr.git","clone_url":"https://github.com/oxguy3/tldr.git","svn_url":"https://github.com/oxguy3/tldr","homepage":"http://tldr-pages.github.io/","size":827,"stargazers_count":0,"watchers_count":0,"language":"Shell","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":"tldr-pages:master","ref":"master","sha":"f38c34f484e182c1665f9dc4c8e9b29b4f68692b","user":{"login":"tldr-pages","id":7366472,"avatar_url":"https://avatars.githubusercontent.com/u/7366472?v=3","gravatar_id":"","url":"https://api.github.com/users/tldr-pages","html_url":"https://github.com/tldr-pages","followers_url":"https://api.github.com/users/tldr-pages/followers","following_url":"https://api.github.com/users/tldr-pages/following{/other_user}","gists_url":"https://api.github.com/users/tldr-pages/gists{/gist_id}","starred_url":"https://api.github.com/users/tldr-pages/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tldr-pages/subscriptions","organizations_url":"https://api.github.com/users/tldr-pages/orgs","repos_url":"https://api.github.com/users/tldr-pages/repos","events_url":"https://api.github.com/users/tldr-pages/events{/privacy}","received_events_url":"https://api.github.com/users/tldr-pages/received_events","type":"Organization","site_admin":false},"repo":{"id":15019962,"name":"tldr","full_name":"tldr-pages/tldr","owner":{"login":"tldr-pages","id":7366472,"avatar_url":"https://avatars.githubusercontent.com/u/7366472?v=3","gravatar_id":"","url":"https://api.github.com/users/tldr-pages","html_url":"https://github.com/tldr-pages","followers_url":"https://api.github.com/users/tldr-pages/followers","following_url":"https://api.github.com/users/tldr-pages/following{/other_user}","gists_url":"https://api.github.com/users/tldr-pages/gists{/gist_id}","starred_url":"https://api.github.com/users/tldr-pages/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tldr-pages/subscriptions","organizations_url":"https://api.github.com/users/tldr-pages/orgs","repos_url":"https://api.github.com/users/tldr-pages/repos","events_url":"https://api.github.com/users/tldr-pages/events{/privacy}","received_events_url":"https://api.github.com/users/tldr-pages/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/tldr-pages/tldr","description":"Simplified and community-driven man pages","fork":false,"url":"https://api.github.com/repos/tldr-pages/tldr","forks_url":"https://api.github.com/repos/tldr-pages/tldr/forks","keys_url":"https://api.github.com/repos/tldr-pages/tldr/keys{/key_id}","collaborators_url":"https://api.github.com/repos/tldr-pages/tldr/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/tldr-pages/tldr/teams","hooks_url":"https://api.github.com/repos/tldr-pages/tldr/hooks","issue_events_url":"https://api.github.com/repos/tldr-pages/tldr/issues/events{/number}","events_url":"https://api.github.com/repos/tldr-pages/tldr/events","assignees_url":"https://api.github.com/repos/tldr-pages/tldr/assignees{/user}","branches_url":"https://api.github.com/repos/tldr-pages/tldr/branches{/branch}","tags_url":"https://api.github.com/repos/tldr-pages/tldr/tags","blobs_url":"https://api.github.com/repos/tldr-pages/tldr/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/tldr-pages/tldr/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/tldr-pages/tldr/git/refs{/sha}","trees_url":"https://api.github.com/repos/tldr-pages/tldr/git/trees{/sha}","statuses_url":"https://api.github.com/repos/tldr-pages/tldr/statuses/{sha}","languages_url":"https://api.github.com/repos/tldr-pages/tldr/languages","stargazers_url":"https://api.github.com/repos/tldr-pages/tldr/stargazers","contributors_url":"https://api.github.com/repos/tldr-pages/tldr/contributors","subscribers_url":"https://api.github.com/repos/tldr-pages/tldr/subscribers","subscription_url":"https://api.github.com/repos/tldr-pages/tldr/subscription","commits_url":"https://api.github.com/repos/tldr-pages/tldr/commits{/sha}","git_commits_url":"https://api.github.com/repos/tldr-pages/tldr/git/commits{/sha}","comments_url":"https://api.github.com/repos/tldr-pages/tldr/comments{/number}","issue_comment_url":"https://api.github.com/repos/tldr-pages/tldr/issues/comments{/number}","contents_url":"https://api.github.com/repos/tldr-pages/tldr/contents/{+path}","compare_url":"https://api.github.com/repos/tldr-pages/tldr/compare/{base}...{head}","merges_url":"https://api.github.com/repos/tldr-pages/tldr/merges","archive_url":"https://api.github.com/repos/tldr-pages/tldr/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/tldr-pages/tldr/downloads","issues_url":"https://api.github.com/repos/tldr-pages/tldr/issues{/number}","pulls_url":"https://api.github.com/repos/tldr-pages/tldr/pulls{/number}","milestones_url":"https://api.github.com/repos/tldr-pages/tldr/milestones{/number}","notifications_url":"https://api.github.com/repos/tldr-pages/tldr/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/tldr-pages/tldr/labels{/name}","releases_url":"https://api.github.com/repos/tldr-pages/tldr/releases{/id}","deployments_url":"https://api.github.com/repos/tldr-pages/tldr/deployments","created_at":"2013-12-08T07:34:43Z","updated_at":"2016-01-24T08:16:15Z","pushed_at":"2016-01-24T08:54:48Z","git_url":"git://github.com/tldr-pages/tldr.git","ssh_url":"git@github.com:tldr-pages/tldr.git","clone_url":"https://github.com/tldr-pages/tldr.git","svn_url":"https://github.com/tldr-pages/tldr","homepage":"http://tldr-pages.github.io/","size":1697,"stargazers_count":7184,"watchers_count":7184,"language":"Shell","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":458,"mirror_url":null,"open_issues_count":57,"forks":458,"open_issues":57,"watchers":7184,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/tldr-pages/tldr/pulls/702"},"html":{"href":"https://github.com/tldr-pages/tldr/pull/702"},"issue":{"href":"https://api.github.com/repos/tldr-pages/tldr/issues/702"},"comments":{"href":"https://api.github.com/repos/tldr-pages/tldr/issues/702/comments"},"review_comments":{"href":"https://api.github.com/repos/tldr-pages/tldr/pulls/702/comments"},"review_comment":{"href":"https://api.github.com/repos/tldr-pages/tldr/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/tldr-pages/tldr/pulls/702/commits"},"statuses":{"href":"https://api.github.com/repos/tldr-pages/tldr/statuses/5676e5892d86ce67acec5a1712e6012440dd4b6c"}}}}