I have a customer table containing name, address, city, zip_code, phone and other fields. Table contains few thousand rows. But there few rows (<100) having one field empty say city. Need a technique to suggest a value for these empty fields from similar records like zip code, phone number etc. Looking for a generic rule. I am using java here.
2.1m questions
2.1m answers
60 comments
57.0k users