Cell #10

Code
  • ScountS14 = coll.Counter(ConfidenceS14.iloc[:,3])
    • Finds the data that deals with the student, and what school they attend
  • labels = list(set(ConfidenceS14.iloc[:,3])) n = len(labels)
    • list(set()) deals with sets, I’m assuming this takes the list of # under the labels and groups them as a set
    • len() keeps number of items in a list (number of data entries)
  • sizes = [] for i in range(0,n): sizes.append(ScountS14[labels[i]])
    • This line gives each “label” (school name) a size based on the percentage of kids that go to that school
    • The size depends on the length of the list set up in the previous line.
  • “Colors” and “explode” change the colors of the pie slices, and dictates whether or not the slice pops in 3D.
  • Changing the “startangle” number switches which colors represent which school
  • Deleted the part highlighted in red because before an error was showing up that said “Too many values to unpack.” Without this part the graph appears fine.
    • patches, text = plt.pie(sizes, colors=colors, autopct='%1.1f%%',shadow=True, startangle=200)
  • “loc=” dictates the orientation of the chart and the legend, “loc = [1,0]” looks the best
Notes

  • Having similar issues with explode as Torri
  • Is “Homeschool” and “Homeschooled” the same thing? They show up as different sections of the pie chart, but they sound similar.
  • Tried to make legend using image on Torri’s blog
  • Accidentally deleted cell 10 while trying to delete a line, then I clicked on the save button instead of the file button. Now the last checkpoint is without cell 10.
  • Deleted and then reuploaded files so all the cells are there.
  • …
  • Now I’m getting a pop up that says  “Unreadable Notebook: C:\Users\sweett\SienaSurveyConfidence.ipynb NotJSONError("Notebook does not appear to be JSON: u''...",)” and I can’t open the python code.
  • Deleted and uploaded again and it’s working now
  • How do I make the % appear again???

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