Discussions

I am working with WageScape's Title data, and I am noticing that there are millions of observations with identical Job Posting IDs, which the data dictionary suggests should be the unique job posting identifier. At a glance, it looks like there are 423M observations in WageScape's Job Postings With Salary database, 407M in Role Mapping, and 454 in Time Logs, yet there are 818M observations in Titles. What is the best way to handle these duplicates, and why are there so many? Are these duplicates the result of some job postings having multiple titles?

Thank you very much for your help!