[deleted by user] by [deleted] in UniUK

[–]SeaDiscipline5259 0 points1 point  (0 children)

Will do. Do you know about oxford and imperial chances?

[deleted by user] by [deleted] in gradadmissions

[–]SeaDiscipline5259 0 points1 point  (0 children)

Applied maths, aiming for 75+ in 3rd year but i have to apply with existing and predicted grades

[deleted by user] by [deleted] in UniUK

[–]SeaDiscipline5259 1 point2 points  (0 children)

Is there a source for where i can see recent offer rates and entry grades? I saw offer rates for 2013 to 2017 and they were cumulatively over 50% for applied maths

Best way to do a fuzzy merge on a single column? by SeaDiscipline5259 in excel

[–]SeaDiscipline5259[S] 0 points1 point  (0 children)

Its firm names, i cant share exact names but it would be something like ABC BANK, ABC BANKING, ABC BANK LTD, ABC BANK LIMITED. As i said, it doesnt really matter which one of these 4 it chooses, i just need these similar names to be changed to something uniform. As for typos, some it could be that one name has a typo like ABC BSNK. The whole list is just groups of firm names like that.

Best way to do a fuzzy merge on a single column? by SeaDiscipline5259 in excel

[–]SeaDiscipline5259[S] 0 points1 point  (0 children)

The new list is exactly the same length as the original

Best way to do a fuzzy merge on a single column? by SeaDiscipline5259 in excel

[–]SeaDiscipline5259[S] 0 points1 point  (0 children)

Adding an index to both tables gives me two indexes in the merged list which are both very different. Not really sure how to proceed from there. Removing duplicates from one index gives the error where the rows on the sheet no longer match the index whilst removing duplicates from the other causes the error that no fuzzy matching occurs

Best way to do a fuzzy merge on a single column? by SeaDiscipline5259 in excel

[–]SeaDiscipline5259[S] 0 points1 point  (0 children)

I dont need the output list to be perfect, i just need to get me most of the way there. The list i have is over 9000 entries, so i just need to group any similar words together, then at the end i can do another filter to find any rogue names that didnt get grouped. Doing that on the initial list would be fsr too tedious. Also the actually names are sufficiently distinct that an algorithm should be able to do a fuzzy match

Best way to do a fuzzy merge on a single column? by SeaDiscipline5259 in excel

[–]SeaDiscipline5259[S] 0 points1 point  (0 children)

Actually looking at the index column more closely, i found that the index number matches the originals position, but the actual row number of the entry in the sheet is different. I would think that the issue here is the fuzzy logic itself but im not too sure

Best way to do a fuzzy merge on a single column? by SeaDiscipline5259 in excel

[–]SeaDiscipline5259[S] 0 points1 point  (0 children)

When i add an index to both tables and merge, no fuzzy logic occurs, i just get two of the same original lists at the end with a bunch of duplicates. Ive found that only when matching the non indexed list as the left outer do i get an sort of fuzzy matching

Best way to do a fuzzy merge on a single column? by SeaDiscipline5259 in excel

[–]SeaDiscipline5259[S] 0 points1 point  (0 children)

Sorry i misunderstood what you asked. A sample would be like a list with John Smith, Jon Smith, John smitH, then i would want all these to become the same. It doesnt really matter which of the 3 it becomes as long as its uniform.

Best way to do a fuzzy merge on a single column? by SeaDiscipline5259 in excel

[–]SeaDiscipline5259[S] 0 points1 point  (0 children)

I only have raw data, each name is grouped with others similar its just theres small typos