Download or read book Database and Image Processing Using Python and Access written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-10-31 with total page 547 pages. Available in PDF, EPUB and Kindle. Book excerpt: The book details how programmers and database professionals can develop access-based Python applications that involves database and image processing. This book is a access database crash course which overs microsoft acces-based GUI programming using Python. In chapter one, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In chapter three, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In chapter four, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have LONGBINARY data type. You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In the last chapter, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

Download or read book Database and Image Processing Using SQL Server and Python written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-10-31 with total page 547 pages. Available in PDF, EPUB and Kindle. Book excerpt: The book details how programmers and database professionals can develop SQL Server-based Python applications that involves database and image processing. This book is SQL Server-based python programming. Microsoft SQL Server is robust relational database management system used by so many organizations of various sizes including top fortune 100 companies. SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft. As a database server, the primary function of the SQL Server is to store and retrieve data used by other applications. Deliberately designed for various levels of programming skill, this book is suitable for students, engineers, and even researchers in various disciplines. There is no need for advanced programming experience, and school-level programming skills are needed. In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In chapter three, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In chapter four, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have VARBINARY(MAX) data type. You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In the last chapter, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

Download or read book START FROM SCRATCH DIGITAL IMAGE PROCESSING WITH TKINTER written by Vivian Siahaan and published by BALIGE PUBLISHING. This book was released on 2023-10-21 with total page 490 pages. Available in PDF, EPUB and Kindle. Book excerpt: "Start from Scratch: Digital Image Processing with Tkinter" is a beginner-friendly guide that delves into the basics of digital image processing using Python and Tkinter, a popular GUI library. The project is divided into distinct modules, each focusing on a specific aspect of image manipulation. The journey begins with an exploration of Image Color Space. Here, readers encounter the Main Form, which serves as the entry point to the application. It provides a user-friendly interface for loading images, selecting color spaces, and visualizing various color channels. The Fundamental Utilities play a crucial role by providing core functionalities like loading images, converting color spaces, and manipulating pixel data. The project also includes forms dedicated to displaying individual color channels and offering insights into the current color space through histograms. The Plotting Utilities module facilitates the creation of visual representations such as plots and graphs, enhancing the user's understanding of color spaces. Moving on, the Image Transformation section introduces readers to techniques like the Fast Fourier Transform (FFT). The Fast Fourier Transform Utilities module enables the implementation of FFT algorithms for converting images from spatial to frequency domains. A corresponding form allows users to view images in the frequency domain, with additional adjustments made to the plotting utilities for effective visualization. In the context of Discrete Cosine Transform (DCT), readers gain insights into algorithms and functions for transforming images. The Form for Discrete Cosine Transform aids in visualizing images in the DCT domain, while the plotting utilities are modified to accommodate these transformed images. The Discrete Sine Transform (DST) section introduces readers to DST algorithms and their role in image transformation. A dedicated form for visualizing images in the DST domain is provided, and the plotting utilities are further extended to handle these transformations effectively. Moving Average Smoothing is another critical aspect covered in the project. The Filter2D Utilities facilitate the application of moving average smoothing techniques. Additionally, metrics utilities enable the assessment of the smoothing process, with forms available for displaying both metrics and the smoothed images. Next, the project addresses Exponential Moving Average techniques, modifying the existing utilities to accommodate this specific approach. Similarly, forms for visualizing results and metrics are provided. Readers are then introduced to techniques like Median Filtering, Savitzky-Golay Filtering, and Wiener Filtering. The Filter2D Utilities are adapted to facilitate these filtering methods, and metrics utilities are employed to assess the effectiveness of each technique. Forms dedicated to each filtering method provide a platform for visualizing the results. The final section of the project explores techniques such as Total Variation Denoising, Non-Local Means Denoising, and PCA Denoising. The Filter2D Utilities are once again modified to support these denoising techniques. Metrics utilities are employed to evaluate the denoising process, and dedicated forms offer visualization capabilities. By breaking down the project into these modules, readers can systematically grasp the fundamentals of digital image processing, gradually building their skills from one concept to the next. Each section provides hands-on experience and practical knowledge, making it an ideal starting point for beginners in image processing.

Download or read book Hands On Image Processing with Python written by Sandipan Dey and published by Packt Publishing Ltd. This book was released on 2018-11-30 with total page 483 pages. Available in PDF, EPUB and Kindle. Book excerpt: Explore the mathematical computations and algorithms for image processing using popular Python tools and frameworks. Key FeaturesPractical coverage of every image processing task with popular Python librariesIncludes topics such as pseudo-coloring, noise smoothing, computing image descriptorsCovers popular machine learning and deep learning techniques for complex image processing tasksBook Description Image processing plays an important role in our daily lives with various applications such as in social media (face detection), medical imaging (X-ray, CT-scan), security (fingerprint recognition) to robotics & space. This book will touch the core of image processing, from concepts to code using Python. The book will start from the classical image processing techniques and explore the evolution of image processing algorithms up to the recent advances in image processing or computer vision with deep learning. We will learn how to use image processing libraries such as PIL, scikit-mage, and scipy ndimage in Python. This book will enable us to write code snippets in Python 3 and quickly implement complex image processing algorithms such as image enhancement, filtering, segmentation, object detection, and classification. We will be able to use machine learning models using the scikit-learn library and later explore deep CNN, such as VGG-19 with Keras, and we will also use an end-to-end deep learning model called YOLO for object detection. We will also cover a few advanced problems, such as image inpainting, gradient blending, variational denoising, seam carving, quilting, and morphing. By the end of this book, we will have learned to implement various algorithms for efficient image processing. What you will learnPerform basic data pre-processing tasks such as image denoising and spatial filtering in PythonImplement Fast Fourier Transform (FFT) and Frequency domain filters (e.g., Weiner) in PythonDo morphological image processing and segment images with different algorithmsLearn techniques to extract features from images and match imagesWrite Python code to implement supervised / unsupervised machine learning algorithms for image processingUse deep learning models for image classification, segmentation, object detection and style transferWho this book is for This book is for Computer Vision Engineers, and machine learning developers who are good with Python programming and want to explore details and complexities of image processing. No prior knowledge of the image processing techniques is expected.

Download or read book Using SQLite written by Jay Kreibich and published by "O'Reilly Media, Inc.". This book was released on 2010-08-17 with total page 526 pages. Available in PDF, EPUB and Kindle. Book excerpt: Explains how to build database-backed applications for the Web, desktop, embedded systems, and operating systems using SQLite.

Download or read book Image Processing and Acquisition using Python written by Ravishankar Chityala and published by CRC Press. This book was released on 2020-06-11 with total page 335 pages. Available in PDF, EPUB and Kindle. Book excerpt: Image Processing and Acquisition using Python provides readers with a sound foundation in both image acquisition and image processing—one of the first books to integrate these topics together. By improving readers’ knowledge of image acquisition techniques and corresponding image processing, the book will help them perform experiments more effectively and cost efficiently as well as analyze and measure more accurately. Long recognized as one of the easiest languages for non-programmers to learn, Python is used in a variety of practical examples. A refresher for more experienced readers, the first part of the book presents an introduction to Python, Python modules, reading and writing images using Python, and an introduction to images. The second part discusses the basics of image processing, including pre/post processing using filters, segmentation, morphological operations, and measurements. The second part describes image acquisition using various modalities, such as x-ray, CT, MRI, light microscopy, and electron microscopy. These modalities encompass most of the common image acquisition methods currently used by researchers in academia and industry. Features Covers both the physical methods of obtaining images and the analytical processing methods required to understand the science behind the images. Contains many examples, detailed derivations, and working Python examples of the techniques. Offers practical tips on image acquisition and processing. Includes numerous exercises to test the reader’s skills in Python programming and image processing, with solutions to selected problems, example programs, and images available on the book’s web page. New to this edition Machine learning has become an indispensable part of image processing and computer vision, so in this new edition two new chapters are included: one on neural networks and the other on convolutional neural networks. A new chapter on affine transform and many new algorithms. Updated Python code aligned to the latest version of modules.

Download or read book LEARN FROM SCRATCH SIGNAL AND IMAGE PROCESSING WITH PYTHON GUI written by Vivian Siahaan and published by BALIGE PUBLISHING. This book was released on 2023-06-14 with total page 372 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, you will learn how to use OpenCV, NumPy library and other libraries to perform signal processing, image processing, object detection, and feature extraction with Python GUI (PyQt). You will learn how to filter signals, detect edges and segments, and denoise images with PyQt. You will also learn how to detect objects (face, eye, and mouth) using Haar Cascades and how to detect features on images using Harris Corner Detection, Shi-Tomasi Corner Detector, Scale-Invariant Feature Transform (SIFT), and Features from Accelerated Segment Test (FAST). In Chapter 1, you will learn: Tutorial Steps To Create A Simple GUI Application, Tutorial Steps to Use Radio Button, Tutorial Steps to Group Radio Buttons, Tutorial Steps to Use CheckBox Widget, Tutorial Steps to Use Two CheckBox Groups, Tutorial Steps to Understand Signals and Slots, Tutorial Steps to Convert Data Types, Tutorial Steps to Use Spin Box Widget, Tutorial Steps to Use ScrollBar and Slider, Tutorial Steps to Use List Widget, Tutorial Steps to Select Multiple List Items in One List Widget and Display It in Another List Widget, Tutorial Steps to Insert Item into List Widget, Tutorial Steps to Use Operations on Widget List, Tutorial Steps to Use Combo Box, Tutorial Steps to Use Calendar Widget and Date Edit, and Tutorial Steps to Use Table Widget. In Chapter 2, you will learn: Tutorial Steps To Create A Simple Line Graph, Tutorial Steps To Create A Simple Line Graph in Python GUI, Tutorial Steps To Create A Simple Line Graph in Python GUI: Part 2, Tutorial Steps To Create Two or More Graphs in the Same Axis, Tutorial Steps To Create Two Axes in One Canvas, Tutorial Steps To Use Two Widgets, Tutorial Steps To Use Two Widgets, Each of Which Has Two Axes, Tutorial Steps To Use Axes With Certain Opacity Levels, Tutorial Steps To Choose Line Color From Combo Box, Tutorial Steps To Calculate Fast Fourier Transform, Tutorial Steps To Create GUI For FFT, Tutorial Steps To Create GUI For FFT With Some Other Input Signals, Tutorial Steps To Create GUI For Noisy Signal, Tutorial Steps To Create GUI For Noisy Signal Filtering, and Tutorial Steps To Create GUI For Wav Signal Filtering. In Chapter 3, you will learn: Tutorial Steps To Convert RGB Image Into Grayscale, Tutorial Steps To Convert RGB Image Into YUV Image, Tutorial Steps To Convert RGB Image Into HSV Image, Tutorial Steps To Filter Image, Tutorial Steps To Display Image Histogram, Tutorial Steps To Display Filtered Image Histogram, Tutorial Steps To Filter Image With CheckBoxes, Tutorial Steps To Implement Image Thresholding, and Tutorial Steps To Implement Adaptive Image Thresholding. In Chapter 4, you will learn: Tutorial Steps To Generate And Display Noisy Image, Tutorial Steps To Implement Edge Detection On Image, Tutorial Steps To Implement Image Segmentation Using Multiple Thresholding and K-Means Algorithm, and Tutorial Steps To Implement Image Denoising. In Chapter 5, you will learn: Tutorial Steps To Detect Face, Eye, and Mouth Using Haar Cascades, Tutorial Steps To Detect Face Using Haar Cascades with PyQt, Tutorial Steps To Detect Eye, and Mouth Using Haar Cascades with PyQt, and Tutorial Steps To Extract Detected Objects. In Chapter 6, you will learn: Tutorial Steps To Detect Image Features Using Harris Corner Detection, Tutorial Steps To Detect Image Features Using Shi-Tomasi Corner Detection, Tutorial Steps To Detect Features Using Scale-Invariant Feature Transform (SIFT), and Tutorial Steps To Detect Features Using Features from Accelerated Segment Test (FAST). You can download the XML files from https://viviansiahaan.blogspot.com/2023/06/learn-from-scratch-signal-and-image.html.

