I wanted to see the json file corresponding to a dataframe that has dataframes as elem

arraytable (objecttable) fails when the argument is a nested table about jsontables.jl HOT 2 OPEN

juliadata commented on June 16, 2024

arraytable (objecttable) fails when the argument is a nested table

from jsontables.jl.

Comments (2)

quinnj commented on June 16, 2024

Yeah, it's true that the machinery in JSONTables.jl isn't set up very well right now for the nested table case. We'll have to think through what makes sense here; maybe we try to apply the sink recursively?

from jsontables.jl.

sprmnt21 commented on June 16, 2024

... or put a kwargs to choose to flatten everything.
By obtaining, in the example considered, such a thing

julia> CSV.read("tabintabm.csv", DataFrame)
7×6 DataFrame
 Row │ name     salary  friends.name  friends.salary  friends.hobbies.name  friends.hobbies.frequency      
     │ String7  Int64   String7       Int64           String7?              Union{Missing, Int64}
─────┼────────────────────────────────────────────────────────────────────────────────────────────────     
   1 │ bob       13000  sarah                  10000  missing                                 missing      
   2 │ bob       13000  bill                    5000  missing                                 missing      
   3 │ marge     10000  rhonda                 10000  missing                                 missing      
   4 │ marge     10000  mike                    5000  surfing                                      10      
   5 │ marge     10000  mike                    5000  surfing                                      15      
   6 │ joe       10000  harry                  10000  missing                                 missing      
   7 │ joe       10000  sally                   5000  missing                                 missing

from jsontables.jl.

Recommend Projects