From the course: Python in Excel: Getting Started with Data Analysis

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Introduction to DataFrames

Introduction to DataFrames

From the course: Python in Excel: Getting Started with Data Analysis

Start my 1-month free trial Buy for my team

Introduction to DataFrames

“

- [Instructor] So far, we've seen how to work with basic Python code in our workbooks, and how to access content in workbooks using the XL function to get data into our Python logic. In this chapter, we're going to learn more about working with data using Python, and we're going to start by examining the pandas DataFrame. If you're already familiar with the basics of DataFrames, you can feel free to skip over this video. A DataFrame is essentially a two-dimensional tabular data structure provided by the pandas library. They are very similar to the data tables that Excel already provides, but they have a lot of built-in features that make them very well suited for performing data operations. Each row in a DataFrame represents an individual set of data content, while each column represents a variable or a feature of that data. Each column has a unique name, and rows are accessed by an integer index value. DataFrames make it really easy to access and manipulate their data content, and…

Contents