Download or read book The Fast Tutorial to Learn Database Programming Using Python GUI with Access and SQL Server written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2020-01-15 with total page 545 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book covers microsoft acces and SQL Server based GUI programming using pyqt. Intentionally designed for various levels of interest and ability of learners, this book is suitable for students, engineers, and even researchers in a variety of disciplines. No advanced programming experience is needed, and only a few school-level programming skill are needed. In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In third chapter, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In fourth chapter, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have VARBINARY(MAX) data type. You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In the last chapter, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

Download or read book Python GUI For Signal and Image Processing written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-10-05 with total page 220 pages. Available in PDF, EPUB and Kindle. Book excerpt: You will learn to create GUI applications using the Qt toolkit. The Qt toolkit, also popularly known as Qt, is a cross-platform application and UI framework developed by Trolltech, which is used to develop GUI applications. You will develop an existing GUI by adding several Line Edit widgets to read input, which are used to set the range and step of the graph (signal). Next, Now, you can use a widget for each graph. Add another Widget from Containers in gui_graphics.ui using Qt Designer. Then, Now, you can use two Widgets, each of which has two canvases. The two canvases has QVBoxLayout in each Widget. Finally, you will apply those Widgets to display the results of signal and image processing techniques.

Download or read book Image Processing Masterclass with Python written by Sandipan Dey and published by BPB Publications. This book was released on 2021-03-10 with total page 428 pages. Available in PDF, EPUB and Kindle. Book excerpt: Over 50 problems solved with classical algorithms + ML / DL models KEY FEATURESÊ _ Problem-driven approach to practice image processing.Ê _ Practical usage of popular Python libraries: Numpy, Scipy, scikit-image, PIL and SimpleITK. _ End-to-end demonstration of popular facial image processing challenges using MTCNN and MicrosoftÕs Cognitive Vision APIs. Ê DESCRIPTIONÊ This book starts with basic Image Processing and manipulation problems and demonstrates how to solve them with popular Python libraries and modules. It then concentrates on problems based on Geometric image transformations and problems to be solved with Image hashing.Ê Next, the book focuses on solving problems based on Sampling, Convolution, Discrete Fourier transform, Frequency domain filtering and image restoration with deconvolution. It also aims at solving Image enhancement problems using differentÊ algorithms such as spatial filters and create a super resolution image using SRGAN. Finally, it explores popular facial image processing problems and solves them with Machine learning and Deep learning models using popular python ML / DL libraries. WHAT YOU WILL LEARNÊÊ _ Develop strong grip on the fundamentals of Image Processing and Image Manipulation. _ Solve popular Image Processing problems using Machine Learning and Deep Learning models. _ Working knowledge on Python libraries including numpy, scipyÊ and scikit-image. _ Use popular Python Machine Learning packages such as scikit-learn, Keras and pytorch. _ Live implementation of Facial Image Processing techniques such as Face Detection / Recognition / Parsing dlib and MTCNN. WHO THIS BOOK IS FORÊÊÊ This book is designed specially for computer vision users, machine learning engineers, image processing experts who are looking for solving modern image processing/computer vision challenges. TABLE OF CONTENTS 1. Chapter 1: Basic Image & Video Processing 2. Chapter 2: More Image Transformation and Manipulation 3. Chapter 3: Sampling, Convolution and Discrete Fourier Transform 4. Chapter 4: Discrete Cosine / Wavelet Transform and Deconvolution 5. Chapter 5: Image Enhancement 6. Chapter 6: More Image Enhancement 7. Chapter 7: Facel Image Processing

