If you're like many of Excel's 750 million users you want to do more with your data-like repeating similar analyses over hundreds of files or combining data in many files for analysis at one time This practical guide shows ambitious non-programmers how to automate & scale the processing & analysis of data in different formats-by using Python After author Clinton Brownley takes you through Python basics you'll be able to write simple scripts for processing data in spreadsheets as well as databases You'll also learn how to use several Python modules for parsing files grouping data & producing statistics No programming experience is necessary Create & run your own Python scripts by learning basic syntax Use Python's csv module to read & parse CSV files Read multiple Excel worksheets & workbooks with the xlrd module Perform database operations in My SQL or with the mysqlclient module Create Python applications to find specific records group data & parse text files Build statistical graphs & plots with matplotlib pandas ggplot & seaborn Produce summary statistics & estimate regression & classification models Schedule your scripts to run automatically in both Windows & Mac environments