SoftwareVersion,2.1.0.46
SystemType,Gen3
CodeClass,Name,Accession,Count
Endogenous,CCNO,NM_021147.4,18
Endogenous,MYC,NM_002467.3,1114
Endogenous,CD79A,NM_001783.3,178
Endogenous,FSTL3,NM_005860.2,529

ScannerID,1609P0139
StagePosition,1
BindingDensity,0.19
CodeClass,Name,Accession,Count
Endogenous,CCNO,NM_021147.4,196
Endogenous,MYC,NM_002467.3,962
Endogenous,CD79A,NM_001783.3,390
Endogenous,FSTL3,NM_005860.2,67

CodeClass,Name,Accession,small_example1,small_example2
CCNO,NM_021147.4,Endogenous,18,196
MYC,NM_002467.3,Endogenous,1114,962
CD79A,NM_001783.3,Endogenous,178,390
FSTL3,NM_005860.2,Endogenous,529,67

import pandas as pd
filenames = ['small_example1.csv', 'small_example2.csv']
path = '/home/Joy'
def convert(filenames):
    for file in filenames:
        df1 = pd.read_csv(file, sep=',')
        df = df1.merge(df2, on=['CodeClass', 'Name', 'Accession'])
        df.to_csv('result.csv')