Question: Examine the following R code we used in class to merge two files while learning about database management. ## Import file 1 of the relational

Examine the following R code we used in class to merge two files while learning about database management.
## Import file 1 of the relational database
Patient_Disease_File1= read.csv(file.choose())
## Import file 2 of the relational database
Disease_GenomeRegion_File2= read.csv(file.choose())
## Make a new file by merging Files 1 and 2 using the shared column "Disease"
joined_file=full_join(Patient_Disease_File1, Disease_GenomeRegion_File2, by = "Disease")
# Here is how your first file looks like. It has 4 rows P1 through P4 and 2 columns named Patient and Disease.
Patient_Disease_File1
Patient Disease
1 P1 Angelman\xd5s syndrome
2 P2 Angelman\xd5s syndrome
3 P3 Breast Cancer
4 P4 Breast Cancer
# Here is how your second file looks like. It has 2 rows, one for Angelman/Xd5s syndrome and one for breast cancer and 2 columns called Disease and Affected genomic region.
Disease Affected.genomic.region
1 Angelman\xd5s syndrome Chromosome 15
2 Breast Cancer BRCA1 The dimension of first
What will be the dimensions of the file you created using the function full_join()?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!