Pandas

Introduction to Pandas

You can think of pandas as an extremely powerful version of Excel, with a lot more features. In this section of the course, you should go through the notebooks in this order:
  • Introduction to Pandas
  • Series
  • DataFrames
  • Missing Data
  • GroupBy
  • Merging,Joining,and Concatenating
  • Operations
  • Data Input and Output

Series


The first main data type we will learn about for pandas is the Series data type. Let's import Pandas and explore the Series object.
A Series is very similar to a NumPy array (in fact it is built on top of the NumPy array object). What differentiates the NumPy array from a Series, is that a Series can have axis labels, meaning it can be indexed by a label, instead of just a number location. It also doesn't need to hold numeric data, it can hold any arbitrary Python Object.
Let's explore this concept through some examples:




Creating a Series

You can convert a list,numpy array, or dictionary to a Series:



Data in a Series

A pandas Series can hold a variety of object types:


Using an Index

The key to using a Series is understanding its index. Pandas makes use of these index names or numbers by allowing for fast look ups of information (works like a hash table or dictionary).
Let's see some examples of how to grab information from a Series. Let us create two sereis, ser1 and ser2:



DataFrames

DataFrames are the workhorse of pandas and are directly inspired by the R programming language. We can think of a DataFrame as a bunch of Series objects put together to share the same index. Let's use pandas to explore this topic!



Selection and Indexing

Let's learn the various methods to grab data from a DataFrame


DataFrame Columns are just Series


Creating a new column:







Conditional Selection

An important feature of pandas is conditional selection using bracket notation, very similar to numpy:




More Index Details

Let's discuss some more features of indexing, including resetting the index or setting it something else. We'll also talk about index hierarchy!






Multi-Index and Index Hierarchy

Let us go over how to work with Multi-Index, first we'll create a quick example of what a Multi-Indexed DataFrame would look like:





Comments

Popular posts from this blog

Matplotlib