Problems loading CSV file in Julia

user_7210250 0
Viewed 301

I'm trying to use the Queryverse to load a csv file, like this

using Queryverse

df = load("my_file.csv"
        , delim = ";"
        , row_estimate = 215_000
        , type_detect_rows = 2_000) |> 
    DataFrame

but I get the following error:

MethodError: no method matching UInt8(::String)

I'm sorry, I can't share an example of the file.

The error message is not very informative. I'm guessing there might be some problem with the type detection of the rows - that's why I played around with the with the function parameters, but it doesn't seem to work out.

Can anyone help?

julia
1 Answers

The problem with your code is the delim parameter that shoud be a Char not a String.

So this should be:

df = load("my_file.csv"
        , delim = ';'
        , row_estimate = 215_000
        , type_detect_rows = 2_000) |> 
    DataFrame

The error you got is related to processing the delimiter parameter not the data in your file!

Nevertheless, nornally the recommended option is to use CSV.jl for reading csv files rather than CSVFiles.jl that is used by Queryverse.load function.

user_99577100
Related