HOME

Data Structure

Set

Controllers

Break - Continue

OOPS

Class - Introduction

Functions - Methods

Functions Introduction

Input and Print

Errors

Types of Errors

Regular Expressions

re - Introduction

Openpyxl

Interaction with Excel

Openpyxl - Charts

String Methods with Excel

Database Connections

Sqlite3 - Excel

Framework - Flask

Flask Introduction

Create Database

Webapp with Sqlite3

Pandas

Pandas_DataFrame_Introduction

Dataframe Dates

Dataframe Operations

Pandas - TextFiles

Web Scraping

matplotlib

File Handling

Data from Text file

Flask Web Framework - Create Students marks card

Steps to Follow:

First install Flask package for Web frame work
Install sqlite3 module to provide the connection with SQL Database
Import the aforementioned packages into python file
Create database - you can change the database name as per your requirement
Create table - you can chagne the table name as per your requirement
Update the values in form
Import the values from form to python file, through creation variables
Insert the values into table by assigning variabels to column headers
COMMIT the transaction
Generate the report by executing the sql query

Insert the data from web page to excel

Flask Welcome message

Flask return welcome page

Flask - web page with variable name

Insert Image on HTML page

Flask - return table data

Flask - Form - Textbox

Change the attributes as per requirement

Hotel Menu Form

Click on below Program extract to view the video