How to take value of common column in one dataframe from another?

Question

I have Empty data frame with some columns,

df_skeleton = pd.DataFrame(columns=columns)

And I have another dataframe df which is subset of above dataframe,But in this dataframe, I have a single row with values.

I want to put a corresponding value of the second dataframe into the

df_skeleton

and all other columns values equal to zero

Eg:

df_skeleton is having 10 columns, name from col1,col2.....col10,

   col1   col2 col3 col4 col5 col5 co6 col7 col8 col9 col10
0

but it does not contain any row or values. It is just skeleton.

And my df is having 3 columns

      col1 col3 col7
 0    23    45   10

Now what i want is

df_skeleton

  col1 col2 col3 col4 col5 col6 col7 col8 col9 col10
0  23   0    45   0    0    0    10   0    0    0

jezrael · Accepted Answer · 2018-05-23T05:51:42.253

4

Use reindex with parameter fill_value:

columns = ['col1','col2','col3','col4','col5','col5','co6','col7','col8','col9','col10']
df_skeleton = pd.DataFrame(columns=columns)

df = df.reindex(columns=df_skeleton.columns, fill_value=0)
print (df)
   col1  col2  col3  col4  col5  col5  co6  col7  col8  col9  col10
0    23     0    45     0     0     0    0    10     0     0      0

edited May 23 '18 at 05:51

answered May 23 '18 at 05:46

jezrael

822,522
95
1,334
1,252

The previous answer was also working. But this look easy and understandable. – Imran Ahmad Ghazali May 23 '18 at 05:54
@ImranAhmadGhazali - This is better, so first was removed. Thank you. – jezrael May 23 '18 at 05:54

score 4 · Answer 2 · answered May 23 '18 at 05:56

4

Use pandas.DataFrame.combine_first

df_skeleton.combine_first(df).fillna(0, downcast='infer')

   co6  col1  col10  col2  col3  col4  col5  col5  col7  col8  col9
0    0    23      0     0    45     0     0     0    10     0     0

answered May 23 '18 at 05:56

piRSquared

285,575
57
475
624

How to take value of common column in one dataframe from another?

2 Answers2