This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
so I have a situation where I have data that needs desperate cleaning. In the example below under Provider Type and Provider Phone number I need to replace the number with the majority number listed. Under ProviderLicense I need to replace the nulls with the with the License number.
Thanks for the sample. Can you provide the answers to my other 2 questions as well? Without those, I can't tell what you want. the easiest way to do that is give us an example of what the output data should look like
I know I'm terrible at explaining things. In the column ProviderType there is multiple Examples like FM, Board Certified FM, FP and fam med. Since FM is imputed the most I would like to replace everything with FM.