Convert a data frame in which one column contains array of numbers as string to a json file

Question

I'd like to convert a data frame into a json file. One of the columns of the data frame contains time series as a string. Thus, the final json looks like this:

[{"...":"...","Dauer":"24h","Wertereihe":"8619.0,9130.0,8302.0,8140.0"}, {...}, {...}]

Is it possible to save the df to a json file in such a way that "Wertereihe" is an array of numbers? This would give: [{"...":"...","Dauer":"24h","Wertereihe":[8619.0,9130.0,8302.0,8140.0]}, {...}, {...}]

I used the following snippet to save the df to a json file: df.to_json(jsonFile, orient = "records")

you need to prepare your JSON file format based on your input dataframe — Dev, Oct 21 '21 at 09:28

Muhammad Hassan · Accepted Answer · 2021-10-21T10:07:13.037

2

IIUC, you need:

df['Wertereihe'] = df['Wertereihe'].apply(lambda x: list(map(float, x.split(','))))
df.to_json(jsonFile, orient = "records")

edited Oct 21 '21 at 10:07

answered Oct 21 '21 at 09:30

Muhammad Hassan

4,079
1
13
27

This changes it from a string that contains an array, i.e. "1, 2, 3" to an array of strings, i.e. ["1", "2", "3"]. What I want is "1, 2, 3" ->[1, 2, 3] – SkogensKonung Oct 21 '21 at 09:44
1

Check my edited answer – Muhammad Hassan Oct 21 '21 at 10:07

Convert a data frame in which one column contains array of numbers as string to a json file

1 Answers1