I have two dataframes created from ingestion json data w/ the below schemas

provider:

{
    npi: "..."
    name: "..."
    location: {
        address: "...",
        insurances: ["...", "..."],
        ...
    },
    ...
}

insurance:

{
    id: ...,
    ...
}

I would like to join provider df on insurance df where provider.location.insurances contains insurance.id, and add matching insurances as a new array field insurances. Is this possible?

So the resulting data structure would be something like this:

{
    npi: "..."
    name: "..."
    location: {
        address: "...",
        insurances: [123, ...],
        ...
    },
    insurances: [{id: 123, ...}, ...]
}