Constante vulling

Constante vulling is een handige imputatiemethode als je ervan uit kunt gaan dat ontbrekende NA-waarden in een gegevensset een bepaalde vaste waarde moeten hebben. Soms raken bij het verplaatsen van data tussen verschillende platforms en software bepaalde waarden in de data ‘kwijt’ of worden ze onterecht als NA gemarkeerd. Met constante vulling kun je deze ontbrekende waarden vervangen door een standaardwaarde.

In deze oefening imputeer je ontbrekende waarden voor de tijdreeks car_sales, die de dagelijkse autoverkopen van een medewerker bij een autodealer weergeeft.

Deze oefening maakt deel uit van de cursus

Tijdreeksgegevens bewerken in R

Cursus bekijken

Oefeninstructies

Bepaal het totale aantal NA-waarden in de tijdreeks car_sales.
Gebruik constante vulling om de ontbrekende waarden van car_sales op te vullen met 0; wijs dit toe aan de variabele car_sales_filled.
Maak een autoplot van de tijdreeks car_sales_filled.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

# Add together the number of NA values
___

# Fill in missing values with zero
___ <- ___

# Autoplot the filled time series
autoplot(___) + 
  labs(y = "Daily Car Sales") + 
  theme_light()

Code bewerken en uitvoeren

Deze oefening maakt deel uit van de cursus

Tijdreeksgegevens bewerken in R

SkillTag.level.intermediateSkillTag.label

4.9+

Begin de cursus gratis

You'll learn the foundations of what a time series represents, how to retrieve summary statistics about the data in a time series, and how to visually interpret a time series plot as part of the exploration step of your analysis. You’ll also cover how to manage date and time information within R objects and ways of incorporating consistent formatting for dates.

Exercise 1: What is time series data?Exercise 2: Plotting time series with autoplot Exercise 3: Time series summary Exercise 4: Interpreting time series plots Exercise 5: Temporal data classes in R Exercise 6: Finding the class Exercise 7: is-dot functions Exercise 8: lubridate's as_date Exercise 9: Formatting dates in R Exercise 10: Conversion specifications Exercise 11: Parsing and formatting dates

Here, you’ll learn to retrieve key attributes of time series information, such as the range in time of the data and how often the data were sampled, to understand your data better. You'll also be introduced to the zoo package, which contains tools and functions for creating and manipulating time series objects. Many data science applications in R use the data frame paradigm; you'll learn how to convert between a data frame and a time series.

Exercise 1: Time series attributes Exercise 2: Temporal attributes and decimal dates Exercise 3: Comparing temporal attributes Exercise 4: Time series objects with the zoo package Exercise 5: Creating a zoo Exercise 6: zoo and ggplot2 Exercise 7: Manipulating zoo objects Exercise 8: Updating and replacing indices Exercise 9: Finding overlapping indices Exercise 10: Converting between zoo and data frame Exercise 11: Moving between data.frame and zoo

You’ll cover how to subset a window from a time series to focus on a particular period of interest. You’ll see that when working with real-world time series data, the timespan of your dataset may cover more information than you need, which can clutter your visualizations. You’ll sample time series data at various rates, such as every minute, hour, month, or year. Further, by aggregating your data, you’ll learn to see the overall trends in the data using the xts package. You'll also learn methods of 'imputing' your data – filling in missing values with constant fill, LOCF, or linear interpolation methods.

Exercise 1: Een venster met observaties subsetten Exercise 2: Een venster selecteren uit een tijdreeks Exercise 3: Een observatie zoeken op een specifieke datum Exercise 4: Logische expressies en subsets Exercise 5: Maand- en kwartaalgegevens Exercise 6: zoo::yearmon Exercise 7: zoo::yearqtr Exercise 8: Herschikken en aggregeren van waarnemingen Exercise 9: Gegevens aggregeren Exercise 10: Aangepast aggregatieniveau Exercise 11: Een geaggregeerde tijdreeks plotten met ggplot2 Exercise 12: Ontbrekende waarden imputeren Exercise 13: Imputatiemethoden Exercise 14: Constante vulling

Huidige oefening

Exercise 15: Last observation carried forward (LOCF)Exercise 16: Lineaire interpolatie

You’ll learn to create “rolling” windows of a time series that move, or "roll" along with data, making it possible to summarize trends in the data across time, such as the average over success months of observations or the sum over several weeks of sales. Overall summary statistics, like mean, median, sum, maximum, and so on, do not always provide insight into how data changes over time, and rolling windows will allow you to compute statistics dynamically. In addition to rolling windows, you will also learn how to create expanding windows, which show how these summary statistics approach their final value.

Exercise 1: What is a rolling window?Exercise 2: Rolling window functions Exercise 3: Rolling windows versus aggregation Exercise 4: Applying functions to rolling windows Exercise 5: Rolling minimum Exercise 6: Rolling apply with a custom function Exercise 7: Expanding windows Exercise 8: Rolling versus expanding windows Exercise 9: Expanding sum Exercise 10: Expanding mean Exercise 11: Congratulations!