pandas: powerful Python data analysis toolkit

1 pandas : powerful Python data analysistoolkitRelease McKinney & PyData Development TeamMarch 17, 2016 CONTENTS1 What s (March 13, 2016) .. (November 21, 2015) .. (October 9, 2015) .. (June 12, 2015) .. (May 11, 2015) .. (March 22, 2015) .. (December 12, 2014) .. (November 9, 2014) .. (October 18, 2014) .. (July 11, 2014) .. (May 31 , 2014) .. (February 3, 2014) .. (January 3, 2014) .. (July 24, 2013) .. (April 22, 2013) .. (January 22, 2013) .. (December 17, 2012) .. (November 14, 2012) .. (October 7, 2012) .. (July 22, 2012).

2 (June 29, 2012) .. (April 12, 2012) .. (March 16, 2012) .. (February 29, 2012) .. (February 9, 2012) .. (December 13, 2011) .. (November 25, 2011) .. (October 24, 2011) .. through (September 25 - October 9, 2011) .. 2572 version support .. pandas .. 2623 Contributing to to start? .. reports and enhancement requests .. with the code .. to the documentation .. to the code base .. your changes topandas.. 2754 Frequently Asked Questions (FAQ) memory usage .. Issues .. data in Qt applications .. 2815 Package structures at a glance.

3 And copying of data .. Support .. Team .. 2846 10 Minutes to Creation .. data .. data .. Series .. Categoricals .. Plotting .. Getting data In/Out .. Gotchas .. 3097 Guides .. Cookbook .. for New pandas Users .. data analysis with Python .. charts with pandas , vincent and xlsxwriter .. Tutorials .. 3128 .. data .. In/Out .. Computation .. Timedeltas .. Aliasing Axis Names .. Creating Example data .. 3459 Intro to data .. (Experimental) .. (Experimental) .. 37210 Essential Basic Head and Tail.

4 Attributes and the raw ndarray(s) .. Accelerated operations .. Flexible binary operations .. Descriptive statistics .. Function application .. Reindexing and altering labels .. Iteration ..dt accessor .. Vectorized string methods .. Sorting .. Copying .. dtypes .. Selecting columns based ondtype.. 42411 Working with Text Splitting and Replacing Strings .. Indexing .. Extracting Substrings .. Testing for Strings that Match or Contain a Pattern .. Creating Indicator Variables .. Method Summary .. 43612 Options and Overview.

5 Getting and Setting Options .. Setting Startup Options in Python /ipython Environment .. Frequently Used Options .. Available Options .. Number Formatting .. Unicode Formatting .. 44813 Indexing and Selecting Different Choices for Indexing .. Basics .. Attribute Access .. Slicing ranges .. Selection By Label .. Selection By Position .. Selecting Random Samples .. Setting With Enlargement .. Fast scalar value getting and setting .. Boolean indexing .. Indexing with isin .. Thewhere()Method and Masking .. Thequery()Method (Experimental).

6 Duplicate data .. Dictionary-likeget()method .. Theselect()Method .. Thelookup()Method .. Index objects .. Set / Reset Index .. Returning a view versus a copy .. 49414 MultiIndex / Advanced Hierarchical indexing (MultiIndex) .. Advanced indexing with hierarchical index .. The need for sortedness withMultiIndex.. Take Methods .. Index Types .. 51515 Computational Statistical Functions .. Window Functions .. Aggregation .. Expanding Windows .. Exponentially Weighted Windows .. 54216 Working with missing Missing data basics .. Datetimes.

7 Inserting missing data .. Calculations with missing data .. Cleaning / filling missing data .. Missing data casting rules and indexing .. 56617 Group By: Splitting an object into groups .. Iterating through groups .. Selecting a group .. Aggregation .. Transformation .. Filtration .. Dispatching to instance methods .. Flexibleapply.. Other useful features .. Examples .. 59518 Merge, join, and Concatenating objects .. Database-style DataFrame joining/merging .. 60819 Reshaping and Pivot Reshaping by pivoting DataFrame objects.

8 Reshaping by stacking and unstacking .. Reshaping by Melt .. Combining with stats and GroupBy .. Pivot tables and cross-tabulations .. Tiling .. Computing indicator / dummy variables .. Factorizing values .. 63920 Time Series / Date Overview .. Time Stamps vs. Time Spans .. Converting to Timestamps .. Generating Ranges of Timestamps .. DatetimeIndex .. DateOffset objects .. Time series-related instance methods .. Resampling .. Time Span Representation .. Converting between Representations .. Representing out-of-bounds spans.

9 Time Zone Handling .. 68221 Time Parsing .. Operations .. Reductions .. Frequency Conversion .. Attributes .. TimedeltaIndex .. Resampling .. 70222 Categorical Object Creation .. Description .. Working with categories .. Sorting and Order .. Comparisons .. Operations .. data munging .. Getting data In/Out .. Missing data .. Differences to R sfactor.. Gotchas .. 72623 Basic Plotting:plot.. Other Plots .. Plotting with Missing data .. Plotting Tools .. Plot Formatting .. Plotting directly with matplotlib.

10 Trellis plotting interface .. 79824 Style81325 IO Tools (Text, CSV, HDF5, ..) CSV & Text files .. JSON .. HTML .. Excel files .. Clipboard .. Pickling .. msgpack (experimental) .. HDF5 (PyTables) .. SQL Queries .. Google BigQuery (Experimental) .. Stata Format .. SAS Formats .. Other file formats .. Performance Considerations .. 91126 Remote data Yahoo! Finance .. Yahoo! Finance Options .. Google Finance .. FRED .. Fama/French .. World Bank .. Google Analytics .. 92227 Enhancing Cython (Writing C extensions for pandas ).