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

String Methods with Excel

Click here to Download the workbook which consits of consolidation of all methods of string

Common Steps for all the programms:

Step1:

wkb = openpyxl.load_workbook("String_Methods.xlsx")

Connect to a workbook

Step2:Create new worksheet with function name

Newsh = wkb.create_sheet(index = 1, title = "LowerCase Sheet")

Step3:Define a variable for worksheet

sh = wkb['Input']

Copy the data from Input sheet to newly created sheet

Apply string function in newly created sheet

String Methods - Lower case

Click on image to view the video:

String Methods - convert into capitalize case

String Methods - convert into Upper case

String Methods - convert into Title case

String Methods - convert into Swap case

It converts lower case into Upper vice versa

String Methods - Isupper

String Methods - ISlower

String Methods - IStitle

String Method - Partition

Provides the partition based on string "a"

String Method - Split

String Method - Replace