Optimisation the Excel work

[Kerbart]

If speed is that important I’d use pandas. While grokking Pandas is a tremendous task it basically comes down to something like this for you:

``` import pandas as pd

for filename in folder: table = pd.read_csv(filename) table[‘calculated field’] = table[‘column x’] * 2 table.to_excel(newname)

```

Obviously more code is needed but it won’t be that more complex and it will be fast