. . . . . . . . . . . . . . . . . . . . . . . . . . . 8 1.2.1.1 Integration with Apache Parquet file format . . . . . . . . . . . . . . . . . . . . . 8 1.2.1.2 infer_objects type conversion . . . . Better support for compressed URLs in read_csv . . . . . . . . . . . . . . . . . 42 1.5.1.6 Pickle file I/O now supports compression . . . . . . . . . . . . . . . . . . . . . . . 42 1.5.1.7 UInt64 Support unique will now be consistent with extension types . . . . . . . . . . . . . . . . 54 1.5.2.5 S3 File Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 1.5.2.6 Partial

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 404 2.4.21 Other file formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 405 2.4.22 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1019 3.1.2 Flat file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1022 3 introduction tutorial To user guide Straight to tutorial... pandas supports the integration with many file formats or data sources out of the box (csv, excel, sql, json, parquet,...). Importing data from each

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 404 2.4.21 Other file formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 405 2.4.22 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1019 3.1.2 Flat file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1022 3 introduction tutorial To user guide Straight to tutorial... pandas supports the integration with many file formats or data sources out of the box (csv, excel, sql, json, parquet,...). Importing data from each

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1033 3.1.2 Flat file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1036 3 introduction tutorial To user guide Straight to tutorial... pandas supports the integration with many file formats or data sources out of the box (csv, excel, sql, json, parquet,...). Importing data from each CSV file. In [2]: titanic = pd.read_csv("data/titanic.csv") pandas provides the read_csv() function to read data stored as a csv file into a pandas DataFrame. pandas supports many different file formats

now be converted to pyarrow (>=0.15.0), which means that it is supported in writing to the Parquet file format when using the pyarrow engine (GH28368). Full roundtrip to parquet (writing and reading back Dependencies and Optional dependencies for more. 1.5.13 Build Changes Pandas has added a pyproject.toml file and will no longer include cythonized files in the source distribution uploaded to PyPI (GH28341, The returned dtype of unique() now matches the input dtype. (GH27874) • Changed the default configuration value for options.matplotlib.register_converters from True to "auto" (GH18720). Now, pandas custom

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407 2.4.21 Other file formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407 2.4.22 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027 3.1.2 Flat file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1030 3 introduction tutorial To user guide Straight to tutorial... pandas supports the integration with many file formats or data sources out of the box (csv, excel, sql, json, parquet,...). Importing data from each

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 406 2.4.21 Other file formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407 2.4.22 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027 3.1.2 Flat file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1030 3 introduction tutorial To user guide Straight to tutorial... pandas supports the integration with many file formats or data sources out of the box (csv, excel, sql, json, parquet,...). Importing data from each

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 342 2.4.19 Other file formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 343 2.4.20 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 913 3.1.2 Flat file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 914 3.1 introduction tutorial To user guide Straight to tutorial... pandas supports the integration with many file formats or data sources out of the box (csv, excel, sql, json, parquet,...). Importing data from each

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 342 2.4.19 Other file formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 343 2.4.20 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 913 3.1.2 Flat file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 914 3.1 introduction tutorial To user guide Straight to tutorial... pandas supports the integration with many file formats or data sources out of the box (csv, excel, sql, json, parquet,...). Importing data from each

Better support for compressed URLs in read_csv . . . . . . . . . . . . . . . . . 13 1.3.1.6 Pickle file I/O now supports compression . . . . . . . . . . . . . . . . . . . . . . . 13 1.3.1.7 UInt64 Support unique will now be consistent with extension types . . . . . . . . . . . . . . . . 25 1.3.2.5 S3 File Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 1.3.2.6 Partial 17, 2012) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331 1.24.1 File parsing new features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331