Earlier quoted context omitted.
Have 100,000 people enter there address with a text field for the state and get back to me with how many states there are.
50 states, probably. ;) Edit: assuming a very US-centric dataset...
Data Is Never Raw
11–14 of 14 posts
Re: Data Is Never Raw
#12"Don't call it Raw Data"
I would ask my manager to get me someone else.
Re: Data Is Never Raw
#13Earlier quoted context omitted.
50 states, probably. ;) Edit: assuming a very US-centric dataset...
50 states, represented probably 500 different ways... full names, partial names, abbreviations, abbreviations with dots, abbreviations with dots and extra spaces, different cases...
Re: Data Is Never Raw
#14Related: I’ve been trying to get away from describing data as “dirty”, which among other things, implies that there is an obviously better “clean” state for the data. I think it better to call data “complicated”, and rather than cleaning it, we have ways to simplify it for processing.
Have 100,000 people enter there address with a text field for the state and get back to me with how many states there are.
The only way we really know the answer to this question is by placing a lot of bias into our answer.