Merging Data

Hello, If we have 2 df with many columns on both and we want to add only ONE column from df2 to df1 (instead of merging the whole thing), what should we do? is there an argument on the left_join function to do that ?

When I download the file it I end up with something in my data-raw folder that can not be opened by Excel or by R. This is the error message:

> or_districts <- read_excel(path = "data-raw/oregon_districts.xlsx",

•                        sheet = "Sheet1")
  

Error: Evaluation error: zip file 'data-raw/oregon_districts.xlsx' cannot be opened.

If I go to the url directly and download it to my laptop then move it into the data-raw folder I am able to open it. How can I get R to download a usable file directly? Thanks!

Hi David, Out of curiosity, how would you do an anti-join in order to keep 4, 4y? Thanks, Atty

Hi David,

When I import the district data - I cannot read sheet 1, so I ended up using this code without specifying sheet 1: oregon_districts <- read_excel(path = "data-raw/oregon-districts.xlsx").

Also, I noticed that maybe you omitted some steps in your final code (enrollment_by_race_ethnicity) - it is not in the solution code you shared, but it is in the video.

Here is my code, I wonder why I could not read my excel Sheet 1.

#Download Oregon District File download.file(url = "https://github.com/rfortherestofus/going-deeper/raw/master/data-raw/oregon-districts.xlsx", mode = "wb", destfile = "data-raw/oregon-districts.xlsx")

#Import Oregon District Data oregon_districts % clean_names ()

#Join Race/Ethnicity and Oregon District Data enrollment_by_race_ethnicity <- left_join(enrollment_by_race_ethnicity, oregon_districts, by = c("district_id" = "attending_district_institutional_id"))

Thanks, Atty

the code shown below the solution video appears to have an error and does not match the code in the Solution video. On line 38 it is missing the x data frame of the left_join() "enrollment_by_race_ethnicity" should come before the comma with oregon_districts after, right? [that's what was done in the solutions video

The animations are Fantastic. The slide text describing full_join() and and inner_join() was confusing for me. The slides appear to be using the same text (I’ve checked multiple times and can’t find a difference) and was confusing.

The animation of inner_join() makes it look like it does NOT keep “all rows and all columns from both x and y”. it only does so IF there is a match.

Is this a correct interpretation of inner_join(): “Only returns rows where there are matches between x and y”?

Hi! When I try to use the read_excel function I get this error:

Error: filepath: /Users/julio/Library/Mobile Documents/com~apple~CloudDocs/R/R for the Rest of Us/Going Deeper with R/going-deeper-dk/data-raw/oregon-districts.xls libxls error: Unable to open file

This is my code: oregon_districs <- read_excel(path = "data-raw/oregon-districts.xls", sheet = "Sheet1")

If I open it with excel I get a warning that the format and extension of the file don't match. In the end I can open it and see the values if I press I want to open it anyway.

Dear Charlie and David, I do not know what I'm doing wrong. I used inner_join to join a df that has 72500 observations and 253 variables (x), and I wanted to join with a df that has 718232 observations and 2 variables (y). I joined them using the variable in which they share the same code ("annotation"). I expected that I would have 72,508 observations and 254 variables in my new matrix, but a matrix with 718,232 observations and 254 variables was generated.

gene_ecoli_mat <- inner_join(matrix_profile_ecoli, ecoli_pangenome_annot, by = "Annotation")

I thought there would be a matrix where the 72508 observations are shared.

Thanks in advance,

Sara

I am often combining multiple datasets where I combining by name. Many times the names are slightly different. (Things like Jr. or AJ vs A.J. or Mike vs Michael) Do you have any suggestions to do handle this?

In the solutions code lines 51-53 seem redundant?