How to write CSV files into XLSX using Python Pandas?
<p>I have several .csv files and I want to write them into one .xlsx file as spreadsheets.</p>

<p>I've loaded these .csv files into Pandas.DataFrame using following code:</p>

<pre><code>df1 = pandas.read_csv('my_file1.csv')
df2 = pandas.read_csv('my_file2.csv')
......
df5 = pandas.read_csv('my_file5.csv')
</code></pre>

<p>But I couldn't find any functions in Pandas that can write these DataFrames into one .xlsx file as separated spreadsheets.</p>

<p>Can anyone help me with this? </p>