This script processes and analyzes CSV datasets, providing functionality for data cleaning, filtering, and various visualizations including histograms, bar charts, pie charts, and scatter plots.
For more details on script development, documentation, and usage, refer to # 10. DOCUMENTATION in script_notebook.ipynb.
NOTE: I will be using the SalesData.csv file as an example for the development of the script.
- Data Loading: Reads a CSV file into a pandas DataFrame.
- Data Preparation: Cleans the data by removing duplicates, handling missing values, and converting date columns.
- Summary Statistics: Generates descriptive statistics for the dataset.
- Filtering: Filters data based on specified column and value.
- Visualizations: Creates histograms, bar charts, pie charts, and scatter plots based on user-defined columns.
- Python 3.x
- pandas
- numpy
- matplotlib
- seaborn
Install the required packages using pip:
pip install pandas numpy matplotlib seaborn