You can do me the favor of teaching me or telling me where to look for how to do the following:
I have two panda dataframes. The first is constant and the second is generated from an Excel that always has variable data. The data in column "0" of the second dataframe is compared with the data in column "0" of the first dataframe and as FJSevilla taught me using pd.merge (how = 'inner') I can save the data that match in a third dataframe.
The drawback is that for the match to exist, the data must be exactly the same, which does not always happen. I'm using PyQt5 for the graphical interface of the program and what I would like is that when the program searches for matches between the second and first dataframe, consider the data with partial matches and in a new window I could choose what is the correct data .
For example, if a data from the second dataframe was called "Option" and in the first dataframe there would be "Option", "OptionB" and "OptionC", it would be great if in a pop-up window in PyQt5 the three options appeared and that the one who pointed out will be saved in the third dataframe and so on.
Thanks !!!