Hello, there is not category for "stupid questions" so I try "Wolfram language" as pure beginner - so sorry for that :
I have for example two Excel files with data, first with columns A1,B second with A2,B. I am looking for specific function which can merge data from these two xlsx files after import, based on some "common identifier"... lets say, identifier is in column B: - it will show some missing rows in first or sedcond data source, if there will not be common identifier in both of files . - function will select some specific column from each data source as "common identifier"
Could anyone give me some hint as to which function is able to do this simple data comparison?
In Python (pandas) it is used pandas.merge(prop, contribs, on="calaccesscommitteeid")
Thanks for your time and possible help.