Hi Guys, Say I have a dataset like this: x = DataFrame(a=[1,3,4,5],b=["a;b;c;d","a;c;d","a;c","b;d"]) I want to first split the column b and then explode it to a long dataset. In python the code is like this: x['b'] = x['b'].str.split(";") x.explode('b') Is there any way I could do the same as…

Is there any function in julia equivalent to pandas explode function

Mattriks January 24, 2022, 4:03am 4

x[!,"b2"] = split.(x.b, ";")
flatten(x, "b2")

For more info, ?flatten.

3 Likes

Topic		Replies	Views
`explode`-like function in DataFrames Data dataframes	3	218	May 10, 2024
How to explode a DataFrame cell containing multiple values into separate rows? General Usage	7	1158	July 7, 2020
JuliaDB - split one column into n columns General Usage juliadb	1	1461	February 12, 2019
Split dataframe row into multiple rows Data dataframes	8	1843	May 1, 2022
Unnesting columns of a data frame containing arrays General Usage question , dataframes , data_structures	1	524	December 9, 2020