Declaring Column Vector Types

Declaring Column Vector Types

CategoricalArrays & other column types

Declaring all columns should be parsed as CategoricalVectors

julia> using uCSV, DataFrames, CategoricalArrays

julia> s =
       """
       a,b,c
       a,b,c
       a,b,c
       a,b,c
       """;

julia> eltype.(DataFrames.columns(DataFrame(uCSV.read(IOBuffer(s), coltypes=CategoricalVector))))
3-element Array{DataType,1}:
 CategoricalString{UInt32}
 CategoricalString{UInt32}
 CategoricalString{UInt32}

Declaring whether each column should be a CategoricalVector or not

julia> using uCSV, DataFrames, CategoricalArrays

julia> s =
       """
       a,b,c
       a,b,c
       a,b,c
       a,b,c
       """;

julia> eltype.(DataFrames.columns(DataFrame(uCSV.read(IOBuffer(s), coltypes=fill(CategoricalVector, 3)))))
3-element Array{DataType,1}:
 CategoricalString{UInt32}
 CategoricalString{UInt32}
 CategoricalString{UInt32}

Declaring whether specific columns should be CategoricalVectors by index

julia> using uCSV, DataFrames, CategoricalArrays

julia> s =
       """
       a,b,c
       a,b,c
       a,b,c
       a,b,c
       """;

julia> eltype.(DataFrames.columns(DataFrame(uCSV.read(IOBuffer(s), coltypes=Dict(3 => CategoricalVector)))))
3-element Array{DataType,1}:
 String                   
 String                   
 CategoricalString{UInt32}

Declaring whether specific columns should be CategoricalVectors by column name

julia> using uCSV, DataFrames, CategoricalArrays

julia> s =
       """
       a,b,c
       a,b,c
       a,b,c
       a,b,c
       """;

julia> eltype.(DataFrames.columns(DataFrame(uCSV.read(IOBuffer(s), header=1, coltypes=Dict("a" => CategoricalVector)))))
3-element Array{DataType,1}:
 CategoricalString{UInt32}
 String                   
 String