|
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 and scale the processing and 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, and producing statistics. No programming experience is necessary.
-
Create and run your own Python scripts by learning basic syntax
-
Use Python’s csv module to read and parse CSV files
-
Read multiple Excel worksheets and workbooks with the xlrd module
-
Perform database operations in MySQL or with the mysqlclient module
-
Create Python applications to find specific records, group data, and parse text files
-
Build statistical graphs and plots with matplotlib, pandas, ggplot, and seaborn
-
Produce summary statistics, and estimate regression and classification models
-
Schedule your scripts to run automatically in both Windows and Mac environments
|
|
|
 Microsoft Windows 7 On DemandNeed answers quickly? Microsoft Windows 7 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.
Inside the Book
... | | Head First HTML and CSS
Tired of reading HTML books that only make sense after you're an expert? Then it's about time you picked up Head First HTML and really learned HTML. You want to learn HTML so you can finally create those web pages you've always wanted, so you can communicate more effectively with friends, family, fans, and fanatic... | | Spoken Language Processing
Speech processing addresses various scientific and technological areas. It includes speech analysis and variable rate coding, in order to store or transmit speech. It also covers speech synthesis, especially from text, speech recognition, including speaker and language identification, and spoken language understanding.
This book... |
Introducing Character Animation with Blender
It’s been five years since the first edition of Introducing Character Animation with Blender came out, and a lot has changed in the world of Blender. Interest in Blender has exploded. When the first edition of this book came out, it was the only English-language book on Blender in print. Now, as this second edition of the book arrives,... | | Microscale Diagnostic Techniques
The fields of micro- and nanotechnology have emerged over the past decade as a
major focus of modern scientific and engineering research and technology.
Driven by advances in microfabrication, the investigation, manipulation and engineering
of systems characterized by micrometer and, more recently, nanometer
scales has become... | | Memory Systems: Cache, DRAM, DiskThe first book to comprehensively cover the intricacies of optimizing the behavior of modern memory systems using a holistic design approach.
Is your memory hierarchy stopping your microprocessor from performing at the high level it should be? Memory Systems: Cache, DRAM, Disk shows you how to resolve this problem. ... |
|
