如何将Excel单元格内逗号分隔的内容放到多个列

//用而Excel转json工具先做数据转换,将Excel转成json

//所在地区为逗号分隔的字符串,需要拆分成省市区放在Excel中

var arr=[{"门店编码":"PH117746","Territory":"VISAYAS","Region":"NORTH ILOILO","所在地区":"Region IV-A CALABARZON,Quezon,SAN ANDRES"},{"门店编码":"PH117745","Territory":"SOUTH LUZON","Region":"SOUTH LUZON 4","所在地区":"Region IV-A CALABARZON,Quezon,PEREZ"},{"门店编码":"PH117744","Territory":"SOUTH LUZON","Region":"SOUTH LUZON 4","所在地区":"Region III CENTRAL LUZON,Nueva Ecija,LUPAO"},{"门店编码":"PH100935","Territory":"EAST NORT

如何将Excel单元格内逗号分隔的内容放到多个列最先出现在Python成神之路

版权声明:
作者:lichengxin
链接:https://www.techfm.club/p/25117.html
来源:TechFM
文章版权归作者所有,未经允许请勿转载。

THE END
分享
二维码
< <上一篇
下一篇>>