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 together for the 2014 surveys.
  • Working on finding a way to check to see if a person came to Urban scholars, if their name isn’t appearing on the chart for that year.
    • Tried this command. This did not work. Error said “Bryanna Bascombe” was invalid syntax.
Bryanna Bascombe in df.<Attendance>.values
Bryanna Bascombe in df.index.values
Attendance.loc[[Bryanna Bascombe],:]
    • Tried deleting <> this did not work.
    • Tried replacing “Attendance” with “Full Name” this did not work.
    • Tried “df.Attendance.column['Full Name'].values” This did not work.
    • Tried “Bryanna Bascombe in df.Attendance.values
Bryanna Bascombe in df.'Full Name'.values
This did not work.

    • Tried just “Attendance.loc[[Bryanna Bascombe],:] This did not work
    • Tried Attendance.loc[['Bryanna Bascombe'],['Full Name']] This did not work
    • Tried deleting ‘’ this did not work
    • If I put the # in, it shows Bryanna, but only one year. Also, this is an inconvenient way to look people up.
    • Tried “Attendance.loc[['Bascombe','Bryanna'],:]” (and with first name first, then last name). This did not work.
    • Tried typing “Girl” instead of “Bryanna Bascombe” to see if bringing up columns in general was a problem, or just her name was a problem. This did not work.  
    • This syntax works! I just needed to add “na=False”  so that it could display the NaN cells
      • Attendance[Attendance['Full Name'].str.contains('Bryanna Bascombe', na=False)]

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

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