openpyxl, xlrd/xlwt – openpyxl version 1.6.1 or higher – Needed for Excel I/O • boto: necessary for Amazon S3 access. • One of the following combinations of libraries is needed to use the top-level read_html() EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY Finance In [296]: import pandas.io.data as web In [297]: start = datetime.datetime(2010, 1, 1) In [298]: end = datetime.datetime(2013, 01, 27) In [299]: f=web.DataReader("F", ’yahoo’, start, end) In

SPSS files (.sav) reading pytables 3.4.2 HDF5 reading / writing qtpy Clipboard I/O s3fs 0.0.8 Amazon S3 access xarray 0.8.2 pandas-like API for N-dimensional data xclip Clipboard I/O on linux xlrd EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY tables on the web are not big enough for the parsing algorithm runtime to matter. It is more likely that the bottleneck will be in the process of reading the raw text from the URL over the web, i.e., IO (input-output)

is ignored in the case of Categorical columns. (GH8868) • Fixed bug with reading CSV files from Amazon S3 on python 3 raising a TypeError (GH9452) • Bug in the Google BigQuery reader where the ‘jobComplete’ argument that is passed to the underlying parser library. You can use this to read non-ascii encoded web pages (GH7323). • read_excel now supports reading from URLs in the same way that read_csv does. (GH6809) Alternative Excel writer • Jinja2: Template engine for conditional HTML formatting. • s3fs: necessary for Amazon S3 access (s3fs >= 0.0.7). 374 Chapter 2. Installation pandas: powerful Python data analysis toolkit

is ignored in the case of Categorical columns. (GH8868) • Fixed bug with reading CSV files from Amazon S3 on python 3 raising a TypeError (GH9452) • Bug in the Google BigQuery reader where the ‘jobComplete’ argument that is passed to the underlying parser library. You can use this to read non-ascii encoded web pages (GH7323). • read_excel now supports reading from URLs in the same way that read_csv does. (GH6809) Alternative Excel writer • Jinja2: Template engine for conditional HTML formatting. • s3fs: necessary for Amazon S3 access (s3fs >= 0.0.7). 372 Chapter 2. Installation pandas: powerful Python data analysis toolkit

higher – Needed for Excel I/O • XlsxWriter – Alternative Excel writer. • boto: necessary for Amazon S3 access. • One of PyQt4, PySide, pygtk, xsel, or xclip: necessary to use read_clipboard(). Most EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY this. • Chapter 5: Here you get to find out if it’s cold in Montreal in the winter (spoiler: yes). Web scraping with pandas is fun! Here we combine dataframes. • Chapter 6: Strings with pandas are great

is ignored in the case of Categorical columns. (GH8868) • Fixed bug with reading CSV files from Amazon S3 on python 3 raising a TypeError (GH9452) • Bug in the Google BigQuery reader where the ‘jobComplete’ argument that is passed to the underlying parser library. You can use this to read non-ascii encoded web pages (GH7323). • read_excel now supports reading from URLs in the same way that read_csv does. (GH6809) Alternative Excel writer • Jinja2: Template engine for conditional HTML formatting. • s3fs: necessary for Amazon S3 access (s3fs >= 0.0.7). • blosc: for msgpack compression using blosc • One of PyQt4, PySide

is ignored in the case of Categorical columns. (GH8868) • Fixed bug with reading CSV files from Amazon S3 on python 3 raising a TypeError (GH9452) • Bug in the Google BigQuery reader where the ‘jobComplete’ argument that is passed to the underlying parser library. You can use this to read non-ascii encoded web pages (GH7323). • read_excel now supports reading from URLs in the same way that read_csv does. (GH6809) xlrd/xlwt – Needed for Excel I/O • XlsxWriter – Alternative Excel writer • boto: necessary for Amazon S3 access. • blosc: for msgpack compression using blosc • One of PyQt4, PySide, pygtk, xsel, or

than 2.0.0 – Needed for Excel I/O • XlsxWriter – Alternative Excel writer. • boto: necessary for Amazon S3 access. • One of PyQt4, PySide, pygtk, xsel, or xclip: necessary to use read_clipboard(). Most EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY this. • Chapter 5: Here you get to find out if it’s cold in Montreal in the winter (spoiler: yes). Web scraping with pandas is fun! Here we combine dataframes. • Chapter 6: Strings with pandas are great

HTTP gcsfs 0.6.0 Google Cloud Storage access pandas-gbq 0.12.0 Google Big Query access s3fs 0.4.0 Amazon S3 access Clipboard Dependency Minimum Version Notes PyQt4/PyQt5 Clipboard I/O qtpy Clipboard EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY HTTP(s) are handled by fsspec, if installed, and its various filesystem implemen- tations (including Amazon S3, Google Cloud, SSH, FTP, webHDFS...). Some of these implementations will require additional packages

HTTP gcsfs 0.6.0 Google Cloud Storage access pandas-gbq 0.12.0 Google Big Query access s3fs 0.4.0 Amazon S3 access 1.4. Tutorials 11 pandas: powerful Python data analysis toolkit, Release 1.3.3 Clipboard EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY HTTP(s) are handled by fsspec, if installed, and its various filesystem implemen- tations (including Amazon S3, Google Cloud, SSH, FTP, webHDFS...). Some of these implementations will require additional packages