{"action":"reopened","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/12679","repository_url":"https://api.github.com/repos/pydata/pandas","labels_url":"https://api.github.com/repos/pydata/pandas/issues/12679/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/12679/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/12679/events","html_url":"https://github.com/pydata/pandas/issues/12679","id":142239573,"number":12679,"title":"pandas.Series.value_counts \"sort=False\" argument not working","user":{"login":"rchurt","id":14302923,"avatar_url":"https://avatars.githubusercontent.com/u/14302923?v=3","gravatar_id":"","url":"https://api.github.com/users/rchurt","html_url":"https://github.com/rchurt","followers_url":"https://api.github.com/users/rchurt/followers","following_url":"https://api.github.com/users/rchurt/following{/other_user}","gists_url":"https://api.github.com/users/rchurt/gists{/gist_id}","starred_url":"https://api.github.com/users/rchurt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rchurt/subscriptions","organizations_url":"https://api.github.com/users/rchurt/orgs","repos_url":"https://api.github.com/users/rchurt/repos","events_url":"https://api.github.com/users/rchurt/events{/privacy}","received_events_url":"https://api.github.com/users/rchurt/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pydata/pandas/labels/Reshaping","name":"Reshaping","color":"02d7e1"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Usage%20Question","name":"Usage Question","color":"0052cc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-03-21T02:38:57Z","updated_at":"2016-03-21T12:29:47Z","closed_at":null,"body":"Hello,\r\n\r\nI'm trying to make a new DataFrame that contains the value counts of a column of an existing DataFrame ([spreadsheet.xlsx](https://github.com/pydata/pandas/files/181629/spreadsheet.xlsx)), but I want the rows in the new DataFrame to be in the same order as the old one.\r\n\r\nWhen I do:\r\n``` python\r\nimport pandas as pd\r\ndf = pd.read_excel('./spreadsheet.xlsx')\r\nprint(df[0].value_counts(sort=False))\r\n```\r\n\r\nI get the DataFrame:\r\n``` python\r\nh4\t8\r\nct1\t6\r\nf2\t2\r\ns1\t2\r\nEST2\t2\r\nf5\t2\r\nE4\t8\r\nh2\t8\r\nhd2\t7\r\nf3\t2\r\nART1\t2\r\ns2\t2\r\nf1\t2\r\nh3\t8\r\nEST1\t2\r\ns3\t2\r\nE6\t8\r\nART2\t2\r\nDGT2\t2\r\nct2\t6\r\ns4\t2\r\nct3\t6\r\nf4\t2\r\nDGT1\t2\r\ns5\t2\r\n```\r\n\r\nWhen what I really want is:\r\n``` python\r\nh2\t8\r\nh3\t8\r\nh4\t8\r\nhd2\t7\r\nE4\t8\r\nE6\t8\r\nct1\t6\r\n.\r\n.\r\n.\r\n```\r\n...because that's the order in which the values occur in the original DataFrame.\r\n\r\nI can't tell how it's sorting them, but it is somehow. Is this the expected behavior?\r\n\r\nThanks\r\n\r\n``` python\r\nInstalled versions:\r\ncommit: None\r\npython: 3.5.1.final.0\r\npython-bits: 64\r\nOS: Darwin\r\nOS-release: 15.3.0\r\nmachine: x86_64\r\nprocessor: i386\r\nbyteorder: little\r\nLC_ALL: None\r\nLANG: None\r\n\r\npandas: 0.18.0\r\nnose: 1.3.7\r\npip: 8.1.1\r\nsetuptools: 20.3\r\nCython: 0.23.4\r\nnumpy: 1.10.4\r\nscipy: 0.17.0\r\nstatsmodels: None\r\nxarray: None\r\nIPython: 4.1.2\r\nsphinx: 1.3.5\r\npatsy: 0.4.0\r\ndateutil: 2.5.0\r\npytz: 2016.1\r\nblosc: None\r\nbottleneck: 1.0.0\r\ntables: 3.2.2\r\nnumexpr: 2.4.6\r\nmatplotlib: 1.5.1\r\nopenpyxl: 2.3.2\r\nxlrd: 0.9.4\r\nxlwt: 1.0.0\r\nxlsxwriter: 0.8.4\r\nlxml: 3.6.0\r\nbs4: 4.4.1\r\nhtml5lib: None\r\nhttplib2: 0.9.2\r\napiclient: 1.5.0\r\nsqlalchemy: 1.0.12\r\npymysql: None\r\npsycopg2: None\r\njinja2: 2.8\r\nboto: 2.39.0\r\n```"}}