Python Pandas Input Output | Import Export Datasets | read_csv, read_excel, read_json, read_table

Python Pandas Workshop - Prof Ram Meghe College of Engineering & Management 2022-02-13 14.47.30 - Part II
python pandas workshop - prof ram meghe college of engineering & management 2022-02-12 14.41.20

Input/output

Pickling

read_pickle(filepath_or_buffer[,

Load pickled pandas object (or any object) from file.

Pickle (serialize) object to file.

Flat file

read_table(filepath_or_buffer[, sep,

Read general delimited file into DataFrame.

read_csv(filepath_or_buffer[, sep,

Read a comma-separated values (csv) file into DataFrame.

Write object to a comma-separated values (csv) file.

read_fwf(filepath_or_buffer[, colspecs,

Read a table of fixed-width formatted lines into DataFrame.

Clipboard

read_clipboard([sep])

Read text from clipboard and pass to read_csv.

Copy object to the system clipboard.

Excel

read_excel(io[, sheet_name, header, names,

Read an Excel file into a pandas DataFrame.

Write object to an Excel sheet.

Parse specified sheet(s) into a DataFrame.

Write Styler to an Excel sheet.

ExcelWriter(path[, engine, date_format,

Class for writing DataFrame objects into excel sheets.

JSON

read_json([path_or_buf, orient, typ, dtype,

Convert a JSON string to pandas object.

json_normalize(data[, record_path, meta,

Normalize semi-structured JSON data into a flat table.

Convert the object to a JSON string.

build_table_schema(data[, index,

Create a Table schema from data.

HTML

read_html(io[, match, flavor, header,

Read HTML tables into a list of DataFrame objects.

Render a DataFrame as an HTML table.

Write Styler to a file, buffer or string in HTML-CSS format.

XML

read_xml(path_or_buffer[, xpath,

Read XML document into a DataFrame object.

Render a DataFrame to an XML document.

Latex

Render object to a LaTeX tabular, longtable, or nested table.

Write Styler to a file, buffer or string in LaTeX format.

HDFStore: PyTables (HDF5)

read_hdf(path_or_buf[, key, mode, errors,

Read from the store, close it if we opened it.