Cant save a data frame into csv which was read from an Excel in Python Pandas
<p>I tried to read a file from excel using pandas  pd.io.excel.read_excel function. This read a file into a data frame df. Now this df when i tried to save into csv it saves only 826 rows out of ~3000 and also throws following error 'ascii' codec can't encode character at position * ord not in range(128). This also results in error output for merge operation. </p>

<p>The same merge gives correct result when file read from csv.</p>