str.split error列的长度必须与key相同，且为多列

Question

我有数据帧df_ip_month，正在尝试将列detail EOBs拆分为同一行上的多个列，每个Account，这样

变成这样

我尝试使用的代码是

df_ip_month[['eob1','eob2','eob3','eob4','eob5','eob6']] = df_ip_month['detail EOBs'].str.split(expand=True)

但是，没有生成任何输出，只有以下错误

ValueError: Columns must be same length as key

为什么

这是数据集

df_ip_month = pd.DataFrame({'Account': ['H5000570011700','H5000484349900','H5000500029400','H5000502860000','H5000631774400','H5000619680500',
                           'H5000587425100','H5000630746300','H5000632095500','H5000505467800','H5000558994900','H5000623617700',
                           'H5000539983300','H5000559033600','H5000570061901','H5000513787300','H5000562451100','H5000568554900'], 
               'detail EOBs': ['','','','','','5002','','5002 1442','','5003','','','','5002 3035 9932 3343 3021 2312','','','5003 3035 9932','']})

Answer 1

df = df.set_index('Account')
df2 = df['detail_EOBs'].str.split(expand=True)
df.join(df2)

您可以在Account列上设置索引，拆分并展开detail_EOBs列，然后将它们重新连接在一起