PYTHON is a multi-paradigm programming language. Object-oriented programming and structured programming are fully supported, and many of its features support functional programming and aspect-oriented programming Many other paradigms are supported via extensions, including design by contract and logic programming.
Advanced Python Training
Python is an interpreted, high-level, general-purpose programming language. Python’s design philosophy emphasizes code readability with its notable use of significant whitespace. Its language constructs and object-oriented approach aim to help programmers write clear, logical code for small and largescale projects.
Python strives for a simpler, less-cluttered syntax and grammar while giving developers a choice in their coding methodology.
Tkinter (Graphical User Interface)
- Building Your First Python GUI Application With Tkinter
- Adding a Widget
- Working With Widgets
- Displaying Text and Images With Label Widgets
- Displaying Clickable Buttons With Button Widgets
- Getting User Input With Entry Widgets
- Getting Multiline User Input With Text Widgets
- Assigning Widgets to Frames With Frame Widgets
- Adjusting Frame Appearance With Reliefs
- Understanding Widget Naming Conventions
- Controlling Layout With Geometry Managers
- pack() Geometry Manager
- place() Geometry Manager
- grid() Geometry Manager
- Making Your Applications Interactive
- Using Events and Event Handlers
- Using bind()
NumPy -Numerical Python
- How does NumPy where work?
- 2D matrices
- Multidimensional array
- Using the result as an index
- Parameters ‘x’ and ‘y’
- Apply on Pandas DataFrames
- Multiple conditions
- Nested where (where within where)
- Finding rows of zeros
- Finding the last occurrence of a true condition Using on DateTime data
Matplotlib (Plotting Graphs Using pyplot)
- Plot Types
- Line Plot
- Histograms
- Paths
- Streamplot
- Bar Charts
- Vertical Line,Horizontal Line,Multiple Lines
- Multiple Plots
MISCELLANEOUS
- Iterable and Iterator
- yield Keyword
- Python Generators
- Python Closures
- Python Decorators
- @property Decorator in Python
- Assert Statement
What is Multitasking
- Process based and Thread based Multitasking
- Applications of Multithreading
- How to implement Multithreading in Python?
- Different Ways to Create a Thread in Python
- Creating a Thread using Thread class
- Creating a Thread class by inheriting Thread class
- Advantages of multithreading in Python
- Naming a Thread in Python
Python MySQL
- Create Database – Python MySQL
- Create Table – Python MySQL
- Insert Data in Table
- Select Data from Table
- Update data in Table
- Delete data from Table
- Drop Table from Database
- WHERE clause – Python MySQL
- Order By clause – Python MySQL
- Limit clause – Python MySQL
- Table Joins – Python MySQL
Python and MySQL Database connectivity
- Installing MySQL Connector/Python
- Establishing a Connection With MySQL Server
- Establishing a Connection
- Creating a New Database
- Connecting to an Existing Database
- Creating, Altering, and Dropping a Table
- Defining the Database Schema
- Creating Tables Using the CREATE TABLE Statement
- Showing a Table Schema Using the DESCRIBE Statement
- Modifying a Table Schema Using the ALTER Statement
- Deleting Tables Using the DROP Statement
- Inserting Records in Tables
Data Manipulation with Pandas
- Pandas in Python
- How to Install Pandas
- Data Frame is by importing a csv file using Pandas.
- How to Read Excel Files to Pandas Data frames
- Setting the Index Column when Reading xls File
- Importing an Excel File to Pandas in Two Easy Steps:
- Pandas Read Excel: How to Read All Sheets
- Setting the Data Type for Data or Columns
- Writing Pandas Data Frames to Excel
- Using execute()
- Using execute many()
- Reading Records From the Database
- Reading Records Using the SELECT Statement
- Filtering Results Using the WHERE Clause
- Handling Multiple Tables Using the JOIN Statement
- Updating and Deleting Records From the Database
REGULAR EXPRESSIONS
- Introduction
- Simple Character Matches
- Special Characters
- Character Classes
- Quantifiers
- The Dot Character
- Greedy Matches
- Grouping
- Matching at Beginning or End
- Match Objects
- Substituting
- Splitting a String
- Compiling Regular Expressions
- Flags
