Read Excel files from Python
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 PythonOffice Development FAQ
Access • How do I export data from Access to an XML file? (VBA, VB 6) • How do I print an Access Report? (VB 6) • How do I…
View More Office Development FAQIntro to Data Structures
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 StructuresComputational tools
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 toolsTime Series / Date functionality
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 functionalityReshaping and Pivot Tables
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 TablesGroup By: split-apply-combine
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-combineIO Tools (Text, CSV, HDF5, …)
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, …)10 Minutes to Pandas
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 PandasPlotting with matplotlib
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