Pandas - Add columns from a list of strings

Question

I want to add columns from a list.

newcols = ['D', 'E', 'F']

df1 = (How it is)

A	B	C
10	15	5
11	14	9

df2 = (How i want it to be)

A	B	C	D	E	F
10	15	5
11	14	9

Do you guys know how to get this done ?? Best Regards!

You didn't accept any of the answers. That's not fair. – Amina Umar Dec 21 '22 at 23:25 — Amina Umar, Dec 21 '22 at 23:25

mozway · Accepted Answer · 2022-12-21T18:56:44.273

2

You can reindex with the columns union:

df2 = df1.reindex(columns=df.columns.union(newcols))

edited Dec 21 '22 at 18:56

answered Dec 21 '22 at 18:50

mozway

SomeDude · Answer 2 · 2022-12-21T19:16:26.513

1

Use concat:

pd.concat([df, pd.DataFrame(columns=newcols)], axis=1)

edited Dec 21 '22 at 19:16

answered Dec 21 '22 at 18:52

SomeDude

The headers will not always be "D,E,F", it was just an example. That's why i need to use the list. – Matheus Assumpção Solinho Dec 21 '22 at 18:53
1

Just use the list name instead. I edited my answer. – SomeDude Dec 21 '22 at 19:16

score 1 · Answer 3 · answered Dec 21 '22 at 18:53

1

assign directly

df[newcols] = ""

answered Dec 21 '22 at 18:53

1

Thanks! It worked fine. Felling kind of dumd right know hahaha! – Matheus Assumpção Solinho Dec 21 '22 at 18:58

3 Answers3