6/01/17 Notes (fixing problems with creating charts for the Confidence survey information)


  • Still trying to fix the error that says my columns don’t exist in cell 7
    • Tried checking if a different year worked, not only did this not work, I also got a new error in cell 4 saying the value had unexpected elements.
    • Tried running the cell after fixing the issues with cell 4 to see if that affected anything. It worked for every year!
  • I added all the column headers to cell 7 and it now displays a chart with all the correct information (except for the problem with years 15-17 mentioned in the “Error in cell 4” section).
  • Error in cell 4
    • I tried typing out the command for the column names of each year to be changed, this did not work.
    • I retried using ConfidenceS14 (this one worked originally) instead of ConfidenceS15. This did not work.
    • The error claims that only 18 elements are expected, yet it is receiving 21 elements but, I counted the # of columns in the excel spreadsheet and there are 21 columns. I don’t know where it’s getting the number 18.
    • I counted the number of labels I typed into the code and there were 16…
    • I retyped the labels and made sure I had all 21. This did not work.
    • I noticed that when the duplicates are deleted in cell three, ConfidenceS15 now only had 18 columns. Years 15-17 all had only 18 columns, year 14 was the only year that has all 21 columns. But, cell 4 still only expects ConfidenceS14 to have 18 elements.
    • I checked the original code and it does the same thing with the duplicates.
    • I looked at the original code where the questions, students, or name of school was displayed. I read through the questions, and “gender,” “grade,” and “length” did not appear.
    • I deleted “Grade,” “Gender,” and “Length” from each column name. When I tried to get the shape of ConfidenceS14 I got an error that said it expected 21 elements, and but it only got 18 elements.
    • I readded “Grade,” “Gender,” and “Length” to only “ConfidenceS14.” It worked (for ConfidenceS14 at least)
    • Deleting “Grade,” “Gender,” and “Length” for years 15-17 took the error away, but  now that information will not appear on the graph.
    • The information did not appear because those questions weren’t asked in those years.
  • The missing information is on every year of the Attitudes about School Success Survey so I will not display those questions for the Confidence survey. Instead I will add that information on by appending the Attitudes survey to it.

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