如何从文本中提取特定单词到另一列（通过查看外部DF）
我确实从中刮过了空缺，这些是我的数据框中的两个列：
Location Description
0 deventer Hygiène Sécurité ...
1 hengelo Supervisor Finan ...
2 zwolle Compensations & ...
28000行，
我想通过查看下面显示的数据框，还有另一列从描述列中提取技能的列。
soft_skill
0 communication
1 abstract reasoning
2 abstract thinking
930行
是如此理想的是，我的新DF看起来像这样：
Location Description Skills
0 deventer Hygiène Sécurité ... collaboration
1 hengelo Supervisor Finan ... communication
2 zwolle Compensations & ... critical thinking
28000行
是否对我如何做到这一点有想法吗？我也在研究ML/NER方法（使用Spacy），但我首先想尝试一下。
完整而干净的描述看起来像这样，大胆的单词应提取到新的列中：
HygièneSécurité环境环境Keolis Netherlands拥有大约2100名员工，我们与他们共同在IJSSELVECHT UTRECHT TWENTE和ALMERE和ALMERE以及火车路线上提供公共交通工具，Zutphenoldenzaal Zwolleleschede和Zwollekampen和Zwollekampen and Zwollekampen and Zwollekampen and Zwollekampen and 7500亿架250000000000 000 000年，内在价值清晰且具有进取心的Keolis Nederland是国际运营流动性公司Keolis Group的100个子公司，该公司在16个国家 /地区提供68500名员工任务的公共交通工具作为荷兰Keolis的QHSE经理，您将专注于创建安全和健康的工作场所的创建。员工的安全和健康以及维护服务质量及其在此角色中的环境友好性，您将为各种管理系统Keolis努力为环境管理系统质量管理系统安全管理系统和其他标准Keolis致力于做出贡献因此，与3个同事的团队一起，您将使组织内所有QHSE所有方面的意识质量和遵守提高到更高的水平上，该部门在部门中挑战进一步专业化，包括进一步发展QHSE政策，企业社会责任政策QHSE意识和预防运动组织的设计和QHSE审核的管理内部控制，尤其是我们如何在组织中确保这一点，并使所有利益相关者保持联系，并在国际出行提供商中与良好的同事保持着良好的挑战地位，与良好的同事有关2100名员工我们是一个大型组织，但我们仍然是非正式的，因此您可以轻松地在同事上进行聊天，但也可以从Deventer的总部进行SPAR，您将管理QHSE QHSE的动态位置，其中没有一天在一个人中是相同的一天正在发展的组织，您自己可以做出基本的贡献，我们拥有出色的附带福利，例如至少27天的假期，具体取决于年龄的年龄奖励和各种在线培训课程，我们有一个有吸引力的租赁计划，我们便利电话和笔记本电脑在国际运营的机动组织中有足够的个人发展和贡献的空间承诺相关的知识和经验我们看到该职位的HBO级别对QHSE的相关完成的教育在相似职位上可证明的经验在实质性的监督和QHSE员工的实质性监督和指导方面的经验证明是一种优势，这是一种优势并对相关的环境和职业健康与安全法律法规和法规进行了调整知识，了解适用的NEN VCA和ISO标准在公共交通组织中出色的咨询和沟通技巧工作经验是一种优势
I have scraped vacancies from Indeed, and these are two of the columns in my DataFrame:
Location Description
0 deventer Hygiène Sécurité ...
1 hengelo Supervisor Finan ...
2 zwolle Compensations & ...
28000 rows
I want to have another column that extracts the skills from the Description column, by looking at the dataframe that is shown below.
soft_skill
0 communication
1 abstract reasoning
2 abstract thinking
930 rows
So ideally my new DF will look like this:
Location Description Skills
0 deventer Hygiène Sécurité ... collaboration
1 hengelo Supervisor Finan ... communication
2 zwolle Compensations & ... critical thinking
28000 rows
Does anybody have an idea on how I could do this? I am also working on a ML/NER approach (using spacy), but I would first like to try this.
A complete and clean description looks like this, and the bold words should be extracted into a new column:
hygiène sécurité environnement keolis netherlands has approximately 2100 employees with whom we jointly provide public transport in ijsselvecht utrecht twente and almere and on the train routes zutphenoldenzaal zwolleenschede and zwollekampen each year we transport 45 million passengers with 700 buses and 25 trains working from two intrinsic values clear and enterprising keolis nederland is a 100 subsidiary of the internationally operating mobility company keolis group which provides public transport in 16 countries with 68500 employees missions as a qhse manager at keolis netherlands you will focus on the creation of a safe and healthy workplace the safety and health of the employees as well as the safeguarding of the quality of service and its environmental friendliness in this role you will contribute to the various management systems keolis strives for environmental management system quality management system safety management system and the other standards keolis commits to thus contributing to the achievement of continuous improvement together with a team of 3 colleagues you will bring the awareness quality and compliance of all qhse aspects within the organization to a higher level there are challenges in the department to further professionalize including further development of the qhse policy design of the csr policy qhse awareness and prevention campaigns organization and management of qhse audits internal control and especially how do we secure this in the organization and keep all stakeholders connected and prepared a nice challenging position within an international mobility provider with nice colleagues why with about 2100 employees we are a large organization but we remain informal so you can easily walk in on colleagues for a chat but also for example to spar from our headquarters in deventer you will manage qhse profil a dynamic position in which no day is the same within an organization that is developing and to which you yourself can make an essential contribution we have excellent fringe benefits such as at least 27 days of vacation depending on age a yearend bonus and a wide range of online training courses we have an attractive lease scheme and we facilitate a phone and laptop there is plenty of room for personal development and contribution within an internationally operating mobility organization and last but not least the informal working atmosphere at our cosy office in deventer competencies which fit within keolis are collaborating working together responsibility openness goodwill commitment relevant knowledge and experience we see for the position a relevant completed education at hbo level towards qhse demonstrable experience in similar positions demonstrable experience in the substantive supervision and coaching of qhse employees knowledge and working in the english language is an advantage extensive and uptodate knowledge of relevant environmental and occupational health and safety laws and regulations knowledge of the applicable nen vca and iso standards excellent advisory and communication skills work experience within public transport organizations is an advantage
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论