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
Asof merge in Julia General Usage dataframes , merge	12	1595	March 23, 2022
Functions to merge DataFrames by nearest date that is earlier? Data dataframes	4	1529	December 20, 2021
Merge dataframes where one value is between two others General Usage question	7	11800	November 22, 2020
Join Dataframes on different IDs within date range New to Julia query , dataframes	1	497	October 4, 2020
Merging dataframes on dates General Usage question	3	441	December 1, 2021

Fuzzy inexact merge

Related topics