Download or read book DATA ANALYSIS PROJECTS WITH MYSQL SQLITE POSTGRESQL AND SQL SERVER USING PYTHON GUI written by Vivian Siahaan and published by BALIGE PUBLISHING. This book was released on 2022-10-26 with total page 1647 pages. Available in PDF, EPUB and Kindle. Book excerpt: PROJECT 1: FULL SOURCE CODE: POSTGRESQL AND DATA SCIENCE FOR PROGRAMMERS WITH PYTHON GUI This project uses the PostgreSQL version of MySQL-based Sakila sample database which is a fictitious database designed to represent a DVD rental store. The tables of the database include film, film_category, actor, film_actor, customer, rental, payment and inventory among others. You can download the database from https://dev.mysql.com/doc/sakila/en/. In this project, you will write Python script to create every table and insert rows of data into each of them. You will develop GUI with PyQt5 to each table in the database. You will also create GUI to plot case distribution of film release year, film rating, rental duration, and categorize film length; plot rating variable against rental_duration variable in stacked bar plots; plot length variable against rental_duration variable in stacked bar plots; read payment table; plot case distribution of Year, Day, Month, Week, and Quarter of payment; plot which year, month, week, days of week, and quarter have most payment amount; read film list by joining five tables: category, film_category, film_actor, film, and actor; plot case distribution of top 10 and bottom 10 actors; plot which film title have least and most sales; plot which actor have least and most sales; plot which film category have least and most sales; plot case distribution of top 10 and bottom 10 overdue costumers; plot which store have most sales; plot average payment amount by month with mean and EWM; and plot payment amount over June 2005. PROJECT 2: FULL SOURCE CODE: MYSQL FOR STUDENTS AND PROGRAMMERS WITH PYTHON GUI In this project, we provide you with a MySQL version of an Oracle sample database named OT which is based on a global fictitious company that sells computer hardware including storage, motherboard, RAM, video card, and CPU. The company maintains the product information such as name, description standard cost, list price, and product line. It also tracks the inventory information for all products including warehouses where products are available. Because the company operates globally, it has warehouses in various locations around the world. The company records all customer information including name, address, and website. Each customer has at least one contact person with detailed information including name, email, and phone. The company also places a credit limit on each customer to limit the amount that customer can owe. Whenever a customer issues a purchase order, a sales order is created in the database with the pending status. When the company ships the order, the order status becomes shipped. In case the customer cancels an order, the order status becomes canceled. In addition to the sales information, the employee data is recorded with some basic information such as name, email, phone, job title, manager, and hire date. In this project, you will write Python script to create every table and insert rows of data into each of them. You will develop GUI with PyQt5 to each table in the database. You will also create GUI to plot: case distribution of order date by year, quarter, month, week, and day; the distribution of amount by year, quarter, month, week, day, and hour; the distribution of bottom 10 sales by product, top 10 sales by product, bottom 10 sales by customer, top 10 sales by customer, bottom 10 sales by category, top 10 sales by category, bottom 10 sales by status, top 10 sales by status, bottom 10 sales by customer city, top 10 sales by customer city, bottom 10 sales by customer state, top 10 sales by customer state, average amount by month with mean and EWM, average amount by every month, amount feature over June 2016, amount feature over 2017, and amount payment in all years. PROJECT 3: ZERO TO MASTERY: THE COMPLETE GUIDE TO LEARNING SQLITE AND PYTHON GUI In this project, we provide you with the SQLite version of The Oracle Database Sample Schemas that provides a common platform for examples in each release of the Oracle Database. The sample database is also a good database for practicing with SQL, especially SQLite. The detailed description of the database can be found on: http://luna-ext.di.fc.ul.pt/oracle11g/server.112/e10831/diagrams.htm#insertedID0. The four schemas are a set of interlinked schemas. This set of schemas provides a layered approach to complexity: A simple schema Human Resources (HR) is useful for introducing basic topics. An extension to this schema supports Oracle Internet Directory demos; A second schema, Order Entry (OE), is useful for dealing with matters of intermediate complexity. Many data types are available in this schema, including non-scalar data types; The Online Catalog (OC) subschema is a collection of object-relational database objects built inside the OE schema; The Product Media (PM) schema is dedicated to multimedia data types; The Sales History (SH) schema is designed to allow for demos with large amounts of data. An extension to this schema provides support for advanced analytic processing. The HR schema consists of seven tables: regions, countries, locations, departments, employees, jobs, and job_histories. This book only implements HR schema, since the other schemas will be implemented in the next books. PROJECT 4: FULL SOURCE CODE: SQL SERVER FOR STUDENTS AND DATA SCIENTISTS WITH PYTHON GUI In this project, we provide you with the SQL SERVER version of SQLite sample database named chinook. The chinook sample database is a good database for practicing with SQL, especially PostgreSQL. The detailed description of the database can be found on: https://www.sqlitetutorial.net/sqlite-sample-database/. The sample database consists of 11 tables: The employee table stores employees data such as employee id, last name, first name, etc. It also has a field named ReportsTo to specify who reports to whom; customers table stores customers data; invoices & invoice_items tables: these two tables store invoice data. The invoice table stores invoice header data and the invoice_items table stores the invoice line items data; The artist table stores artists data. It is a simple table that contains only the artist id and name; The album table stores data about a list of tracks. Each album belongs to one artist. However, one artist may have multiple albums; The media_type table stores media types such as MPEG audio and AAC audio files; genre table stores music types such as rock, jazz, metal, etc; The track table stores the data of songs. Each track belongs to one album; playlist & playlist_track tables: The playlist table store data about playlists. Each playlist contains a list of tracks. Each track may belong to multiple playlists. The relationship between the playlist table and track table is many-to-many. The playlist_track table is used to reflect this relationship. In this project, you will write Python script to create every table and insert rows of data into each of them. You will develop GUI with PyQt5 to each table in the database. You will also create GUI to plot: case distribution of order date by year, quarter, month, week, and day; the distribution of amount by year, quarter, month, week, day, and hour; the bottom/top 10 sales by employee, the bottom/top 10 sales by customer, the bottom/top 10 sales by customer, the bottom/top 10 sales by artist, the bottom/top 10 sales by genre, the bottom/top 10 sales by play list, the bottom/top 10 sales by customer city, the bottom/top 10 sales by customer city, the bottom/top 10 sales by customer city, the payment amount by month with mean and EWM, the average payment amount by every month, and amount payment in all years.

