Read, Write Excel and CSV Files

Course Introduction
How Does Learning Python Can Help You?
Why Python is so Popular?
Who can Enroll In This Course? Any Prerequisites?
How is This Different From Free Codebasics YouTube Playlist?
What Kind Of Computer Do I Need For This Course?
Go Over Course Structure

Join Discord
Video Resolution

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

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

7 Career Options After Learning Python
Next Steps: Python Backend Engineer, Software Engineer
Next Steps: Data Analyst, Data Scientist
Stay Connected And Thank You

Final Quiz

Read, Write Excel and CSV Files

Prev Next

Lecture content Locked

Enroll in Course to Unlock

Contents

1. Course Overview

Course Introduction

How Does Learning Python Can Help You?

Why Python is so Popular?

Who can Enroll In This Course? Any Prerequisites?

How is This Different From Free Codebasics YouTube Playlist?

What Kind Of Computer Do I Need For This Course?

Go Over Course Structure

2. Enhance your Learning Experience

Join Discord

Video Resolution

3. Project Description

Project 1: Hospitality Domain Data Analysis

Project 2: Medical Data Extraction

4. 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

5. 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

6. 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

7. Project 2: Prescription Document

Technical Architecture of the Project

Installation of Necessary Libraries

Extract text from a pdf document