I am looking for a tool/approach to perform an inexact merge. I have two (or more) dataframes with datetime columns (and value columns) that do not correspond. I imagine specifying a tolerance value (say 5 minutes) for the merge. Is there a package (or a best practice approach) that can help me wi…

The SortMerge.jl package is designed exactly for this purpose: using DataFrames, CSV, SortMerge, Dates url="""https://gist.githubusercontent.com/kafisatz/ed1f42fb4b5fd1ce1cf3a8a12b8e80b6/raw/70df7040c550bbdedd168c90a78caf4ee2808881/hadata.csv""" fi = download(url) df0 = CSV.File(fi) |> DataFrame …

Fuzzy inexact merge

General Usage

Tamas_Papp July 25, 2020, 2:23pm 4

This is not apparent to me from the code — sorry if I missed something.

Functions to merge DataFrames by nearest date that is earlier?

Topic		Replies	Views
Merge dataframes where one value is between two others General Usage question	7	11393	November 22, 2020
A nice use case for DataFrames.jl - flexible dedup General Usage dataframes , tables , splitapplycombine	4	583	July 16, 2021
Hello!, I'm currently trying to merge a set of asset returns from a CSV file, we h General Usage	1	249	February 10, 2021
Join Dataframes on different IDs within date range New to Julia query , dataframes	1	484	October 4, 2020
[ANN] DataFrameIntervals.jl — joins on intervals of time Package Announcements dataframes	40	2198	October 31, 2022

Fuzzy inexact merge

Related topics