how to handle values that only appear once in a column?
Assuming those are target categories, the most common strategies are:


Drop them. Do not try to predict categories with single observations because the model will overfit.
Bundle them to together into a "dustbin" category. Then the model can learn to predict "dustbin" category membership.