Given two DataFrames of different lengths, and different parameter names… julia> dfA = DataFrame(:Parameter => ["size", "weight", "color", "smell"], :Value => ["small", "120", "red", "none"]) 4×2 DataFrame Row │ Parameter Value │ String String ─────┼─────────────────── 1 │ s…

try this antijoin(dfB,dfA,on=[:Parameter, :Value])

antijoin() certainly works on this sample data set, thanks! I’ll try it with the real data, but I don’t see why it would fail. I’ll report back, thanks, again! EDIT: As expected, it works perfectly. I wasn’t familiar with the function, so thank you, @rocco_sprmnt21 .

Some variants and alternatives antijoin(dfB,dfA,on=names(dfB)) DataFrame(setdiff(eachrow(dfB),eachrow(dfA))) DataFrame([x for x in eachrow(dfB) if x ∉ eachrow(dfA)]) eachrow(dfB)[findall(x->x ∉ eachrow(dfA), eachrow(dfB))] dfB[findall(x->x ∉ eachrow(dfA), eachrow(dfB)),:]

This is very good info, which I’m sure I’ll reference in the future. Thanks again! My attempt with setdiff() had failed when I tried it, but now see that the use of eachrow() is key. I’ll play with these options to get more familiar with their use and syntax.

Differences in Two DataFrames

General Usage

pdeffebach November 10, 2022, 7:54pm 2

I don’t think such a thing exists. See an earlier thread.

Topic		Replies	Views
Discarding rows of dataframe base on condition on column of another dataframe General Usage dataframes	6	431	December 24, 2023
Filtering one DataFrame using parameters of another, with different lengths New to Julia dataframes	5	404	March 8, 2023
Set-like operations on DataFrames? Data question , dataframes	13	2653	February 1, 2023
Dataframes: How to conditionally remove rows based on data values? General Usage	4	8470	October 1, 2020
How to create a new DF with only the rows that contain specific values from two different columns New to Julia question	5	140	September 15, 2024

Differences in Two DataFrames

Related topics