'I am fairly new to python and I want to know if my code will execute the task I described or did I miss anything? how can I fix the picture error?
The program is supposed to take the rows in column [newAssetCode] and compare them to the rows in column ['allAssetCodes'] to then find the assets in [newAssetCode] that already exist in ['allAssetCodes']. The program will then count how many times the assets exist in ['allAssetCodes']. for example if If ['allAssetCodes'] contains 'XYZ','XYZ1', 'XYZ2' it will count that and then add a digit to that count and append that number in a new list creating 'XYZ3'. Then count how many instances of 'XYZ' there are again until they have been correctly numbered. Did I write this code correctly? so that it can perform the task above and how can I fix this error
Solution 1:[1]
Make sure the file you are trying to load, Codes.xlsx, is in the same directory as the python script you are running.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Micha? |