# Why does DataFrames take so long to load?

**URL:** <https://discourse.julialang.org/t/why-does-dataframes-take-so-long-to-load/7812>\
**Category:** New to Julia\
**Created:** [December 17, 2017, 3:18am UTC](https://discourse.julialang.org/t/why-does-dataframes-take-so-long-to-load/7812 "2017-12-17T03:18:40Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![tk3369](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tk3369/32/2824_2.png) [@tk3369](https://discourse.julialang.org/u/tk3369)\
**Post date:** [December 17, 2017, 3:18am UTC](https://discourse.julialang.org/t/why-does-dataframes-take-so-long-to-load/7812/1 "2017-12-17T03:18:40Z")

</div>

Is there any way to speed this up? I don’t think I’m the only one bothered by this… 🙂

```julia
julia> @time using DataFrames
 28.351476 seconds (2.77 M allocations: 165.493 MiB, 2.67% gc time)

julia> versioninfo()
Julia Version 0.6.1
Commit 0d7248e (2017-10-24 22:15 UTC)
Platform Info:
  OS: macOS (x86_64-apple-darwin14.5.0)
  CPU: Intel(R) Core(TM) i5-4258U CPU @ 2.40GHz
  WORD_SIZE: 64
  BLAS: libopenblas (USE64BITINT DYNAMIC_ARCH NO_AFFINITY Haswell)
  LAPACK: libopenblas64_
  LIBM: libopenlibm
  LLVM: libLLVM-3.9.1 (ORCJIT, haswell)

```

---

<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 17, 2017, 4:02am UTC](https://discourse.julialang.org/t/why-does-dataframes-take-so-long-to-load/7812/2 "2017-12-17T04:02:04Z")

</div>

For reference, mine doesn’t take that long:

```julia
julia> @time using DataFrames
  1.138097 seconds (1.20 M allocations: 66.721 MiB, 14.38% gc time)

julia> versioninfo()
Julia Version 0.6.1-pre.0
Commit dcf39a1dda* (2017-06-19 13:06 UTC)
Platform Info:
  OS: Linux (x86_64-pc-linux-gnu)
  CPU: Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz
  WORD_SIZE: 64
  BLAS: libopenblas (USE64BITINT DYNAMIC_ARCH NO_AFFINITY Haswell)
  LAPACK: libopenblas64_
  LIBM: libopenlibm
  LLVM: libLLVM-3.9.1 (ORCJIT, skylake)

julia> Pkg.status("DataFrames")
 - DataFrames 0.11.2

```

---

<div class="post-metadata">

**Author:** ![xiaodai](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/xiaodai/32/15937_2.png) [@xiaodai](https://discourse.julialang.org/u/xiaodai)\
**Post date:** [December 17, 2017, 4:02am UTC](https://discourse.julialang.org/t/why-does-dataframes-take-so-long-to-load/7812/3 "2017-12-17T04:02:15Z")

</div>

Are you using Juno? On my Windows PC, timing it in Juno is 9 seconds but in Julia REPL it is 1.7 seconds.

Sometimes Juno is only 4 seconds, so a bit of variability there.

Unless it’s the first time you are doing `using DataFrames` after updating it or installing it for the first time.

---

<div class="post-metadata">

**Author:** ![tk3369](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tk3369/32/2824_2.png) [@tk3369](https://discourse.julialang.org/u/tk3369)\
**Post date:** [December 17, 2017, 4:32am UTC](https://discourse.julialang.org/t/why-does-dataframes-take-so-long-to-load/7812/4 "2017-12-17T04:32:52Z")

</div>

I am just using the REPL. In fact, every time I restart the REPL it takes just as long.

---

<div class="post-metadata">

**Author:** ![xiaodai](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/xiaodai/32/15937_2.png) [@xiaodai](https://discourse.julialang.org/u/xiaodai)\
**Post date:** [December 17, 2017, 5:20am UTC](https://discourse.julialang.org/t/why-does-dataframes-take-so-long-to-load/7812/5 "2017-12-17T05:20:41Z")

</div>

Probably a long shot but what is your `Pkg.status("DataFrames")`. I suggest raising a performance bug in the DataFrames together with that information.

Perhaps you can try `Pkg.checkout("DataFrames")` to install the latest version of DataFrames to help rule in/out if DataFrames is the issue.

---

<div class="post-metadata">

**Author:** ![tk3369](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tk3369/32/2824_2.png) [@tk3369](https://discourse.julialang.org/u/tk3369)\
**Post date:** [December 17, 2017, 5:59am UTC](https://discourse.julialang.org/t/why-does-dataframes-take-so-long-to-load/7812/6 "2017-12-17T05:59:15Z")

</div>

Strange but it works after removing and reinstalling all packages.  
Thanks for the suggestions.

```julia
julia> @time using DataFrames
  2.567160 seconds (2.89 M allocations: 164.181 MiB, 11.35% gc time)

```