Notes of using Python for Data Analytics

Chapter 0: Foundations of Python Basic syntax Data types, indexing, and slicing Flow control and looping Functions Object-oriented programming List comprehensions Regular expression Data input and output Basic text files Excel Database Chapter 1: Essential libraries Numpy Pandas Basic data visualization Scatter Plots Histograms Cumulative Frequencies Error-bars Box plots Pie Charts Chapter 2: Statistics brief…

OpenSolver—A free optimizer for Excel

OpenSolver is free and open source software for Excel without any annoying limits on problem size. This kind of software makes me think of What’s Best. It is good for undergraduate’s hands-on project for OR related classes at the very beginning stage. It also provides API for Excel VBA, awesome! Even exists a Google Sheets version!…