Duration
1 day
Overview
Learn features, advanced functionalities, unit testing and more in this extensive Python training course.
The Python language has been emerging as a very powerful, flexible, and simple programming tool for building all manner of applications. Maybe you're one of the many developers looking get started with Python. If so, then this hands-on language course is just the thing for you.
What You'll Learn
- Install Python and writing basic scripts
- Language features needed in all applications
- Advanced functionality such as OO Python, the Pyramid web framework, MongoDB, and Data API
- Unit testing, debugging, and multi-threaded parallel code in Python
Who Needs to Attend
Developers who need to be effective with Python immediately after the course
Course Content
- 1. Python for Data Analysis - NumPy
Introduction
- Ndarray Object
- Data Types
- Array Attributes
- Array Creation Routines
- Array from existing data
- Numerical ranges
- Array Indexing and Slicing
- Advanced Indexing
- Iterating over Array
- Array Manipulation
- Arithmetic Operators
- Binary Operators
- String Functions
- Mathematical Functions
- Statistical Functions
- 2. Python for Data Analysis - Pandas
- Introduction to Pandas
- Series
- DataFrames
- Missing Data
- Group by
- Merging Joining and Concatenating
- Operations
- Data Input and Output
- Pivot Table
- Pivot Table Filtering
- 3. Python for Data Analysis – SciPy
Introduction
- Basic functions
- Special functions
- Integration
- Optimization
- Interpolation
- Fourier transforms
- Linear Algebra
- Compressed Sparse Graph Routines
- Statistics
- File IO
- 4. Python for Data Visualization
- Matplotlib
- Seaborn
- Distribution Plots
- Categorical Plots
- Matrix Plots
- Grids
- Regression Plots
- Pandas Built-in Data Visualization
- Plotly and Cufflinks
- Geographical Plotting
- Choropleth Maps
- 5. Basics of Relational Databases
Introduction
- Relational Model
- Creating Database
- Connecting to Database
- Connection Strings
- Creating tables and Viewing Table details
- Introduction to SQL
- Selecting data using Raw SQL
- Handling ResultSet
- Filtering and targeting data
- Ordering data
- Counting
- Inserting Data
- Updating Data
- Deleting Data
- SQL Relationships
- Joins
- Group By
Programme scope, delivery arrangements and suitability are confirmed during enquiry.