Download or read book Programming Computer Vision with Python written by Jan Erik Solem and published by "O'Reilly Media, Inc.". This book was released on 2012-06-19 with total page 264 pages. Available in PDF, EPUB and Kindle. Book excerpt: If you want a basic understanding of computer vision’s underlying theory and algorithms, this hands-on introduction is the ideal place to start. You’ll learn techniques for object recognition, 3D reconstruction, stereo imaging, augmented reality, and other computer vision applications as you follow clear examples written in Python. Programming Computer Vision with Python explains computer vision in broad terms that won’t bog you down in theory. You get complete code samples with explanations on how to reproduce and build upon each example, along with exercises to help you apply what you’ve learned. This book is ideal for students, researchers, and enthusiasts with basic programming and standard mathematical skills. Learn techniques used in robot navigation, medical image analysis, and other computer vision applications Work with image mappings and transforms, such as texture warping and panorama creation Compute 3D reconstructions from several images of the same scene Organize images based on similarity or content, using clustering methods Build efficient image retrieval techniques to search for images based on visual content Use algorithms to classify image content and recognize objects Access the popular OpenCV library through a Python interface

Download or read book Practical Machine Learning for Data Analysis Using Python written by Abdulhamit Subasi and published by Academic Press. This book was released on 2020-06-05 with total page 534 pages. Available in PDF, EPUB and Kindle. Book excerpt: Practical Machine Learning for Data Analysis Using Python is a problem solver’s guide for creating real-world intelligent systems. It provides a comprehensive approach with concepts, practices, hands-on examples, and sample code. The book teaches readers the vital skills required to understand and solve different problems with machine learning. It teaches machine learning techniques necessary to become a successful practitioner, through the presentation of real-world case studies in Python machine learning ecosystems. The book also focuses on building a foundation of machine learning knowledge to solve different real-world case studies across various fields, including biomedical signal analysis, healthcare, security, economics, and finance. Moreover, it covers a wide range of machine learning models, including regression, classification, and forecasting. The goal of the book is to help a broad range of readers, including IT professionals, analysts, developers, data scientists, engineers, and graduate students, to solve their own real-world problems. Offers a comprehensive overview of the application of machine learning tools in data analysis across a wide range of subject areas Teaches readers how to apply machine learning techniques to biomedical signals, financial data, and healthcare data Explores important classification and regression algorithms as well as other machine learning techniques Explains how to use Python to handle data extraction, manipulation, and exploration techniques, as well as how to visualize data spread across multiple dimensions and extract useful features

Download or read book Python 3 Image Processing written by Pajankar Ashwin and published by BPB Publications. This book was released on 2019-09-20 with total page 252 pages. Available in PDF, EPUB and Kindle. Book excerpt: Gain a working knowledge of practical image processing and with scikit-image.Key features Comprehensive coverage of various aspects of scientific Python and concepts in image processing. Covers various additional topics such as Raspberry Pi, conda package manager, and Anaconda distribution of Python. Simple language, crystal clear approach, and straight forward comprehensible presentation of concepts followed by code examples and output screenshots. Adopting user-friendly style for explanation of code examples.DescriptionThe book has been written in such a way that the concepts are explained in detail, giving adequate emphasis on code examples. To make the topics more comprehensive, screenshots and code samples are furnished extensively throughout the book. The book is conceptualized and written in such a way that the beginner readers will find it very easy to understand the concepts and implement the programs.The book also features the most current version of Raspberry Pi and associated software with it. This book teaches novice beginners how to write interesting image processing programs with scientific Python ecosystem. The book will also be helpful to experienced professionals to make transition to rewarding careers in scientific Python and computer vision. What will you learn Raspberry Pi, Python 3 Basics Scientific Python Ecosystem NumPy and Matplotlib Visualization with Matplotlib Basic NumPy, Advanced Image Processing with NumPy and Matplotlib Getting started with scikit-image Thresholding, Histogram Equalization, and Transformations Kernels, Convolution, and Filters Morphological Operations and Image Restoration Noise Removal and Edge Detection Advanced Image Processing OperationsWho this book is for Students pursuing BE/BSc/ME/MSc/BTech/MTech in Computer Science, Electronics, Electrical, and Mathematics Python enthusiasts Computer Vision and Image Processing professionals Anyone fond of tinkering with Raspberry Pi Researchers in Computer Vision Table of contents1. Concepts in Image Processing2. Installing Python 3 on Windows3. Introduction to Raspberry Pi4. Python 3 Basics5. Introduction to the Scientific Python Ecosystem6. Introduction to NumPy and Matplotlib7. Visualization with Matplotlib8. Basic Image Processing with NumPy and Matplotlib9. Advanced Image Processing with NumPy and Matplotlib10. Getting Started with Scikit-Image11. Thresholding Histogram Equalization and Transformations12. Kernels, Convolution and Filters13. Morphological Operations and Image Restoration14. Noise Removal and Edge Detection15. Advanced Image Processing Operations16. Wrapping UpAbout the authorAshwin Pajankar is a polymath. He has more than two decades of programming experience. He is a Science Popularizer, a Programmer, a Maker, an Author, and a Youtuber. He is passionate about STEM (Science-Technology-Education-Mathematics) education. He is also a freelance software developer and technology trainer. He graduated from IIIT Hyderabad with M.Tech. in Computer Science and Engineering. He has worked in a few multinational corporations including Cisco Systems and Cognizant for more than a decade. Ashwin is also an online trainer with various eLearning platforms like BPBOnline, Udemy, and Skillshare. In his free time, he consults on the topics of Python programming and data science to the local software companies in the city of Nasik. He is actively involved in various social initiatives and has won many accolades during his student life and at his past workplaces.His Website: http://www.ashwinpajankar.com/His LinkedIn Profile: https://www.linkedin.com/in/ashwinpajankar/

