{{ header }}

.. _api.io:

============
Input/output
============
.. currentmodule:: pandas

.. note::
   For an overview, see :ref:`io`.

Pickling
~~~~~~~~
.. autosummary::
   :toctree: api/

   read_pickle
   DataFrame.to_pickle

Flat file
~~~~~~~~~
.. autosummary::
   :toctree: api/

   read_table
   read_csv
   DataFrame.to_csv
   read_fwf

.. currentmodule:: pandas.io.parsers

.. autosummary::
   :toctree: api/

   TextFileReader
   TextFileReader.read
   TextFileReader.get_chunk
   TextFileReader.close

.. currentmodule:: pandas

Clipboard
~~~~~~~~~
.. autosummary::
   :toctree: api/

   read_clipboard
   DataFrame.to_clipboard

Excel
~~~~~
.. autosummary::
   :toctree: api/

   read_excel
   DataFrame.to_excel
   ExcelFile
   ExcelFile.book
   ExcelFile.sheet_names
   ExcelFile.parse

.. currentmodule:: pandas.io.formats.style

.. autosummary::
   :toctree: api/

   Styler.to_excel

.. currentmodule:: pandas

.. autosummary::
   :toctree: api/

   ExcelWriter

.. currentmodule:: pandas

JSON
~~~~
.. autosummary::
   :toctree: api/

   read_json
   json_normalize
   DataFrame.to_json

.. currentmodule:: pandas.io.json

.. autosummary::
   :toctree: api/

   build_table_schema

.. currentmodule:: pandas.api.typing

.. autosummary::
   :toctree: api/

   JsonReader

.. currentmodule:: pandas

HTML
~~~~
.. autosummary::
   :toctree: api/

   read_html
   DataFrame.to_html

.. currentmodule:: pandas.io.formats.style

.. autosummary::
   :toctree: api/

   Styler.to_html

.. currentmodule:: pandas

XML
~~~~
.. autosummary::
   :toctree: api/

   read_xml
   DataFrame.to_xml

Latex
~~~~~
.. autosummary::
   :toctree: api/

   DataFrame.to_latex

.. currentmodule:: pandas.io.formats.style

.. autosummary::
   :toctree: api/

   Styler.to_latex

.. currentmodule:: pandas

HDFStore: PyTables (HDF5)
~~~~~~~~~~~~~~~~~~~~~~~~~
.. autosummary::
   :toctree: api/

   read_hdf
   HDFStore.put
   HDFStore.append
   HDFStore.append_to_multiple
   HDFStore.get
   HDFStore.select
   HDFStore.select_as_coordinates
   HDFStore.select_as_multiple
   HDFStore.select_column
   HDFStore.remove
   HDFStore.create_table_index
   HDFStore.copy
   HDFStore.flush
   HDFStore.info
   HDFStore.is_open
   HDFStore.keys
   HDFStore.groups
   HDFStore.get_storer
   HDFStore.walk

.. warning::

   One can store a subclass of :class:`DataFrame` or :class:`Series` to HDF5,
   but the type of the subclass is lost upon storing.

Feather
~~~~~~~
.. autosummary::
   :toctree: api/

   read_feather
   DataFrame.to_feather

Parquet
~~~~~~~
.. autosummary::
   :toctree: api/

   read_parquet
   DataFrame.to_parquet

Iceberg
~~~~~~~
.. autosummary::
    :toctree: api/

    read_iceberg
    DataFrame.to_iceberg

.. warning:: ``read_iceberg`` is experimental and may change without warning.

ORC
~~~
.. autosummary::
   :toctree: api/

   read_orc
   DataFrame.to_orc

SAS
~~~
.. autosummary::
   :toctree: api/

   read_sas

SPSS
~~~~
.. autosummary::
   :toctree: api/

   read_spss

SQL
~~~
.. autosummary::
   :toctree: api/

   read_sql_table
   read_sql_query
   read_sql
   DataFrame.to_sql

STATA
~~~~~
.. autosummary::
   :toctree: api/

   read_stata
   DataFrame.to_stata

.. currentmodule:: pandas.io.stata

.. autosummary::
   :toctree: api/

   StataReader.data_label
   StataReader.value_labels
   StataReader.variable_labels
   StataWriter.write_file
