Pandas Tutorial

Constructors-

Method	Description
pd.Series (data=None, index=None, dtype=None, name=None, copy=False, fastpath=<no_default>)	One-dimensional ndarray with axis labels (including time series).
pd.DataFrame (data=None, index=None, columns=None, dtype=None, copy=False)	Two-dimensional, size-mutable, potentially heterogeneous tabular data.

Pickling-

Method	Description
pd.read_pickle (filepath_or_buffer, compression='infer', storage_options=None)	Load pickled pandas object (or any object) from file.

Flat File-

Method	Description
pd.read_table (filepath_or_buffer, , sep=None, delimiter=None, header='infer', names=<no_default>, index_col=None, usecols=None, dtype=None, engine=None, converters=None, true_values=None, false_values=None, skipinitialspace=False, skiprows=None, skipfooter=0, nrows=None, na_values=None, keep_default_na=True, na_filter=True, verbose=<no_default>, skip_blank_lines=True, parse_dates=False, infer_datetime_format=<no_default>, keep_date_col=<no_default>, date_parser=<no_default>, date_format=None, dayfirst=False, cache_dates=True, iterator=False, chunksize=None, compression='infer', thousands=None, decimal='.', lineterminator=None, quotechar='"', quoting=0, doublequote=True, escapechar=None, comment=None, encoding=None, encoding_errors='strict', dialect=None, on_bad_lines='error', low_memory=True, memory_map=False, float_precision=None, storage_options=None, dtype_backend=<no_default>*)	Read general delimited file into DataFrame.
pd.read_csv (filepath_or_buffer, , sep=None, delimiter=None, header='infer', names=<no_default>, index_col=None, usecols=None, dtype=None, engine=None, converters=None, true_values=None, false_values=None, skipinitialspace=False, skiprows=None, skipfooter=0, nrows=None, na_values=None, keep_default_na=True, na_filter=True, verbose=<no_default>, skip_blank_lines=True, parse_dates=False, infer_datetime_format=<no_default>, keep_date_col=<no_default>, date_parser=<no_default>, date_format=None, dayfirst=False, cache_dates=True, iterator=False, chunksize=None, compression='infer', thousands=None, decimal='.', lineterminator=None, quotechar='"', quoting=0, doublequote=True, escapechar=None, comment=None, encoding=None, encoding_errors='strict', dialect=None, on_bad_lines='error', low_memory=True, memory_map=False, float_precision=None, storage_options=None, dtype_backend=<no_default>*)	Read a comma-separated values (csv) file into DataFrame.
pd.read_fwf (filepath_or_buffer, colspecs='infer', widths=None, infer_nrows=100, dtype_backend=<no_default>, interator=False, chunksize=None, **kwds)	Read a table of fixed-width formatted lines into DataFrame.

Clipboard-

Method	Description
pd.read_clipboard (sep='\s+', dtype_backend=<no_default>, **kwargs)	Read text from clipboard and pass to pd.read_csv() .

Excel-

Method	Description
pd.read_excel (io, sheet_name=0, , header=0, names=None, index_col=None, usecols=None, dtype=None, engine=None, converters=None, true_values=None, false_values=None, skiprows=None, nrows=None, na_values=None, keep_default_na=True, na_filter=True, verbose=False, parse_dates=False, date_parser=<no_default>, date_format=None, thousands=None, decimal='.', comment=None, skipfooter=0, storage_options=None, dtype_backend=<no_default>, engine_kwargs=None*)	Read an Excel file into a pandas DataFrame.
pd.ExcelFile.parse (sheet_name=0, header=0, names=None, index_col=None, usecols=None, converters=None, true_values=None, false_values=None, skiprows=None, nrows=None, na_values=None, parse_dates=False, date_parser=<no_default>, date_format=None, thousands=None, comment=None, skipfooter=0, dtype_backend=<no_default>, **kwds)	Parse specified sheet(s) into a DataFrame.

Method

Description

pd.read_excel (io, sheet_name=0, *, header=0, names=None, index_col=None, usecols=None, dtype=None, engine=None, converters=None, true_values=None, false_values=None, skiprows=None, nrows=None, na_values=None, keep_default_na=True, na_filter=True, verbose=False, parse_dates=False, date_parser=<no_default>, date_format=None, thousands=None, decimal='.', comment=None, skipfooter=0, storage_options=None, dtype_backend=<no_default>, engine_kwargs=None)

Read an Excel file into a pandas DataFrame.

pd.ExcelFile.parse (sheet_name=0, header=0, names=None, index_col=None, usecols=None, converters=None, true_values=None, false_values=None, skiprows=None, nrows=None, na_values=None, parse_dates=False, date_parser=<no_default>, date_format=None, thousands=None, comment=None, skipfooter=0, dtype_backend=<no_default>, **kwds)

