Data Wrangling with Python: Tips and Tools to Make Your Life Easier

Book Description

How do you take your data analysis skills beyond Excel to the next level? By learning just enough Python to get stuff done. This hands-on guide shows non-programmers like you how to process information that’s initially too messy or difficult to access. You don’t need to know a thing about the Python programming language to get started.

Through various step-by-step exercises, you’ll learn how to acquire, clean, analyze, and present data efficiently. You’ll also discover how to automate your data process, schedule file- editing and clean-up tasks, process larger datasets, and create compelling stories with data you obtain.

• Quickly learn basic Python syntax, data types, and language concepts
• Work with both machine-readable and human-consumable data
• Scrape websites and APIs to find a bounty of useful information
• Clean and format data to eliminate duplicates and errors in your datasets
• Learn when to standardize data and when to test and script data cleanup
• Explore and analyze your datasets with new Python libraries and techniques
• Use Python solutions to automate your entire data-wrangling process

Table of Contents

Chapter 1. Introduction to Python
Chapter 2. Python Basics
Chapter 3. Data Meant to Be Read by Machines
Chapter 4. Working with Excel Files
Chapter 5. PDFs and Problem Solving in Python
Chapter 6. Acquiring and Storing Data
Chapter 7. Data Cleanup: Investigation, Matching, and Formatting
Chapter 8. Data Cleanup: Standardizing and Scripting
Chapter 9. Data Exploration and Analysis
Chapter 10. Presenting Your Data
Chapter 11. Web Scraping: Acquiring and Storing Data from the Web
Chapter 12. Advanced Web Scraping: Screen Scrapers and Spiders
Chapter 13. APIs
Chapter 14. Automation and Scaling
Chapter 15. Conclusion
Appendix A. Comparison of Languages Mentioned
Appendix B. Python Resources for Beginners
Appendix C. Learning the Command Line
Appendix D. Advanced Python Setup
Appendix E. Python Gotchas
Appendix F. IPython Hints
Appendix G. Using Amazon Web Services

中文：

书名：与Python的数据角力：让您的生活变得更轻松的提示和工具

如何让您的数据分析技能超越Excel更上一层楼？通过学习足够多的Python来完成任务。本实践指南向像您这样的非程序员展示如何处理最初过于杂乱或难以访问的信息。要入门，您不需要了解任何有关Python编程语言的知识。

通过各种循序渐进的练习，您将学习如何高效地获取、清理、分析和呈现数据。您还将了解如何自动化数据处理、安排文件编辑和清理任务、处理更大的数据集以及使用您获得的数据创建引人入胜的故事。

• 快速学习基本的Python语法、数据类型和语言概念
• 同时使用机器可读和人类可使用的数据
• 抓取网站和API以找到大量有用的信息
• 清理和格式化数据以消除数据集中的重复项和错误
• 了解何时标准化数据以及何时测试数据清理并编写脚本
• 使用新的Python库和技术浏览和分析您的数据集
• 使用Python解决方案自动化您的整个数据争论过程

目录表

Chapter 1. Introduction to Python
第2章.Python基础知识
第三章机器读取的数据
第4章.使用Excel文件
第5章.PDF和在Python中解决问题
第6章：获取和存储数据
第7章数据清理：调查、匹配和格式化
第8章数据清理：标准化和脚本
第9章：数据探索和分析
第十章.展示您的数据
第11章Web抓取：从Web获取和存储数据
Chapter 12. Advanced Web Scraping: Screen Scrapers and Spiders
第十三章API
Chapter 14. Automation and Scaling
第十五章结论
附录A.所述语文的比较
Appendix B. Python Resources for Beginners
附录C.学习命令行
Appendix D. Advanced Python Setup
附录E.巨蟒Gotchas
附录F.IPython提示
附录G.使用Amazon Web服务