Q1. Read the csv files in the folder. Solution: What is the R code? Q2. Merge the data frames using the variable "ID". Name the Merged Data Frame "USDA". Solution: What is the R code?

11. Create a histogram of Vitamin C distribution in foods, with a limit of 0 to 100 on the x-axis and breaks of 100. 12. Add a new variable to the data frame that takes value 1 if the food has higher sodium than average, 0 otherwise. Call this variable HighSodium. 13. Do the same for HighCalories, HighProtein, HighSugar, and HighFat. 14. How many foods have both high sodium and high fat? 15. Calculate the average amount of iron by high and low protein (i.e. average amount of iron in foods with high protein and average amount of iron in foods with low protein). I need rmd file (r programing). I see the code but was wondering if: 1) I could please get an RMD file with the code that shows solutions (r code and output) for each of the 15 questions. 2) I also need knitted MS word file that shows it all. I have attached similar pdf document just so you see as an example. P.S. When preparing data set (Q3) I think that two data types should be changed as they are categorized incorrectly. 25401280_102 Brankovich Nenad .pdf This RStudio file Can this be saved as .rmd please?

Please send me two files for the solution. The first file should be an RMD (R) file. The second file should be in MS Word (knitted) with snapshots…thank you! . Read the csv files in the folder. 2. Merge the data frames using the variable "ID". Name the Merged Data Frame "USDA". 3. Prepare the dataset for analysis. 4. Remove records with missing values in 4 or more vectors. 5. How many records remain in the data frame? 6. For records with missing values for Sugar, Vitamin E and Vitamin D, replace missing values with mean value for the respective vector. 7. With a single line of code, remove all remaining records with missing values. Name the new Data Frame "USDAclean". 8. How many records remain in the data frame? 9. Which food has the highest sodium level? 10. Create a scatter plot using Protein and Fat, with the plot title “Fat vs Protein”, labeling the axes “Fat” and “Protein”, and making the data points red.

Please upload two files for the solution. The first file should be an RMD file. The second file should be in MS Word with snapshots.thank you! Read the csv files in the folder.Calculate the average amount of iron by high and low protein (i.e. average amount of iron in foods with high protein and average amount of iron in foods with low protein).