creating a csv file from two csv files
sub_compiler.merge(sub_opt, how='inner', on='instruction')


This is how to do table join on your table.

Another option if it is already aligned and you just want to concatenate you can do 

pd.concat([sub_compiler,sub_opt[['opt']]], axis=1)


This is naive column-wise concatenate.

Finally just proceed with to_csv.