I have a csv file that I want to edit manually on my Mac. I work with data digitization from PDFs, and sometimes rare errors occur that I just want to fix manually.
For the sake of reproducibility, I want to edit the csv file recording every change in a log file. For example, I change the entry "Callfornia" to "California" for a certain observation, and the log file records:
Line 5, Column "address", change "Callfornia" to "California"
I know I can write a script (eg, in Python) that will make the changes I want, and this will be reproducible. However, in my workflow, it would be easier to have a WYSIWYG editor that also keeps track of what is going on.