Data Cleaning in Mode

Hi all,

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?

 

Thanks,

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
reply to topic
Like Follow
  • 3 wk agoLast active
  • 69Views
  • 1 Following

Create A New Discussion

Share your thoughts