Watch Python in Excel 2023 Masterclass for Data Science Free Online - Full Video Classroom | MJ Accedemy

Udemy – Python in Excel 2023 Masterclass for Data Science 2024-3

Download Course (Free)

Lecture 16/57

00:00/00:00

Lecture 16 of 57

User-defined Functions and Classes

Download Course (Free)

Course Content

0 / 57 completed

Section 1: Getting started7 videos

Sneak Preview Merging and joining Data with Pandas in Excel

16m

Python in Excel Features & alternative Tools (xlwings)

29m

Python in Excel How it works & what you need

Welcome

How to get the most out of this course

18m

How to set up Python in Excel (BETA)

Troubleshooting

13m

Section 2: Python in Excel - First Steps and Must Knows12 videos

Introduction

Simple Operations using the PY Function

25m

Python Variables vs. Excel Cell References

15m

Python Objects and Data Types

34m

NoneType Objects

28m

Extracting Data from Python Objects to Excel

20m

Diagnostics

16m

Output Types Python Output vs. Excel Value

29m

User-defined Functions and Classes

6mNow Playing

Initialization Settings and Customizations

23m

Calculation Order and Recalculation

35m

Python Plots (Matplotlib & Seaborn)

48m

Section 3: Project 1 Explanatory Data Analysis (EDA) with Python and Excel10 videos

Project Introduction and Downloads

13m

Instructions and Hints

24m

Excursus Project Solution in a Jupyter Notebook

15m

Task 3 Univariate Data Analysis 1

27m

Task 2 Initial Data Inspection

45m

Task 4 Univariate Data Analysis 2

14m

Task 1 How to load and import the Dataset

35m

Task 5 Multivariate Data Analysis 1

19m

Task 7 Multivariate Data Analysis 3

20m

Task 6 Multivariate Data Analysis 2

18m

Section 4: Project 2 Time Series and Financial Data Analysis with Python in Excel5 videos

Task 1 How to load the Dataset and Initial Data Inspection

26m

Task 3 Dynamic Resampling and Financial Returns

27m

Task 5 Covariance and Correlation Matrix and Heatmaps

20m

Task 4 Statistics and Performance Analysis

26m

Task 2 How to create dynamic Price Charts

47m

Section 5: Project 3 Merging and aggregating Data with Pandas in Excel2 videos

Task 1 Creating and Aggregating DataFrames

31m

Task 2 Creating a tool to joinmerge Datasets with full flexibility

30m

Section 6: Project 4 Multiple Regression Analysis, Hypothesis Testing and Preprocessing6 videos

Coding Solution (Part 1)

29m

Project Introduction, Downloads and Hints

39m

Coding Solution (Part 2)

20m

Coding Solution (Part 3)

49m

Implementation & Feature Elimination in Excel (Part 2)

50m

Implementation & Feature Elimination in Excel (Part 1)

43m

Section 7: Bonus Project Using Python in Excel and xlwings together - the ultimate Boost12 videos

Set up and Installation of xlwings

Data Viewer - Update

How to use xlwings as a Data Viewer

33m

Introduction to Running Python Scripts in Excel & Downloads

How to connect to an Excel Workbook

28m

How to read and write single Values

18m

Installing the xlwings add-in and other preparations

25m

Troubleshooting

11m

Running Python Scripts with Run main

Bonus Project Introduction & Downloads

23m

Instruction and Hints

22m

Solution

29m

Section 8: Appendix Installing and working with Anaconda and Jupyter Notebooks3 videos

Download and Install Anaconda

29m

How to work with Jupyter Notebooks

37m

How to open Jupyter Notebooks

38m

About this Lecture

Section: Python in Excel - First Steps and Must Knows • Size: 13.95 MB • Duration: 6m

Course Summary

