Most applied-to job titles

MediumLinkedInmergevalue_countshead· 20 XP

The jobs team wants to know which job titles attract the most applications.

Join applications.csv to job_posts.csv and store the 5 job titles with the most applications, with columns job_title and applications, most first.

Expected answer

Store your answer in result.

  • Exactly 5 rows, in order

Hints, the later steps and the answer come with Pro.

import pandas as pd

applications = pd.read_csv("applications.csv")
posts = pd.read_csv("job_posts.csv")
result = ...