Session 6

** Please click all the tabs (in sequence) to get the entire set of information in these pages. **

** To download code, see the instructions in Session 2: https://rpubs.com/hkb/DAX-Session2 **

Objectives

• Project Planning Review

  • State the area or domain you want to work on (e.g., Sports, or Social Media Use)

  • List 2-5 main questions you want to answer from the data

  • State your data source, and how you would access the data

  • List how and where you would do your computations (e.g., on RStudio)

  • Try to identify some tasks that you would need to accomplish (e.g., set up the data, how to transform it, what visualizations you would want to build)

  • Come up with a timeline to do all these things, so that you have a first draft by August 4th.

• Collecting or Creating Data Sets

• Basic Operations on Data Sets

Collecting or Creating Data Sets

Create one

# build an example data frame
df.eg <- data.frame(col1 = letters[1:5], col2 = seq(2,4,length=5), cases = sample(50,5))
# df.eg$col4 = (100*df.eg$col2)/df.eg$col3
df.eg <- df.eg %>% mutate(deaths = 100*col2/cases)

df.eg <- df.eg %>% mutate(lag.deaths = lead(deaths,2)) 
# print the first few rows
print(head(df.eg))

df2 <- data.frame(col1 = letters[3:4], names = c( "Mallika", "Liam"))

print(df2)

df.merge <- inner_join(df.eg, df2, by="col1")
print(df.merge)