LinkedIn – Python in Excel: Working with pandas DataFrames 2024-4

Python in Excel course: Working with pandas DataFrames. This course teaches you how to analyze data using Pandas DataFrames in Excel. Pandas is a powerful library in Python that allows you to work efficiently with structured data. In this course, you will learn the basic concepts of DataFrames, including data selection, calculations, filtering, manipulation, and charting. In addition, you will learn how to clean data, work with textual data, combine DataFrames, aggregate data, and analyze time series. At the end of the course, you will be able to use Pandas to solve a wide range of data analysis problems in Excel.

What you will learn:

• How to create and work with Pandas DataFrames
• How to select and filter data
• How to perform calculations and manipulate data
• How to clean data and work with textual data
• How to combine DataFrames and collect data
• How to analyze time series
• How to draw a diagram using Pandas

This course is suitable for people who:

• Interested in learning how to use Python to analyze data in Excel.
• Already familiar with the basics of Python.
• They have experience working with Excel.
• Want to improve their skills in data analysis.