Reconcile and generate the report from 2 data sets

[Akulk120]

I have 2 data files and i need to reconcile them using the RStudio. I cannot do this in Excel since the data length is too much. My current VB tool is manual and too much time consuming. So need to create a more quick tool. Can you please advise what is the best method and tool to be used? I am also open to use Python.

Data1
C1	C2	C3	C4	Total
A	B	C	D	5
A	B	C	D	2
A	B	C	D1	1
A	B1	C	D2	0
A	B2	C	D	0
A	B	C	D	3

Data2
C5	C6	C7	C7.1	C8	Total
A	B	C	Cq	D	5
A	B	C	Cq	D	2
A	B	C	Cq	D1	1
A	B1	C	Cq	D2	0
A	B2	C	Cq	D	0
A	B	C	Cq	D	3

1. Oder of the columns remain Same, however order might differ.
2. We need to reconcile the data between the Data1 and Data2
3. Currently I have a VB Tool which actually clubs the data from required columns and form a string and compare.
4. Required to generate the report, how many are match, howmany are mismatch, Incase of mismatch what is the difference up to 6 decimal places

[turgut090]

@Akulk120 Please, search/ask such questions here https://stackoverflow.com/