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:
- Feature Creation: Right-click on a column title to see the options available to create new features based on that column. See our page about Feature Creation for complete details.
- 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.
Exporting Your Datasets
Near the bottom left of the Spreadsheet View, there is a “Save as CSV” button that will allow you to export your active dataset to preserve any modifications you’ve made to the dataset for future analysis.