Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
David_Burnham
Super User

Column Filling

This script will fill missing values within a column based on other occurrences of data7114_datatable.JPG:

In this illustrative data table, we might choose to forward-fill the Jan Ozone column or back-fill the Dec Ozone column.

For example, forward-filling the Jan Ozone column would set the value of 2.63 for the whole of 1955; back-filling the Dec Ozone column would set the value to 3.83 for the whole of 1955.

This type of data often arises when two tables are joined, but they have differing sample rates.

The script allows you to specify the direction of the fill, and whether to fill in-place or to create a new column:

7115_colfill.png

Article Labels
Article Tags
Contributors