Spreadsheet Modeling and Wrangling with Python
INFORMS Transactions on Education · 2025-01 · 25 (2) · 152-168
DOI: 10.1287/ited.2023.0047 ↗Kurz gefasst
Fachartikel in der Zeitschrift INFORMS Transactions on Education, 2025-01. Verfasst von Mark W. Isken. Die Arbeit wurde bisher 4-mal zitiert (Crossref) und nennt 12 Literaturangaben.
Abstract (Originalsprache)
A staple of many spreadsheet-based management science courses is the use of Excel for activities such as model building, sensitivity analysis, goal seeking, and Monte-Carlo simulation. What might those things look like if carried out using Python? We describe a teaching module in which Python is used to do typical Excel-based modeling and data-wrangling tasks. In addition, students are exposed to basic software engineering principles, including project folder structures, version control, object-oriented programming, and other more advanced Python skills, creating deployable packages and documentation. The module is supported with Jupyter notebooks, Python scripts, course web pages that include numerous screencasts, and a few GitHub repositories. All of the supporting materials are permissively licensed and freely accessible. Supplemental Material: The supplemental files are available at https://doi.org/10.1287/ited.2023.0047 .
Zitieren
APA
Isken, M. W. (2025). Spreadsheet Modeling and Wrangling with Python. INFORMS Transactions on Education, 25(2), 152-168. https://doi.org/10.1287/ited.2023.0047
Vancouver
Isken MW. Spreadsheet Modeling and Wrangling with Python. INFORMS Transactions on Education. 2025;25(2):152-168. doi:10.1287/ited.2023.0047
BibTeX
@article{Isken2025,
author = {Isken, Mark W.},
title = {Spreadsheet Modeling and Wrangling with Python},
journal = {INFORMS Transactions on Education},
year = {2025},
volume = {25},
number = {2},
pages = {152--168},
doi = {10.1287/ited.2023.0047}
}
EUVIMED