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

Using Python with Excel

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

Python is one of the world's most widely used object-oriented programming languages. It's a powerful tool that can help you streamline workflows as a developer and a data scientist. In this course, join instructor George Mount to learn how to combine the power of the Python language with the data analysis and reporting tools built into Microsoft Excel.

Discover how to leverage the pandas and openpyxl libraries to inspect, filter, clean, and convert data and how to build solid reports that help businesses take action. Learn how to work with large amounts of data that would be unmanageable in Excel alone, managing and manipulating data sets like a pro. By the end of this course, you’ll be prepared to use Python with Excel to start leading your business to better insights than ever before.

This course was created by Madecraft. We are pleased to host this training in our library.

 


01 - Introduction
  • 01 - Managing Excel with Python

  • 02 - 1. Python and pandas
  • 01 - Jupyter Notebooks basics
  • 02 - Introducing the Python pandas library
  • 03 - Loading and saving data with pandas
  • 04 - Viewing and inspecting data with pandas
  • 05 - Manipulating data with pandas
  • 06 - Working with dates and times in pandas

  • 03 - 2. openpyxl
  • 01 - Using openpyxl with Workbooks
  • 02 - Selecting cells, rows, and columns
  • 03 - Adding workbook formatting
  • 04 - Creating names, ranges, and tables

  • 04 - 3. Working with Reports
  • 01 - Managing multiple sheets
  • 02 - Working with large worksheets
  • 03 - Conditional formatting
  • 04 - Creating Excel plots in Python
  • 05 - Exporting Python plots to Excel

  • 05 - Conclusion
  • 01 - Next steps
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 19366
    حجم: 124 مگابایت
    مدت زمان: 57 دقیقه
    تاریخ انتشار: 21 شهریور 1402
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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