Python Forum
Removing hyphens and adding zeros
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Removing hyphens and adding zeros
#1
What is the meaning of the following code from the Learn Data Analysis with Python book? Can someone elaborate on the first 10-12 lines. Why return s[-9] or in other words assign to ssn? Negative index? As I understand, first replacing hyphens with a space. Then, splitting at the space and rejoin? If number of digits less than 9 and not 'missing' then .. why add the zeros? Then what next?

The ssns are:
ssns = ['867-53-0909','333-22-4444','123-12-1234',
'777-93-9311','123-12-1423']

def right(s, amount):
    return s[-amount]
def standardize_ssn(ssn):
    try:
      ssn = ssn.replace("-","")
      ssn = "".join(ssn.split())
      if len(ssn)<9 and ssn != 'Missing':
         ssn="000000000" + ssn
         ssn=right(ssn,9)
    except:
      pass
    return ssn
df.ssn = df.ssn.apply(standardize_ssn)
df
Reply


Messages In This Thread
Removing hyphens and adding zeros - by sidney - Aug-14-2019, 09:18 AM
RE: Removing hyphens and adding zeros - by ThomasL - Aug-14-2019, 12:31 PM
RE: Removing hyphens and adding zeros - by sidney - Aug-14-2019, 01:48 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  getting trailing zeros with 1 during pandas read fullstop 1 1,050 Jan-05-2020, 04:01 PM
Last Post: ichabod801
  Numpy saving and loading introduces zeros in the middle of every element DreamingInsanity 0 353 Dec-11-2019, 07:21 PM
Last Post: DreamingInsanity

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020