Data Manipulation for Science and Industry

Contents:

• Copyright Notice & Bug Fixing
• Introduction to Python 3
  • Integer Division
  • The print statement
  • The raw_input function
  • The range() function
  • Dictionary Changes
  • Tkinter changes
  • urllib
  • Functional Programming
• Comma Separated Values (CSV) Data Files
  • Basic File Output
  • CSV File Output
  • Basic File Input
  • CSV File Input
  • Reading CSV files using the CSV module
  • Real CSV Files
  • Writing CSV files using the CSV module
• Graphical User Interfaces
  • Introduction
  • Adding Buttons
  • Layout of Widgets
    • The Pack Layout manager
    • Using Frames to Organize Widgets
    • The Grid Layout Manager
  • Dialog windows
    • Info and Question Dialogs
    • File Dialogs
  • Using Objects for GUI programs
  • Single Line Text Entry
  • Linking StringVars to Entry widgets
  • Using IntVars with Radio Buttons
  • Adding images to your GUI
  • Option Menus (Drop Down Menu)
  • Binding methods/functions to user interface events
  • Switching Between Multiple Windows
  • Scrolling any window
  • Tic-Tac-Toe Game Example
  • The Canvas Widget
  • Exercises
• Reading Data from the Web: Web Scraping & Regular Expressions
  • Ethical Web Scraping
  • Basic webpage download
    • Using Regular Expressions (RegEx) to Locate Patterns Easily
    • Regex Example: Extracting addresses
  • Requesting Dynamic webpages: A Simple GET Request
  • Filling out POST Forms
  • Parsing HTML Tables
• Installing Modules: Adding extra features
  • Automated Installation: easy_install
    • Using easy_install on Windows
    • Using easy_install on a Macintosh
    • Testing your Install
  • Manual Installation
• Database Connectivity: SQL Databases
  • SQL Fundamentals
  • Using a Local SQL database: sqlite3
    • Creating a Table
    • Adding Data
    • Reading Data
  • Connecting to a MySQL database with pymysql
• XML: Structured Data Storage
  • XML Fundamentals
  • Using XML in Python
    • Writing a Tree
    • Reading an XML File
  • Exercises

Search Tool

• Search Page