5 Development Team 20 4.6 License 20 5 Intro to Data Structures 23 5.1 Series 23 5.2 DataFrame 27 5.3 Panel 40 6 Essential basic functionality 43 6.1 Head and Tail 43 6.2 Attributes .... 80 7.4 Hierarchical indexing (MultiIndex) ..... 81 7.5 Adding an index to an existing DataFrame ..... 90 7.6 Indexing internal details ..... 92 8 Computational tools ..... 95 8.1 Statistical objects ..... 129 11.2 Database-style DataFrame joining/merging ..... 137 12 Reshaping and Pivot Tables ..... 147 12.1 Reshaping by pivoting DataFrame objects ..... 147 12.2 Reshaping by stacking

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175 2.2.2 DataFrame . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180 2.3 Essential . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 508 2.7.2 Database-style DataFrame or named Series joining/merging . . . . . . . . . . . . . . . . . 518 2.7.3 Timeseries friendly . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 543 2.8.1 Reshaping by pivoting DataFrame objects . . . . . . . . . . . . . . . . . . . . . . . . . . . 543 2.8.2 Reshaping by stacking and

. . . . . . . . . . 100 3 Frequently Asked Questions (FAQ) 101 3.1 How do I control the way my DataFrame is displayed? . . . . . . . . . . . . . . . . . . . . . . . . . 101 3.2 Adding Features to your . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147 8.2 DataFrame . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279 10.25 Adding an index to an existing DataFrame . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 280 10.26 Add an index using DataFrame columns . . . . . . . . . . . . . . . . . .

5 Development Team 24 4.6 License 24 5 Intro to Data Structures 27 5.1 Series 27 5.2 DataFrame 31 5.3 Panel 44 6 Essential basic functionality 49 6.1 Head and Tail 49 6.2 Attributes .... 86 7.4 Hierarchical indexing (MultiIndex) ..... 87 7.5 Adding an index to an existing DataFrame ..... 96 7.6 Indexing internal details ..... 98 8 Computational tools ..... 101 8.1 Statistical objects ..... 137 11.2 Database-style DataFrame joining/merging ..... 145 12 Reshaping and Pivot Tables ..... 155 12.1 Reshaping by pivoting DataFrame objects ..... 155 12.2 Reshaping by stacking

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 2.2.2 DataFrame . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180 2.3 Essential . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 505 2.7.2 Database-style DataFrame or named Series joining/merging . . . . . . . . . . . . . . . . . 519 2.7.3 Timeseries friendly . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 544 2.8.1 Reshaping by pivoting DataFrame objects . . . . . . . . . . . . . . . . . . . . . . . . . . . 544 2.8.2 Reshaping by stacking and

5 Development Team 20 4.6 License 20 5 Intro to Data Structures 23 5.1 Series 23 5.2 DataFrame 27 5.3 Panel 40 6 Essential basic functionality 43 6.1 Head and Tail 43 6.2 Attributes .... 80 7.4 Hierarchical indexing (MultiIndex) ..... 81 7.5 Adding an index to an existing DataFrame ..... 90 7.6 Indexing internal details ..... 92 8 Computational tools ..... 95 8.1 Statistical Concatenating objects ..... 129 11.2 Database-style DataFrame joining/merging ..... 137 12 Reshaping and Pivot Tables ..... 147 12.1 Reshaping by pivoting DataFrame objects ..... 147 12.2 Reshaping by stacking

5 Bug Fixes ..... 135 1.9 v0.16.0 (March 22, 2015) ..... 137 1.9.1 New features ..... 138 DataFrame Assign ..... 138 Interaction with scipy.sparse ..... 140 String Methods Enhancements ..... 141 12 v0.15.0 (October 18, 2014) ..... 165 1.12.1 New features ..... 166 Categoricals in Series/DataFrame ..... 166 TimedeltaIndex/Scalar ..... 167 Memory Usage ..... 170 .dt accessor ..... 171 237 1.16.5 Float64Index API Change ..... 239 1.16.6 HDFStore API Changes ..... 241 1.16.7 DataFrame repr Changes ..... 244 1.16.8 Enhancements ..... 244 1.16.9 Experimental ..... 251 1.16.10

Converting to Markdown We’ve added to_markdown() for creating a markdown table (GH11052) In [1]: df = pd.DataFrame({"A": [1, 2, 3], "B": [1, 2, 3]}, index=['a', 'a', 'b']) In [2]: print(df.to_markdown()) | | A | array. A StringArray can only store strings. 2. object dtype breaks dtype-specific operations like DataFrame.select_dtypes(). There isn’t a clear way to select just text while excluding non-text, but still string accessor methods work. Where appropriate, the return type of the Series or columns of a DataFrame will also have string dtype. In [12]: s.str.upper() Out[12]: 0 ABC (continues on next page) 1.3

Installing pandas 163 2.3 Dependencies 166 3 Frequently Asked Questions (FAQ) 169 3.1 DataFrame memory usage 169 3.2 PeriodIndex / DateArray properties and functions 172 3.3 Frequency conversion Creating Example Data ..... 235 8 Intro to Data Structures ..... 237 8.1 Series ..... 237 8.2 DataFrame ..... 242 8.3 Panel ..... 254 8.4 Panel4D (Experimental) ..... 258 8.5 PanelND (Experimental) 17.2 Database-style DataFrame joining/merging ..... 462 17.3 Merging with Multi-indexes ..... 471 18 Reshaping and Pivot Tables ..... 475 18.1 Reshaping by pivoting DataFrame objects ..... 475

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 2.2.2 DataFrame . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180 2.3 Essential . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 505 2.7.2 Database-style DataFrame or named Series joining/merging . . . . . . . . . . . . . . . . . 519 2.7.3 Timeseries friendly . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 543 2.8.1 Reshaping by pivoting DataFrame objects . . . . . . . . . . . . . . . . . . . . . . . . . . . 543 2.8.2 Reshaping by stacking and