Pandas error in Python: columns must be same length as key

Pandas error in Python: columns must be same length as key

You need a bit modify solution, because sometimes it return 2 and sometimes only one column:

df2 = pd.DataFrame({STATUS:[Estimated 3:17 PM,Delayed 3:00 PM]})


df3 = df2[STATUS].str.split(n=1, expand=True)
df3.columns = [STATUS_ID{}.format(x+1) for x in df3.columns]
print (df3)
  STATUS_ID1 STATUS_ID2
0  Estimated    3:17 PM
1    Delayed    3:00 PM

df2 = df2.join(df3)
print (df2)
              STATUS STATUS_ID1 STATUS_ID2
0  Estimated 3:17 PM  Estimated    3:17 PM
1    Delayed 3:00 PM    Delayed    3:00 PM

Another possible data – all data have no whitespaces and solution working too:

df2 = pd.DataFrame({STATUS:[Canceled,Canceled]})

and solution return:

print (df2)
     STATUS STATUS_ID1
0  Canceled   Canceled
1  Canceled   Canceled

All together:

df3 = df2[STATUS].str.split(n=1, expand=True)
df3.columns = [STATUS_ID{}.format(x+1) for x in df3.columns]
df2 = df2.join(df3)

Pandas error in Python: columns must be same length as key