About

How to Use the Mini CSV Explorer Application

Welcome to the Mini CSV Explorer Application! This web application allows you to perform various actions on CSV files, helping you analyze and manipulate tabular data efficiently. Here is a step-by-step guide on how to use the application:

1. Uploading a CSV File

To get started, click on the "Upload CSV" button located at the top of the page. Select the CSV file you want to analyze from your local computer, and click "Open" or "Upload" to import the file into the application. You can specify the delimiter of your data file at the top-right part of the page.

2. Exploring the Data

Once the CSV file is uploaded, the application will display the data in a tabular format. You can scroll through the table to explore the entire dataset. Use the pagination controls at the right-top of the table to navigate through multiple pages, if applicable.

3. Performing Actions

The application provides several actions to manipulate and analyze the data. These actions can be accessed through the action menu located in the header row of the table or at the beginning of each row. The menu will appear as soon as you click on the arrow button. Here are some of the key actions you can perform:

• Filter: Select a column and choose specific values to filter the data.
• Sort Ascending/Descending: Sort the data based on the values in a selected column.
• Group By Column: Group the data based on the values in a selected column, which allows you to include/exclude others columns in the groupby and apply different aggregations on the others columns like (Count, Count Of Unique Values, Min, Max, Sum, Median, Mean, Standard Deviation, Top Value By Frequency, First Value, Last Value and Collect Values in An Array).
• Describe Column: View statistics for a selected column.
• Show Value Counts: Display the frequency count of each unique value in a selected column.
• Show Value Progression Plot: Display a line plot showing how values in the column progressed starting from the first entry to the last entry.
• Show Histogram Chart: Display a histogram of the values in the column.
• Show Frequency Chart: Display a chart showing the values frequencies in the column.
• Modifying Data: Add or remove columns, add or delete rows, remove duplicates, remove missing values, replace values, edit rows and column names(by double clicking on the cell) and more.
• Selecting and Extracting Data: Select specific columns or rows and extract them into a new table.

4. Exporting Data

If you want to export the modified or filtered data, click on the "Export CSV" button located at the top-menu of the page. This will generate a CSV file containing the current data view. You can then save the exported file to your computer for further analysis or sharing. You can also change the name of the exported file by changing the value on top of the table.

5. Clearing Data

To clear the currently loaded CSV data and start fresh, click on the "Clear Data" button. This will remove the existing data from the application.

6. Enjoy Exploring and Analyzing Data!

With the Mini CSV Explorer Application, you have the power to manipulate, analyze, and gain insights from your CSV files. Feel free to experiment with different actions and explore your data in various ways to uncover valuable information.