From the course: Python in Excel
Join today to access over 24,700 courses taught by industry experts.
Using pandas DataFrames in Excel
From the course: Python in Excel
Using pandas DataFrames in Excel
- We've seen how to run basic Python scripts within Excel and how to pass values back and forth between Python and Excel. Now let's dive a bit deeper into working with data using Python libraries. We'll look specifically at pandas, a library that's widely used in data science and data analysis. Pandas works with information organized in data frames. A data frame is what we might think of in Excel as a table or a range, a two-dimensional set of values with columns and rows representing some structured or related data or observations. When we reference a range of values or a table in a Python cell, it's represented as a data frame automatically and that gives us the ability to work with this data using Python libraries like Pandas very easily. So for example, I'll create a Python cell over here and provide a variable name. I'll call this one scores and then I'll provide the data from my table. This could be any table…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.