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