Adman Analytics

AI is good at pulling the Hard Skills from job postings, and comparing that to what’s in your resume. After a long job search, you may wonder what Hard Skills you need to focus on. Here’s a python script that helped me out.

I started with a CSV that was copy and pasted from a number of job postings. It’s really messy, and I wanted to clean it up, and add the number of times each keyword appeared in the file. That way I can filter out all the one-offs.

import csv
from collections import Counter

input_filename = 'skills.csv'
output_filename = 'skills_counted.csv'

skills = []
with open(input_filename, 'r', newline='', encoding='utf-8') as infile:
    reader = csv.reader(infile)
    for row in reader:
        for skill in row:
            cleaned_skill = skill.strip()
            if cleaned_skill:
                skills.append(cleaned_skill)

# Count occurrences
counts = Counter(skills)

# Sort keywords alphabetically
sorted_keywords = sorted(counts.items())

# Write to output file
with open(output_filename, 'w', newline='', encoding='utf-8') as outfile:
    writer = csv.writer(outfile)
    writer.writerow(['Keyword', 'Count'])
    for keyword, count in sorted_keywords:
        writer.writerow([keyword, count])

print(f"Created {output_filename} with keyword counts in two columns, sorted alphabetically.")