Hi everyone,<\/p>\n
I\u2019m currently working on an assignment for a Junior Data Engineer role, and I could use some guidance. The task involves merging three datasets from different sources (Facebook, Google, and Company Website) into one comprehensive dataset. The columns I\u2019m focusing on are:<\/p>\n
Domain<\/strong> (most reliable) Phone Number<\/strong> (second most reliable) Name<\/strong> Category<\/strong> Address<\/strong> <\/p>\n I\u2019ve mostly cleaned the datasets, but I need to merge them accurately. My main goals are to:<\/p>\n Merge the datasets<\/strong> using one or two columns (Domain and Phone Number). Ensure no overlap<\/strong> in information and that each row complements itself to create the most accurate and reliable data. <\/p>\n Could anyone suggest the best steps to take for this process? Should I use tools like Power Query or MySQL? Any recommendations for tutorials or YouTube videos would also be greatly appreciated.<\/p>\n Thanks in advance for your help!<\/p>\n<\/div>\n submitted by \/u\/FortaDeMunca <\/a>
[link]<\/a><\/span> [comments]<\/a><\/span><\/p>
