Input/Output

Pickling

read_pickle(path) Load pickled pandas object (or any other pickled object) from the specified

`read_table`(filepath_or_buffer[, sep, ...])	Read general delimited file into DataFrame
`read_csv`(filepath_or_buffer[, sep, ...])	Read CSV (comma-separated) file into DataFrame
`read_fwf`(filepath_or_buffer[, colspecs, widths])	Read a table of fixed-width formatted lines into DataFrame

read_clipboard(**kwargs) Read text from clipboard and pass to read_table.

`read_excel`(io[, sheetname, header, ...])	Read an Excel table into a pandas DataFrame
`ExcelFile.parse`([sheetname, header, ...])	Parse specified sheet(s) into a DataFrame

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

read_html(io[, match, flavor, header, ...]) Read HTML tables into a list of DataFrame objects.

`read_hdf`(path_or_buf[, key])	read from the store, close it if we opened it
`HDFStore.put`(key, value[, format, append])	Store object in HDFStore
`HDFStore.append`(key, value[, format, ...])	Append to Table in file.
`HDFStore.get`(key)	Retrieve pandas object stored in file
`HDFStore.select`(key[, where, start, stop, ...])	Retrieve pandas object stored in file, optionally based on where

read_sas(filepath_or_buffer[, format, ...]) Read SAS files stored as either XPORT or SAS7BDAT format files.

`read_sql_table`(table_name, con[, schema, ...])	Read SQL database table into a DataFrame.
`read_sql_query`(sql, con[, index_col, ...])	Read SQL query into a DataFrame.
`read_sql`(sql, con[, index_col, ...])	Read SQL query or database table into a DataFrame.

`read_gbq`(query[, project_id, index_col, ...])	Load data from Google BigQuery.
`to_gbq`(dataframe, destination_table, project_id)	Write a DataFrame to a Google BigQuery table.

read_stata(filepath_or_buffer[, ...]) Read Stata file into DataFrame

`StataReader.data`(**kwargs)	DEPRECATED: Reads observations from Stata file, converting them into a dataframe
`StataReader.data_label`()	Returns data label of Stata file
`StataReader.value_labels`()	Returns a dict, associating each variable name a dict, associating
`StataReader.variable_labels`()	Returns variable labels as a dict, associating each variable name
`StataWriter.write_file`()