Parse specified sheet(s) into a DataFrame.

JSON-

Method	Description
pd.read_json (path_or_buf, , orient=None, typ='frame', dtype=None, convert_axes=None, convert_dates=True, keep_default_dates=True, precise_float=False, date_unit=None, encoding=None, encoding_errors='strict', lines=False, chunksize=None, compression='infer', nrows=None, storage_options=None, dtype_backend=<no_default>, engine='ujson'*)	Convert a JSON string to pandas object.
pd.json_normalize (data, record_path=None, meta=None, meta_prefix=None, record_prefix=None, errors='ignore', sep='.', max_level=None)	Normalize semi-structured JSON data into a flat table.

Method

Description

pd.read_json (path_or_buf, *, orient=None, typ='frame', dtype=None, convert_axes=None, convert_dates=True, keep_default_dates=True, precise_float=False, date_unit=None, encoding=None, encoding_errors='strict', lines=False, chunksize=None, compression='infer', nrows=None, storage_options=None, dtype_backend=<no_default>, engine='ujson')

Convert a JSON string to pandas object.

pd.json_normalize (data, record_path=None, meta=None, meta_prefix=None, record_prefix=None, errors='ignore', sep='.', max_level=None)

Normalize semi-structured JSON data into a flat table.

Markup Languages-

Method	Description
pd.read_html (io, , match='.+', flavor=None, header=None, index_col=None, skiprows=None, attrs=None, parse_dates=False, thousands=', ', encoding=None, decimal='.', converters=None, na_values=None, keep_default_na=True, displayed_only=True, extract_links=None, dtype_backend=<no_default>, storage_options=None*)	Read HTML tables into a list of DataFrame objects.
pd.read_xml (path_or_buffer, , xpath='./', namespaces=None, elems_only=False, attrs_only=False, names=None, dtype=None, converters=None, parse_dates=None, encoding='utf-8', parser='lxml', stylesheet=None, iterparse=None, compression='infer', storage_options=None, dtype_backend=<no_default>)	Read XML document into a DataFrame object.

Method

Description

pd.read_html (io, *, match='.+', flavor=None, header=None, index_col=None, skiprows=None, attrs=None, parse_dates=False, thousands=', ', encoding=None, decimal='.', converters=None, na_values=None, keep_default_na=True, displayed_only=True, extract_links=None, dtype_backend=<no_default>, storage_options=None)

Read HTML tables into a list of DataFrame objects.

pd.read_xml (path_or_buffer, *, xpath='./*', namespaces=None, elems_only=False, attrs_only=False, names=None, dtype=None, converters=None, parse_dates=None, encoding='utf-8', parser='lxml', stylesheet=None, iterparse=None, compression='infer', storage_options=None, dtype_backend=<no_default>)

Read XML document into a DataFrame object.

HDFStore-

Method	Description
pd.read_hdf (path_or_buf, key=None, mode='r', errors='strict', where=None, start=None, stop=None, columns=None, iterator=False, chunksize=None, **kwargs)	Read from the store, close it if we opened it.

Columnar Storage-

Method	Description
pd.read_feather (path, columns=None, use_threads=True, storage_options=None, dtype_backend=<no_default>)	Load a feather-format object from the file path.
pd.read_parquet (path, engine='auto', columns=None, storage_options=None, use_nullable_dtypes=<no_default>, dtype_backend=<no_default>, filesystem=None, filters=None, **kwargs)	Load a parquet object from the file path, returning a DataFrame.
pd.read_orc (path, columns=None, dtype_backend=<no_default>, filesystem=None, **kwargs)	Load an ORC object from the file path, returning a DataFrame.

SQL-

Method	Description
pd.read_sql_table (table_name, con, schema=None, index_col=None, coerce_float=True, parse_dates=None, columns=None, chunksize=None, dtype_backend=<no_default>)	Read SQL database table into a DataFrame.
pd.read_sql_query (sql, con, index_col=None, coerce_float=True, params=None, parse_dates=None, chunksize=None, dtype=None, dtype_backend=<no_default>)	Read SQL query into a DataFrame.
pd.read_sql (sql, con, index_col=None, coerce_float=True, params=None, parse_dates=None, columns=None, chunksize=None, dtype_backend=<no_default>, dtype=None)	Read SQL query or database table into a DataFrame.

Previous Next

BetterDocs

Support

EmailDiscordForms

Documentations

Python

Company

AboutDocs

Policies

Terms of ServicePrivacy Policy