EUVIMEDEUVIMED entdecken
Crossref

Spreadsheet Modeling and Wrangling with Python

Mark W. Isken

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.

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →