. . . . . . . . . . . . . . . . . . . . . . . . 858 26 Enhancing Performance 861 26.1 Cython (Writing C extensions for pandas) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 861 26 plotting interface, which exposes each kind of plot as a method of the .plot attribute. Instead of writing series.plot(kind=, ...), you can now also use series.plot.(...): In [10]: df = pd.DataFrame(np inferring from the presence of the HTTP Content-Encoding header in the response (GH8685) • Enable writing Excel files in memory using StringIO/BytesIO (GH7074) • Enable serialization of lists and dicts

. . . . . . . . 386 3.5.3 Test-driven development/code writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 387 3.5.3.1 Writing tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1023 24.1.26 Writing out Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1023 24.1.26.1 Writing to CSV format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1023 24.1.26.2 Writing a formatted string . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1024 xix 24.2 JSON . . . . . . . . . . . . . . . . . .

. . . . . . . . 384 3.5.3 Test-driven development/code writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 385 3.5.3.1 Writing tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1018 24.1.26 Writing out Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1019 24.1.26.1 Writing to CSV format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1019 24.1.26.2 Writing a formatted string . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1019 24.2 JSON . . . . . . . . . . . . . . . . . . . .

. . . . . . . . 414 3.5.3 Test-driven development/code writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 415 3.5.3.1 Writing tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1058 24.1.26 Writing out Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1058 24.1.26.1 Writing to CSV format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1058 24.1.26.2 Writing a formatted string . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1059 24.2 JSON . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . 335 3.5.2 Test-driven development/code writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 335 Writing tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 923 25.1.23 Writing out Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 923 Writing to CSV format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 923 Writing a formatted string . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 924 25.2 JSON . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . 337 3.5.2 Test-driven development/code writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 337 Writing tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 925 25.1.23 Writing out Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 925 Writing to CSV format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 925 Writing a formatted string . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 926 25.2 JSON . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . 409 19 Enhancing Performance 411 19.1 Cython (Writing C extensions for pandas) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 411 20 Added module for reading and writing Stata files: pandas.io.stata (GH1512) accessable via read_stata top-level function for reading, and to_stata DataFrame method for writing, See the docs • Added module module for reading and writing json format files: pandas.io.json accessable via read_json top- level function for reading, and to_json DataFrame method for writing, See the docs various issues (GH1226, GH3804

. . . . . . . . . . . . . . . . . . . . . . . . 531 21 Enhancing Performance 535 21.1 Cython (Writing C extensions for pandas) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 535 21 infer_datetime_format=True) • date_format and datetime_format keywords can now be specified when writing to excel files (GH4133) 1.1. v0.13.1 (February 3, 2014) 7 pandas: powerful Python data analysis /df_table2 frame_table (typ->appendable,nrows->10,ncols->2,indexers->[index]) • Significant table writing performance improvements • handle a passed Series in table format (GH4330) • can now serialize

. . . . . . . . . . . . . . . . . . . . . . . . 591 21 Enhancing Performance 595 21.1 Cython (Writing C extensions for pandas) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 595 21 as the name of the inserted column containing the pivoted data. 1.1.5 SQL The SQL reading and writing functions now support more database flavors through SQLAlchemy (GH2717, GH4163, GH5950, GH6292). functions include: • support for writing the index. This can be controlled with the index keyword (default is True). • specify the column label to use when writing the index with index_label. • specify

where tags were missing for DataFrame.index values (GH28204). • Regression in to_csv() where writing a Series or DataFrame indexed by an IntervalIndex would incorrectly raise a TypeError (GH28210) is equipped with an exhaustive set of unit tests, covering about 97% of the code base as of this writing. To run it on your machine to verify that everything is working (and that you have all of the dependencies 4.2 HDF5-based reading / writing SQLAlchemy 1.1.4 SQL support for databases other than sqlite SciPy 0.19.0 Miscellaneous statistical functions XLsxWriter 0.9.8 Excel writing blosc Compression for msgpack