I am trying to edit my dataset with more than 10,000 submissions. One of my questions ask a name of country and the responses are different for countries like the US. For instance, I have ‘US’, ‘us’, ‘U.S’, ‘The US’, ‘United States’, ‘The United States of America’…
Is there a way to fix this without having to edit each submission manually? Can we do it through a Python , SQL scripts , or API?
Thank you so much in advance