Download or read book Step By Step Neural Networks for Image Classification using Python GUI written by Hamzan Wadi and published by Turida Publisher. This book was released on with total page 207 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides a practical explanation of the backpropagation neural networks algorithm and how it can be implemented for image classification. The discussion in this book is presented in step by step so that it will help readers understand the fundamental of the backpropagation neural networks and its steps. This book is very suitable for students, researchers, and anyone who want to learn and implement the backpropagation neural networks for image classification using PYTHON GUI. The discussion in this book will provide readers deep understanding about the backpropagation neural networks architecture and its parameters. The readers will be guided to understand the steps of the backpropagation neural networks for image classification through case example. The readers will be guided to create their own neural networks class and build their complete applications for data image classification. The final objective of this book is that the readers are able to realize each step of the multilayer perceptron neural networks for image classification. In Addition, the readers also are able to create the neural networks applications which consists of two types of applications which are command window based application and GUI based application. Here are the material that you will learn in this book. CHAPTER 1: This chapter will guide you in preparing what software are needed to realize the backpropagation neural networks using Python GUI. The discussion in this chapter will start from installing Python and the libraries that will be used, installing Qt Designer, understanding and using Qt Designer to design the application UI, and the last is about how to create a GUI program using Python and Qt Designer. CHAPTER 2: This chapter discusses the important parts in the backpropagation neural networks algorithm which includes the architecture of the backpropagation neural networks, the parameters contained in the backpropagation neural networks, the steps of the backpropagation neural networks algorithm, and the mathematical calculations of the backpropagation neural networks. CHAPTER 3: This chapter discusses in detail the mathematical calculations of fruit quality classification using the backpropagation neural networks which includes the feature extraction process of fruit images, data normalization, the training process, and the classification process. The feature extraction method used in this case is GLCM (Gray Level Co-occurrence Matrix). The image features that will be used in this case are energy, contrast, entropy, and homogeneity. CHAPTER 4: This chapter discusses how to implement the backpropagation neural networks algorithm for fruit quality classification using Python. This chapter will present the steps to create your backpropagation neural networks class and to define the functions that represent each process of the backpropagation neural networks. This chapter will also present the steps to create a class for image processing. And in final discussion you will be guided to create your backpropagation neural networks application from scratch to classify the quality of fruit. CHAPTER 5: This chapter will discuss how to create a GUI based application for fruit quality classification using the backpropagation neural networks algorithm. This chapter will discuss in detail the steps for designing the application UI by using Qt Designer, the steps for creating a class for the backpropagation neural networks GUI based application, and how to run the GUI based application to classify the fruit data.

