Split a pandas dataframe header into multiple columns

Question

I'm trying to split the dataframe header id;signin_count;status into more columns where I can put my data into. I've tried df.columns.values, but I couldn't get a string to use .split in, as I was hoping. Instead, I got:

Index(['id;signin_count;status'], dtype='object')

Which returns AttributeError: 'Index' object has no attribute 'split' when I try .split

In broader terms, I have:

id;signin_count;status
0   353;20;done;
1   374;94;pending;
2   377;4;done;

And want:

    id      signin_count  status
0   353     20            done
1   374     94            pending
2   377     4             done

Splitting the data itself is not the problem here, that I can do. The focus is on how to access the header names without hardcoding it, as I will have to do the same with any other dataset with the same format

From the get-go, thank you

You can use df.columns[0].split(';'). columns render a list of values, in your case, all you need is the first value. — rrcal
– rrcal, Commented Feb 1, 2020 at 21:15
M_S_N answered your root problem, you'll probably end up creating new dfs for every split since all the data shape changes — deadvoid
– deadvoid, Commented Feb 1, 2020 at 21:19

M_S_N · Accepted Answer · 2020-02-01 21:15:50Z

3

If you are reading your data from a csv file you can define sep to ; and read it as:

df=pd.read_csv('filename.csv', sep=';', index_col=False)

Output:

    id  signin_count    status
0   353     20  done
1   374     94  pending
2   377     4   done

answered Feb 1, 2020 at 21:15

M_S_N

2,8061 gold badge19 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Felipe Barbosa Over a year ago

Thanks! It's way easier than what I was trying to do

Collectives™ on Stack Overflow

Split a pandas dataframe header into multiple columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related