Pandas - Add columns from a list of strings [duplicate]

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
– Amina Umar

2022-12-21 23:25:58 +00:00
Commented Dec 21, 2022 at 23:25 — Amina Umar
– Amina Umar, Commented Dec 21, 2022 at 23:25

mozway · Accepted Answer · 2022-12-21 18:56:44Z

2

You can reindex with the columns union:

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

edited Dec 21, 2022 at 18:56

answered Dec 21, 2022 at 18:50

mozway

267k13 gold badges56 silver badges106 bronze badges

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

Comments

Bhargav · Accepted Answer · 2022-12-21 18:53:03Z

1

assign directly

df[newcols] = ""

answered Dec 21, 2022 at 18:53

Bhargav

4,8912 gold badges12 silver badges29 bronze badges

1 Comment

Matheus Assumpção Solinho Over a year ago

Thanks! It worked fine. Felling kind of dumd right know hahaha!

SomeDude · Accepted Answer · 2022-12-21 19:16:26Z

1

Use concat:

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

edited Dec 21, 2022 at 19:16

answered Dec 21, 2022 at 18:52

SomeDude

14.3k5 gold badges26 silver badges49 bronze badges

2 Comments

Matheus Assumpção Solinho Over a year ago

The headers will not always be "D,E,F", it was just an example. That's why i need to use the list.

SomeDude Over a year ago

Just use the list name instead. I edited my answer.

Collectives™ on Stack Overflow

Pandas - Add columns from a list of strings [duplicate]

3 Answers 3

Comments

1 Comment

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Linked

Related