From the course: Python in Excel: Working with pandas DataFrames

What you should know

- [Narrator] This course builds on top of the introductory course "Python in Excel" so I would recommend you to watch it before starting with this one. If you don't have at least a basic Python knowledge, please watch a course about Python first. There are various beginner courses here on LinkedIn Learning such as "Python for Non-Programmers" or "Learning Python." In every video, I will be using an exercise file in the form of an Excel workbook. You can download these files from the course page. There will be two versions of each file. The name of the first version will finish with _begin, and the other one with _end. To follow along the course, use the one named begin. The file version that is named end represents how the file should look like at the end of the corresponding video. Here is a typical sample file. Most of the time, I will walk you through the Python cells from top to bottom. To see the Python code, I will edit the cell. And to edit a cell, either double click it or hit the F2 key. Alternatively, you can always also see the code here in the formula bar.

Contents