Input/output

The following table lists both implemented and not implemented methods. If you have need of an operation that is listed as not implemented, feel free to open an issue on the GitHub repository, or give a thumbs up to already created issues. Contributions are also welcome!

The following table is structured as follows: The first column contains the method name. The second column contains link to a description of corresponding pandas method. The third column is a flag for whether or not there is an implementation in Xorbits for the method in the left column. Y stands for yes, N stands for no, P standsfor partial (meaning some parameters may not be supported yet), and D stands for default to pandas.

Pickling

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_pickle	read_pickle	Y
DataFrame.to_pickle	DataFrame.to_pickle	Y

Flat file

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_table	read_table	Y
read_csv	read_csv	Y
DataFrame.to_csv	DataFrame.to_csv	Y
read_fwf	read_fwf	Y

Clipboard

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_clipboard	read_clipboard	Y
DataFrame.to_clipboard	DataFrame.to_clipboard	Y

Excel

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_excel	read_excel	Y
DataFrame.to_excel	DataFrame.to_excel	Y
ExcelFile.parse	ExcelFile.parse	Y
ExcelWriter	ExcelWriter	Y

xorbits.pandas.io.formats.style	pandas.io.formats.style	Implemented? (Y/N/P/D)	Notes for Current implementation
Styler.to_excel	Styler.to_excel	Y

JSON

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_json	read_json	Y
json_normalize	json_normalize	Y
DataFrame.to_json	DataFrame.to_json	Y

xorbits.pandas.io.json	pandas.io.json	Implemented? (Y/N/P/D)	Notes for Current implementation
build_table_schema	build_table_schema	Y

HTML

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_html	read_html	Y
DataFrame.to_html	DataFrame.to_html	Y

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
Styler.to_html	Styler.to_html	Y

XML

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_xml	read_xml	Y
DataFrame.to_xml	DataFrame.to_xml	Y

Latex

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
DataFrame.to_latex	DataFrame.to_latex	Y

xorbits.pandas.io.formats.style	pandas.io.formats.style	Implemented? (Y/N/P/D)	Notes for Current implementation
Styler.to_latex	Styler.to_latex	Y

HDFStore: PyTables (HDF5)

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_hdf	read_hdf	Y
HDFStore.put	HDFStore.put	Y
HDFStore.append	HDFStore.append	Y
HDFStore.get	HDFStore.get	Y
HDFStore.select	HDFStore.select	Y
HDFStore.info	HDFStore.info	Y
HDFStore.keys	HDFStore.keys	Y
HDFStore.groups	HDFStore.groups	Y
HDFStore.walk	HDFStore.walk	Y

Warning

One can store a subclass of DataFrame or Series to HDF5, but the type of the subclass is lost upon storing.

Feather

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_feather	read_feather	Y
DataFrame.to_feather	DataFrame.to_feather	Y

Parquet

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_parquet	read_parquet	Y
DataFrame.to_parquet	DataFrame.to_parquet	Y

ORC

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_orc	read_orc	Y
DataFrame.to_orc	DataFrame.to_orc	Y

SAS

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_sas	read_sas	Y

SPSS

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_spss	read_spss	Y

SQL

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_sql_table	read_sql_table	Y
read_sql_query	read_sql_query	Y
read_sql	read_sql	Y
DataFrame.to_sql	DataFrame.to_sql	Y

Google BigQuery

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_gbq	read_gbq	Y

STATA

xorbits.pandas	pandas	Implemented? (Y/N/P/D)	Notes for Current implementation
read_stata	read_stata	Y
DataFrame.to_stata	DataFrame.to_stata	Y

xorbits.pandas.io.stata	pandas.io.stata	Implemented? (Y/N/P/D)	Notes for Current implementation
StataReader.data_label	StataReader.data_label	Y
StataReader.value_labels	StataReader.value_labels	Y
StataReader.variable_labels	StataReader.variable_labels	Y
StataWriter.write_file	StataWriter.write_file	Y