Open
Description
While working with JSON data (or similar) in Julia it is common to have Dicts which you want to flatten/unnest.
transform(df, :b => AsTable) could be a great solution, but in JSON it is common for keys to be missing, and transform(df, :b => AsTable) will not work for this case.
Example:
a1=Dict("a"=>1, "b"=>Dict("c"=>1, "d"=>2))
a2=Dict("a"=>1, "b"=>Dict("c"=>1))
a=[a1;a2]
df=DataFrame(a)
bug=transform(df, :b => AsTable)
ERROR: ArgumentError: keys of the returned elements must be identical
Expected result: Missing value in row 2 for column d
Metadata
Metadata
Assignees
Labels
No labels