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.
- Basic Data Cleansing: 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, you can use our Find and Replace tool.
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.
Row View Options
By default, we show all rows of the currently active dataset in Spreadsheet View. However, if you have some hidden points in your current plot (for example, after applying a filter), you may want to examine only the visible points. In this case, you can choose to show either only visible rows or only hidden rows by using the dropdown menu at the bottom of Spreadsheet View.
Exporting Your Datasets
Near the bottom left of the Spreadsheet View, there is an “Export Dataset As” dropdown menu that will allow you to export your active dataset to preserve any modifications you’ve made to the dataset for future analysis. This supports exporting your data as a CSV file, as well as our Network Data Formats.