{"action":"closed","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/9635","labels_url":"https://api.github.com/repos/pydata/pandas/issues/9635/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/9635/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/9635/events","html_url":"https://github.com/pydata/pandas/issues/9635","id":60799613,"number":9635,"title":"Hdf5/PyTables support for TimedeltaIndex","user":{"login":"JonasAbernot","id":5037636,"avatar_url":"https://avatars.githubusercontent.com/u/5037636?v=3","gravatar_id":"","url":"https://api.github.com/users/JonasAbernot","html_url":"https://github.com/JonasAbernot","followers_url":"https://api.github.com/users/JonasAbernot/followers","following_url":"https://api.github.com/users/JonasAbernot/following{/other_user}","gists_url":"https://api.github.com/users/JonasAbernot/gists{/gist_id}","starred_url":"https://api.github.com/users/JonasAbernot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonasAbernot/subscriptions","organizations_url":"https://api.github.com/users/JonasAbernot/orgs","repos_url":"https://api.github.com/users/JonasAbernot/repos","events_url":"https://api.github.com/users/JonasAbernot/events{/privacy}","received_events_url":"https://api.github.com/users/JonasAbernot/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/Dtypes","name":"Dtypes","color":"e102d8"},{"url":"https://api.github.com/repos/pydata/pandas/labels/HDF5","name":"HDF5","color":"5319e7"},{"url":"https://api.github.com/repos/pydata/pandas/labels/Timedelta","name":"Timedelta","color":"5319e7"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/pydata/pandas/milestones/29","html_url":"https://github.com/pydata/pandas/milestones/0.16.1","labels_url":"https://api.github.com/repos/pydata/pandas/milestones/29/labels","id":816810,"number":29,"title":"0.16.1","description":"after 0.16.0 of course!","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":101,"closed_issues":32,"state":"open","created_at":"2014-10-07T14:39:07Z","updated_at":"2015-04-04T18:40:47Z","due_on":"2015-04-30T07:00:00Z","closed_at":null},"comments":2,"created_at":"2015-03-12T10:40:11Z","updated_at":"2015-04-04T18:40:47Z","closed_at":"2015-04-04T18:40:47Z","body":"When stored in HDFStore, TimedeltaIndex are converted into Int64Index.\r\n\r\n```python\r\ndf = pd.DataFrame(np.random.normal(size=(10,5)))\r\ndf.index = pd.timedelta_range(start='0s',periods=10,freq='1s')\r\nstore = pd.HDFStore('test.h5')\r\nstore['df'] = df\r\ndf = store['df']\r\nprint df.index\r\n```\r\n```\r\nInt64Index([0, 1000000000, 2000000000, 3000000000, 4000000000, 5000000000, 6000000000, 7000000000, 8000000000, 9000000000], dtype='int64')\r\n```\r\nAlthough the backward conversion is easy (pd.TimedeltaIndex(df.index)) , it's surprising.\r\n\r\n```python\r\npd.show_versions()\r\n```\r\n```\r\nINSTALLED VERSIONS\r\n------------------\r\ncommit: None\r\npython: 2.7.6.final.0\r\npython-bits: 64\r\nOS: Linux\r\nOS-release: 3.13.0-46-generic\r\nmachine: x86_64\r\nprocessor: x86_64\r\nbyteorder: little\r\nLC_ALL: None\r\nLANG: fr_FR.UTF-8\r\n\r\npandas: 0.15.2-269-ge3d1b0e\r\nnose: 1.3.1\r\nCython: 0.20.1post0\r\nnumpy: 1.8.2\r\nscipy: 0.13.3\r\nstatsmodels: None\r\nIPython: 1.2.1\r\nsphinx: 1.2.2\r\npatsy: None\r\ndateutil: 2.4.1\r\npytz: 2013b\r\nbottleneck: None\r\ntables: 3.1.1\r\nnumexpr: 2.2.2\r\nmatplotlib: 1.3.1\r\nopenpyxl: None\r\nxlrd: None\r\nxlwt: 0.7.5\r\nxlsxwriter: None\r\nlxml: None\r\nbs4: None\r\nhtml5lib: 0.999\r\nhttplib2: 0.8\r\napiclient: None\r\nrpy2: None\r\nsqlalchemy: 0.9.8\r\npymysql: None\r\npsycopg2: None\r\n\r\n```\r\n\r\nI would have been happy to help and add this myself, but I really have no idea were is this hiding. I don't even know if I should have looked toward PyTables instead of here.\r\n\r\nThanks !\r\n"}}