6/22/17 Notes


  • I resaved the google master file to my computer so that the code has the updated version of the file
    • I got an error saying the file didn’t exist so I opened the file on my computer and saved it again, making sure it was saved as a csv file. This did not work
    • I copied and pasted the file name into the code to make sure it was correct. This did not work.
    • I renamed the file to “Attendance 2003-2017” (I’m wondering if the parentheses in the original title messed it up). This did not work
    • I restarted Kernel and cleared all outputs. This did not work.
    • I deleted all the versions of this file I had, and redownloaded it. This worked!
  • Working on being able to search names of classes in all the columns
  • Tried using this command:
    • “Studentinfo14[Studentinfo14['Pm S1'+'Am S1'].str.contains('Check', na=False)]”
    • I searched “check” because I know that it appears in both columns. This did not work.
  • I am going to combine all the class columns into one column using the same command I used to make the full name column.
    • I successfully combine the Am and Pm columns.
    • I am going to try to combined all the class columns at once so that I don’t have to keep repeating the command.
    • Here is the command I typed:
    • Studentinfo14['Class']= Studentinfo14['Am S1'] + ' ' + Studentinfo14['Pm S1'] + ' ' + Studentinfo14['Am S2']
    • This worked!
    • I added all the other column names in a similar fashion, and this worked.
    • Now I can search for classes in all columns.
  • However, now the data for the students’ responses is appearing as “Nan”
    • I added the command that enables the code to show all the rows and columns to this cell. This did not work
    • I am going through my code to see which surveys aren’t appearing because some surveys display the actual numbers and some only display “Nan”
    • That made no sense so I cleared my Kernels and tried again. Now the numbers are being displayed but not the column names
    • I added a cell before I merged all the files and had it display the individual files so I could see which ones displayed numbers and which ones displayed “Nan”
      • Confidence: Displays numbers
      • Attitudes: Displays numbers and short answers
      • Career: Displays numbers
      • Semantics: Displays numbers
    • I checked “Bryanna Bascombe”  (someone whose name was in the survey files) and her data appeared
    • I searched “Reality” in the cell that searches specific classes (I chose this class because Bryanna took it and I know she took the surveys). This worked
  • I’m going to go back and add the column titles for every year and test the other years to make sure everything runs smoothly .

Comments

Post a Comment

Popular posts from this blog

6/14/17 Notes

I want to write a code so that I can search the name of a class, and everyone who took that class will appear. Originally I assumed I could use the same command I did to search for a specific name, and then edit that so the code would search for a specific person. However, looking at the format of the file, there are four different columns that contain class information, while there’s only one column with name information. I am going to see if I can search for a specific class in the “Am S1” column first to see if everything runs smoothly, and if that works, I will look for ways to search for an ID word in multiple columns. I tried this command. Only the column headings are appearing and nothing else Studentinfo14[Studentinfo14['Am S1'].str.contains('Discovery', na=False)] I changed “Studentinfo14” to attendance so that the code would look for this information in the attendance file instead of the master file. This worked, but using this file means that I ca...
Read more

6/06/17 Notes (formatting code and searching for a specific person)

Working on fixing the format of the code, deleting cells, and making sure everything in an organized order to make it easier to use Earlier I was having a problem displaying the Confidence survey chart so I renamed all the columns and then it displayed. I now found that the command “ConfidenceS#.lock[:,:] also works, and is much more efficient because now I don’t have to go through each survey and copy and past the column names for every year of every survey. This works for all of them except Semantics, not sure why. I finished adding all the survey information I needed to merge all the surveys for 2014. I keep getting errors in the cells that deal with inverting numbered responses because certain column headers “don’t exist.” This means I actually will have to rename all the columns. However, for some reason this does not affect the cells that merge all the data. I successfully uploaded all the files onto the code and merged all the surveys and the attendance spreadsheet to...
Read more

May 22, 2017 -- SienaSemanticsSurvey -- Code Breakdown -- Cell #8

Image
Information on Counter Counter: container that keeps track of how many times equivalent values are added. ScountsS14=coll.Counter(SemanticsS14.iloc[:,3])                                            ^ locates each student's data, but pulls out the 4th column (name of school)                       ^creates a collection of how many times student's listed the same school labels = list(set(SemanticsS14.iloc[:,3])                       ^ removes duplicates                 ^ creates a list n = len(labels)         ^ gives the length of the list found above                   ^ becomes representative of size which will be used below to distribute pieces of pie...
Read more