your S3 bucket requires credentials you will need to set them as environment variables or in the ~/.aws/ credentials config file, refer to the S3Fs documentation on credentials. 264 Chapter 2. User Guide • fjetter • gabrielvf1 + • gdex1 + • gfyoung • guru kiran + • h-vishal • iamshwin • jamin-aws-ospo + • jbrockmendel • jfcorbett + • jnecus + • kernc • kota matsuoka + • kylekeppler + • leandermaben read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented

your S3 bucket requires credentials you will need to set them as environment variables or in the ~/.aws/ credentials config file, refer to the S3Fs documentation on credentials. Writing out data Writing • fjetter • gabrielvf1 + • gdex1 + • gfyoung • guru kiran + • h-vishal • iamshwin • jamin-aws-ospo + • jbrockmendel • jfcorbett + • jnecus + • kernc • kota matsuoka + • kylekeppler + • leandermaben read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented

read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented bz2-compressed files from AWS S3 (GH11070, GH11072). • In pd.read_csv, recognize s3n:// and s3a:// URLs as designating S3 file storage (GH11070, GH11071). • Read CSV files from AWS S3 incrementally, instead Python 2.) (GH11070, GH11073) • pd.read_csv is now able to infer compression type for files read from AWS S3 storage (GH11070, GH11074). Backwards incompatible API changes Changes to sorting API The sorting

read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented bz2-compressed files from AWS S3 (GH11070, GH11072). • In pd.read_csv, recognize s3n:// and s3a:// URLs as designating S3 file storage (GH11070, GH11071). • Read CSV files from AWS S3 incrementally, instead Python 2.) (GH11070, GH11073) • pd.read_csv is now able to infer compression type for files read from AWS S3 storage (GH11070, GH11074). Backwards incompatible API changes Changes to sorting API The sorting

read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented bz2-compressed files from AWS S3 (GH11070, GH11072). • In pd.read_csv, recognize s3n:// and s3a:// URLs as designating S3 file storage (GH11070, GH11071). • Read CSV files from AWS S3 incrementally, instead Python 2.) (GH11070, GH11073) • pd.read_csv is now able to infer compression type for files read from AWS S3 storage (GH11070, GH11074). 1.10.2 Backwards incompatible API changes 1.10.2.1 Changes to sorting

read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented bz2-compressed files from AWS S3 (GH11070, GH11072). • In pd.read_csv, recognize s3n:// and s3a:// URLs as designating S3 file storage (GH11070, GH11071). • Read CSV files from AWS S3 incrementally, instead Python 2.) (GH11070, GH11073) • pd.read_csv is now able to infer compression type for files read from AWS S3 storage (GH11070, GH11074). 1.9.2 Backwards incompatible API changes 1.9.2.1 Changes to sorting

Harry Potter J K. Rowling 2005 29.99 2 web Learning XML Erik T. Ray 2003 39.95 Even read XML from AWS S3 buckets such as Python Software Foundation’s IRS 990 Form: In [331]: df = pd.read_xml( .....: • fjetter • gabrielvf1 + • gdex1 + • gfyoung • guru kiran + • h-vishal • iamshwin • jamin-aws-ospo + • jbrockmendel • jfcorbett + • jnecus + • kernc • kota matsuoka + • kylekeppler + • leandermaben read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented

Harry Potter J K. Rowling 2005 29.99 2 web Learning XML Erik T. Ray 2003 39.95 Even read XML from AWS S3 buckets such as Python Software Foundation’s IRS 990 Form: In [331]: df = pd.read_xml( .....: • fjetter • gabrielvf1 + • gdex1 + • gfyoung • guru kiran + • h-vishal • iamshwin • jamin-aws-ospo + • jbrockmendel • jfcorbett + • jnecus + • kernc • kota matsuoka + • kylekeppler + • leandermaben read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented

Harry Potter J K. Rowling 2005 29.99 2 web Learning XML Erik T. Ray 2003 39.95 Even read XML from AWS S3 buckets such as Python Software Foundation’s IRS 990 Form: In [331]: df = pd.read_xml( .....: • fjetter • gabrielvf1 + • gdex1 + • gfyoung • guru kiran + • h-vishal • iamshwin • jamin-aws-ospo + • jbrockmendel • jfcorbett + • jnecus + • kernc • kota matsuoka + • kylekeppler + • leandermaben read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented

your S3 bucket requires credentials you will need to set them as environment variables or in the ~/.aws/ credentials config file, refer to the S3Fs documentation on credentials. 3.1. IO tools (text, CSV read_excel now supports s3 urls of the format s3://bucketname/filename (GH11447) • add support for AWS_S3_HOST env variable when reading from s3 (GH12198) • A simple version of Panel.round() is now implemented bz2-compressed files from AWS S3 (GH11070, GH11072). • In pd.read_csv, recognize s3n:// and s3a:// URLs as designating S3 file storage (GH11070, GH11071). • Read CSV files from AWS S3 incrementally, instead