Download or read book FRAME ANALYSIS AND PROCESSING IN DIGITAL VIDEO USING PYTHON AND TKINTER written by Vivian Siahaan and published by BALIGE PUBLISHING. This book was released on 2024-03-27 with total page 167 pages. Available in PDF, EPUB and Kindle. Book excerpt: The first project in chapter one which is Canny Edge Detector presented here is a graphical user interface (GUI) application built using Tkinter in Python. This application allows users to open video files (of formats like mp4, avi, or mkv) and view them along with their corresponding Canny edge detection frames. The application provides functionalities such as playing, pausing, stopping, navigating through frames, and jumping to specific times within the video. Upon opening the application, users are greeted with a clean interface comprising two main sections: the video display panel and the control panel. The video display panel consists of two canvas widgets, one for displaying the original video and another for displaying the Canny edge detection result. These canvases allow users to visualize the video and its corresponding edge detection in real-time. The control panel houses various buttons and widgets for controlling the video playback and interaction. Users can open video files using the "Open Video" button, select a zoom scale for viewing convenience, jump to specific times within the video, play/pause the video, stop the video, navigate through frames, and even open another instance of the application for simultaneous use. The core functionality lies in the methods responsible for displaying frames and performing Canny edge detection. The show_frame() method retrieves frames from the video, resizes them based on the selected zoom scale, and displays them on the original video canvas. Similarly, the show_canny_frame() method applies the Canny edge detection algorithm to the frames, enhances the edges using dilation, and displays the resulting edge detection frames on the corresponding canvas. The application also supports mouse interactions such as dragging to pan the video frames within the canvas and scrolling to navigate through frames. These interactions are facilitated by event handling methods like on_press(), on_drag(), and on_scroll(), ensuring smooth user experience and intuitive control over video playback and exploration. Overall, this project provides a user-friendly platform for visualizing video content and exploring Canny edge detection results, making it valuable for educational purposes, research, or practical applications involving image processing and computer vision. This second project in chapter one implements a graphical user interface (GUI) application for performing edge detection using the Prewitt operator on videos. The purpose of the code is to provide users with a tool to visualize videos, apply the Prewitt edge detection algorithm, and interactively control playback and visualization parameters. The third project in chapter one which is "Sobel Edge Detector" is implemented in Python using Tkinter and OpenCV serves as a graphical user interface (GUI) for viewing and analyzing videos with real-time Sobel edge detection capabilities. The "Frei-Chen Edge Detection" project as fourth project in chapter one is a graphical user interface (GUI) application built using Python and the Tkinter library. The application is designed to process and visualize video files by detecting edges using the Frei-Chen edge detection algorithm. The core functionality of the application lies in the implementation of the Frei-Chen edge detection algorithm. This algorithm involves convolving the video frames with predefined kernels to compute the gradient magnitude, which represents the strength of edges in the image. The resulting edge-detected frames are thresholded to convert grayscale values to binary values, enhancing the visibility of edges. The application also includes features for user interaction, such as mouse wheel scrolling to zoom in and out, click-and-drag functionality to pan across the video frames, and input fields for jumping to specific times within the video. Additionally, users have the option to open multiple instances of the application simultaneously to analyze different videos concurrently, providing flexibility and convenience in video processing tasks. Overall, the "Frei-Chen Edge Detection" project offers a user-friendly interface for edge detection in videos, empowering users to explore and analyze visual data effectively. The "KIRSCH EDGE DETECTOR" project as the fifth project in chapter one is a Python application built using Tkinter, OpenCV, and NumPy libraries for performing edge detection on video files. It handles the visualization of the edge-detected frames in real-time. It retrieves the current frame from the video, applies Gaussian blur for noise reduction, performs Kirsch edge detection, and applies thresholding to obtain the binary edge image. The processed frame is then displayed on the canvas alongside the original video. This "SCHARR EDGE DETECTOR" as the sixth project in chapter one is creating a graphical user interface (GUI) to visualize edge detection in videos using the Scharr algorithm. It allows users to open video files, play/pause video playback, navigate frame by frame, and apply Scharr edge detection in real-time. The GUI consists of multiple components organized into panels. The main panel displays the original video on the left side and the edge-detected video using the Scharr algorithm on the right side. Both panels utilize Tkinter Canvas widgets for efficient rendering and manipulation of video frames. Users can interact with the application using control buttons located in the control panel. These buttons include options to open a video file, adjust the zoom scale, jump to a specific time in the video, play/pause video playback, stop the video, navigate to the previous or next frame, and open another instance of the application for parallel video analysis. The core functionality of the application lies in the VideoScharr class, which encapsulates methods for video loading, playback control, frame processing, and edge detection using the Scharr algorithm. The apply_scharr method implements the Scharr edge detection algorithm, applying a pair of 3x3 convolution kernels to compute horizontal and vertical derivatives of the image and then combining them to calculate the edge magnitude. Overall, the "SCHARR EDGE DETECTOR" project provides users with an intuitive interface to explore edge detection techniques in videos using the Scharr algorithm. It combines the power of image processing libraries like OpenCV and the flexibility of Tkinter for creating interactive and responsive GUI applications in Python. The first project in chapter two is designed to provide a user-friendly interface for processing video frames using Gaussian filtering techniques. It encompasses various components and functionalities tailored towards efficient video analysis and processing. The GaussianFilter Class serves as the backbone of the application, managing GUI initialization and video processing functionalities. The GUI layout is constructed with Tkinter widgets, comprising two main panels for video display and control buttons. Key functionalities include opening video files, controlling playback, adjusting zoom levels, navigating frames, and interacting with video frames via mouse events. Additionally, users can process frames using OpenCV for Gaussian filtering to enhance video quality and reduce noise. Time navigation functionality allows users to jump to specific time points in the video. Moreover, the application supports multiple instances for simultaneous video analysis in independent windows. Overall, this project offers a comprehensive toolset for video analysis and processing, empowering users with an intuitive interface and diverse functionalities. The second project in chapter two presents a Tkinter application tailored for video frame filtering utilizing a mean filter. It offers comprehensive functionalities including opening, playing/pausing, and stopping video playback, alongside options to navigate to previous and next frames, jump to specified times, and adjust zoom scale. Displayed on separate canvases, the original and filtered video frames are showcased distinctly. Upon video file opening, the application utilizes imageio.get_reader() for video reading, while play_video() and play_filtered_video() methods handle frame display. Individual frame rendering is managed by show_frame() and show_mean_frame(), incorporating noise addition through the add_noise() method. Mouse wheel scrolling, canvas dragging, and scrollbar scrolling are facilitated through event handlers, enhancing user interaction. Supplementary functionalities include time navigation, frame navigation, and the ability to open multiple instances using open_another_player(). The main() function initializes the Tkinter application and executes the event loop for GUI display. The third project in chapter two aims to develop a user-friendly graphical interface application for filtering video frames with a median filter. Supporting various video formats like MP4, AVI, and MKV, users can seamlessly open, play, pause, stop, and navigate through video frames. The key feature lies in real-time application of the median filter to enhance frame quality by noise reduction. Upon video file opening, the original frames are displayed alongside filtered frames, with users empowered to control zoom levels and frame navigation. Leveraging libraries such as tkinter, imageio, PIL, and OpenCV, the application facilitates efficient video analysis and processing, catering to diverse domains like surveillance, medical imaging, and scientific research. The fourth project in chapter two exemplifies the utilization of a bilateral filter within a Tkinter-based graphical user interface (GUI) for real-time video frame filtering. The script showcases the application of bilateral filtering, renowned for its ability to smooth images while preserving edges, to enhance video frames. The GUI integrates two main components: canvas panels for displaying original and filtered frames, facilitating interactive viewing and manipulation. Upon video file opening, original frames are displayed on the left panel, while bilateral-filtered frames appear on the right. Adjustable parameters within the bilateral filter method enable fine-tuning for noise reduction and edge preservation based on specific video characteristics. Control functionalities for playback, frame navigation, zoom scaling, and time jumping enhance user interaction, providing flexibility in exploring diverse video filtering techniques. Overall, the script offers a practical demonstration of bilateral filtering in real-time video processing within a Tkinter GUI, enabling efficient exploration of filtering methodologies. The fifth project in chapter two integrates a video player application with non-local means denoising functionality, utilizing tkinter for GUI design, PIL for image processing, imageio for video file reading, and OpenCV for denoising. The GUI, set up by the NonLocalMeansDenoising class, includes controls for playback, zoom, time navigation, and frame browsing, alongside features like mouse wheel scrolling and dragging for user interaction. Video loading and display are managed through methods like open_video and play_video(), which iterate through frames, resize them, and add noise for display on the canvas. Non-local means denoising is applied using the apply_non_local_denoising() method, enhancing frames before display on the filter canvas via show_non_local_frame(). The GUI fosters user interaction, offering controls for playback, zoom, time navigation, and frame browsing, while also ensuring error handling for seamless operation during video loading, processing, and denoising. The sixth project in chapter two provides a platform for filtering video frames using anisotropic diffusion. Users can load various video formats and control playback (play, pause, stop) while adjusting zoom levels and jumping to specific timestamps. Original video frames are displayed alongside filtered versions achieved through anisotropic diffusion, aiming to denoise images while preserving critical edges and structures. Leveraging OpenCV and imageio for image processing and PIL for manipulation tasks, the application offers a user-friendly interface with intuitive control buttons and multi-video instance support, facilitating efficient analysis and enhancement of video content through anisotropic diffusion-based filtering. The seventh project in chapter two is built with Tkinter and OpenCV for filtering video frames using the Wiener filter. It offers a user-friendly interface for opening video files, controlling playback, adjusting zoom levels, and applying the Wiener filter for noise reduction. With separate panels for displaying original and filtered video frames, users can interact with the frames via zooming, scrolling, and dragging functionalities. The application handles video processing internally by adding random noise to frames and applying the Wiener filter, ensuring enhanced visual quality. Overall, it provides a convenient tool for visualizing and analyzing videos while showcasing the effectiveness of the Wiener filter in image processing tasks. The first project in chapter three showcases optical flow observation using the Lucas-Kanade method. Users can open video files, play, pause, and stop them, adjust zoom levels, and jump to specific frames. The interface comprises two panels for original video display and optical flow results. With functionalities like frame navigation, zoom adjustment, and time-based jumping, users can efficiently analyze optical flow patterns. The Lucas-Kanade algorithm computes optical flow between consecutive frames, visualized as arrows and points, allowing users to observe directional changes and flow strength. Mouse wheel scrolling facilitates zoom adjustments for detailed inspection or broader perspective viewing. Overall, the application provides intuitive navigation and robust optical flow analysis tools for effective video observation. The second project in chapter three is designed to visualize optical flow with Kalman filtering. It features controls for video file manipulation, frame navigation, zoom adjustment, and parameter specification. The application provides side-by-side canvases for displaying original video frames and optical flow results, allowing users to interact with the frames and explore flow patterns. Internally, it employs OpenCV and NumPy for optical flow computation using the Farneback method, enhancing stability and accuracy with Kalman filtering. Overall, it offers a user-friendly interface for analyzing video data, benefiting fields like computer vision and motion tracking. The third project in chapter three is for optical flow analysis in videos using Gaussian pyramid techniques. Users can open video files and visualize optical flow between consecutive frames. The interface presents two panels: one for original video frames and the other for computed optical flow. Users can adjust zoom levels and specify optical flow parameters. Control buttons enable common video playback actions, and multiple instances can be opened for simultaneous analysis. Internally, OpenCV, Tkinter, and imageio libraries are used for video processing, GUI development, and image manipulation, respectively. Optical flow computation relies on the Farneback method, with resulting vectors visualized on the frames to reveal motion patterns.

Download or read book Building Two Desktop Applications Using Python GUI and MariaDB written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-11-06 with total page 533 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, you will create two desktop applications using Python GUI and MariaDB. This book is mariadb-based python programming Intentionally designed for various levels of interest and ability of learners, this book is suitable for students, engineers, and even researchers in a variety of disciplines. No advanced programming experience is needed, and only a few school-level programming skill are needed. In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In third chapter, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In fourth chapter, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In chapter nine, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.