Skip to content

Instantly share code, notes, and snippets.

@miotke
Last active September 20, 2023 03:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save miotke/9b4b56d6f8bff7471a6b1a1638989759 to your computer and use it in GitHub Desktop.
Save miotke/9b4b56d6f8bff7471a6b1a1638989759 to your computer and use it in GitHub Desktop.
"""
Reads my Job_Applications csv file and finds all of the
unique job titles.
"""
import csv
from collections import Counter
titles = []
file = "Job_Applications.csv"
with open(file, "r") as f:
reader = csv.DictReader(f)
line_count = 0
for row in reader:
if line_count == 0:
line_count += 1
titles.append(row["Title"])
titles_set = set(titles)
for title in Counter(titles_set):
print(title)
print(f"\nTotal titles {len(titles)}")
print(f"Total unique titles {len(titles_set)}")
"""
OUTPUT:
IT Functional Analyst
IT Security Administrator
IT Solutions Engineer
Enterprise Systems Engineer
System Administrator
Systems Administrator
Staff IT Systems Engineer
Mac Solution Architect
Systems Engineer, Productivity & Collaboration
SaaS Systems Administrator
Expert IAM Engineer, Okta
Senior IT Systems Engineer
Principal IT Engineer - Digital Workplace
Sr. IAM Engineer
System Administrator II
Senior Identity Engineer, Client Engineering
IT Operations Engineer
Cloud Applications Engineer, Okta
Senior IT Operations Engineer (Remote)
Site Reliability Engineer - Identity Platform
IT Systems Engineer
Senior Systems Administrator
Systems Engineer III, Enterprise
Sr. IT Systems Engineer
Senior macOS Client Platform Engineer
Client Platform Specialist
Total titles 29
Total unique titles 26
"""
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment