Make the data gap free using fill gaps

The fill gaps function helps to make the incomplete data gap free and after filling gaps it can be useful for the subsequent analysis of the data set.

Step 1: Select the data from the left file tree or from “files” tab which needs to be manipulated.

Step 2: Once you select the file, it will be opened in the “Data Wrangler”.

Step 3: Click on “Fill gaps” and a popup will appear.

Step 4: Click on the columns in which you want to apply fill gaps under “Select data”.

Step 5: After selecting the columns, every cell of selected column of the file will be checked and there are six options with which you can make your data gap free.

  1. Linear interpolation: It considers the last cell with value and next cell with value, then, fills the intermediate empty cell with values that would produce a straight line if the values are plotted.
  2. Previous value: Fills the gaps by repeating the value of the last cell with a value.
  3. Mean of all values: Fills the gaps by using the mean of all values in the column.
  4. Median of all values: fills the gaps by using the median of all values in the column.
  5. Minimum of all values: fills the gap by using the minimum value of all the values in the column.
  6. Maximum of all values: fills the gap by using the minimum value of all the values in the column.

Step 6: The default “Result” is to overwrite the original file with the updated file.

Select what you want to save as your output file from the “output” drop down menu.

If you want to keep the original file along with your updated file then, click on “Keep all columns” or “only keep selected columns” under “create new file”. Click “run”. The new file will be saved in the same folder as original file.