Scene 11 of Data Manipulation in Core Technical Interview Questions for Software Engineers
By Amin Ariana — April 2011
Given a Google Search Query, find the AdWords Categories best describing it
Problem Statement
You have one file with (query, URL, score) comma separated row data in which for each URL, the score of its relevance to the given query is given. You have another file that has (URL, categories) info where categories are also comma separated and describe the URL content. Given a query, find the categories best describing its results.
Example:
and
Evaluation
- Writing an algorithm that outputs some meaningful results (25%)
- Being memory-efficient at scale (25%)
- Producing complete result coverage (25%)
- Producing percentages for category rankings (25%)
References
Sashi is from Google. He asked me this question in my interview.