I'm new to Python and I want to start using it vs. using Excel.
At the moment, I want to calculate the average selling price using a comma separated file that looks similar to this:
Filename: pricelist.txt
Part Number Amount
A 10
A 12
A 19
A 12
B 19
B 13
B 10
I want to see the output to look similar to this:
Part Number Amount
A 13.25
B 14
How would I write code to do this?
Thanks a million in advance!!!!
Regards,
Dan
At the moment, I want to calculate the average selling price using a comma separated file that looks similar to this:
Filename: pricelist.txt
Part Number Amount
A 10
A 12
A 19
A 12
B 19
B 13
B 10
I want to see the output to look similar to this:
Part Number Amount
A 13.25
B 14
How would I write code to do this?
Thanks a million in advance!!!!
Regards,
Dan