Add a short description here!
Project description
pandas-xlsx-tables
Even though you might not like it, Excel isn't going anywhere. And Excel with tables is a lot better than without.
Strangely Pandas does not support reading from and writing to excel tables out of the box, and due to the complexity of Pandas this is not easily added (though having this built into Pandas would be the prefered solution). This separate package is thus a separate companion to Pandas, with utility functions to read and write Excel Tables from and to Pandas DataFrames.
>>> from pandas_xlsx_tables import xlsx_table_to_df
>>> df = xlsx_table_to_df("my_file.xlsx", "Table1")
>>> df
col1 col2
Row
0 1 a
1 2 b
And the reverse process:
>>> from pandas_xlsx_tables import df_to_xlsx_table
>>> df_to_xlsx_table(df, "my_table", header_orientation="diagonal", index=False)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pandas-xlsx-tables-0.0.4.tar.gz
(31.1 kB
view hashes)
Built Distribution
Close
Hashes for pandas_xlsx_tables-0.0.4-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 36485cfa3ed551238dc97fd2be0ad6060265ac26a001242c02cd3ad15c53c07c |
|
MD5 | 6afea5052ce8e84a95aec1b752483737 |
|
BLAKE2b-256 | 32c9f42c975df4238f36c7294164e6df68ee88c98ed7f8e9adbe21a50efec0a1 |