dataframe-statistical-analyzer 0.1.0

No project description provided

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. Clone the repository:

   git clone https://github.com/DurgeshRathod/DataFrameAnalyzer.git
   cd DataFrameAnalyzer
   

2. Install the required dependencies:

   pip install -r requirements.txt
   

Usage

1. Import the necessary modules:

   import pandas as pd
   from DataFrameAnalyzer 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.