Skip to content
This repository has been archived by the owner on Jan 18, 2022. It is now read-only.
/ xwpandas Public archive

High performance Excel IO tools for pandas DataFrame

License

Notifications You must be signed in to change notification settings

MinjeJeon/xwpandas

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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')