# What is the future of time-indexed dataframes?

**URL:** https://discourse.julialang.org/t/what-is-the-future-of-time-indexed-dataframes/7751
**Category:** Data
**Tags:** question, dataframes, time-series
**Created:** [December 14, 2017, 12:08am UTC](https://discourse.julialang.org/t/what-is-the-future-of-time-indexed-dataframes/7751 "2017-12-14T00:08:52Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![juliohm](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/juliohm/32/215266_2.png) [@juliohm](https://discourse.julialang.org/u/juliohm)
#### Post date: [December 14, 2017, 12:08am UTC](https://discourse.julialang.org/t/what-is-the-future-of-time-indexed-dataframes/7751/1 "2017-12-14T00:08:52Z")

</div>

After some research today, I came across this thread discussing the pros and cons of different approaches for handling time series data in dataframe-like format: [https://github.com/JuliaStats/Roadmap.jl/issues/10](https://github.com/JuliaStats/Roadmap.jl/issues/10)

Can you please shed light on the current state of the API and the future plans? It seems to me that, currently, the TimeSeries.jl API is orthogonal to the DataFrames.jl API. I wonder if these two will be merged in the future similar to what Pandas provides for Python?

---

<div class="post-metadata">

### Author: ![aaowens](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/aaowens/32/12101_2.png) [@aaowens](https://discourse.julialang.org/u/aaowens)
#### Post date: [December 14, 2017, 12:25am UTC](https://discourse.julialang.org/t/what-is-the-future-of-time-indexed-dataframes/7751/2 "2017-12-14T00:25:46Z")

</div>

I saw some discussion of this for IndexedTables here [https://github.com/JuliaComputing/IndexedTables.jl/issues/56](https://github.com/JuliaComputing/IndexedTables.jl/issues/56) . I’d think efficient time series operations would be fairly easy to attach to an `IndexedTable` since the they are sorted by design. In particular, it would be great if they supported panel data operations like in Stata.

---

<div class="post-metadata">

### Author: ![StefanKarpinski](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/stefankarpinski/32/24_2.png) [@StefanKarpinski](https://discourse.julialang.org/u/StefanKarpinski)
#### Post date: [December 14, 2017, 12:32am UTC](https://discourse.julialang.org/t/what-is-the-future-of-time-indexed-dataframes/7751/3 "2017-12-14T00:32:01Z")

</div>

JuliaDB/IndexedTables also supports efficient `asofjoin` which is particularly useful for working with time series data.

---

<div class="post-metadata">

### Author: ![juliohm](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/juliohm/32/215266_2.png) [@juliohm](https://discourse.julialang.org/u/juliohm)
#### Post date: [December 14, 2017, 12:39am UTC](https://discourse.julialang.org/t/what-is-the-future-of-time-indexed-dataframes/7751/4 "2017-12-14T00:39:49Z")

</div>

Thank you all for the links and comments. Is there a somewhat defined plan for joining all these alternative implementations? I am a little lost with how I should proceed.
