CSV DATA INSIGHTS
Divyabarathi P ,Vaishnavi Sriraman
Bannari Amman Institute of Technology
divyabarathip@bitsathy.ac.in , svaishnavi2806@gmail.com
ABSTRACT
To create an all-inclusive and intuitive CSV file preparation and analysis tool. Through the uploading of CSV files and the retrieval of vital data, this technology enables users to receive profound insights into their datasets. The program automatically offers information upon file upload, including the quantity of columns, the detection of absent and duplicate rows, and a thorough breakdown of the data types linked to each column. Additionally, our research uses univariate analysis to provide customers with useful statistical insights into the distribution and properties of their data for both numerical and categorical columns. With the help of this functionality, users may make more informed decisions by having a deeper grasp of the distribution patterns in their data. Our application provides full insights when working with either numerical variables that require statistical measurements or categorical variables that require frequency analysis. We increase user engagement by using Plotly's power to present the results through an interactive dashboard. Users can easily examine patterns, trends, and anomalies in their datasets thanks to this visual representation. To further enhance the utility of our tool, we have implemented a user interface (UI) that facilitates data preprocessing. Users can conveniently remove unwanted columns and perform data type conversions directly through the interface. This streamlines the data preparation process, saving time and effort for individuals working with diverse datasets. Our project addresses the need for a comprehensive and accessible tool for users dealing with CSV files, providing a holistic solution for file analysis, visualization, and preprocessing. The combination of informative insights and interactive features ensures that users can efficiently manage and optimize their datasets with ease.