Menu "Cleanse"
You can manually edit the loaded data in Visplore for analysis. For example, you can replace outlying values by meaningful estimates. When editing data, all visualizations and computations are updated immediately. |
This menu offers multiple options to edit selected data (= "the Focus") in the currently shown variable(s):
- Set missing: Replaces the data by missing values. This can make sense as missing values are ignored for computations such as statistics.
- Set to value: Sets the data to a specific, user-defined value.
- Linear interpolation: Replaces data by a linear interpolation between samples before and after each contiguous interval.
- Most recent value: Replaces data by repeating the value before each contiguous interval.
- From other variable: The user may specify another variable as data source of the replacement. The data can be rescaled to match the scaling of the target variable.
- From time before/after: The data is replaced by data from the same time series, applying a user-defined time offset, for example by data from one week before.
- Add offset: Adds a constant, user-defined offset to the data.
- Multiply by factor: Multiplies the data by a user-defined factor.
- Restore original: Restores edited data to the values imported from the data source. Only edited data is affected.
Some options are only available if the data contains a time stamp.
Note: Edited data only affects the analysis in Visplore and does not change the data in the data source. To persist your changes, you can export the edited data or embed it in a .visplore file.
Further information about cleansing data