Read, Write Excel and CSV Files

Course Introduction
How Does Learning Python Can Help You?
Why Python is so Popular?

Project 1: Hospitality Domain Data Analysis
Project 2: Medical Data Extraction

Python Installation - Windows
Python Installation - Linux
Python Installation - Mac
How to Download Code and Get Help If I Have a Question?
Variables
Variables - Quiz
Variables - Exercise
Numbers
Numbers - Quiz
Numbers - Exercise
Strings
Strings - Quiz
Strings - Exercise
Lists
Lists - Quiz
Lists - Exercise
Install Pycharm
If Condition
If Condition - Quiz
If Condition - Exercise
For Loop
For loop - Quiz
For loop - Exercise
Functions
Functions - Quiz
Functions - Exercise
Dictionary and Tuples
Dictionary and Tuples - Quiz
Dictionary and Tuples - Exercise
Modules and Pip
Modules and Pip - Quiz
Modules and Pip - Exercise
File Handling
File Handling - Quiz
File handling - Exercise
Classes and Objects
Classes and Objects - Quiz
Classes and Objects - Exercise
Inheritance
Inheritance - Quiz
Inheritance - Exercise
Exception Handling
Exception Handling - Quiz
Exception Handling - Exercise

Pandas Introduction and Installation
Dataframe Basics
Read, Write Excel and CSV Files
Handle NA values - Part 1
Handle NA values - Part 2
Group by
Concat and Merge

Problem Statement, OLTP vs OLAP, ETL, Data Warehouse
Data Understanding: CSV Files
Data Understanding: Fact vs Dim table, Star vs Snowflake Schema
Data Exploration
Data Cleaning
Data Transformation
Insights Generation

Disclaimer

Technical Architecture of the Project
Installation of Necessary Libraries
Extract text from a pdf document
Thresholding in OpenCV
Regular Expressions or Regex
Regex Exercise
Python class for prescription
Code Refactoring
Unit Tests using pytest
I Need a Favour

Write patient details class yourself
Extract name from a document
Extract remaining fields from a document
Write patient details class
Integrate doc parser classes into an extractor

FastAPI Basics
Write FastAPI server for our project
Integration With Frontend And Deployment

Final_Quiz Mandatory

Read, Write Excel and CSV Files

Lecture content Locked

Enroll in Bootcamp to Unlock

Contents

1. Welcome to The Python Experience

Course Introduction

How Does Learning Python Can Help You?

Why Python is so Popular?

2. Project Description

Project 1: Hospitality Domain Data Analysis

Project 2: Medical Data Extraction

3. Python Basics

Python Installation - Windows

Python Installation - Linux

Python Installation - Mac

How to Download Code and Get Help If I Have a Question?

Variables

Variables - Quiz

Variables - Exercise

Numbers

Numbers - Quiz

Numbers - Exercise

Strings

Strings - Quiz

Strings - Exercise

Lists

Lists - Quiz

Lists - Exercise

Install Pycharm

If Condition

If Condition - Quiz

If Condition - Exercise

For Loop

For loop - Quiz

For loop - Exercise

Functions

Functions - Quiz

Functions - Exercise

Dictionary and Tuples

Dictionary and Tuples - Quiz

Dictionary and Tuples - Exercise

Modules and Pip

Modules and Pip - Quiz

Modules and Pip - Exercise

File Handling

File Handling - Quiz

File handling - Exercise

Classes and Objects

Classes and Objects - Quiz

Classes and Objects - Exercise

Inheritance

Inheritance - Quiz

Inheritance - Exercise

Exception Handling

Exception Handling - Quiz

Exception Handling - Exercise

4. Pandas

Pandas Introduction and Installation

Dataframe Basics

Read, Write Excel and CSV Files

Handle NA values - Part 1

Handle NA values - Part 2

Group by

Concat and Merge

5. Project 1: Hotel Data Analytics

Problem Statement, OLTP vs OLAP, ETL, Data Warehouse

Data Understanding: CSV Files

Data Understanding: Fact vs Dim table, Star vs Snowflake Schema

Data Exploration

Data Cleaning

Data Transformation

Insights Generation

6. End Note

Disclaimer

7. Project 2: Prescription Document

Technical Architecture of the Project

Installation of Necessary Libraries

Extract text from a pdf document

Thresholding in OpenCV

Regular Expressions or Regex

Regex Exercise

Python class for prescription

Code Refactoring