A simple Python Script to remove 0 quantity row from a Product Database in CSV file.
Before starting, make sure you have Python installed in your system.
RemoveZeroes.py is the python script file which is placed at root path. (User can place it anywhere as per their comfort)
Product_DB.csv is a sample Database for testing the python script. It contains the following column headers.
| P_ID | PRODUCT NAME | INCHARGE | BARCODE | STOCK | QUANTITY | UNITS | AREA | CATEGORY | RATIO |
Kindly note that the column number of QUANTITY is 6.
Now open your terminal and go to the directory where your RemoveZeroes.py is placed.
Run python RemoveZeroes.py and specify the path to the directory containing your Product_DB.csv.
Enter the CSV filename (i.e Product_DB) and Quantity Column Number followed by Output filename of your choice.
Also note that you need not specify the extension (.csv) as an input
Here is the screenshot of my output terminal:
