Trang chủ

Business Analytics & Intelligence

Data Analysis

Pandas Basics - Replace Excel with Python Data Analysis

Pandas Basics - Replace Excel with Python Data Analysis

Loại khoá học: Business Analytics & Intelligence

PYTHON data analysis using the Pandas library to manipulate datasets and automate tasks from Excel practical application

50.000 VND

399.000 VND

Đầy Đủ Bài Giảng

Học Online Tiện Lợi

Kích Hoạt Nhanh 2-5 Phút

Thanh toán tự động

Được phép tải xuống

Mô tả

Level up your Excel data analysis skills by transitioning from Excel to Python seamlessly with my tailored course designed exclusively for professionals. Discover the power of the Python's Pandas library in handling large datasets, automating boring and repetitive tasks, and simplifying data management.

What sets this course apart?

Real-world Application: This course isn’t a generic Python tutorial. It's crafted by a seasoned finance professional for professionals. Hence, every lesson, tip, and trick is rooted in real-life scenarios.
From Basics to Advanced: Whether you're a novice or someone who's dabbled in Python before, this course caters to all. It commences with the foundational aspects of Python and Pandas and gradually dives into advanced techniques ensuring a comprehensive learning experience.
Practical Focus: We understand that finance professionals mostly deal with CSV and Excel files. This course primarily revolves around these, but we also touch upon importing data in varied formats.
End-to-end Learning: Apart from learning Python and Pandas, get acquainted with the Jupyter Notebooks programming environment. Follow along as we delve deep into importing, inspecting, and manipulating data. Master the art of data cleaning using string functions, and ascertain ways to avoid errors. Conclusively, we’ll guide you on summarizing your data, ensuring it’s export-ready.

Bạn sẽ học được gì

Yêu cầu

Nội dung khoá học

29 sections

Introduction to the Course

4 lectures

Introduction

03:58

Course Structure

05:07

Tips for Success

13:28

Introduction to Our Dataset

03:50

Using Jupyter Notebooks

5 lectures

Installing Jupyter Notebooks

02:08

Using Jupyter Notebooks - Introduction

06:45

Using Jupyter Notebooks - Code Colours

02:48

Using Jupyter Notebooks - Keyboard Shortcuts

09:26

Using Jupyter Notebooks Quiz

4 questions

Introduction to Python

5 lectures

Introduction to Python - Basics

12:07

Introduction to Python Quiz

9 questions

Introduction to Python - Attributes and Functions

16:18

Attributes and Functions

9 questions

Introduction to Python - Lists, Tuples and Dictionaries

07:15

Introduction to Pandas

2 lectures

Index

16:55

Series and Dataframe

05:57

Importing Data

15 lectures

Importing a CSV File

04:59

Using Variables to Store File Paths

05:14

Importing Excel, Other File Formats and Online Files

05:03

Importing Specific Columns

09:09

Setting a Column as Index

08:27

Renaming Column Labels

10:02

Specifying the Header Row

05:17

Exclude Rows From Being Imported

07:11

Exclude Footers from Being Imported

04:31

Import Rows Partially

02:42

Keep Blank Rows

01:23

Specify Null Values

03:32

Convert Floats to Strings

06:17

Convert Date Columns to Date Format

06:17

Specifying Which Excel Sheet to Import

08:55

Working with the Index

9 lectures

Index Terminology

09:48

Derive Dataframe Index Values

05:14

Deriving the Value of the Index Given a Location

05:15

Assigning a Column to be the Index

10:08

Removing or Resetting Index Labels

12:34

Changing the Order of a Multi-Index

05:49

Sorting Data Using the Index

09:45

Searching and Filtering Based on an Index Label

12:55

Renaming the Index Using a List

06:17

Inspecting Your Dataframe

3 lectures

Viewing a Portion of the Data

09:41

Show the Largest or Smallest Values

09:03

Inspecting Dataframe Attributes

06:09

Inspecting Column Contents

6 lectures

Count the Occurrence of Column Values

07:38

Descriptive Statistics

05:57

Cumulative Max, Min and Sum Values

03:33

Checking for Null Values

04:55

Checking for Unique and Duplicate Values

07:07

Searching for the Presence of a Value

11:12

Comparisons

4 lectures

Column Value Comparison

06:26

Comparing Two Columns

05:40

Index Value Comparison

07:21

Comparing Columns from Two Dataframes

06:08

Working with Data Types

4 lectures

Data Types Overview

10:45

Converting to Datetime

06:40

Converting to String and Numeric

14:13

Converting to Categorical

16:57

Renaming Columns

3 lectures

Using a Dictionary

07:26

Using a List

06:36

Using String Functions

08:20

Selecting or Referencing Columns

1 lectures

Selecting or Referencing Columns

09:22

Removing Columns

2 lectures

Using the Drop Function

02:24

Using the Pop Function

02:19

Filtering Columns

4 lectures

Filtering Columns Using a List

04:06

Filtering Columns Using the Filter Function

08:08

Filtering Columns by Data Types

03:16

Filtering Columns Using the Slicing Object

08:40

Rearranging Columns

4 lectures

