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