{"action":"created","issue":{"url":"https://api.github.com/repos/dato-code/SFrame/issues/41","labels_url":"https://api.github.com/repos/dato-code/SFrame/issues/41/labels{/name}","comments_url":"https://api.github.com/repos/dato-code/SFrame/issues/41/comments","events_url":"https://api.github.com/repos/dato-code/SFrame/issues/41/events","html_url":"https://github.com/dato-code/SFrame/issues/41","id":111542618,"number":41,"title":"Problem in CSV reader","user":{"login":"malmaud","id":987837,"avatar_url":"https://avatars.githubusercontent.com/u/987837?v=3","gravatar_id":"","url":"https://api.github.com/users/malmaud","html_url":"https://github.com/malmaud","followers_url":"https://api.github.com/users/malmaud/followers","following_url":"https://api.github.com/users/malmaud/following{/other_user}","gists_url":"https://api.github.com/users/malmaud/gists{/gist_id}","starred_url":"https://api.github.com/users/malmaud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/malmaud/subscriptions","organizations_url":"https://api.github.com/users/malmaud/orgs","repos_url":"https://api.github.com/users/malmaud/repos","events_url":"https://api.github.com/users/malmaud/events{/privacy}","received_events_url":"https://api.github.com/users/malmaud/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-15T04:23:53Z","updated_at":"2015-10-15T05:32:58Z","closed_at":null,"body":"[This CSV file](https://www.dropbox.com/s/uf7s750wzh16mzk/batch.csv?dl=1) loads fine with pandas, but seems to choke the SFrame CSV parser:\r\n\r\n```\r\nIn [24]: df=gl.SFrame.read_csv(\"batch.csv\")\r\nPROGRESS: Unable to parse line \"\"3Y3N5A7N4F8BFCSGP0QMO7PDF0FYME\",\"26PZ9RNDWIOV420VVL4TLU13ZJYUFK\",\"x\",\"y\",\"z\",\"Fri Oct 09 12:38:00 PDT 2015\",\"20\",\"BatchId:2118345;\",\"2700\",\"604800\",\"Fri Oct 16 12:38:00 PDT 2015\",\"\",\"\",\"31HQ4X3T3S9XZSVFGK2JUSI8Z2RSLJ\",\"A3579N2TITA69M\",\"Submitted\",\"Fri Oct...\"\r\nPROGRESS: Unable to parse line \"\"3Y3N5A7N4F8BFCSGP0QMO7PDF0FYME\",\"26PZ9RNDWIOV420VVL4TLU13ZJYUFK\",\"x\",\"y\",\"z\",\"Fri Oct 09 12:38:00 PDT 2015\",\"20\",\"BatchId:2118345;\",\"2700\",\"604800\",\"Fri Oct 16 12:38:00 PDT 2015\",\"\",\"\",\"32N49TQG3GHWV1LFDOIYW1M44UOVAB\",\"A3BBGFC0RG39HK\",\"Submitted\",\"Fri Oct...\"\r\nPROGRESS: 2 lines failed to parse correctly\r\nPROGRESS: Finished parsing file /Users/malmaud/tmp/batch.csv\r\nPROGRESS: Parsing completed. Parsed 0 lines in 0.010217 secs.\r\nInsufficient number of rows to perform type inference\r\nCould not detect types. Using str for each column.\r\nPROGRESS: Unable to parse line \"\"3Y3N5A7N4F8BFCSGP0QMO7PDF0FYME\",\"26PZ9RNDWIOV420VVL4TLU13ZJYUFK\",\"x\",\"y\",\"z\",\"Fri Oct 09 12:38:00 PDT 2015\",\"20\",\"BatchId:2118345;\",\"2700\",\"604800\",\"Fri Oct 16 12:38:00 PDT 2015\",\"\",\"\",\"31HQ4X3T3S9XZSVFGK2JUSI8Z2RSLJ\",\"A3579N2TITA69M\",\"Submitted\",\"Fri Oct...\"\r\nPROGRESS: Unable to parse line \"\"3Y3N5A7N4F8BFCSGP0QMO7PDF0FYME\",\"26PZ9RNDWIOV420VVL4TLU13ZJYUFK\",\"x\",\"y\",\"z\",\"Fri Oct 09 12:38:00 PDT 2015\",\"20\",\"BatchId:2118345;\",\"2700\",\"604800\",\"Fri Oct 16 12:38:00 PDT 2015\",\"\",\"\",\"32N49TQG3GHWV1LFDOIYW1M44UOVAB\",\"A3BBGFC0RG39HK\",\"Submitted\",\"Fri Oct...\"\r\nPROGRESS: 2 lines failed to parse correctly\r\nPROGRESS: Finished parsing file /Users/malmaud/tmp/batch.csv\r\nPROGRESS: Parsing completed. Parsed 0 lines in 0.01067 secs.\r\n```"},"comment":{"url":"https://api.github.com/repos/dato-code/SFrame/issues/comments/148286155","html_url":"https://github.com/dato-code/SFrame/issues/41#issuecomment-148286155","issue_url":"https://api.github.com/repos/dato-code/SFrame/issues/41","id":148286155,"user":{"login":"ylow","id":2740522,"avatar_url":"https://avatars.githubusercontent.com/u/2740522?v=3","gravatar_id":"","url":"https://api.github.com/users/ylow","html_url":"https://github.com/ylow","followers_url":"https://api.github.com/users/ylow/followers","following_url":"https://api.github.com/users/ylow/following{/other_user}","gists_url":"https://api.github.com/users/ylow/gists{/gist_id}","starred_url":"https://api.github.com/users/ylow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ylow/subscriptions","organizations_url":"https://api.github.com/users/ylow/orgs","repos_url":"https://api.github.com/users/ylow/repos","events_url":"https://api.github.com/users/ylow/events{/privacy}","received_events_url":"https://api.github.com/users/ylow/received_events","type":"User","site_admin":false},"created_at":"2015-10-15T05:32:58Z","updated_at":"2015-10-15T05:32:58Z","body":"We need better CSV error reporting, but essentially the two data lines have three fewer columns than the header. We intentionally fail on this case. Pandas parser by default will pad with NaN values. (if you look at the output of the pandas parse)."}}