Description
Course “Using Python with Excel”. Python is one of the most widely used object-oriented programming languages in the world. Python is a powerful language that can help you as a developer. And a data scientist who can handle complex tasks with ease. In this course, you’ll learn how to combine the power of Python with the data analysis tools built into Microsoft Excel. Learn how to use the Pandas library and openpyxl libraries to validate, filter, transform data, and more. In addition, you will learn how to work with large amounts of data that cannot be managed in Excel alone without using Python, and manage and manipulate data sets like a professional to suit your needs.
What you’ll learn in the Using Python with Excel course
- Introducing the Python library openpyxl
- Using openpyxl
- Selecting cells, rows and columns
- openpyxl with pandas
- data conversion
- Parsing large tables
- Advanced Charting with Excel and Python
- Introducing the Python library openpyxl
- Using openpyxl with books
- Selecting cells, rows and columns
- Formatting books
- Charts and graphs
- Tables and pictures
- Formatting books
- Charts and graphs
- Viewing and Inspecting Data with Pandas
- Tables and pictures
- Introducing the Python Pandas Library
- Loading and Saving Data with Pandas
- Filter and sort with Pandas
- Clean data with Pandas
- AND…
Features of the course “Using Python with Excel”
Course headings
Photos from the Using Python with Excel course
Example video course
installation instructions
Once extracted, watch using your favorite player.
English subtitles
Quality: 720p
Download link
Password for file(s): www.downloadly.ir
size
114 MB