I am new to pandas. Is there any way i can merge this 2 dataframes into following result
DataFrame1:-
|-------------|---------|----------------------|-------|
|Test Case | SubTest | App | Count |
| geekebench5 | OpenCL | geekbench_x86_64.exe | 1.0 |
| geekebench5 | OpenCL | geekbench_x86_64.exe | 1.0 |
| geekebench5 | Vulkan | geekbench_x86_64.exe | 1.0 |
| geekebench5 | cpu | geekbench_x86_64.exe | 2.0 |
| geekebench5 | cpu | geekbench_x86_64.exe | 1.0 |
| geekebench5 | cpu | geekbench_x86_64.exe | 1.0 |
| geekebench5 | cpu | geekbench_x86_64.exe | 1.0 |
| geekebench5 | cpu | Process | 1.0 |
|-------------|---------|----------------------|-------|
DataFrame2:-
|-------------|---------|----------------------|-------|
|Test Case | SubTest | App | Count |
| geekebench5 | OpenCL | geekbench_x86_64.exe | 2.0 |
| geekebench5 | Vulkan | geekbench_x86_64.exe | 1.0 |
| geekebench5 | cpu | geekbench_x86_64.exe | 2.0 |
| geekebench5 | cpu | geekbench_x86_64.exe | 1.0 |
|-------------|---------|----------------------|-------|
DataFrame Result:-
|-------------|---------|----------------------|---------|---------|
|Test Case | SubTest | App | Count_x | Count_y |
| geekebench5 | OpenCL | geekbench_x86_64.exe | 1.0 | 2.0 |
| geekebench5 | OpenCL | geekbench_x86_64.exe | 1.0 | NaN |
| geekebench5 | Vulkan | geekbench_x86_64.exe | 1.0 | 1.0 |
| geekebench5 | cpu | geekbench_x86_64.exe | 2.0 | 2.0 |
| geekebench5 | cpu | geekbench_x86_64.exe | 1.0 | 1.0 |
| geekebench5 | cpu | geekbench_x86_64.exe | 1.0 | NaN |
| geekebench5 | cpu | geekbench_x86_64.exe | 1.0 | NaN |
| geekebench5 | cpu | Process | 1.0 | NaN |
|-------------|---------|----------------------|---------|---------|
Merging using left operation does not help. No of row count increases and it instead of NaN, it enters the previous row value
