python学习--列替换问题

问题：原来数据是score列包含三列，修整列，并把列分开并替换原列

代码：

p=pd.DataFrame({'gender':[' M',' M ',' F ','  M','F'],
               'name':['jack','tom','marry','zack','heheda'],
               'socre':['90,90,90','89,88,87','90,90,90','78,78,78','60,60,60']})
print(p)

    gender    name     socre
0      M    jack  90,90,90
1     M      tom  89,88,87
2     F    marry  90,90,90
3      M    zack  78,78,78
4      F  heheda  60,60,60

p['gender']=p['gender'].str.strip()
print(p)

  gender    name     socre
0      M    jack  90,90,90
1      M     tom  89,88,87
2      F   marry  90,90,90
3      M    zack  78,78,78
4      F  heheda  60,60,60

p['name']=p['name'].str.upper()
print(p)

  gender    name     socre
0      M    JACK  90,90,90
1      M     TOM  89,88,87
2      F   MARRY  90,90,90
3      M    ZACK  78,78,78
4      F  HEHEDA  60,60,60

p['english']=p['socre'].str.split(',').str.get(0)
p['math']=p['socre'].str.split(',').str.get(1)
p['art']=p['socre'].str.split(',').str.get(2)
p.drop('socre',axis=1, inplace=True)
print(p)

   gender    name english math art
0      M    JACK      90   90  90
1      M     TOM      89   88  87
2      F   MARRY      90   90  90
3      M    ZACK      78   78  78
4      F  HEHEDA      60   60  60

转载于:https://www.cnblogs.com/xurui89/p/10761733.html