Python数据分析基础(影印版)(英文版)

如果你像75亿Excel用户中的许多人一样，想要 对数据做更多的事情，比如对数百个文件重复类似的 分析，或者将许多文件中的数据组合在一起进行分析 ，这本实用指南向雄心勃勃的非程序员说明了如何通 过使用Python来自动化和扩展对不同格式数据的处理 和分析。 在《Python数据分析基础(影印版)(英文版)》作 者克林顿·W.布朗利Clinton Brownley讲解Python 基础知识后，你将能够编写简单的脚本来处理电子表 格以及数据库中的数据。你还将学习如何使用多个 Python模块来解析文件、分组数据和生成统计数据。 这一切都无需编程基础。

Clinton Brownley博士是Facebook的数据科学家，他负责各种数据管道、统计建模和数据可视化项目，这些项目为大规模基础设施提供数据驱动决策。他还是Section on Practice of the Institute for Operations Research and theManagement Sciences的理事会成员。

Preface 1. Python Basics How to Create a Python Script How to Run a Python Script Useful Tips for Interacting with the Command Line Pythons Basic Building Blocks Numbers Strings Regular Expressions and Pattern Matching Dates 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 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 Rows Value 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 Fries 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 3. Excel Files Introspecting an Excel Workbook Processing a Single Worksheet Read and Write an Excel File Filter for Specific Rows Select Specific Columns Reading 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 4. Databases Pythons Built-in sqlite3 Module Insert New Records into a Table Update Records in a Table MySQL Database Insert New Records into a Table Query a Table and Write Output to a CSV File Update Records in a Table Chapter Exercises 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 6. Figures and Plots matplotlib Bar Plot Histogram Line Plot Scatter Plot Box Plot pandas ggplot seaborn 7. Descriptive Statistics and Modeling Datasets Wine Quality Customer Churn Wine Quality Descriptive Statistics Grouping, Histograms, and t-tests Pairwise Relationships and Correlation Linear Regression with Least-Squares Estimation Interpreting Coefficients Standardizing Independent Variables Making Predictions Customer Churn Logistic Regression Interpreting Coefficients Making Predictions 8. Scheduling Scripts to Run Automatically Task Scheduler (Windows) The cron Utility (macOS and Unix) Crontab File: One-Time Set-up Adding Cron Jobs to the Crontab File 9. Where to Go from Here Additional Standard Library Modules and Built-in Functions Python Standard Library (PSL): A Few More Standard Modules Built-in Functions Python Package Index (PyPI): Additional Add-in Modules NumPy SciPy Scikit-Learn A Few Additional Add-in Packages Additional Data Structures Stacks Queues Graphs Trees Where to Go from Here A. Download Instruaions B. Answers to Exercises Bibliography Index