{"action":"created","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/13104","repository_url":"https://api.github.com/repos/pydata/pandas","labels_url":"https://api.github.com/repos/pydata/pandas/issues/13104/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/13104/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/13104/events","html_url":"https://github.com/pydata/pandas/issues/13104","id":153509175,"number":13104,"title":"pd.DataFrame.describe percentile string precision","user":{"login":"bla1089","id":12834389,"avatar_url":"https://avatars.githubusercontent.com/u/12834389?v=3","gravatar_id":"","url":"https://api.github.com/users/bla1089","html_url":"https://github.com/bla1089","followers_url":"https://api.github.com/users/bla1089/followers","following_url":"https://api.github.com/users/bla1089/following{/other_user}","gists_url":"https://api.github.com/users/bla1089/gists{/gist_id}","starred_url":"https://api.github.com/users/bla1089/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bla1089/subscriptions","organizations_url":"https://api.github.com/users/bla1089/orgs","repos_url":"https://api.github.com/users/bla1089/repos","events_url":"https://api.github.com/users/bla1089/events{/privacy}","received_events_url":"https://api.github.com/users/bla1089/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pydata/pandas/labels/Bug","name":"Bug","color":"e10c02"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Difficulty%20Novice","name":"Difficulty Novice","color":"fbca04"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Effort%20Low","name":"Effort Low","color":"006b75"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Indexing","name":"Indexing","color":"0b02e1"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Numeric","name":"Numeric","color":"006b75"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Output-Formatting","name":"Output-Formatting","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/pydata/pandas/milestones/40","html_url":"https://github.com/pydata/pandas/milestones/0.18.2","labels_url":"https://api.github.com/repos/pydata/pandas/milestones/40/labels","id":1639795,"number":40,"title":"0.18.2","description":"","creator":{"login":"jreback","id":953992,"avatar_url":"https://avatars.githubusercontent.com/u/953992?v=3","gravatar_id":"","url":"https://api.github.com/users/jreback","html_url":"https://github.com/jreback","followers_url":"https://api.github.com/users/jreback/followers","following_url":"https://api.github.com/users/jreback/following{/other_user}","gists_url":"https://api.github.com/users/jreback/gists{/gist_id}","starred_url":"https://api.github.com/users/jreback/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jreback/subscriptions","organizations_url":"https://api.github.com/users/jreback/orgs","repos_url":"https://api.github.com/users/jreback/repos","events_url":"https://api.github.com/users/jreback/events{/privacy}","received_events_url":"https://api.github.com/users/jreback/received_events","type":"User","site_admin":false},"open_issues":185,"closed_issues":66,"state":"open","created_at":"2016-03-11T21:24:45Z","updated_at":"2016-05-18T22:10:30Z","due_on":"2016-06-14T04:00:00Z","closed_at":null},"comments":18,"created_at":"2016-05-06T18:19:22Z","updated_at":"2016-05-19T02:36:26Z","closed_at":null,"body":"When using `pd.DataFrame.describe`, if your percentiles are different only at the 4th decimal place, a `ValueError` is thrown because the the percentiles that vary at the 4th decimal place become the same value.\r\n\r\n```\r\nIn [1]: s = Series(np.random.randn(10))\r\n\r\nIn [2]: s.describe()\r\nOut[2]: \r\ncount    10.000000\r\nmean      0.291571\r\nstd       1.057143\r\nmin      -1.453547\r\n25%      -0.614614\r\n50%       0.637435\r\n75%       0.968905\r\nmax       1.823964\r\ndtype: float64\r\n\r\nIn [3]: s.describe(percentiles=[0.0001, 0.0005, 0.001, 0.999, 0.9995, 0.9999])\r\nOut[3]: \r\ncount     10.000000\r\nmean       0.291571\r\nstd        1.057143\r\nmin       -1.453547\r\n0.0%      -1.453107\r\n0.1%      -1.451348\r\n0.1%      -1.449149\r\n50%        0.637435\r\n99.9%      1.817201\r\n100.0%     1.820583\r\n100.0%     1.823288\r\nmax        1.823964\r\ndtype: float64\r\n```"},"comment":{"url":"https://api.github.com/repos/pydata/pandas/issues/comments/220213087","html_url":"https://github.com/pydata/pandas/issues/13104#issuecomment-220213087","issue_url":"https://api.github.com/repos/pydata/pandas/issues/13104","id":220213087,"user":{"login":"pijucha","id":9507544,"avatar_url":"https://avatars.githubusercontent.com/u/9507544?v=3","gravatar_id":"","url":"https://api.github.com/users/pijucha","html_url":"https://github.com/pijucha","followers_url":"https://api.github.com/users/pijucha/followers","following_url":"https://api.github.com/users/pijucha/following{/other_user}","gists_url":"https://api.github.com/users/pijucha/gists{/gist_id}","starred_url":"https://api.github.com/users/pijucha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pijucha/subscriptions","organizations_url":"https://api.github.com/users/pijucha/orgs","repos_url":"https://api.github.com/users/pijucha/repos","events_url":"https://api.github.com/users/pijucha/events{/privacy}","received_events_url":"https://api.github.com/users/pijucha/received_events","type":"User","site_admin":false},"created_at":"2016-05-19T02:36:26Z","updated_at":"2016-05-19T02:36:26Z","body":"All right. I'm posting it once more to give some visual comparison.\r\n```\r\n# Possible output of s.describe(percentiles=[0.0001, 0.0005, 0.001, 0.999, 0.9995, 0.9999])\r\ncount     10.000000\r\nmean       0.291571\r\nstd        1.057143\r\nmin       -1.453547\r\n 0.01%    -1.453107\r\n 0.05%    -1.451348\r\n 0.1 %    -1.449149\r\n50   %     0.637435\r\n99.9 %     1.817201\r\n99.95%     1.820583\r\n99.99%     1.823288\r\nmax        1.823964\r\n```"}}