How to change the type of a variable for a loaded table?

Specific Domains Statistics
,
3

You can do that with ScientificTypes fairly easily (actually that’s exactly the kind of use case ST was developed for)

julia> using ScientificTypes
julia> t = JuliaDB.table(1:10, randn(10), rand(Bool, 10); names = [:x, :y, :z]);
julia> t2 = coerce(t, :z => Multiclass)

In the background what that does is form a derived table where the column :z has been obtained by doing categorical(select(t, z)); if you wanted to have that as ordered categoricals, coerce(t, :z => OrderedFactor) does the trick. t2 has the same type as t.

1 Like