Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
279 B
2
Indexable
Never
sql = ['SQL', 'query']
df['SQL_skills'] = 0
skills = sql

for i in range(len(df['job_description'])):
    for skill in skills:
        if skill in df['job_description'].str.split()[i]:
            df['SQL_skills'][i] = 1
        else:
            df['SQL_skills'][i] = 0