Week 8: Input/Output, string manipulation and plyr package

Week 8: Input/output, string manipulation and plyr package


    This week was interesting, and the concepts covered within were quite complex this week, seeing code I've never seen before to alter csv files in ways I haven't had the chance to. I had issues downloading the file however, as it didn't wish to save properly, having instead to copy the info into a notepad file, save as all files, and manually type .csv at the end of the file.  However, in the end I got it done, the variable names may be a little wonky as a result, but the code is functional, and I will explain line by line what is going on. The code is available on my GitHub here, and I will upload the csv also.


This is the first few lines of my program, with the first two simply reading in necessary libraries for the program to function, the third reading the csv data (file that I created) into the variable assignment8dataset and then we group the dataset by "sex" (gender), calculate the average grade of each group (male/female grades) and then adds that mean back to the dataframe. 


The first line is creating a text file on my computer, saving the student averages and separating the information in the documents with commas. The line after creates a new dataset that only retains the names that have the letter "i" in it. And the final sentence or line of code simply creates another textfile to my computer with that information (names that have the letter "i" in it"). The results of which can be seen here:

Above you can see that all the students with a name containing the letter "i", 14 of the 20 original observations remain. Only one male in the dataset had a name containing the letter "i", which is something of note. 

The above is the file showing the grouped data, that is the file showing the grouped averages of the genders as well, allowing you to see if the grade the individual received was better or worse than the average of their gender peers. In simpler less convoluted words, you can check the average grade against that of the average male if they're male, or female if they're female. For example, Lauri Scored higher than the average woman, and Raul scored slightly under the average male. 

This week's assignments and lectures were a pleasure as always, I hope I fulfilled the assignment requirements and the little hiccup I had with the file formatting being weird was easily circumvented by the copying of and saving of a new file with the same information, lain out as was intended. I continue looking forward to future assignments, and again enjoyed this weeks coursework.




Comments

Post a Comment

Popular posts from this blog

Week 4: Programming Structure in R

Image
  Week 4: Programming Structure in R      This week was interesting, I'm currently taking visual analytics, predictive analytics, and data text mining so they're all really bleeding into each other quite beautifully. Visiting box plots and histograms is always enlightening in terms of what they can generally reveal about a particular dataset.  With this information at the front of our minds: (Raw data) My code followed by the output:      Frequency here is just taken to mean number of people that falls within that range. There are 2 people under 50 for instance. It can be said from the boxplot that most fall within the 60-120 range for blood pressure, with some ranging to 200 and going as low as 10 it appears. The histogram confirms that most fall within what would be termed a reasonable range, that is 50-150, but the data is skewed by the 4 people that fall in the 0-50 and 150-250 ranges.       From the raw data we can also se...
Read more
Image
  Assignment Blog 2; Fixing myMean     To begin, we must first see what the problems are, and sometimes they're highlighted by the error message which is as follows: The error message shows that the code is not working as intended because "assignment" is not found. This helps us easily flag our issues within the code. First "someData" is not a variable that has been established so it cannot be referenced in this program, and sum(assignment) is missing the 2 that it very much needs to be the variable that has values stored. A corrected version of the above code is shown here: As you can see above, fixing the variable names allowed for the program to properly reference what it needed to, in order to function as intended. The average output is correct, double checked with a calculator just to be sure, with the mean score on assignment 2 being 19.25.
Read more
Image
Assignment #1 This is a first little test of what is possible in this blogging software. I enjoy WordPress more but unfortunately; I seem to be taking both of your classes at the same time which means for my own sanity I must use two different platforms to separate the classes properly in my mind. I'm sure it will be easier on you guys too. I have also done the github stuff: I think this will be an enjoyable semester and I honestly look forward to the challenge of this and my other classes. I nearly died last week to ketoacidosis; it was really close. The chance I get to sit here and do this after working a shift is something I don't take for granted anymore so let's continue. Here is the console window of RStudio: There were no issues installing, the links lead right where I needed to go, I downloaded R 4.5.2 for windows, my operating system is using 25H2 which is windows 11, and my R Studio version is 2026.01.0-392.  I was also tasked with describing a vector, basically...
Read more