Database Cleanup & Keyword Optimization

Job ID: 38236055

Budget: $80 – $100 USD

1. Extract Keywords: Extract keywords from the provided URL.
2. Collate Duplicates Together: Identify and collate keywords for variations of keywords that essentially mean the same thing. For example, "How to learn development" "How to learn programming" "learn development" and "how to become a software developer" should all be considered under a unifying keyword "How to learn development" and if there are 20 similar queries then the count for “How to learn development” should be 20.
3. Count Occurrences: Count how many times each keyword appears. This involves keeping a tally of each keyword's occurrence including separate keywords.
4. Sort Keywords: Sort the keywords by their count in descending order so that the most frequent keywords appear first.
Related categories: Python MySQL Data Analytics