# Convert sqlite data to dataframe without nullable type

**URL:** <https://discourse.julialang.org/t/convert-sqlite-data-to-dataframe-without-nullable-type/689>\
**Category:** General Usage\
**Created:** [December 2, 2016, 6:03am UTC](https://discourse.julialang.org/t/convert-sqlite-data-to-dataframe-without-nullable-type/689 "2016-12-02T06:03:43Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![nalimilan](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nalimilan/32/147_2.png) [@nalimilan](https://discourse.julialang.org/u/nalimilan)\
**Post date:** [December 2, 2016, 1:58pm UTC](https://discourse.julialang.org/t/convert-sqlite-data-to-dataframe-without-nullable-type/689/3 "2016-12-02T13:58:51Z")

</div>

Indeed data frames are not yet ready to use with `NullableArray`. See [this thread](https://discourse.julialang.org/t/teaching-data-analysis-with-julia-what-to-do-about-dataframes-and-all-that/422) and [this announcement](https://discourse.julialang.org/t/announcement-dataframes-0-9-0-planned-for-february/).

I’m not sure what’s the best way to work with SQLite.jl at the moment, but if you don’t have any missing values, just convert columns to standard `Array` after importing the data.

---

_[View the full topic](https://discourse.julialang.org/t/convert-sqlite-data-to-dataframe-without-nullable-type/689)._