Welcome to read-csv-excel’s documentation!

read-csv-excel is a Python library that provides a collection of common and customized functions for handling data, particularly CSV and Excel data. It simplifies the process of converting data into Pandas DataFrames, performing statistical analysis, and creating visualizations.

Check out the Usage section for further information, including how to Installation the project and examples for the usage of the functions.

Note

This project is under active development.

Contents

• Usage
  • Installation
  • Load dataframe from file
    • df_csv_excel.read_data.read_data_by_path()
• Process Dataframe Column
  • Process Date Column
    • parse_dates()
  • Process JSON Data in DataFrame
    • get_feature_from_json()
  • Get Latest Row by Column
    • get_latest_row_by_column()
  • Get Email Domain and Prefix from Email Column
    • get_email_host()
  • Calculate Age
    • calculate_age()
• Feature Engineering
  • Check Significant Association with Chi_square
    • significant_association_chi_square()
  • Calculate Jaccard similarity
    • get_similarity()
  • Calculate Information Value (IV)
    • calculate_iv()
• Model Evaluation
  • Evaluate Binary Classification Performance
    • binary_classification_eval()
• graph
  • Plot Pie Chart
    • plot_pie_chart()
• API