Data Cleaning How to split Pandas column-CodePudding

It has been sometime since i tried working in python

I have this data frame with many columns too many to name

  last/first    location    job    department
  smith john    Vancouver   A1     servers
  rogers steve  Toronto     A2     eng
  Rogers Dave   Toronto     A4     HR

how to I remove caps in the last/first column and also split the last/first column by " "?

goal

  last      first    location    job    department
  smith     john     Vancouver   A1     servers
  rogers    steve    Toronto     A2     eng
  rogers    dave     Toronto     A4     HR

CodePudding user response：

IIUC, you could use str.lower and str.split:

df[['last', 'first']] = (df.pop('last/first')
                           .str.lower()
                           .str.split(n=1, expand=True)
                         )

output:

    location job department    last  first
0  Vancouver  A1    servers   smith   john
1    Toronto  A2        eng  rogers  steve
2    Toronto  A4         HR  rogers   dave