The problem is as follows: I have a dataframe with a column that has Vector{Float64} elements. When I store the dataframe in a CSV file and then retrieve it, the type of the column changed from Vector{Float64} to String. Which is really annoying since I need the values from within the Vector. A MWE…

normally, for types you would want to store in a format that remembers the type like arrow, parquet, or even JDF.jl. but aren’t you storing an array at row 1 column :columnA? that’ seem to be the issue here

That is the whole point. I want to store an array in the dataframe as an element. JDF seems like a solution, but would it be possible to retrieve the data in the Python programming language? The main reason I use a CSV format is because it is also usable to read the file in Python.

[image] Cevheriferd: an array in the dataframe as an element ok then the data will be written out as "[10, 2, 20]" you need some code to parse that back as array. So you want it to be read by python? not sure what’s a good, I think maybe arrow. The parquet writer in julia doesn’t do that yet…

Issues reading CSV file with array elements

General Usage

mike_k September 6, 2021, 1:55pm 5

I have asked more or less the same question a while ago here. Maybe some answers are helpful for you.

1 Like

Topic		Replies	Views
Save Dataframe in file and read it again General Usage question	4	3933	May 28, 2020
DataFrames/CSV: how to read vectors from *.csv? General Usage	9	2977	March 26, 2021
Outputing/Inputing vectors in DataFrames General Usage dataframes , csv	2	506	January 17, 2023
Is there a way to read a DataFrame from file specifying the type of each column? New to Julia question	7	192	November 1, 2024
Creating DataFrame from vector of rows, and fixing type Data dataframes , type-inference	2	144	March 6, 2025

Issues reading CSV file with array elements

Related topics