Python in Excel 2023 Masterclass for Data Science is a training course on the integration of Python and Excel for data science, published by Udemy Online Academy. Integrating Python and Excel for data science involves leveraging the strengths of both tools to perform data analysis, manipulation, visualization, and automation. Excel, a widely used spreadsheet application, is known for its user-friendly interface and powerful data management capabilities. Python, a versatile programming language, excels in data manipulation, statistical analysis and machine learning. The combination of these tools can significantly enhance data science workflows, enabling users to efficiently manage large data sets, perform complex analyses, and create sophisticated visualizations.This integration enhances data analysis workflows and makes it easier to manage large data sets, perform complex calculations, create complex visualizations, and automate repetitive tasks. By combining these tools, data scientists can unlock new levels of efficiency and insight, driving better decision-making and more effective data-driven strategies. In this course, you will learn how to use the full power of Python and Excel in data science by integrating them together. This course is recommended for Python data scientists looking to do their work in Excel and frequent Excel users looking to enhance their work results with Python code in Excel.

Course Content

0 / 57 completed

Section 1: Getting started7 videos

Sneak Preview Merging and joining Data with Pandas in Excel

16m

Python in Excel Features & alternative Tools (xlwings)

29m

Python in Excel How it works & what you need

Welcome

How to get the most out of this course

18m

How to set up Python in Excel (BETA)

Troubleshooting

13m

Section 2: Python in Excel - First Steps and Must Knows12 videos

Introduction

Simple Operations using the PY Function

25m

Python Variables vs. Excel Cell References

15m

Python Objects and Data Types

34m

NoneType Objects

28m

Extracting Data from Python Objects to Excel

20m

Diagnostics

16m

Output Types Python Output vs. Excel Value

29m

User-defined Functions and Classes

6mNow Playing

Initialization Settings and Customizations

23m

Calculation Order and Recalculation

35m

Python Plots (Matplotlib & Seaborn)

48m

Section 3: Project 1 Explanatory Data Analysis (EDA) with Python and Excel10 videos

Project Introduction and Downloads

13m

Instructions and Hints

24m

Excursus Project Solution in a Jupyter Notebook

15m

Task 3 Univariate Data Analysis 1

27m

Task 2 Initial Data Inspection

45m

Task 4 Univariate Data Analysis 2

14m

Task 1 How to load and import the Dataset

35m

Task 5 Multivariate Data Analysis 1

19m

Task 7 Multivariate Data Analysis 3

20m

Task 6 Multivariate Data Analysis 2

18m

Section 4: Project 2 Time Series and Financial Data Analysis with Python in Excel5 videos

Task 1 How to load the Dataset and Initial Data Inspection

26m

Task 3 Dynamic Resampling and Financial Returns

27m

Task 5 Covariance and Correlation Matrix and Heatmaps

20m

Task 4 Statistics and Performance Analysis

26m

Task 2 How to create dynamic Price Charts

47m

Section 5: Project 3 Merging and aggregating Data with Pandas in Excel2 videos

Task 1 Creating and Aggregating DataFrames

31m

Task 2 Creating a tool to joinmerge Datasets with full flexibility

30m

Section 6: Project 4 Multiple Regression Analysis, Hypothesis Testing and Preprocessing6 videos

Coding Solution (Part 1)

29m

Project Introduction, Downloads and Hints

39m

Coding Solution (Part 2)

20m

Coding Solution (Part 3)

49m

Implementation & Feature Elimination in Excel (Part 2)

50m

Implementation & Feature Elimination in Excel (Part 1)

43m

Section 7: Bonus Project Using Python in Excel and xlwings together - the ultimate Boost12 videos

Set up and Installation of xlwings

Data Viewer - Update

How to use xlwings as a Data Viewer

33m

Introduction to Running Python Scripts in Excel & Downloads

How to connect to an Excel Workbook

28m

How to read and write single Values

18m

Installing the xlwings add-in and other preparations

25m

Troubleshooting

11m

Running Python Scripts with Run main

Bonus Project Introduction & Downloads

23m

Instruction and Hints

22m

Solution

29m

Section 8: Appendix Installing and working with Anaconda and Jupyter Notebooks3 videos

Download and Install Anaconda

29m

How to work with Jupyter Notebooks

37m

How to open Jupyter Notebooks

38m