3 e_Q@s(ddlZddlZddlmZddZdS)N) BeautifulSoupc Cs4tjd}g}xtdt|D]}t|j|dj|j|d<tjd}|j d|j|d|j|d<tjd}|j d|j|d|j|d<tj dd|j|d}|j |j|d |j|d ||j|d |j|d gqWtj |d d dd d gd }|j dtjd}g}xtdt|D]}t|j|dj|j|d<tjd}|j d|j|d|j|d<tjd}|j d|j|d|j|d<tj dd|j|d}|j |j|d|j|d|j|d ||j|d |j|d gq.Wtj |ddd dd d gd }|j ddS)Nz jobs_des.csvrdetailsz<.*?>z/<.*?>|&([a-z0-9]+|#[0-9]{1,6}|#x[0-9a-f]{1,6});z [^a-zA-Z0-9]+ idtitlecitystate_province)columnszclean_jobs.csvzresumes_des.csvresume_details resume_id person_idzclean_resumes.csv) pdread_csvrangelenrilocZget_textrecompilesubappend DataFrameto_csv)j_dfZ jobs_desciprawdfr_dfZ resume_descrI/var/www/html/talenthub/backend/ai/resume-to-job-match/clean_dataframe.pyclean_jobs_resume_csvs8      <       2r!)pandasrrbs4rr!rrrr s