Module 8. Assignment CSV files

 

(please click images for higher clarity)

The images above showcase file‑write operations succeeded and the R code. 

The first step imports the data without commas, from the dataset.txt file. It then creates a summarized table that shows the average grade for males and females. The resulting data frame, gender_mean, is then written to a tab-delimited text file named gender_mean.txt for reference or sharing.

The second step filters the data to find all students whose names contain the letter “i” or “I,” using the grepl() function. A smaller data frame, i_students, is created from these matching rows and saved to a csv file. The final step produces a new csv file, created including all original columns, for just the names including the letter "I". This is the final document for this project, creating a new data set containing just those names.