From the course: Python in Excel: Working with pandas DataFrames
Unlock the full course today
Join today to access over 23,300 courses taught by industry experts.
pandas DataFrame and Series
From the course: Python in Excel: Working with pandas DataFrames
pandas DataFrame and Series
- [Instructor] Python in Excel is all about working with Pandas DataFrames. So let's see what a DataFrame is and how you can create one from your Excel data. Pandas is Python's go-to library for statistics, data analysis and time-series analysis. The core data structure that Pandas uses is called DataFrame and it looks and behaves a lot like a spreadsheet or a range of a spreadsheet. A DataFrame has three parts. There's the actual data and then there are column headers and row indices. We normally just call them columns and index. It's usually easy to use meaningful column names such as first name or last name where the schema here shows A, B, C, but the index is often used in its default state, which is an integer index starting at zero and incrementing by one with every row, exactly as shown here on the slide. Importantly, a DataFrame column can only host a single data type, so the whole column must be either strings or floats or Booleans, et cetera. When you extract a single column…
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.