Data science

Update to Data Science Software Popularity

June 8, 2023 | Bob Muenchen

I’ve updated The Popularity of Data Science Software‘s market share estimates based on scholarly articles. I posted it below, so you don’t have to sift through the main article to read the new section. Scholarly Articles Scholarly articles provide a rich source of information about data science ...
[...Read more...]

How to format a column as percentage in Excel using openpyxl

May 22, 2023 | George Mount

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 ... [...Read more...]

How to automatically adjust Excel column widths in openpyxl

May 22, 2023 | George Mount

Excel’s popularity stems from its user-friendly data formatting and presentation capabilities. Take, for example, the nuisance of narrow columns. Resolving this issue in Excel is as simple as selecting the affected columns and double-clicking on any one of them: Python does present unique strengths to Excel, but visual formatting ...
[...Read more...]
1 38 39 40 41 42 123