Pandas : Add column to another column

Question

I'm confused on how do I add a column to another in pandas

Here is what I'm trying to do :

from pandas import DataFrame
df1 = DataFrame({'a':[1,2], 'b':[3,4]})
concat((df1['a'], df1['b'].rename({'b':'a'}))).reset_index(drop=True)

Which do return what I want : A serie with my 4 values. What I don't understand is : Why I can't assign it to column 'a' ?

>>> from pandas import DataFrame
>>> df1 = DataFrame({'a':[1,2], 'b':[3,4]})
>>> concat((df1['a'], df1['b'].rename({'b':'a'}))).reset_index(drop=True)
0    1
1    2
2    3
3    4
dtype: int64
>>> df1['a'] = concat((df1['a'], df1['b'].rename({'b':'a'}))).reset_index(drop=True)
>>> df1
   a  b
0  1  3
1  2  4

Is there any way to make it more readable by the way? I'm confused on how it should worked... Note that I don't need column 'b' afterward.

Thanks for your help :)

Sam

Sunderam Dubey · Accepted Answer · 2022-11-18 11:01:11Z

1

pandas series doesn't contain columns.

If you want to use column by Dataframe, use df[['a']] instead df['a']

& you want change column's name need axis or columns

pd.concat([df1[['a']], df1[['b']].rename(columns={'b':'a'})]).reset_index(drop=True)

output:

If I create your output using your code, code like above. But I wouldn't use the above code.

I will use following code:

pd.concat([df1['a'], df1['b']]).to_frame('a').reset_index(drop='True')

edited Nov 18, 2022 at 11:01

Sunderam Dubey

8,83512 gold badges25 silver badges43 bronze badges

answered Nov 14, 2022 at 10:23

Panda Kim

13.6k2 gold badges7 silver badges15 bronze badges

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

Comments

mozway · Accepted Answer · 2022-11-14 10:14:16Z

1

When you assign, you are not creating new rows/indices (except with a single value, which is not the case here).

pd.concat((df1['a'], df1['b'].rename({'b':'a'}))).reset_index(drop=True)

Gives you:

0    1
1    2
2    3
3    4
dtype: int64

Pandas aligns the indices before assignment. So, only the indices matching the existing df index are used, here 0 and 1, the rest is discarded

answered Nov 14, 2022 at 10:14

mozway

267k13 gold badges55 silver badges106 bronze badges

Collectives™ on Stack Overflow

Pandas : Add column to another column

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related