'String splitting in pandas, ValueError

df[['Department', 'Category', 'Machine']] = df['Location'].astype(str).str.split('.', expand=True)

Coating.Coating.Coating.SY06 - This is how records look in Location

I was trying to both reduce and increase amount of columns and same error keep pop up: ValueError: Columns must be same length as key

Anybody have any ideas of why?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source