Data Science Training Program

NA

• Introduction To Python
• Installation and Working with Python
• Understanding Python variables
• Python basic Operators
• Understanding the Python blocks.
• Version Control with Git & GitHub

• Python Keyword and Identiers
• Python Comments, Multiline Comments.
• Python Indentation
• Understating the concepts of Operators

• Introduction To Variables
• Variables, expression condition and function
• Global and Local Variables in Python
• Packing and Unpacking Arguments
• Type Casting in Python
• Byte objects vs. string in Python
• Variable Scope

• Python Data Type
• Declaring and using Numeric data types
• Using string data type and string operations
• Understanding Non-numeric data types
• Understanding the concept of Casting and Boolean.
• Strings
• List
• Tuples
• Dictionary
• Sets

• Control Structure & Flow
• Statements if, else, elif
• How to use nested IF and Else in Python
• Loops
• Loops and Control Statements.
• Jumping Statements Break, Continue, pass
• Looping techniques in Python
• How to use Range function in Loop
• Programs for printing Patterns in Python
• How to use if and else with Loop
• Use of Switch Function in Loop
• Elegant way of Python Iteration
• Generator in Python
• How to use nested Loop in Python
• Use If and Else in for and While Loop
• Examples of Looping with Break and Continue Statement
• How to use IN or NOT IN keyword in Python Loop.

• Python Function, Modules and Packages
• Python Syntax
• Function Call
• Return Statement
• Arguments in a function Required, Default, Positional, Variable-length
• Write an Empty Function in Python pass statement.
• Lamda/ Anonymous Function
• *args and **kwargs
• Help function in Python
• Scope and Life Time of Variable in Python Function
• Nested Loop in Python Function
• Recursive Function and Its Advantage and Disadvantage
• Organizing python codes using functions
• Organizing python projects into modules
• Importing own module as well as external modules
• Understanding Packages
• Random functions in python
• Programming using functions, modules & external packages
• Map, Filter and Reduce function with Lambda Function
• More example of Python Function

• List
• What is List.
• List Creation
• List Length
• List Append
• List Insert
• List Remove
• List Append & Extend using + and Keyword
• List Delete
• List related Keyword in Python
• List Revers
• List Sorting
• List having Multiple Reference
• String Split to create a List
• List Indexing
• List Slicing
• List count and Looping
• List Comprehension and Nested Comprehension

• Tuple
• What is Tuple
• Tuple Creation
• Accessing Elements in Tuple
• Changing a Tuple
• Tuple Deletion
• Tuple Count
• Tuple Index
• Tuple Membership
• TupleBuilt in Function (Length, Sort)

• Dictionary
• Dict Creation
• Dict Access (Accessing Dict Values)
• Dict Get Method
• Dict Add or Modify Elements
• Dict Copy
• Dict From Keys.
• Dict Items
• Dict Keys (Updating, Removing and Iterating)
• Dict Values
• Dict Comprehension
• Default Dictionaries
• Ordered Dictionaries
• Looping Dictionaries
• Dict useful methods (Pop, Pop Item, Str , Update etc.)

• Sets
• What is Set
• Set Creation
• Add element to a Set
• Remove elements from a Set
• PythonSet Operations
• Frozen Sets

• Strings
• What is Set
• Set Creation
• Add element to a Set
• Remove elements from a Set
• PythonSet Operations

• Python Exception Handling
• Python Errors and Built-in-Exceptions
• Exception handing Try, Except and Finally
• Catching Exceptions in Python
• Catching Specic Exception in Python
• Raising Exception
• Try and Finally

• Python File Handling
• Opening a File
• Python File Modes
• Closing File
• Writing to a File
• Reading from a File
• Renaming and Deleting Files in Python
• Python Directory and File Management
• List Directories and Files
• Making New Directory
• Changing Directory

• Python Database Interaction
• Basic SQL, DDL and DML commands
• SQL Database connection using
• Creating and searching tables
• Reading and Storing cong information on database
• Programming using database connections

• Reading an excel
• Working With Excel
• Reading an excel le using Python
• Writing to an excel sheet using Python
• Python| Reading an excel le
• Python | Writing an excel le
• Adjusting Rows and Column using Python
• ArithmeticOperation in Excel le.
• Play with Workbook, Sheets and Cells in Excel using Python
• Creating and Removing Sheets
• Formatting the Excel File Data
• More example of Python Function

• Complete Understanding of OS Module of Python
• Check Dirs. (exist or not)
• How to split path and extension
• How to get user prole detail
• Get the path of Desktop, Documents, Downloads etc.
• Handle the File System Organization using OS
• How to get any les and folders details using OS