Watts-College / cpp-527-fall-2021

A course shell for CPP 527 Foundations of Data Science II
https://watts-college.github.io/cpp-527-fall-2021/
2 stars 6 forks source link

Final Project #82

Closed WSKQ23 closed 3 years ago

WSKQ23 commented 3 years ago

Hello @lecy , I just noticed a change in the data set link below:

URL <- 'https://docs.google.com/spreadsheets/d/1RoiO9bfpbXowprWdZrgtYXG9_WuK3NFemwlvDGdym7E/export?gid=1335284952&format=csv'
d <- read.csv( URL )
head( d ) %>% pander()

I created the merge yesterday using

dat3 <- merge( x=d, y=gen, by.x = "first.name", by.y = "name", all = TRUE) 
head(dat3)%>% pander() 

and it works well.

Trying to do some work on it today It shows this error below Error in fix.by(by.x, x) : 'by' must specify a uniquely valid column

And noticed that first.name is no longer in thed data set.

Please help

lecy commented 3 years ago

first.name is a variable you create in Step 2 and add yourself.

It definitely needs to be in the dataset before you merge.

WSKQ23 commented 3 years ago

I got you Thanks Sir