podlove_clean_stats: Connect and clean podcast and reference data

In lordyo/podlover: Collects, Cleans and Analyzes Podcast Download Data from Podlove Publisher

Description

podlove_clean_stats takes podcast download and various reference data to create a tidy set of download attempts. The reference data consists of the tables for podlove episodes (df_episodes), blog posts (df_posts), user agents (df_user) and media files (df_mediafile).

Usage

podlove_clean_stats(
  df_stats,
  df_mediafile,
  df_user,
  df_episodes,
  df_posts,
  ddupe = FALSE,
  launch_date = NULL
)

Arguments

df_stats	contents of the MySQL table wp_podlove_downloadintentclean
df_mediafile	contents of the MySQL table wp_podlove_downloadintentclean
df_user	contents of the MySQL table wp_podlove_useragent
df_episodes	contents of the MySQL table wp_podlove_episode
df_posts	contents of the MySQL table wp_posts
ddupe	boolean switcher for legacy deduplication. Don't use this until you know what you're doing.
launch_date	date of the first official podcast episode release, defaults to date of first download attempt (which may be before the first episode was released)

Value

a dataframe containing all episode download attempts

Examples

## Not run: 
podlove_clean <- podlove_clean_stats(df_stats = table_stats,
                                     df_mediafile = table_mediafile,
                                     df_user = table_useragent,
                                     df_episodes = table_episodes,
                                     df_posts = table_posts,
                                     launch_date = "2017-12-04")
                                     
## End(Not run)

lordyo/podlover documentation built on Feb. 20, 2020, 5:58 p.m.