Input/output#
Pickling#
|
Load pickled pandas object (or any object) from file. |
|
Pickle (serialize) object to file. |
Flat file#
|
Read general delimited file into DataFrame. |
|
Read a comma-separated values (csv) file into DataFrame. |
|
Write object to a comma-separated values (csv) file. |
|
Read a table of fixed-width formatted lines into DataFrame. |
Clipboard#
|
Read text from clipboard and pass to |
|
Copy object to the system clipboard. |
Excel#
|
Read an Excel file into a |
|
Write object to an Excel sheet. |
|
Class for parsing tabular Excel sheets into DataFrame objects. |
|
Parse specified sheet(s) into a DataFrame. |
|
Write Styler to an Excel sheet. |
|
Class for writing DataFrame objects into excel sheets. |
JSON#
|
Convert a JSON string to pandas object. |
|
Normalize semi-structured JSON data into a flat table. |
|
Convert the object to a JSON string. |
|
Create a Table schema from |
HTML#
|
Read HTML tables into a |
|
Render a DataFrame as an HTML table. |
|
Write Styler to a file, buffer or string in HTML-CSS format. |
XML#
|
Read XML document into a |
|
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 from the store, close it if we opened it. |
|
Store object in HDFStore. |
|
Append to Table in file. |
|
Retrieve pandas object stored in file. |
|
Retrieve pandas object stored in file, optionally based on where criteria. |
Print detailed information on the store. |
|
|
Return a list of keys corresponding to objects stored in HDFStore. |
Return a list of all the top-level nodes. |
|
|
Walk the pytables group hierarchy for pandas objects. |
Feather#
|
Load a feather-format object from the file path. |
|
Write a DataFrame to the binary Feather format. |
Parquet#
|
Load a parquet object from the file path, returning a DataFrame. |
|
Write a DataFrame to the binary parquet format. |
ORC#
|
Load an ORC object from the file path, returning a DataFrame. |
|
Write a DataFrame to the ORC format. |
SAS#
|
Read SAS files stored as either XPORT or SAS7BDAT format files. |
SPSS#
|
Load an SPSS file from the file path, returning a DataFrame. |
SQL#
|
Read SQL database table into a DataFrame. |
|
Read SQL query into a DataFrame. |
|
Read SQL query or database table into a DataFrame. |
|
Write records stored in a DataFrame to a SQL database. |
Google BigQuery#
|
(DEPRECATED) Load data from Google BigQuery. |
STATA#
|
Read Stata file into DataFrame. |
|
Export DataFrame object to Stata dta format. |
Return data label of Stata file. |
|
Return a nested dict associating each variable name to its value and label. |
|
Return a dict associating each variable name with corresponding label. |
|
Export DataFrame object to Stata dta format. |