I have the following dataframe(df2)
Nombrearchivo Numero PosicionRegistro
20161020_113502_131221557378544949.jpg 208-13567 588
20161020_113448_131221555449704589.jpg 208-1356 588
20161020_113348_131221557962771773.jpg 208-567958- 588
TOMAS_131225713254987197.pdf 017-30402- 649
and the tuple contains(resultFileName)
[('20161020_113502_131221557378544949.jpg', 85, 17),
('20161020_113352_131221557853238556.jpg', 82, 21),
('20161020_113422_131221557754328771.jpg', 79, 20),
('20161020_113448_131221555449704589.jpg', 76, 18),
('20161020_113437_131221557662296937.jpg', 76, 19),
('20161020_113348_131221557962771773.jpg', 76, 22)]
I need to show the data of the dataframe where the file name matches the data of the tuple, I tried several methods that I was reviewing with lamba but in all of them I could not advance anything an example of what I got to try is
resultNombreArchivo = process.extract(inputNombreArchivo,InputDataSet["nombreArchivo"],limit=6,scorer=fuzz.ratio)
df2 = pd.DataFrame(InputDataSet)
print(df2[df2["nombreArchivo"].apply(lambda x: resultNombreArchivo[0][0] in x)])
It should work as I mentioned to you in my comment:
Using
apply
:Update
If you want to filter your
DataFrame
to find out which of them contain files that are inside the tuples, you can useisin
: