6/27/17 Notes (Fixing case sensitivity and deleting apostrophes)

  • Still trying to make the names in the attendance file all uppercase
  • Tried typing the number of the First Name and Last Name columns in between the brackets instead of the column name. This did not work.
  • Tried typing the letter of the First Name and Last Name columns in between the brackets instead of the column name. This did not work.
  • I accidentally typed two commands to make the “First Name” column all caps instead of both the first and last name columns. This worked, I only got an error when I tried to make the last name column all caps which means that there is something wrong with that column. I am going to look through it to make sure there aren’t any numbers in that column.
  • I found a name with parentheses it so I deleted them. This did not work.
  • I tried changing the format of all the last name cells from “general” to “text” this did not work (the format of the first name column is “general” and it works fine)
  • I added a “1” to Bilal so that the cell read “Bilal1” to see if having a number in one cell would cause an error. The name appears but the 1 does not so I’m not sure if the code just deleted the 1, or if it’s not responding to the edits I’m making in the file
  • I deleted the name “Bilal” and saved the edit on my file, then, cleared the outputs on the code. However, when I ran the cell, “Bilal” still appeared which means the code isn’t responding to the edits I’m making to the file.
  • I deleted the Attendance file from Jupyter Notebook, and reimported it.
  • Now the First Name column won’t appear which means that blank spaces mess up the code.
  • I’m going to retry all the edits I made earlier but delete and reimport the code this time after every edit I make.
  • Changing the format of the cells to “Text” worked!
  • Now I’m going to manually find the similarity between misspelled names that I know are the same name, to give me a reference as to how similar the names should be when I find a command to make the code automatically merge similar names.
  • I was comparing MOASIAH CROMARTIE to MO’ASIAH CROMARTIE but the apostrophe in the name messed up the code. I will have to find a command that deletes apostrophes in the names before I continue on.
  • Here is a command I found online that I tried:
    • ConfidenceS14['Full Name'].replace("'"," ")
    • This didn’t give me an error, but it didn’t delete the apostrophes either
    • Tried just ConfidenceS14.replace("'"," ") instead. This did not work.
    • Tried replacing the apostrophe with an underscore instead of a space. This did not work.
  • Tried this command:
    • ConfidenceS14['Full Name'].translate(None,"'")
    • This did not work
  • Tried this:
    • Con14 = ConfidenceS14['Full Name']
'Con14'.replace("'","_")
    • This did not work.
  • Tried this:
    • line = ConfidenceS14['Full Name']
''.join(c for c in line if c not in "'")
    • This combined a person’s last name with the next person’s first name, and did not delete the apostrophe
    • Tried putting a space in between the apostrophes in the second line, this only put a space between each name
    • I tried ''.join(c for c in line if c not in "A") just to see what would happen, and it did delete the As in the sequence so i need to find a new command.
  • Tried:
    • line = ConfidenceS14['Full Name']
line.translate(None, "'")
  • There was an error with the “translate” so I researched the translate function and I found this command:
    • from string import maketrans   
intab = "'"
outtab = "_"
trantab = maketrans(intab, outtab)
str = ConfidenceS14['Full Name']
print str.translate(trantab)

    • I got the same error as I did for the code before.
    • Apparently this is happening because something in my string isn’t actually a string so I either need to fix my string, or find a new way to delete/replace the apostrophes.

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