Author: calsalmon

Use the excellent xlrd package, which works on any platform. That means you can read Excel files from Python in Linux! Example usage: Open the workbook import…

View More Read Excel files from Python

We’ll start with a quick, non-comprehensive overview of the fundamental data structures in pandas to get you started. The fundamental behavior about data types, indexing,…

View More Intro to Data Structures

Statistical functions Percent Change Both Series and DataFrame has a method pct_change to compute the percent change over a given number of periods (using fill_method to fill NA/null values). In [376]: ser =…

View More Computational tools

pandas has proven very successful as a tool for working with time series data, especially in the financial data analysis space. With the 0.8 release,…

View More Time Series / Date functionality

Reshaping by pivoting DataFrame objects Data is often stored in CSV files or databases in so-called “stacked” or “record” format: In [1450]: df Out[1450]: date…

View More Reshaping and Pivot Tables

By “group by” we are referring to a process involving one or more of the following steps Splitting the data into groups based on some criteria…

View More Group By: split-apply-combine

CSV & Text files The two workhorse functions for reading text files (a.k.a. flat files) areread_csv() and read_table(). They both use the same parsing code to intelligently…

View More IO Tools (Text, CSV, HDF5, …)

This is a short introduction to pandas, geared mainly for new users. Customarily, we import as follows In [1]: import pandas as pd In [2]:…

View More 10 Minutes to Pandas

Plotting with matplotlib Note We intend to build more plotting integration with matplotlib as time goes on. We use the standard convention for referencing the matplotlib API:…

View More Plotting with matplotlib