Foundations for analytics with Python /
Saved in:
| Author / Creator: | Brownley, Clinton W. |
|---|---|
| Edition: | First edition. |
| Imprint: | Sebastopol, CA : O'Reilly Media, Inc., 2016. |
| Description: | 1 online resource ( 351 p.) |
| Language: | English |
| Subject: | |
| Format: | E-Resource Book |
| URL for this record: | http://pi.lib.uchicago.edu/1001/cat/bib/11609573 |
Table of Contents:
- Copyright; Table of Contents; Preface; Why Read This Book? Why Learn These Skills?; Who Is This Book For?; Why Windows?; Why Python?; Base Python and pandas; Anaconda Python; Installing Anaconda Python (Windows or Mac); Text Editors; Download Book Materials; Overview of Chapters; Conventions Used in This Book; Using Code Examples; Safari® Books Online; How to Contact Us; Acknowledgments; Chapter 1. Python Basics; How to Create a Python Script; How to Run a Python Script; Useful Tips for Interacting with the Command Line; Python's Basic Building Blocks; Numbers; Strings
- Regular Expressions and Pattern MatchingDates; Lists; Tuples; Dictionaries; Control Flow; Reading a Text File; Create a Text File; Script and Input File in Same Location; Modern File-Reading Syntax; Reading Multiple Text Files with glob; Create Another Text File; Writing to a Text File; Add Code to first_script.py; Writing to a Comma-Separated Values (CSV) File; print Statements; Chapter Exercises; Chapter 2. Comma-Separated Values (CSV) Files; Base Python Versus pandas; Read and Write a CSV File (Part 1); How Basic String Parsing Can Fail; Read and Write a CSV File (Part 2)
- Filter for Specific RowsValue in Row Meets a Condition; Value in Row Is in a Set of Interest; Value in Row Matches a Pattern/Regular Expression; Select Specific Columns; Column Index Values; Column Headings; Select Contiguous Rows; Add a Header Row; Reading Multiple CSV Files; Count Number of Files and Number of Rows and Columns in Each File; Concatenate Data from Multiple Files; Sum and Average a Set of Values per File; Chapter Exercises; Chapter 3. Excel Files; Introspecting an Excel Workbook; Processing a Single Worksheet; Read and Write an Excel File; Filter for Specific Rows
- Select Specific ColumnsReading All Worksheets in a Workbook; Filter for Specific Rows Across All Worksheets; Select Specific Columns Across All Worksheets; Reading a Set of Worksheets in an Excel Workbook; Filter for Specific Rows Across a Set of Worksheets; Processing Multiple Workbooks; Count Number of Workbooks and Rows and Columns in Each Workbook; Concatenate Data from Multiple Workbooks; Sum and Average Values per Workbook and Worksheet; Chapter Exercises; Chapter 4. Databases; Python's Built-in sqlite3 Module; Insert New Records into a Table; Update Records in a Table; MySQL Database
- Insert New Records into a TableQuery a Table and Write Output to a CSV File; Update Records in a Table; Chapter Exercises; Chapter 5. Applications; Find a Set of Items in a Large Collection of Files; Calculate a Statistic for Any Number of Categories from Data in a CSV File; Calculate Statistics for Any Number of Categories from Data in a Text File; Chapter Exercises; Chapter 6. Figures and Plots; matplotlib; Bar Plot; Histogram; Line Plot; Scatter Plot; Box Plot; pandas; ggplot; seaborn; Chapter 7. Descriptive Statistics and Modeling; Datasets; Wine Quality; Customer Churn; Wine Quality
