Excel’s popularity is attributed to its user-friendly data formatting and presentation features. Although Python offers distinct advantages for Excel, its raw data output is often unsuitable for business purposes. The following notebook demonstrates how to create a calculated percentage column in pandas and format the results in an Excel workbook using openpyxl:

To format is divine

The combination of Excel’s exceptional text formatting features and Python’s remarkable capability for automation creates a powerful duo for data manipulation and analysis. By using openpyxl, the two tools seamlessly integrate. What questions do you have about formatting Excel workbooks from Python or about openpyxl more generally? Let me know in the comments.