وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 24243
    حجم: 2431 مگابایت
    مدت زمان: 351 دقیقه
    تاریخ انتشار: 13 آذر 1402
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید