Hi, I am trying to do an ‘as of’ merge in Julia with two large Dataframes, based on the time and the equipment_id provided. As a manner of example, let me introduce the two df.head() using DataFrames df1 = DataFrame( date = DateTime.(["2022-02-20T08:05:22", "2022-02-20T08:05:42", …

I don’t get the result you expect, but I don’t know how else to interpret the conditions you described in a generic way. Could something like this be right for you? gdate1=groupby(rightjoin(df1,df2,on=:equipment_id, makeunique=true),:date_1) subset(gdate1, [:date,:date_1]=>(x,y)->minimum(abs.(x-…

Asof merge in Julia

General Usage

rafael.guerra February 23, 2022, 8:24am 2

Check this solution using the SortMerge.jl package, it should help.

2 Likes

Topic		Replies	Views
Functions to merge DataFrames by nearest date that is earlier? Data dataframes	4	1526	December 20, 2021
Fuzzy inexact merge General Usage	5	1528	July 29, 2020
Merge dataframes where one value is between two others General Usage question	7	11770	November 22, 2020
Join Dataframes on different IDs within date range New to Julia query , dataframes	1	495	October 4, 2020
Asof join support in DataFrames.jl Data dataframes	9	919	October 13, 2022

Asof merge in Julia

Related topics