Is there a package to do DataFrames comparisons?

oxinabox · August 3, 2021, 2:18pm

It would be really nice if @ssfrr 's DeepDiffs.jl directly supported Tables.
(probably displaying via PrettyTables.jl)
But it does not

it does however support vectors

So some demos

julia> using DataFrames, DeepDiffs

julia> costs = DataFrame(brand=["BurgerDuke", "BurgerDuke", "BurgerDuke", "McDannys", "McDan
       nys"], product = ["burger", "fries", "drink", "burger", "drink"], price=[10.0, 5.0, 1.0, 9.5
       , 0.5])
5×3 DataFrame
 Row │ brand       product  price   
     │ String      String   Float64 
─────┼──────────────────────────────
   1 │ BurgerDuke  burger      10.0
   2 │ BurgerDuke  fries        5.0
   3 │ BurgerDuke  drink        1.0
   4 │ McDannys    burger       9.5
   5 │ McDan\nnys  drink        0.5

julia> costs2 = DataFrame(brand=["BurgerDuke", "BurgerDuke", "BurgerDuke", "McDannys", "McDan
       nys"], product = ["burger", "fries", "drink", "burger", "drink"], price=[10.0, 7.0, 1.0, 9.5
       , 0.5])
5×3 DataFrame
 Row │ brand       product  price   
     │ String      String   Float64 
─────┼──────────────────────────────
   1 │ BurgerDuke  burger      10.0
   2 │ BurgerDuke  fries        7.0
   3 │ BurgerDuke  drink        1.0
   4 │ McDannys    burger       9.5
   5 │ McDan\nnys  drink        0.5

by row

by column

Perhaps best is to convert to dict:
as_dict(t) = getfield(Tables.dictcolumntable(t), :values)