from pyexcel cookbook import merge_two_files merge_two_files("example csv""example xls""output xls"the output xls would have the following datacolumn column column column column select candidate columns of two files and form new one suppose you have these two filesexample ods column column column column column column column column column column example xls data ["column ""column ""column ""column ""column "][ ][ ][ pyexcel sheet(datas save_as("example csv"data ["column ""column ""column ""column ""column "][ pyexcel sheet(datas save_as("example xls"and you want to filter out column and from example odsfilter out column and and merge themcolumn column column column column column the following code will do the job support the project