I have 2 csv files as below :

File-1

procedure   code
anand database  321-87
shiva network   321-123
jana audit  321-56
kalai recruitment   321-10

in file-1, each word in a row is a key word.

File-2

s.no    procedure
1   kalai has a recruitment group
2   shiva is the network person in my office
3   he is the auditor in my office
4   anand is the database here
5   i bought a new phone this week
6   jana is working in the audit team

in the above scenario, i need to pick the row in file-2 which contains all the key words of each row in file-1. suppose for example, row-1 in file-1 contains 2 key words 'anand' & 'database'. i need to select the row in file-2 which contains both the keywords 'anand' & 'database'.

can anyone help me out in this?

If df is relatively small, you could use str.contains. First, build a pattern from df.

dfprocedure     code
0     anand database   321-87
1      shiva network  321-123
2         jana audit   321-56
3  kalai recruitment   321-10p = df.procedure.str.split().str.join('.*?').str.cat(sep='|')p
'anand.*?database|shiva.*?network|jana.*?audit|kalai.*?recruitment'

Now, pass it to str.contains on df2.procedure.

df2[df2.procedure.str.contains(p)]s.no                                 procedure
0     1             kalai has a recruitment group
1     2  shiva is the network person in my office
3     4                anand is the database here
5     6         jana is working in the audit team