creating a csv file from two csv files I have two csv files:

sub_compiler.to_csv('sub_compiler.csv')
sub_compiler.head()




and 

sub_opt = pd.read_csv('sub_opt.csv')
sub_opt.head()




and what I would like to do is to create a csv file where I have something of the form 

compiler, opt 

How could I do this? I need to do this to make a submission.

Thank's in advance.

[EDIT] Thank you for the answers. Now I have obtained :



don't understand why I have the columns called unnamed. 

My objective is to get a csv file that contains only the columns compiler and opt. How could I do this? Thank's again.

[EDIT 2] I have solved my problem but if I open the csv file manually, so just click on the file, I have the following:



s it contains only 11 lines, but it contains 3000 lines in jupyter. Is it there something wrong?

[EDIT 3] I tried to to the following:

import pandas as pd

test = pd.read_csv('1495927.csv')
test


and I have:



where 1495927.csv is the csv file I have created and that is in the image where I have 11 elements.
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.