Read and write list of `pandas.DataFrame`s of tabular data from/to excel file.
Project description
xlsx2dfs
Read and write list of pandas.DataFrame
s of tabular data from/to excel file.
Installation
Install by:
pip install xlsx2dfs
Alternatively:
pip install -e 'git+https://gwangjinkim@bitbucket.org/gwangjinkim/xlsx2dfs.git#egg=xlsx2dfs'
Usage
xlsx2dfs
reads a xlsx file with different sheets and tables as pandas data frame
and a list of sheet_names.
from xlsx2dfs import xlsx2dfs, withNames, dfs2xlsx
set test file name/path
fpath = "test.xlsx"
read into list of data frames and list of names
dfs, sheet_names = xlsx2dfs(fpath)
write a list of data frames and sheet_names into a file
out_fpath = "out_test.xlsx"
dfs2xlsx(withNames("sheet1", dfs[0], "sheet2" dfs[1], "sheet3", dfs[2]), out_fpath)
document the version:
- Linux:
$ pip freeze | grep xlsx2dfs
- Windows:
c:\> pip freeze | findstr xlsx2dfs
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
xlsx2dfs-0.1.0.post2.tar.gz
(2.6 kB
view hashes)
Built Distribution
Close
Hashes for xlsx2dfs-0.1.0.post2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 28332a1493b430d11450c714231b8c1f3bbacdc71b2c9b9dce1a5004bdc4989e |
|
MD5 | 00e3f26fb029ac013e7c0121e7b339e1 |
|
BLAKE2b-256 | 80308d237072badb3b05f4b543febf8abbc4ddbd97adfb27e12f0b4673ed239c |