{"action":"created","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/9710","labels_url":"https://api.github.com/repos/pydata/pandas/issues/9710/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/9710/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/9710/events","html_url":"https://github.com/pydata/pandas/issues/9710","id":63724227,"number":9710,"title":"read_csv skips rows with value 0 if having initial space","user":{"login":"aarimond","id":5584988,"avatar_url":"https://avatars.githubusercontent.com/u/5584988?v=3","gravatar_id":"","url":"https://api.github.com/users/aarimond","html_url":"https://github.com/aarimond","followers_url":"https://api.github.com/users/aarimond/followers","following_url":"https://api.github.com/users/aarimond/following{/other_user}","gists_url":"https://api.github.com/users/aarimond/gists{/gist_id}","starred_url":"https://api.github.com/users/aarimond/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aarimond/subscriptions","organizations_url":"https://api.github.com/users/aarimond/orgs","repos_url":"https://api.github.com/users/aarimond/repos","events_url":"https://api.github.com/users/aarimond/events{/privacy}","received_events_url":"https://api.github.com/users/aarimond/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pydata/pandas/labels/CSV","name":"CSV","color":"5319e7"},{"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":"2015-03-23T13:34:23Z","updated_at":"2015-03-23T22:48:47Z","closed_at":null,"body":"Hi,\r\n\r\nI have something like the following csv file:\r\n\r\n```\r\nMyColumn\r\n   0\r\n   1\r\n   0\r\n   1\r\n```\r\nNote the initial space in each row.\r\nUpgrading from 0.14.1 to 0.16 I recognized that read_csv started throwing away the 0 rows\r\n\r\n```\r\nIn [31]: pandas.read_csv('test.csv')\r\nOut[31]:\r\n   MyColumn\r\n0         1\r\n1         1\r\n```\r\nskipinitialspace=True did not help:\r\n\r\n```\r\nIn [32]: pandas.read_csv('test.csv', skipinitialspace=True)\r\nOut[32]:\r\n   MyColumn\r\n0         1\r\n1         1\r\n```\r\nhowever, skip_blank_lines=False would help:\r\n```\r\nIn [34]: pandas.read_csv('test.csv', skip_blank_lines=False)\r\nOut[34]:\r\n   MyColumn\r\n0         0\r\n1         1\r\n2         0\r\n3         1\r\n```\r\nNot sure if this is working as intended.\r\n\r\nCheers,\r\nAlex\r\n\r\n\r\nPS:\r\nHaving a second columns works as expected:\r\n```\r\nIn [41]: pandas.read_csv('test.csv')\r\nOut[41]:\r\n   MyColumn  SecondColumn\r\n0         0             3\r\n1         1             4\r\n2         0             0\r\n3         1             6\r\n```\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/pydata/pandas/issues/comments/85236693","html_url":"https://github.com/pydata/pandas/issues/9710#issuecomment-85236693","issue_url":"https://api.github.com/repos/pydata/pandas/issues/9710","id":85236693,"user":{"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},"created_at":"2015-03-23T22:48:47Z","updated_at":"2015-03-23T22:48:47Z","body":"@aarimond can you update the top section with the examples that don't work. (and make them self-reproducing), like your last example here [124]. Will be more clear exactly what doesn't work."}}