import pandas as pd

keys_df = pd.DataFrame([ ["steve"  , "2266", "Steve, Inc"],
                    ["edward" , "3377", "Ed, Inc"],
                    ["Juan"   , "4488", "Juan, Inc"],
                    ["Pedro"  , "5599", "Pedro, Inc"]],
                    columns=["contains", "parent_id", "parent_name"])

new_df = pd.DataFrame([ [ "9845" , "steve (bikes) qc", None,None],
            [ "9846" , "mark inc",None,None],
            [ "9847" , "young steve",None,None],
            [ "9845" , "Juan 22",None,None],
            [ "9845" , "Zak",None,None]],
            columns=["id", "name", "parent_name", "parent_id"])

id            name         parent_id    parent_name
"9845"  "steve (bikes) qc"      "2266"   "Steve, Inc"
"9846"          "mark inc"       None          None
"9847"       "young steve"      "2266"   "Steve, Inc"
"9845"           "Juan 22"      "4488"    "Juan, Inc"
"9845"               "Zak"       None          None