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 of the relational database
PatientDiseaseFile read.csvfilechoose
## Import file of the relational database
DiseaseGenomeRegionFile read.csvfilechoose
## Make a new file by merging Files and using the shared column "Disease"
joinedfilefulljoinPatientDiseaseFile DiseaseGenomeRegionFile by "Disease"
# Here is how your first file looks like. It has rows P through P and columns named Patient and Disease.
PatientDiseaseFile
Patient Disease
P Angelmanxds syndrome
P Angelmanxds syndrome
P Breast Cancer
P Breast Cancer
# Here is how your second file looks like. It has rows, one for AngelmanXds syndrome and one for breast cancer and columns called Disease and Affected genomic region.
Disease Affected.genomic.region
Angelmanxds syndrome Chromosome
Breast Cancer BRCA The dimension of first
What will be the dimensions of the file you created using the function fulljoin
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
