(GH9402) • Bug in DatetimeIndex when localizing with NaT (GH10477) • Bug in Series.dt ops in preserving meta-data (GH10477) • Bug in preserving NaT when passed in an otherwise invalid to_datetime construction v2 respectively, failing if the requested version is not available. The openpyxl engine is a now a meta- engine that automatically uses whichever version of openpyxl is installed. (GH7177) • DataFrame All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The functionality of providing DBAPI connection

(GH9402) • Bug in DatetimeIndex when localizing with NaT (GH10477) • Bug in Series.dt ops in preserving meta-data (GH10477) • Bug in preserving NaT when passed in an otherwise invalid to_datetime construction v2 respectively, failing if the requested version is not available. The openpyxl engine is a now a meta- engine that automatically uses whichever version of openpyxl is installed. (GH7177) • DataFrame All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The functionality of providing DBAPI connection

(GH9402) • Bug in DatetimeIndex when localizing with NaT (GH10477) • Bug in Series.dt ops in preserving meta-data (GH10477) • Bug in preserving NaT when passed in an otherwise invalid to_datetime construction v2 respectively, failing if the requested version is not available. The openpyxl engine is a now a meta- engine that automatically uses whichever version of openpyxl is installed. (GH7177) • DataFrame All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The functionality of providing DBAPI connection

(GH9402) • Bug in DatetimeIndex when localizing with NaT (GH10477) • Bug in Series.dt ops in preserving meta-data (GH10477) • Bug in preserving NaT when passed in an otherwise invalid to_datetime construction v2 respectively, failing if the requested version is not available. The openpyxl engine is a now a meta- engine that automatically uses whichever version of openpyxl is installed. (GH7177) • DataFrame All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The functionality of providing DBAPI connection

(GH9402) • Bug in DatetimeIndex when localizing with NaT (GH10477) • Bug in Series.dt ops in preserving meta-data (GH10477) • Bug in preserving NaT when passed in an otherwise invalid to_datetime construction v2 respectively, failing if the requested version is not available. The openpyxl engine is a now a meta- engine that automatically uses whichever version of openpyxl is installed. (GH7177) • DataFrame All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The functionality of providing DBAPI connection

deliminted JSON from S3 (GH17200) • Bug in pandas.io.json.json_normalize() to avoid modification of meta (GH18610) • Bug in to_latex() where repeated multi-index values were not printed even though a higher (GH9402) • Bug in DatetimeIndex when localizing with NaT (GH10477) • Bug in Series.dt ops in preserving meta-data (GH10477) • Bug in preserving NaT when passed in an otherwise invalid to_datetime construction v2 respectively, failing if the requested version is not available. The openpyxl engine is a now a meta- engine that automatically uses whichever version of openpyxl is installed. (GH7177) • DataFrame

\\\\\\\\\\\\\\Out[71]: ˓→ A B C 0 1.0 2.0 4.0 1 5.0 NaN 10.0 Comments Sometimes comments or meta data may be included in a file: In [72]: print(open('tmp.csv').read()) ID,level,category Patient1 from a filelike handle Modifying formatting in XlsxWriter output HTML Reading HTML tables from a server that cannot handle the default request header HDFStore The HDFStores docs Simple queries with json_normalize(data: Union[Dict, List[Dict]], record_path: Union[str, List, NoneType] = None, meta: Union[str, List, NoneType] = None, meta_prefix: Union[str, NoneType] = None, record_prefix: Union[str, NoneType] = None

\\\\\\\\\\\\\\Out[71]: ˓→ A B C 0 1.0 2.0 4.0 1 5.0 NaN 10.0 Comments Sometimes comments or meta data may be included in a file: In [72]: print(open('tmp.csv').read()) ID,level,category Patient1 pandas: powerful Python data analysis toolkit, Release 0.25.1 HTML Reading HTML tables from a server that cannot handle the default request header HDFStore The HDFStores docs Simple queries with json_normalize(data: Union[Dict, List[Dict]], record_path: Union[str, List, NoneType] = None, meta: Union[str, List, NoneType] = None, meta_prefix: Union[str, NoneType] = None, record_prefix: Union[str, NoneType] = None

Using the tips dataset again, let’s find the average gratuity by size of the party and sex of the server. In Excel, we use the following configuration for the PivotTable: The equivalent in pandas: In skiprows=4, header=1) Out[78]: A B C 0 1.0 2.0 4.0 1 5.0 NaN 10.0 Comments Sometimes comments or meta data may be included in a file: In [79]: print(open("tmp.csv").read()) ID,level,category Patient1 read_xml( .....: "s3://pmc-oa-opendata/oa_comm/xml/all/PMC1236943.xml", .....: xpath=".//journal-meta", .....: ) .....: (continues on next page) 2.2. Guides 345 pandas: powerful Python data analysis

\\\\\\\\\\\\\\Out[71]: ˓→ A B C 0 1.0 2.0 4.0 1 5.0 NaN 10.0 Comments Sometimes comments or meta data may be included in a file: In [72]: print(open('tmp.csv').read()) ID,level,category Patient1 from a filelike handle Modifying formatting in XlsxWriter output HTML Reading HTML tables from a server that cannot handle the default request header HDFStore The HDFStores docs Simple Queries with "col 2": "b"}, {"index": "row 2", "col 1": "c", "col 2": "d"}]}' json_normalize(data[, record_path, meta, ...]) Normalize semi-structured JSON data into a flat table. build_table_schema(data[, index, .