Spreadsheet Modeling and Wrangling with Python

References

• Albright SC, Winston WL (2016) Business Analytics: Data Analysis & Decision Making, 6th ed. (Cengage Learning, Boston).Google Scholar
• Alderson DL (2022) Interactive computing for accelerated learning in computation and data science. INFORMS Trans. Ed. 22(2):130–145.Google Scholar
• Babier A, Fernandes C, Zhu IY (2023) Advising student-driven analytics projects: A summary of experiences and lessons learned. INFORMS Trans. Ed. 23(2):121–135.Google Scholar
• Baker K (2000) Gaining insight in linear programming from patterns in optimal solutions. INFORMS Trans. Ed. 1(1):4–17.Google Scholar
• Barba LA, Barker LJ, Blank DS, Brown J, Downey AB, George T, Heagy LJ, et al. (2019) Teaching and learning with Jupyter. Accessed July 28, 2023, https://jupyter4edu.github.io/jupyter-edu-book.Google Scholar
• Bell PC (2000) Teaching business statistics with Microsoft Excel. INFORMS Trans. Ed. 1(1):18–26.Google Scholar
• Beuzen T, Timbers T (2022) Welcome to Python packages!—Python packages. Accessed July 28, 2023, https://py-pkgs.org/.Google Scholar
• Camm JD, Cochran JJ, Fry MJ, Ohlmann JW (2020) Business Analytics (Cengage Learning, Boston).Google Scholar
• Canny S (2013) Python-pptx. Accessed July 28, 2023, https://python-pptx.readthedocs.io/en/latest/.Google Scholar
• Carraway RL, Clyman DR (2000) Integrating spreadsheets into a case-based MBA quantitative methods course: Real managers make real decisions. INFORMS Trans. Ed. 1(1):38–46.Google Scholar
• Cimpanu C (2017) Microsoft considers adding Python as an official scripting language to Excel. Accessed July 28, 2023, https://www.bleepingcomputer.com/news/microsoft/microsoft-considers-adding-python-as-an-official-scripting-language-to-excel/.Google Scholar
• Evans JR (2000) Spreadsheets as a tool for teaching simulation. INFORMS Trans. Ed. 1(1):27–37.Google Scholar
• Grus J (2018) I don’t like notebooks. JupyterCon 2018.Google Scholar
• Harris CR, Millman KJ, van der Walt SJ, Gommers R, Virtanen P, Cournapeau D, Wieser E, et al. (2020) Array programming with NumPy. Nature 585(7825):357–362.Google Scholar
• Isken MW (2003) Data cleansing and analysis as a prelude to model based decision support. INFORMS Trans. Ed. 3(3):23–75.Google Scholar
• Isken MW (2014) Translating a laboratory based spreadsheet modeling course to an online format: Experience from a natural experiment. INFORMS Trans. Ed. 14(3):120–128.Google Scholar
• Johnson JW (2020) Benefits and pitfalls of Jupyter notebooks in the classroom. Proc. 21st Annual Conf. Inform. Tech. Ed., Association for Computing Machinery, New York, 32–37.Google Scholar
• Jupyter Team (2015) Project Jupyter documentation. Accessed July 28, 2023, https://docs.jupyter.org/en/latest/.Google Scholar
• Lakhani S, Vora M, Mahajan A (2023) Puzzle—An OR approach for wordle. INFORMS Trans. Ed. 24(1):103–104.Google Scholar
• McKinney W (2022) Python for Data Analysis (O’Reilly, Sebastopol, CA).Google Scholar
• Moffitt C (2022) Practical business Python. Accessed July 28, 2023, https://pbpython.com/.Google Scholar
• Nelson C (2024) Software Engineering for Data Scientists (O’Reilly, Sebastopol, CA).Google Scholar
• Pedregosa F, Varoquaux G, Gramfort A, Michel V, Thirion B, Grisel O, Blondel M, et al. (2011) Scikit-learn: Machine learning in Python. J. Machine Learn. Res. 12:2825–2830.Google Scholar
• Perez F, Granger BE (2015) Project Jupyter: Computational narratives as the engine of collaborative data science. Jupyter Blog (July 7), https://blog.jupyter.org/project-jupyter-computational-narratives-as-the-engine-of-collaborative-data-science-2b5fb94c3c58.Google Scholar
• Perkel JM (2018) Why Jupyter is data scientists’ computational notebook of choice. Nature 563(7732):145–147.Crossref, Google Scholar
• Powell SG (2001) Teaching modeling in management science. INFORMS Trans. Ed. 1(2):62–67.Google Scholar
• Powell SG, Baker KR (2019) Business Analytics: The Art of Modeling with Spreadsheets, 5th ed. (Wiley, Hoboken, NJ).Google Scholar
• Ragsdale C (2017) Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics, 8th ed. (Cengage Learning, Boston).Google Scholar
• Ragsdale CT (2001) Teaching management science with spreadsheets: From decision models to decision support. INFORMS Trans. Ed. 1(2):68–74.Google Scholar
• Rodrigues B (2023) Building reproducible analytical pipelines with R. Accessed July 28, 2023, https://raps-with-r.dev/.Google Scholar
• Roy A; Cookiecutter Community (2012) Cookiecutter: Better project templates. Accessed July 28, 2023.Google Scholar
• Rule A, Birmingham A, Zuniga C, Altintas I, Huang SC, Knight R, Moshiri N, et al. (2018) Ten simple rules for reproducible research in Jupyter notebooks. Preprint, submitted October 13, https://arxiv.org/abs/1810.08055.Google Scholar
• Savage S (2001) Blitzograms—interactive histograms. INFORMS Trans. Ed. 1(2):77–87.Google Scholar
• Savage SL (2012) The Flaw of Averages: Why We Underestimate Risk in the Face of Uncertainty, 1st ed. (Wiley, Hoboken, NJ).Google Scholar
• Treadway A (2023) Software Engineering for Data Scientists (Manning, Shelter Island, NY).Google Scholar
• Ufford M, Pacer M, Seal M, Kelley K (2019) Beyond interactive: Notebook innovation at Netflix. Accessed July 28, 2023, https://netflixtechblog.com/notebook-innovation-591ee3221233.Google Scholar
• Virtanen P, Gommers R, Oliphant TE, Haberland M, Reddy T, Cournapeau D, Burovski E, et al. (2020) SciPy 1.0: Fundamental algorithms for scientific computing in Python. Nature Methods 17(3):261–272.Google Scholar
• Walls P (2023) Mathematical Python. Accessed July 28, 2023, https://github.com/patrickwalls/mathematicalpython.Google Scholar
• Wastl E (2023) Advent of code. Accessed December 6, 2023, https://adventofcode.com/2023/about.Google Scholar
• Wickham H (2014) Tidy data. J. Statist. Software 59(10):1–23.Google Scholar
• Winston WL, Albright SC (2018) Practical Management Science, 6th ed. (Cengage Learning, Boston).Google Scholar