I am trying to read a CSV file that has a column of Arrays. While reading it via CSVFiles.jl and CSV.jl the column of arrays are loaded as String. This is how that specific column values look like in the CSV File [q_meta]

I think I found the solution. Used the following code: map(x->parse.(Int64,x),[split(chop(elements, head=1), ",") for elements in q_meta[:SubjectId] ]) where SubjectId is the column name and q_meta is the csv file loaded as a data frame.

At the moment the package assumes that the lines are json objects (“{…}”) rather than json arrays (“[…]”) but I can work on that

Files with arrays similar to the first example on the JSONLines website can now be read using the readarrays(file) function. I plan to eventually merge this into the readfile function but I have to clean up the code first. Check out: https://github.com/danielw2904/JSONLines.jl/commit/7afa32f7fbc09…

CSV file reading Arrays as String in CSVFiles.jl and CSV.jl

General Usage

Jeff_Emanuel August 21, 2020, 5:20pm 2

That looks like a perfect use case for jsonlines Initial version of my first package: A JSON Lines reader

Topic		Replies	Views
DataFrames/CSV: how to read vectors from *.csv? General Usage	9	2986	March 26, 2021
Convert Any["0.30", "0.34"] to [0.30, 0.34] New to Julia question	7	504	August 30, 2021
Reading from a text file to create an array of arrays New to Julia	3	2794	June 5, 2018
DataFrames: reading vector from *.csv file to dataframe column General Usage	2	1401	October 3, 2019
Reading multiple integers from the same line without string manipulation General Usage question , io , file	1	627	July 30, 2021

CSV file reading Arrays as String in CSVFiles.jl and CSV.jl

Related topics