Skip to content

The key functionalities include summary statistics calculation, percentage change computation, outlier detection, trend analysis, moving average calculation, correlation analysis, and seasonal pattern interpretation.

License

Notifications You must be signed in to change notification settings

DurgeshRathod/dataframe-statistical-analyzer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DataFrame Statistical Analyzer Utility 📊

The DataFrameAnalyzer project provides a robust and extensible tool for analyzing and visualizing data stored in a Pandas DataFrame. The tool encapsulates various data analysis functionalities, including summary statistics, percentage change computation, outlier detection, trend analysis, moving average calculation, correlation analysis, and seasonal pattern interpretation. The project is designed following the SOLID principles and incorporates design patterns to ensure maintainability and ease of use. 🚀

Features 🌟

  • Summary Statistics: Statistical summary of the DataFrame. 📈
  • Month-to-Month Percentage Changes: Percentage changes between consecutive months. 🔄
  • Outliers Detection (Z-score > 3): DataFrame segments identified as outliers based on Z-score. 🚨
  • Outliers Detection (MAD): DataFrame segments identified as outliers based on Median Absolute Deviation. 📉
  • Trend Analysis (Linear Regression): Slope and intercept of linear trends for numeric columns. 📈
  • Moving Average (3 months window): Moving average values for numeric columns over a 3-month window. 📊
  • Calculating DIPS: DataFrame segments identified as dips below certain thresholds. 📉
  • Calculating Increases: DataFrame segments identified as increases above certain thresholds. 📈
  • Seasonal Patterns: Monthly seasonal patterns identified using Holt-Winters exponential smoothing. 🌿
  • Correlation Analysis: Correlation matrix between numeric columns. 🔗

Installation 🛠️

  1. Install the package:
    pip install dataframe-statistical-analyzer

Usage 🖥️

  1. Import the necessary modules:

    import pandas as pd
    from dataframe_statistical_analyzer import DataFrameAnalyzer
  2. Prepare your DataFrame:

    data = {
        "month": ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'],
        "stock_price": [50.0, 51.5, 49.8, 52.0, 53.2, 54.0, 55.0, 56.0, 57.5, 59.0, 60.0, 61.0]
    }
    
    df = pd.DataFrame(data)
  3. Initialize the DataFrameAnalyzer with the DataFrame:

    analyzer = DataFrameAnalyzer(df)
  4. Perform the analysis:

    analyzer.analyze()
  5. Expected Outputs: When you run the analyze() method of DataFrameAnalyzer, you can expect to see the following outputs:

    • Summary Statistics: Statistical summary of the DataFrame.
    • Month-to-Month Percentage Changes: Percentage changes between consecutive months.
    • Outliers Detection (Z-score > 3): DataFrame segments identified as outliers based on Z-score.
    • Outliers Detection (MAD): DataFrame segments identified as outliers based on Median Absolute Deviation.
    • Trend Analysis (Linear Regression): Slope and intercept of linear trends for numeric columns.
    • Moving Average (3 months window): Moving average values for numeric columns over a 3-month window.
    • Calculating DIPS: DataFrame segments identified as dips below certain thresholds.
    • Calculating Increases: DataFrame segments identified as increases above certain thresholds.
    • Seasonal Patterns: Monthly seasonal patterns identified using Holt-Winters exponential smoothing.
    • Correlation Analysis: Correlation matrix between numeric columns.

Contributing 🤝

We welcome contributions to the DataFrameAnalyzer project. Please fork the repository and submit a pull request with your changes. Ensure your code adheres to the existing style and includes appropriate tests.

License 📜

This project is licensed under the MIT License. See the LICENSE file for more details.

Acknowledgments 🙏

This project utilizes several open-source libraries, including Pandas, Matplotlib, Scipy, Scikit-learn, and Statsmodels. We thank the developers and maintainers of these libraries for their invaluable contributions to the open-source community.

About

The key functionalities include summary statistics calculation, percentage change computation, outlier detection, trend analysis, moving average calculation, correlation analysis, and seasonal pattern interpretation.

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages