{"action":"created","issue":{"url":"https://api.github.com/repos/manahl/arctic/issues/113","repository_url":"https://api.github.com/repos/manahl/arctic","labels_url":"https://api.github.com/repos/manahl/arctic/issues/113/labels{/name}","comments_url":"https://api.github.com/repos/manahl/arctic/issues/113/comments","events_url":"https://api.github.com/repos/manahl/arctic/issues/113/events","html_url":"https://github.com/manahl/arctic/issues/113","id":142997423,"number":113,"title":"unlabeled dataframes and series changed when read back from arctic","user":{"login":"bmoscon","id":1280059,"avatar_url":"https://avatars.githubusercontent.com/u/1280059?v=3","gravatar_id":"","url":"https://api.github.com/users/bmoscon","html_url":"https://github.com/bmoscon","followers_url":"https://api.github.com/users/bmoscon/followers","following_url":"https://api.github.com/users/bmoscon/following{/other_user}","gists_url":"https://api.github.com/users/bmoscon/gists{/gist_id}","starred_url":"https://api.github.com/users/bmoscon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bmoscon/subscriptions","organizations_url":"https://api.github.com/users/bmoscon/orgs","repos_url":"https://api.github.com/users/bmoscon/repos","events_url":"https://api.github.com/users/bmoscon/events{/privacy}","received_events_url":"https://api.github.com/users/bmoscon/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/manahl/arctic/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/manahl/arctic/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-03-23T15:46:01Z","updated_at":"2016-03-23T16:47:53Z","closed_at":null,"body":"Here is a test case (add to tests/integration/test_pandas_store)\r\n\r\n````\r\ndf = DataFrame(data=[1, 2, 3],\r\n                   index=Index(data=[dt(2016, 01, 01),\r\n                                     dt(2016, 01, 02),\r\n                                     dt(2016, 01, 03)],\r\n                               name='date'))\r\n    library.write('test', df)\r\n    ret = library.read('test').data\r\n    assert_frame_equal(ret, df)\r\n````\r\n\r\nbasically the to/from records functionality will hard code in some colum/series names if none are present. Series get named 'values', and columns become u'0' to u'N'\r\n\r\nSeries default name is None, and dataframe column names are 0 -> N (integer, not string). Not sure if this is intentional or not, or if its even something to care about (most series and columns in dataframes will be named). \r\n\r\n\r\nFrom the above example here are the values of df.columns and ret.columns, respectively:\r\n\r\n````\r\nInt64Index([0], dtype='int64')\r\nIndex([u'0'], dtype='object')\r\n````\r\n\r\nnote 0 goes from int64 to string object. "},"comment":{"url":"https://api.github.com/repos/manahl/arctic/issues/comments/200435351","html_url":"https://github.com/manahl/arctic/issues/113#issuecomment-200435351","issue_url":"https://api.github.com/repos/manahl/arctic/issues/113","id":200435351,"user":{"login":"richardbounds","id":325229,"avatar_url":"https://avatars.githubusercontent.com/u/325229?v=3","gravatar_id":"","url":"https://api.github.com/users/richardbounds","html_url":"https://github.com/richardbounds","followers_url":"https://api.github.com/users/richardbounds/followers","following_url":"https://api.github.com/users/richardbounds/following{/other_user}","gists_url":"https://api.github.com/users/richardbounds/gists{/gist_id}","starred_url":"https://api.github.com/users/richardbounds/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/richardbounds/subscriptions","organizations_url":"https://api.github.com/users/richardbounds/orgs","repos_url":"https://api.github.com/users/richardbounds/repos","events_url":"https://api.github.com/users/richardbounds/events{/privacy}","received_events_url":"https://api.github.com/users/richardbounds/received_events","type":"User","site_admin":false},"created_at":"2016-03-23T16:47:53Z","updated_at":"2016-03-23T16:47:53Z","body":"Pretty sure this was intentional, although I can't remember exactly why. At one point I think we stored the column names in the dtype, so it may be something to do with the type checking/promotion code in _ndarry_store. I wonder whether @jjbmatthews remembers?"}}