# Fuzzy inexact merge

**URL:** https://discourse.julialang.org/t/fuzzy-inexact-merge/43666
**Category:** General Usage
**Created:** [July 25, 2020, 12:57pm UTC](https://discourse.julialang.org/t/fuzzy-inexact-merge/43666 "2020-07-25T12:57:34Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![gcalderone](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/gcalderone/32/1539_2.png) [@gcalderone](https://discourse.julialang.org/u/gcalderone)
#### Post date: [July 29, 2020, 9:11am UTC](https://discourse.julialang.org/t/fuzzy-inexact-merge/43666/5 "2020-07-29T09:11:16Z")

</div>

The [SortMerge.jl](https://github.com/gcalderone/SortMerge.jl) package is designed exactly for this purpose:

```julia
using DataFrames, CSV, SortMerge, Dates

url="""https://gist.githubusercontent.com/kafisatz/ed1f42fb4b5fd1ce1cf3a8a12b8e80b6/raw/70df7040c550bbdedd168c90a78caf4ee2808881/hadata.csv"""
fi = download(url)
df0 = CSV.File(fi) |> DataFrame

df1 = filter(x->x.entity_id == "kitchen_temperature",df0)
df2 = filter(x->x.entity_id == "buero_temperature",df0)

j = sortmerge(df1.datetime, df2.datetime, Minute(5),
              sd=(v1, v2, i1, i2, threshold) -> begin
              diff = v1[i1] - v2[i2]
              (abs(diff) > threshold) && (return sign(diff))
              return 0
              end)

# Rows common to both dataframes (i.e., inner join)
tmp = hcat(df1[j[1], :], df2[j[2], :], makeunique=true)

# Print maximum clock difference between matched rows
println(Minute(maximum(abs.(df1[j[1], :datetime] .- df2[j[2], :datetime]))))

# Rows from first dataframe without matching rows in the second one:
tmp = df1[countmatch(j, 1) .== 0, :]

# Rows from second dataframe without matching rows in the first one:
tmp = df2[countmatch(j, 2) .== 0, :]

```

---

_[View the full topic](https://discourse.julialang.org/t/fuzzy-inexact-merge/43666)._