Skip to main content

High performance Excel IO tools for DataFrame

Project description

xwpandas

xwpandas is high performance Excel IO tools for pandas DataFrame. xp.save function in xwpandas saves large(100k~ rows) DataFrame to xlsx format 2x~3x faster than xlsxwriter engine in pandas.

Installation

xwpandas can be installed using pip package manager.

$ pip install xwpandas

Usage

Read data from Excel file

import xwpandas as xp
df = xp.read('path/to/file.xlsx')
df

View data in Excel window

xp.view(df)

Save DataFrame to Excel file

xp.save(df, 'path/to/file.xlsx')

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

xwpandas-0.1.0.tar.gz (4.3 kB view details)

Uploaded Source

Built Distribution

xwpandas-0.1.0-py3-none-any.whl (5.0 kB view details)

Uploaded Python 3

File details

Details for the file xwpandas-0.1.0.tar.gz.

File metadata

  • Download URL: xwpandas-0.1.0.tar.gz
  • Upload date:
  • Size: 4.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/40.2.0 requests-toolbelt/0.8.0 tqdm/4.26.0 CPython/3.6.6

File hashes

Hashes for xwpandas-0.1.0.tar.gz
Algorithm Hash digest
SHA256 d315e5996b87f7e80c91ba6b9951bc79c42c73a5ac852d47289bef3a6589689e
MD5 d63613faf6e0aa31c2cefc09ef07b85a
BLAKE2b-256 6d7ab7799ddd4a312b0e48bdf90c78d7a9d4bab043469e95727750385eca275f

See more details on using hashes here.

File details

Details for the file xwpandas-0.1.0-py3-none-any.whl.

File metadata

  • Download URL: xwpandas-0.1.0-py3-none-any.whl
  • Upload date:
  • Size: 5.0 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/40.2.0 requests-toolbelt/0.8.0 tqdm/4.26.0 CPython/3.6.6

File hashes

Hashes for xwpandas-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 d4fa665c8415bc7d802975c70587cfedf409a6d3e746895c11b13608426d81e6
MD5 24b82c8a77e9f08eccca66c4d3612565
BLAKE2b-256 1f9a3a7d94bfd0aedfab4de4bfcf7066bc37114fac0177addb48f5951e9354e6

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page