7/7/17 Notes(Changing the names of classes in the data frame)

Trying to edit the names of classes so that they appear as their STEM code in the dataframe
  • I tried using the “maketrantab” function but this doesn’t work because the strings have to be the same length so I can’t translate a word into one letter with this.
  • Tried this command (Space is the file because I’m using a smaller file to see if it works before I add it to the real code):
    • Space.replace(value=dict{'Classes':{'art':'H'}})
    • “{” was invalid syntax so I replaced it with parenthesis.
    • I got an error saying : was invalid syntax so I deleted it
    • Now I’m getting an error saying my string isn’t callable
  • Tried this command:
    • Space['Classes'] = Space['Classes'].map({'art': 'H'})
    • This didn’t give me an error but when I tried to display the classes column I got all “Nan” values
    • I tried coding letters for all the classes instead of just one (I have a list of classes in one column. This did not work I still got NaN values in the classes column.
    • I tried changing the format of my file so that each class was in an individual column, then using this command:
      • Space['Am1'] = Space['Am1'].map({'English':'H'})
      • This still gave me NaN values in all the cells in “Am1” even the ones I didn’t try to change.
      • I tried writing code to change all the class names. This did not work.
      • I tried switching the order of the classes, and their new name (I wrote ‘H’: ‘English’ instead of ‘English’: ‘H’ this did not work.
    • Tried just typing “Space['Am1'].map({'English':'H','physics':'SP','math':'M'})” this had no effect, I still got the class names
    • Tried this command I found online
      • Space.Am1.replace(to_replace=dict(English=H, math=M, physics=SP), inplace=True)
      • I got an error saying H was not defined so I put apostrophes around all the letters. This worked!
    • I tried merging the class columns into one “Classes” column, and then translating the class names. This did not work so I will have to translate the names before I merge them into one column.

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