7/6/17 Notes (Trying to find total attendance)

I want to add a command that will add all the numbers in the attendance column together for one person.
  • I tried this command I found online:
    • StudentinfoAll.loc[StudentinfoAll['Full Name'] == 'Ella Hubbell', 'Attendance'].sum()
    • I got an error saying “Attendance’ is not in the columns” but is a column header
    • I looked at the chart that I made and there are multiple Attendance columns so I tried typing “Attendance_x” instead.
    • This didn’t add them it just put the numbers together into the number “10109”
  • I tried this command instead:
    • StudentinfoAll.sum(axis = {‘Georgianna Bamberger’,'Attendance_x'} skipna=None)
    • This did not work.
    • I deleted the skipna part because it was “invalid syntax”
    • I got an error saying this was “unhashable” so I changed the format of the cells in the Attendance file to “text” and reuploaded the file. This did not worked.
    • I replaced Georgianna Bamberger’s name, and ‘Attendance’ with the numbers that correspond with where the labels are on the chart.
  • I tried this command because I want my code to add the values in Attendance if the full name is Georgianna Bamberger. Here is what I typed:
    • StudentinfoAll.sum('Attendance_x' if 'Full Name' = Georgianna Bamberger)
    • I’m having problems with the syntax of 'Full Name' = Georgianna Bamberger
    • I tried this instead: StudentinfoAll.sum('Attendance_x' if 'Georgianna Bamberger' in 'Full Name'). This did not work.
    • I tried StudentinfoAll.sum('Attendance_x') just to see if it would add all the attendance values together but ‘Attendance_x’ is not an axis so I need to learn how to format this as an axis, or find a different command.
  • I tried following the exact pattern of the example online just to see what would happen, so I could edit it from there. Here is what I typed.
    • StudentinfoAll.sum(axis = {index(0), columns(1)})
    • “Index” was not defined so I replaced it with ‘Full Name’ this did not work because the string is “not callable” (which means it can’t be called)
  • Apparently in pandas “axis=0” means you’re adding the values of a column.
  • I typed “StudentinfoAll.sum(axis = 0)” to see what would happen and it listed out each column name and their sum (if the columns had numbers).
  • I tried typing “StudentinfoAll.sum(axis = 0, 'Attendance_x')” to see if it would add all the values for just the attendance column. This did not work.
  • I tried this “StudentinfoAll.sum(axis = 0 ['Atendance'])” this did not work.
  • Tried this command: “StudentinfoAll.sum('Attendance_x', axis = 0)” this did not work
  • Tried “StudentinfoAll.sum(axis = 0, if column='Attendance_x')” invalid syntax
  • Tried “StudentinfoAll.sum(axis = 0) if column = 'Attendance_x'” invalid syntax
  • Tried “StudentinfoAll['Attendance_x'].sum(axis = 0)” this gave me the sum of all the attendance values, now I just have to find a way to have it add the attendance values for just a specific person.
  • Tried this command:
    • StudentinfoAll[[Attendance['Georgianna Bamberger']]].sum(axis = 0)
    • The key error was ‘Georgianna Bamberger’ so I restarted Kernel and cleared all outputs. This did not work, I think because her name is under “Full Name” not Attendance.
  • Tried this command:
    • StudentinfoAll[[960,1010,1071],['Attendance']].sum(axis=0)
    • The numbers are the rows where her name appears
    • This did not work because it’s a “list”
  • Tried this command:
    • if StudentinfoAll['Full Name']='Georgianna Bammberger'
   StudentinfoAll['Attendance_x'].sum(axis=0)

    • This did not work
  • I made the code display just Georgianna Bamberger’s name and attendance for each year and I found that apparently there are two columns named “Attendance_x” and that might be messing up the code.
  • Tried this command
    • StudentinfoAll['Attendance_x'].sum(axis=0) for StudentinfoAll.rows[960,1010,1071]
  • I tried this command:
    • StudentinfoAll[StudentinfoAll['Full Name'] == '<Georgianna Bamberger>']['Attendance_x'].sum()
    • This told me the sum was 0 which is wrong. I wonder if I need to change the format of the cells in the attendance file into something other than “text”
    • I changed the format to numbers and this did not work.
  • Tried this
    • StudentinfoAll.groupby('Full Name').agg({'Attendance_x': np.sum})
    • This just alphabetized the names, deleted the data, and didn’t display the sum

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