DataStreams with mixed data

53 views
Skip to first unread message

Brandon Booth

unread,
Feb 11, 2016, 2:58:39 PM2/11/16
to julia-users
I'm trying to stream dataframes to an SQLite table and everything works fine unless the dataframe has both numeric and character columns.

When I run:
source = DataStreams.Data.Table(df)

It works if the dataframe is all strings or all numbers. With mixed data, however, it changes all the values to #NULL. Am I doing something wrong?

Thanks.

Brandon

Brandon Booth

unread,
Feb 11, 2016, 4:05:09 PM2/11/16
to julia-users
I should clarify, with mixed data, all columns starting with the first numeric column are changed to #NULL. So the first 11 columns are text, columns 12-15 are numeric, and then 16-20 are text. When I convert it to Data.Table, columns 1-11 are strings and columns 12 - 20 are #NULL.
Reply all
Reply to author
Forward
0 new messages