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
Join Dataframes on different IDs within date range New to Julia query , dataframes	1	484	October 4, 2020
Merging two dataframes of different length New to Julia dataframes	2	771	April 22, 2022
Merge dataframes where one value is between two others General Usage question	7	11399	November 22, 2020
Merge two dataframes together Data	1	9476	November 14, 2020
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

Asof merge in Julia

Related topics