Synopses & Reviews
Many of Excel's 750 million users would like to do more with their data, such as repeating similar analyses over hundreds of files or combining the data in many files for analysis at one time. This practical guide shows ambitious non-programmers how to automate and scale data processing and analysis of different data formats with Python, using business-relevant examples with complete, easy-to-read code.
Beginning with the basics of Python, author Clinton Brownley shows you how to deal with Excel, CSV, and text files in Python, leading up to scheduling scripts to automatically gather and process information without human intervention. More practical than many other introductions to Python, this book gives you skills you can immediately apply in your job.
- Automate and scale data processing with only a knowledge of Excel
- Get an excellent, practical introduction to scripting languages in general
- Learn techniques through real-world business examples, including three in-depth projects
About the Author
Clinton Brownley, PhD, is the founder of CWB Decision Solutions, an analytics-based management consulting company headquartered in Silicon Valley. Since 2006, Dr. Brownley has used analytics and decision modeling techniques to address complex policy and strategy decisions for a variety of public and private organizations. In 2007, Dr. Brownley was an adjunct faculty member at American University, where he taught a graduate course on operations research techniques, decision analysis, and spreadsheet modeling. Dr. Brownley is a Councilmember for CPMS: The Practice Section of the Institute for Operations Research and the Management Sciences, an Executive Committee member for the Statistical Consulting Section of the American Statistical Association, and is also an active member of the Decision Analysis Society. Dr. Brownley received B.S. and M.S. degrees from Carnegie Mellon University and a Ph.D. degree from American University.