Data Analysis With Pandas And Numpy In Python

Data Analysis With Pandas And Numpy In Python
Published 3/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz

NumPy and Pandas for Data Analysis and Financial Applications, Examples in Trading Market Analysis

What you’ll learn

Data manipulation: working with data, filter, sort, and transform large datasets

Data analysis: perform a wide range of data analysis tasks, including aggregating data, performing statistical calculations

Data wrangling: cleaning and preparing data for analysis, handling missing data, merge datasets, and reshape data

Requirements

Python basics, for loops, condition statements, python containers; lists, sets, tuples and dictionnaries.

Description

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: NumPy or Numerical Python

Lecture 2 NumPy Installation

Lecture 3 NumPy Basic Functions

Lecture 4 NumPy Slicing

Lecture 5 NumPy Multidimentional Arrays

Lecture 6 NumPy DTypes

Lecture 7 NumPy Structured Arrays

Lecture 8 NumPy Reading And Writing Data Files

Lecture 9 NumPy Arithmetic Operations

Lecture 10 NumPy Logical Operations

Lecture 11 NumPy Array Broadcasting

Lecture 12 NumPy Conditional Indexing

Section 3: NumPy Exercises

Lecture 13 Exercises And Solutions

Lecture 14 Exercise 1

Lecture 15 Exercise 2

Lecture 16 Exercise 3

Lecture 17 Exercise 4

Lecture 18 Exercise 5

Lecture 19 Exercise 6

Section 4: Data Structure in Pandas

Lecture 20 Pandas Series

Lecture 21 Series Missing Values

Lecture 22 Applying Functions to Series

Lecture 23 Pandas DataFrames

Section 5: DataFrame Manipulation

Lecture 24 Columns And Indexes In Pandas

Lecture 25 Accessing DataFrames With Loc[] and iLoc[]

Lecture 26 Accessing Scalars/Values In DataFrames at[] And iat[]

Lecture 27 Filling And Replacing Values In DataFrames

Lecture 28 Arithmetic Operations On DataFrames

Lecture 29 Concatenating DataFrames

Lecture 30 Merging And Joining DataFrames

Section 6: Advanced Pandas Function

Lecture 31 Recap And Planning This Lesson

Lecture 32 Pivot Tables

Lecture 33 GroupBy In DataFrames

Lecture 34 Binning Values And The Cut Function

Lecture 35 MultiLevel Indexing In DataFrames

Lecture 36 Filling Missing Values

Section 7: Time and Time Series in Pandas

Lecture 37 Date Time In Python

Lecture 38 Time Zones And Time Deltas In Python

Lecture 39 Rolling And Shift Functions

Section 8: Reading and Writing Data with Pandas

Lecture 40 Reading And Writing Files With Pandas

Section 9: Data Visualization with Pandas

Lecture 41 Plotting Graphs Bars And Histograms

Lecture 42 Boxplots

Lecture 43 Area Plots

Lecture 44 Scatter Points

Lecture 46 Conclusion

Section 10: Pandas Exercises

Lecture 47 Pandas Exercises

Lecture 48 Exercise 1 Financial Data Analysis

Lecture 49 Exercise 2 Stacked BarPlots In Pandas

Lecture 50 Exercise 3 Dinner With Friends

Lecture 51 Exercise 4 Oil spill in water: Data cleaning example

Lecture 52 Exercise 5 Financial Trading Analysis/Prediction

Lecture 53 Exercise 6 Financial Trading: analyzing the engulfing candles

Beginner in Python building Data Science skills for real world applications