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