Automating individual data corrections
I have identified very specific errors in my dataset. I can fix them by hand very easily, but for various reasons, I need to automate/script it. Specifically, I need to change the value in the column "Task" from "Contributor" to "Reviewer" but only for very specific cells out of many. These cells can be identified by content in one or more other columns, "Report#" or "Name".Both the names and the ...