Python in Excel 2023 Masterclass for Data Science

سرفصل های دوره

Super-exciting BRAND-NEW Excel Feature for early adopters! Use Pandas, Seaborn, Scikit-Learn & more directly in Excel!

1. Getting started

1. Welcome

2. How to get the most out of this course

3. Python in Excel How it works & what you need

4. Python in Excel Features & alternative Tools (xlwings)

5. How to set up Python in Excel (BETA)

6. Troubleshooting

2. Python in Excel - First Steps and Must Knows

1. Introduction

2.1 Book1 SimpleOps.xlsx

2. Simple Operations using the PY Function

3.1 Book2 Variables vs References.xlsx

3. Python Variables vs. Excel Cell References

4.1 Book3 DataTypes.xlsx

4. Python Objects and Data Types

5.1 Book4 NoneTypes.xlsx

5. NoneType Objects

6.1 Book5 OutputTypes.xlsx

6. Output Types Python Output vs. Excel Value

7.1 Book6 ExtractData.xlsx

7. Extracting Data from Python Objects to Excel

8.1 Book7 Diagnostics.xlsx

8. Diagnostics

9.1 Book8 CaluclationOrder.xlsx

9. Calculation Order and Recalculation

10.1 Book9 Initialization.xlsx

10. Initialization Settings and Customizations

11.1 Book10 Functions.xlsx

11. User-defined Functions and Classes

12.1 Book11 Plots.xlsx

12. Python Plots (Matplotlib & Seaborn)

3. Project 1 Explanatory Data Analysis (EDA) with Python and Excel

1.1 Project1 EDA.zip

1. Project Introduction and Downloads

2. Instructions and Hints

3. Excursus Project Solution in a Jupyter Notebook

4. Task 1 How to load and import the Dataset

5. Task 2 Initial Data Inspection

6. Task 3 Univariate Data Analysis 1

7. Task 4 Univariate Data Analysis 2

8. Task 5 Multivariate Data Analysis 1

9. Task 6 Multivariate Data Analysis 2

10. Task 7 Multivariate Data Analysis 3

4. Project 2 Time Series and Financial Data Analysis with Python in Excel

1.1 Project2 FinancialDataAnalysis.zip

1. Project Introduction and Downloads

2. Instructions and Hints

3. Excursus Project Solution in a Jupyter Notebook

4. Task 1 How to load the Dataset and Initial Data Inspection

5. Task 2 How to create dynamic Price Charts

6. Task 3 Dynamic Resampling and Financial Returns

7. Task 4 Statistics and Performance Analysis

8. Task 5 Covariance and Correlation Matrix and Heatmaps

5. Bonus Project Using Python in Excel and xlwings together - the ultimate Boost

1.1 First Steps.zip

1. Introduction & Downloads

2. Set up and Installation of xlwings

3. How to use xlwings as a Data Viewer

4. Data Viewer - Update

5. How to connect to an Excel Workbook

6. How to read and write single Values

7.1 RunPython.zip

7. Introduction to Running Python Scripts in Excel & Downloads

8.1 Add-in File Download.html

8. Installing the xlwings add-in and other preparations

9. Running Python Scripts with Run main

10.1 Troubleshooting Link.html

10. Troubleshooting

11.1 Case Study.zip

11. Bonus Project Introduction & Downloads

12. Instruction and Hints

13. Solution

6. Appendix Installing and working with Anaconda and Jupyter Notebooks

1. Download and Install Anaconda

2. How to open Jupyter Notebooks

3. How to work with Jupyter Notebooks

7. Whats next (outlook and additional resources)

1. Bonus Lecture.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy