Description
Using Python with Excel course. 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 helps make complex tasks simple. In this course, you will learn how to combine the power of the Python language with the data analysis tools built into Microsoft Excel. Learn how to use the Pandas library and openpyxl libraries to examine, filter and transform data and more. Also, learn how to work with large amounts of data that are unmanageable in Excel alone without using Python, and manage data sets like a professional and manipulate them according to your needs.
What you will learn in Using Python with Excel course
- Introducing the openpyxl Python library
- Using openpyxl
- Selection of cells, rows and columns
- openpyxl with Pandas
- Data conversion
- Parsing large spreadsheets
- Advanced charting with Excel and Python
- Introducing the openpyxl Python library
- Using openpyxl with workbooks
- Selection of cells, rows and columns
- Formatting workbooks
- Charts and diagrams
- Tables and pictures
- Formatting workbooks
- Charts and graphs
- View and inspect data with Pandas
- Tables and pictures
- Introducing the Python Pandas library
- Loading and saving data with Pandas
- Filter and sort with Pandas
- Clear data with Pandas
- And …
Specifications of Using Python with Excel course
Course headings
Pictures of Using Python with Excel course
Sample video of the course
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
114 MB