classmethod DataFrame.from_csv(path, header=0, sep=', ', index_col=0, parse_dates=True, encoding=None, tupleize_cols=None, infer_datetime_format=False)[source]

Read CSV file.

Deprecated since version 0.21.0: Use read_csv() instead.

It is preferable to use the more powerful read_csv() for most general purposes, but from_csv makes for an easy roundtrip to and from a file (the exact counterpart of to_csv), especially with a DataFrame of time series data.

This method only differs from the preferred read_csv() in some defaults:

  • index_col is 0 instead of None (take first column as index by default)

  • parse_dates is True instead of False (try parsing the index as datetime by default)

So a pd.DataFrame.from_csv(path) can be replaced by pd.read_csv(path, index_col=0, parse_dates=True).

pathstring file path or file handle / StringIO
headerint, default 0

Row to use as header (skip prior rows)

sepstring, default ‘,’

Field delimiter

index_colint or sequence, default 0

Column to use for index. If a sequence is given, a MultiIndex is used. Different default from read_table

parse_datesboolean, default True

Parse dates. Different default from read_table

tupleize_colsboolean, default False

write multi_index columns as a list of tuples (if True) or new (expanded format) if False)

infer_datetime_formatboolean, default False

If True and parse_dates is True for a column, try to infer the datetime format based on the first datetime string. If the format can be inferred, there often will be a large parsing speed-up.


See also

Scroll To Top