Python

Module 1:


1: Introduction

  • • What is Python..?
  • • A Brief history of Python
  • • Why Should I learn Python..?
  • • Installing Python/li>
  • • How to execute Python program Write your first program

1: Introduction

  • • What is Python..?
  • • A Brief history of Python
  • • Why Should I learn Python..?
  • • Installing Python/li>
  • • How to execute Python program Write your first program

2: Variables & Data Types

  • • Variables
  • • Numbers
  • • String
  • • Lists ,Tuples & Dictionary

3: Conditional Statements & Loops

  • • if...statement
  • • if...else statement
  • • elif...statement
  • • The while...Loop
  • • The for....Loop

4: Control Statements

  • • Continue statement
  • • Break statement
  • • Pass statement

5: Functions

  • • Define function
  • • Calling a function
  • • Calling a function
  • • Built-in functions

6: Modules & Packages

  • • Modules
  • • How to import a module...?
  • • Packages
  • • How to create packages

7: Classes & Objects

  • • Introduction about classes & objects
  • • Creating a class & object Inheritance
  • • Methods Overriding
  • • Data hiding

8: Files & Exception Handling

  • • Writing data to a file
  • • Reading data from a file
  • • Read and Write data from csv file try...except
  • • finally os module
  • • try...except...else

Module 2:


Getting started with Python Libraries

  • • What is data analysis ?
  • • Why python for data analysis ? Essential python libraries installation and setup
  • • Ipython
  • • Jupyter notebook 2.7 vs 3.5

Module 4:


  • • NumPy Arrays
  • • Creating multidimensional array NumPy Data types
  • • Array attributes
  • • Indexing and Slicing
  • • Creating array views and copies Manipulating array shapes
  • • I/O with NumPy

Module 5:


  • • Working with Pandas
  • • Installing pandas
  • • Pandas dataframes
  • • Pandas Series
  • • Data aggregation with Pandas DataFrames Concatenating and appending
  • • DataFrames Joining DataFrames
  • • Handling missing data

Module 6:


  • • Data Loading,Storage and file format
  • • Writing CSV files with numpy and pandas HDF5 format
  • • Reading and Writing to Excel with pandas
  • • Parsing HTML with Beautiful Soup PyTables
  • • JSON data

Module 7:


  • • Python Regular Expressions
  • • What are regular expressions? The match Function
  • • The search Function Matching vs searching
  • • Search and Replace
  • • Extended Regular Expressions Wildcard

Module 8:


  • • CGI
  • • Introduction Architecture
  • • CGI environment variable GET and POST methods Cookies
  • • File upload

Module 9:


  • • Python Oracle Database Access
  • • Install the cx_Oracle and other Packages
  • • Create Database Connection
  • • CREATE, INSERT, READ, UPDATE and DELETE Operation DML and DDL
  • • Oepration with Databases
  • • Performing Transactions
  • • Handling Database Errors
  • • Disconnecting Database

Module 10:


  • • Python Multithreaded Programming
  • • What is multithreading? Starting a New Thread
  • • The Threading Module Synchronizing Threads Multithreaded Priority Queue

Introduction to Python

Installation of Python framework and packages: Anaconda & pip Writing/ Running python programs using Spyder Command Prompt Working with Jupyter, notebooks, Creating Python variables Numeric , string and logical operations Data containers : Lists , Dictionaries, Tuples & sets Practice assignment