analytics_packages

Helper functions for generic analysis and iteracting with Excel files

Documentation
PyPI

Installation

pip install kabbes_analytics_packages

Usage

For more in-depth documentation, read the information provided on the Pages. Or better yet, read the source code.

import analytics_packages.custom_xlwings as cxw

wb = cxw.get_wb( 'excel_data.xlsx' )
ws = cxw.get_ws( wb, sheet = 'Sheet1' ) 
df = cxw.get_df_from_ws( ws ) #Pandas DataFrame

cxw.delete_sheet( ws )

import analytics_packages.custom_pandas as cpd
import pandas as pd

df = pd.DataFrame( {'A': [ 1,2,3 ], 'B': [ 4,5,6 ] } )
df_new = cpd.move_last_column_to_first( df )
print (df_new)

>>>
   B  A
0  4  1
1  5  2
2  6  3

Author

James Kabbes