Spreadsheet View appears on screen after loading data into the application. This window allows you to browse through the whole dataset as a table. Under each header, you can also open 2D histograms for each column – this is a great way to view the distribution of each feature.
Configuring Your Data
A few important pieces of maintenance may need to be performed in Spreadsheet View for newly loaded datasets:
- Converting the column type: When VIP loads in a dataset the application assigns a type to each column based on the data it contains (see Data Types). You can change this by clicking on the column title, and then selecting the Convert option if it is available.
- Renaming Columns: Click on the column title, and then select Rename to change the name of the column.
- Defining Missing Values: VIP recognizes empty cells as “Missing”, and will handle them differently when doing calculations and visualizing those columns. However, some datasets define missing values in a different way, such as by entering the words “missing” or “N/A”. To make the app recognize these as missing values, simply select the Define Missing Values button, enter the desired text, and click Apply.
Switching Between Loaded Datasets
As you load datasets they will appear on the left side of Spreadsheet View under the local tab. The currently loaded dataset has a green highlight next to its name. To switch to a different dataset, simply click on it. To remove a loaded dataset from memory, click the red X that appears when hovering over its name.