Advanced Python

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.

• 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()

• • 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

• Plot Types
• Line Plot
• Histograms
• Paths
• Streamplot
• Bar Charts
• Vertical Line,Horizontal Line,Multiple Lines
• Multiple Plots

• Iterable and Iterator
• yield Keyword
• Python Generators
• Python Closures
• Python Decorators
• @property Decorator in Python
• Assert Statement

• 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

• 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

• 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

• 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