how to convert excel file to vector in python using pandas for each job, the columns of (interest, personalities, values, and skills) contains the weight of attributes that are written between (). for example sports(1) the weight is 1 and math(2) the weight is 2.
so this vector contains 1, 2, 3 for all columns of (interest, personalities, values, and skills).
so the vector is shown that:
It is one vector for each job with its attribute.
Personalitios Coordinating or leading athers(3), Raepons bilty for people heath and safetyl2), Dealing with physically aggresive peoplez). Time pressure), Deaing with angry or rude peope(2), Frequent decizion makingl1), Dealing with cusiomers(). Stig most of the time(2 orking Observano3). Amalyticalth. Intuitive Research(2). Technology(y. Coondinate Activites2), Teaching(1). Counse?ngn? Helping Cthers 3), Understanding Culture(3). Promating ldess(1), Managing Peope2 Proof Reading), Inormation Sear2), Nonverbal communication2), Presentation1), Wricing(2, Publishinglt). Content management). Interviewing1), Delegating tasks(2). Negotiation 2) Ralatonahip managamant1), Time Management), Ragulating Rul), Public lation) Sensitive 2, Friendy 3), Empathetia 2), mmigration Support |Cooperativea Responsible(1). Onderlyt3). Detailed1) Observanb 3. Analyticalth. Intuitive(2). Creative(2). Friendhyf3), Empatheticl2). Frequant decision makingt) Dealing with Unpredictable work schedules(1). Sitting most Consulting(2), Learming New Things1). Critical thinkingl1). Data analysi), Problem-solvingl). Natura), Tooks2) Math 2), Sclanco 2),Practial), Cunious2), Probiam Solving(2), f th? time 2). Repettivemoc ons 2 working indoors al ReGearch 3). Business analys s 3). Busness development 2. Businees inteligence 1. Business the time3), Authority to direst other2), Creativity), manement, Busines storyteling(2 Informaton Searcht) Presentation(1) Feeling of achievementty, Good working conditions(2) Tachnology),Atstiolty Creative Business Planner Administrative?Delegating tasks(1). Negotiation(1). Relationship management(1). Time Managemen), Content strategy, Publio relation Independence), Job prestige2), Keep busy 2, Cuture1), Promoting Idea 2), ManagingWork Negotisting2), Perzuasive2 People(a). Poitics/t). Working wth Data( Respectful3). Osderly(3), Detaled1) Opportunities for advancement(z), Responsibiity o make Personalitios Coordinating or leading athers(3), Raepons bilty for people heath and safetyl2), Dealing with physically aggresive peoplez). Time pressure), Deaing with angry or rude peope(2), Frequent decizion makingl1), Dealing with cusiomers(). Stig most of the time(2 orking Observano3). Amalyticalth. Intuitive Research(2). Technology(y. Coondinate Activites2), Teaching(1). Counse?ngn? Helping Cthers 3), Understanding Culture(3). Promating ldess(1), Managing Peope2 Proof Reading), Inormation Sear2), Nonverbal communication2), Presentation1), Wricing(2, Publishinglt). Content management). Interviewing1), Delegating tasks(2). Negotiation 2) Ralatonahip managamant1), Time Management), Ragulating Rul), Public lation) Sensitive 2, Friendy 3), Empathetia 2), mmigration Support |Cooperativea Responsible(1). Onderlyt3). Detailed1) Observanb 3. Analyticalth. Intuitive(2). Creative(2). Friendhyf3), Empatheticl2). Frequant decision makingt) Dealing with Unpredictable work schedules(1). Sitting most Consulting(2), Learming New Things1). Critical thinkingl1). Data analysi), Problem-solvingl). Natura), Tooks2) Math 2), Sclanco 2),Practial), Cunious2), Probiam Solving(2), f th? time 2). Repettivemoc ons 2 working indoors al ReGearch 3). Business analys s 3). Busness development 2. Businees inteligence 1. Business the time3), Authority to direst other2), Creativity), manement, Busines storyteling(2 Informaton Searcht) Presentation(1) Feeling of achievementty, Good working conditions(2) Tachnology),Atstiolty Creative Business Planner Administrative?Delegating tasks(1). Negotiation(1). Relationship management(1). Time Managemen), Content strategy, Publio relation Independence), Job prestige2), Keep busy 2, Cuture1), Promoting Idea 2), ManagingWork Negotisting2), Perzuasive2 People(a). Poitics/t). Working wth Data( Respectful3). Osderly(3), Detaled1) Opportunities for advancement(z), Responsibiity o make