Data Cleaning in Mode
I am using a public dataset in Mode to practice data cleaning in SQL.
The dataset contains entries with variant spelling that need to be standardized. It seems like the UPDATE command is the way to go, but when I attempt to execute the query, I get the following error:
cannot execute UPDATE in a read-only transaction
Is there a workaround for this or anything else you might recommend?