Check if a string in Data Frame column is in or part of another string in a different Data Frame column

Viewed 26

Any Idea how to do so, let's say I have df_sites and df_meters.

I want to search for every item in df_sites[col1] is it in or part of a string in df_meters[col1].

I tried

meters=  {'col1': [
"AL \ MA \ AR \ 053",
"AL \ MA \ AR \ 05454",
"AL \ MA \ AR \ 05BVBX",
"AL \ MA \ QW \ 05OLOL \ 123",
"AL \ MA \ QW \ 05OLOL",
"AL \ MA \ AR \ 05OLOL",
"AL \ MA \ ABCVR",
"AL \ MA \ ZSC",
"AL \ MA \ ARDD \ 05OLOL \ fgs",
"AL \ MA \ ABCVR \ 05OLOL \ freon",
"AL \ MA \ ZSC \ 05OLOL \ Gas"
],
'col2': ["53",
"5454",
"05BVBX",
"05BVBX",
"05BVBX",
"05OLOL",
"05OLOL",
"05OLOL",
"05OLOL",
"05OLOL",
"05OLOL"], 

'col3' : ['d5',
'd5',
'd5',
'd5',
'd5',
'd5',
'd5',
'd5',
'd5',
'd5',
'd5'
]}


df_meters = pd.DataFrame(meters)
df_sites = pd.DataFrame(sites)





for i, j in df_sites[col1].iteritems():
    for k, h in df_meters[col1].iteritems():
        if j in h:
            print(j)

but did not work as expected

0 Answers
Related