Efficient way to apply conditions/rules to a csv file

I have a CSV file on the employee for example

employee id, employee name, city, state, salary  

Let's say I want to apply a bunch of conditions for ex: if the city is "Toronto" increment salary by 100. And let's say I have 100 such rules, I'd have to write 100 if/else condition.

What's would be the most efficient way to apply those rules to the data in the CSV file and update the file?

https://stackoverflow.com/questions/66881389/efficient-way-to-apply-conditions-rules-to-a-csv-file March 31, 2021 at 11:50AM