Having just started with Python, I may be asking a basic question.
I have two sets of lists, one containing volume names and associated counts. Here's a sample of the data:
volumes1 = ['Shield', 'Side', 'expHall', 'Funnel', 'gridpiece']counts1= [3911, 1479, 553, 368, 342]and another set of lists
volumes2 = ['Shield', 'leg', 'Funnel', 'gridpiece','wafer']counts2= [291, 469, 73, 28, 32]
It's important to note that not all volumes appear in both lists, and their order might vary.
The goal is to create a dataframe with three columns: the first column listing all volumes from both sets, the second column showing corresponding values from counts1, and the third column displaying related values from counts2.
If a volume in the first column of the dataframe isn't present in volumes1, the value in the second column is set to 0. Similarly, if a volume in the first column isn't found in volumes2, the value in the third column is set to 0. Therefore, the resulting output for the given values should look like:
| volumes | counts1 | counts2 |
| Shield | 3911 | 291 |
| Side | 1479 | 0 |
| expHall | 553 | 0 |
| Funnel | 368 | 73 |
| gridpiece | 342 | 28 |
| leg | 0 | 469 |
| wafer | 0 | 32 |
As a beginner in Python, I've struggled to achieve this elegantly and efficiently. Can anyone suggest a quick and efficient way to accomplish this?
Thanks