CSV Interpreter

Documentation File for CSV Parser Website

Introduction

Welcome to the CSV Parser website documentation. Our website is dedicated to providing an intuitive and powerful interface for parsing and analyzing structured data contained in CSV files. This document outlines the functionalities provided by the website, as well as the data structure used in our test suite.

Website Functionality

CSV File Parsing

We utilize PapaParse, a robust JavaScript parser, for handling CSV files efficiently. This tool enables asynchronous loading, automatic detection of delimiters, and a powerful step-by-step parsing feature.

Data Analysis

Our platform integrates Chart.js for visualizing data through interactive charts. This allows users to gain insights into their data by representing it graphically.

Data Tracing

Users can trace test results from abstract concepts down to specific evaluations, facilitating a comprehensive understanding of each step in their data testing process.

Data Structure Description

  • Data: Contains an overall summary of the results for each AT and CT. It contains a UniqueID int value that’s useful for distinguishing between tests.
  • Abstract Test (AT): Defines the constraints or properties being tested. Contains a column named Property that specifies the property being tested.
  • Concrete Test (CT): Specifies the list of inputs on which the test is performed. Each concrete test includes multiple evaluations (rows) and the column ‘SpeciesName’ that lists the species involved in the test.
  • Evaluations: The fundamental execution unit, where actual data tests are performed and results are recorded.

Result Columns

  • Pass/Fail/Error/FlakeyKey (0/1): Indicates the result of the evaluations.
  • Deterministic (0/1): Shows if the test results consistently pass/fail/error.
  • Evaluation_Number (int): Total number of evaluations.

How to Use the Website

Uploading CSV Files

Navigate to the file upload section, select your CSV file, and begin the parsing process.

Viewing Results

Once the file is parsed, use the interactive charts to visualize various metrics and results across different tests.

Data Tracing

Utilize the tracing feature to navigate from abstract test descriptions to specific evaluations, aiding in detailed data analysis.