Rearranging Columns Using a List

03:59

Rearranging Columns Using a Slice Object

06:13

Based on a Reference Column

11:44

Using Filter and List Comprehension

08:15

Selecting Rows

1 lectures

Selecting Rows Using .loc and .iloc

08:46

Filtering Rows

9 lectures

Filtering Duplicate Rows

11:44

Filtering with a Single Condition

09:12

Filtering Rows with Multiple Conditions

07:09

Filtering Numeric Values Falling within a Range

06:10

Filtering Rows Based on Occurrence from a List

04:43

Filtering Rows for Null Values

04:25

Filtering Rows Containing a Substring

07:04

Filtering Rows Based on Top Occurrence

03:50

Filtering Rows Using the Query Function

03:59

Rearranging Rows

1 lectures

Sorting Rows Using Column Values

11:08

Operations

1 lectures

Operations - Arithmetic Operations

05:39

Adding Data

3 lectures

Adding Data Using the Index Operator

04:07

Adding Data Using the Assign Function

03:02

Adding Data at a Specific Position Using the Insert Function

08:14

Adding Data Based on a Condition

4 lectures

Adding Data Based on a Condition Using a Boolean Array

06:42

Adding Data Based on a Condition Using the Where Function

09:02

Adding Data Based on a Condition Using the Map Function

07:07

Adding Data Based on a Condition Based on Numeric Ranges

15:24

Amending Existing Data

2 lectures

Amending All Values in a Column

08:59

Amending Column Data Partially

06:02

Setting with Copy Warning

6 lectures

Setting with Copy Warning - Example 1

05:05

Setting with Copy Warning - Example 2

05:46

Setting with Copy Warning - Example 3

05:34

Setting with Copy Warning - Example 4

05:01

Setting with Copy Warning - Example 5

05:14

Setting with Copy Warning - Example 6

05:20

String Operations

7 lectures

String Operations - Removing Leading or Trailing Spaces or Characters

06:10

String Operations - Replace Instances of Strings

07:18

String Operations - Search for Values in a Column Not Present in Another Column

05:46

String Operations - String Casing

02:20

String Operations - Combine Several Rows of Strings by Group

08:38

String Operations - Deriving Substrings

03:38

String Operations - Add Leading Zeroes

04:12

Dealing with Null Values

3 lectures

Null Values - Searching for Null Values

07:53

Null Values - Replacing Null Values

05:10

Null Values - Dropping Null Values

03:37

Concatenate, Merge and Join

2 lectures

Concatenate and Append

10:18

Merge

11:51

Groupby

1 lectures

Groupby Syntax

18:28

Summarising Data - Pivot Table

5 lectures

Pivot Table - Introduction

03:29

Pivot Table - Aggregating Functions

03:07

Pivot Table - Aggregating Values

04:59

Pivot Table - Dealing with Null Values and Totals

09:08

Pivot Table - Columns

07:23

Export Data

4 lectures

Export to Excel or CSV - Simple Method

07:49

Export to Excel - Set Column Widths

08:52

Export to Excel - Set Columns with Number Formatting

07:33

Export to Excel - Dynamic Column Referencing

11:08

Đánh giá của học viên

Chưa có đánh giá

Course Rating

5

0%

4

0%

3

0%

2

0%

1

0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Email

Nội dung

Khoá học liên quan

Oracle SQL Performance Tuning Masterclass (2024)

Oracle SQL Performance Tuning Masterclass (2024)

Excel ứng dụng trong phân tích tài chính

Excel ứng dụng trong phân tích tài chính

ChatGPT Complete Guide: Learn Midjourney, ChatGPT 4 & More

ChatGPT Complete Guide: Learn Midjourney, ChatGPT 4 & More

Master Excel and Solve 500 Problems (Beginner - Advanced)

Master Excel and Solve 500 Problems (Beginner - Advanced)

Unlock Excel VBA and Excel Macros

Unlock Excel VBA and Excel Macros

Làm chủ VBA Excel để tự động hóa công việc

Làm chủ VBA Excel để tự động hóa công việc

59 ChatGPT HACKS To Make Money Online in 2024

59 ChatGPT HACKS To Make Money Online in 2024

The Data Analyst Course: Complete Data Analyst Bootcamp

The Data Analyst Course: Complete Data Analyst Bootcamp

Microsoft Excel: Data Analysis with Excel Pivot Tables

Microsoft Excel: Data Analysis with Excel Pivot Tables

Microsoft Excel: Advanced Excel Formulas & Functions

Microsoft Excel: Advanced Excel Formulas & Functions

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

Khoá học Google Apps Script nâng cao trong Google Sheets

Khoá học Google Apps Script nâng cao trong Google Sheets

SAP ABAP Programming For Beginners - Online Training

SAP ABAP Programming For Beginners - Online Training

Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel

Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel

Microsoft Excel: Data Visualization with 20+ Excel Charts

Microsoft Excel: Data Visualization with 20+ Excel Charts

Microsoft Excel: Business Intelligence w/ Power Query & DAX

Microsoft Excel: Business Intelligence w/ Power Query & DAX

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi