no method countna(Array{UTF8String,1}) - while using show() on a DF

[dbartow]

Im working with IJulia and DataFrames (via ODBC), and showing the contents of a DataFrame works in Julia CL but not IJulia - any advice on how to resolve this?

here is an example of what works in the CL for me:

julia> results = query("SELECT * FROM auditrecord LIMIT 100000");

julia> show(results)
100000x9 DataFrame
|--------|----------|-------------------------|----------|----------|-----------|------------|-------------------------------------------------|---------|----------------------------------------------------|
| Row # | id | created | tenantid | username | category | objecttype | objectname | success | details |
| 1 | 12174956 | 2012-09-27 14:56:38.073 | | | Licensing | license | Test | t | Valid license check: 12345-12345-12345-12345-12345 |

Doing the same in IJulia produces this:

In [6]:
show(results)

100000x9 DataFrame

no method countna(Array{UTF8String,1})
while loading In[6], in expression starting on line 1
in colmissing at /home/ubuntu/.julia/v0.3/DataFrames/src/show.jl:301
in column_summary at /home/ubuntu/.julia/v0.3/DataFrames/src/show.jl:308
in show at /home/ubuntu/.julia/v0.3/DataFrames/src/show.jl:230
in show at /home/ubuntu/.julia/v0.3/DataFrames/src/show.jl:216
in show at /home/ubuntu/.julia/v0.3/DataFrames/src/show.jl:246

Some relevant env info:

Julia Version 0.3.0-prerelease
Platform Info:
System: Linux (x86_64-linux-gnu)
CPU: Intel(R) Xeon(R) CPU E5-2665 0 @ 2.40GHz
WORD_SIZE: 64
Ubuntu 13.10
uname: Linux 3.11.0-15-generic #25-Ubuntu SMP Thu Jan 30 17:22:01 UTC 2014 x86_64 x86_64
Memory: 33.495826721191406 GB (32355.9765625 MB free)
Uptime: 511517.0 sec
Load Avg: 0.052734375 0.1025390625 0.07568359375
Intel(R) Xeon(R) CPU E5-2665 0 @ 2.40GHz:
speed user nice sys idle irq
#1 2394 MHz 32242 s 3074 s 33336 s 51064417 s 0 s
#2 2394 MHz 37799 s 3635 s 46705 s 51061038 s 0 s
#3 2394 MHz 15026 s 63 s 33485 s 51101765 s 0 s
#4 2394 MHz 8351 s 645 s 41159 s 51099579 s 0 s

BLAS: libopenblas (NO_LAPACK NO_LAPACKE DYNAMIC_ARCH NO_AFFINITY)
LAPACK: liblapack.so.3
LIBM: libopenlibm
Environment:
TERM = screen
HOME = /home/ubuntu
PATH = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

Package Directory: /home/ubuntu/.julia/v0.3
3 required packages:

• IJulia 0.1.4
• ODBC 0.3.5
• PyPlot 1.2.2
  15 additional packages:
• BinDeps 0.2.12
• Blocks 0.0.2
• Color 0.2.8
• DataArrays 0.1.2
• DataFrames 0.5.0 pinned.e286d986.tmp
• Datetime 0.1.2
• GZip 0.2.10
• JSON 0.3.3
• Nettle 0.1.3
• PyCall 0.4.2
• REPLCompletions 0.0.0
• SortingAlgorithms 0.0.1
• StatsBase 0.3.7
• URIParser 0.0.1
• ZMQ 0.1.8

[johnmyleswhite]

show always depends upon countna, so I suspect the problem here lies in DataFrames rather than IJulia. Is your Julia REPL using the same versions of all packages as your IJulia session?

[quinnj]

This was due to a change in DataFrames that wasn't tracked in that version of ODBC. I would recommend running:

Pkg.free("DataFrames")
Pkg.update()

And you should see both DataFrames and ODBC update (current version of ODBC is 0.3.7) where everything should be working fine.

[dbartow]

Thanks for the fast reply - updating those packages fixed the problem for me. Much appreciated!

Best Regards,

• - Dan