as the header. encoding [str, default None] Encoding to use for UTF when reading/writing (e.g. 'utf-8'). List of Python standard encodings. dialect [str or csv.Dialect instance, default None] If provided pd.DataFrame([0, 1, 2]) In [129]: buffer = io.BytesIO() In [130]: data.to_csv(buffer, encoding="utf-8", compression="gzip") 2.4. IO tools (text, CSV, HDF5, ...) 295 pandas: powerful Python data analysis Let’s look at a few examples. Read an XML string: In [322]: xml = """UTF-8"?> .....: .....: .....:

Release 1.4.4 encoding [str, default None] Encoding to use for UTF when reading/writing (e.g. 'utf-8'). List of Python standard encodings. dialect [str or csv.Dialect instance, default None] If provided pd.DataFrame([0, 1, 2]) In [135]: buffer = io.BytesIO() In [136]: data.to_csv(buffer, encoding="utf-8", compression="gzip") Specifying method for floating-point conversion The parameter float_precision Let’s look at a few examples. Read an XML string: In [359]: xml = """UTF-8"?> .....: .....: .....:

as the header. encoding [str, default None] Encoding to use for UTF when reading/writing (e.g. 'utf-8'). List of Python standard encodings. dialect [str or csv.Dialect instance, default None] If provided pd.DataFrame([0, 1, 2]) In [134]: buffer = io.BytesIO() In [135]: data.to_csv(buffer, encoding="utf-8", compression="gzip") Specifying method for floating-point conversion The parameter float_precision Let’s look at a few examples. Read an XML string: In [358]: xml = """UTF-8"?> .....: .....: .....:

as the header. encoding [str, default None] Encoding to use for UTF when reading/writing (e.g. 'utf-8'). List of Python standard encodings. dialect [str or csv.Dialect instance, default None] If provided pd.DataFrame([0, 1, 2]) In [125]: buffer = io.BytesIO() In [126]: data.to_csv(buffer, encoding="utf-8", compression="gzip") Specifying method for floating-point conversion The parameter float_precision Let’s look at a few examples. Read an XML string: In [318]: xml = """UTF-8"?> .....: .....: .....:

as the header. encoding [str, default None] Encoding to use for UTF when reading/writing (e.g. 'utf-8'). List of Python standard encodings. dialect [str or csv.Dialect instance, default None] If provided analysis toolkit, Release 1.3.3 (continued from previous page) In [126]: data.to_csv(buffer, encoding="utf-8", compression="gzip") Specifying method for floating-point conversion The parameter float_precision Let’s look at a few examples. Read an XML string: In [318]: xml = """UTF-8"?> .....: .....: .....:

as the header. encoding [str, default None] Encoding to use for UTF when reading/writing (e.g. 'utf-8'). List of Python standard encodings. dialect [str or csv.Dialect instance, default None] If provided analysis toolkit, Release 1.3.4 (continued from previous page) In [126]: data.to_csv(buffer, encoding="utf-8", compression="gzip") Specifying method for floating-point conversion The parameter float_precision Let’s look at a few examples. Read an XML string: In [318]: xml = """UTF-8"?> .....: .....: .....:

empty series, rather than self. (GH11937) • to_msgpack and read_msgpack encoding now defaults to 'utf-8'. (GH12170) • the order of keyword arguments to text file parsing functions (.read_csv(), .read_table() does memory_usage in .info() (GH11597) • DataFrame.to_latex() now supports non-ascii encodings (eg utf-8) in Python 2 with the parameter encoding (GH7061) • pandas.merge() and DataFrame.merge() will show """ .....: Option 1: pass rows explicitly to skiprows In [168]: pd.read_csv(StringIO(data.decode('UTF-8')), sep=';', skiprows=[11,12], .....: index_col=0, parse_dates=True, header=10) .....: Out[168]:

empty series, rather than self. (GH11937) • to_msgpack and read_msgpack encoding now defaults to 'utf-8'. (GH12170) • the order of keyword arguments to text file parsing functions (.read_csv(), .read_table() does memory_usage in .info() (GH11597) • DataFrame.to_latex() now supports non-ascii encodings (eg utf-8) in Python 2 with the parameter encoding (GH7061) • pandas.merge() and DataFrame.merge() will show """ .....: Option 1: pass rows explicitly to skiprows In [168]: pd.read_csv(StringIO(data.decode('UTF-8')), sep=';', skiprows=[11,12], .....: index_col=0, parse_dates=True, header=10) .....: Out[168]:

prints and parses dates with the year first, eg 2005/01/20 display.encoding : [default: UTF-8] [currently: UTF-8]: str/unicode Defaults to the detected encoding of the console. Specifies the encoding column labels • encoding: a string representing the encoding to use for decoding unicode data, e.g. ’utf-8‘ or ’latin-1’. • verbose: show number of NA values inserted in non-numeric columns • squeeze: if are accepted. encoding : string, default None Encoding to use for UTF when reading/writing (ex. ‘utf-8’) squeeze : boolean, default False If the parsed data only contains one column then return a Series

values (GH7757) • Bug in DataFrame.to_csv() defaulting to ‘ascii’ encoding in Python 3, instead of ‘utf-8’ (GH17097) • Bug in read_stata() where value labels could not be read when using an iterator (GH16923) empty series, rather than self. (GH11937) • to_msgpack and read_msgpack encoding now defaults to 'utf-8'. (GH12170) • the order of keyword arguments to text file parsing functions (.read_csv(), .read_table() does memory_usage in .info() (GH11597) • DataFrame.to_latex() now supports non-ascii encodings (eg utf-8) in Python 2 with the parameter encoding (GH7061) • pandas.merge() and DataFrame.merge() will show