I am trying to use python to create a lookup table. The lookup table is in a csv right now.
Category1, .15xPrice + 2.00
Category2, .18xPrice + 2.00
The lookup locates the Category, and the second column is the algorithm that is executed against a given value assigned to the the variable Price.
I do not know how to execute this.
PRice = 29.95
Category = Category1
THe output would be (29.95 * .15) + 2.00 or 6.4925
How do I accomplish this?