How can I combine multiple CSV files into one Excel worksheet using Python?

I am trying to combine multiple CSV files into an Excel worksheet so I can analyse my data.