Suppose I have two csv sheets.
TranId,Trandate,TranAmnt as column names. And 10 rows of data. So to compare the files the condition is like: A.TranId==B.TranId && A.TranDate==B.TranDate && A.TranAmnt==B.TranAmnt. Now I need to match the data of according to the rule and get output row wise.
I have tried comparing it in Pandas using join and merge but it doesn't provide the desired output.
So basically the comparison is for reconciliation of files and to check the processing speed of the file. (Note: data is in bulk). The output needs to be dumped in Oracle database. So kindly please help me with this. Thanks in Advance.