Merge multiple column in one column in python

Question

I have a pandas data frame where the total of first column is done in second column and same for the second and third column:

    Column1  Column2  Column3  
 0     3                         
 1     2                         
 2     1       6                 
 3             7        13

What I want to do now is merge all the columns (1,2,3) into one column A (ignoring the total value) like this:

How could I best approach this issue? Here is the code mentioned below.

import pandas as pd
 
data = {'Column1':[3, 2, 1, ""],
        'Column2': ["", "", "6", "7"],
        'Column3':["", "", "", 13]}

abc = pd.DataFrame(data)

abc

abc.to_dict()

My Output:

{'Column1': {0: 3, 1: 2, 2: 1, 3: ''},
 'Column2': {0: '', 1: '', 2: '6', 3: '7'},
 'Column3': {0: '', 1: '', 2: '', 3: 13}}

Are empty values NaN or empty string i.e ''? Please add df.to_dict() to the question. — Ch3steR
– Ch3steR, Commented Dec 16, 2021 at 5:50
kindly share the source dataframe as a dictionary : df.to_dict() — sammywemmy
– sammywemmy, Commented Dec 16, 2021 at 6:00
Edited my question and put the code with converting data frame to a dictionary. — Vansh
– Vansh, Commented Dec 16, 2021 at 6:11

jezrael · Accepted Answer · 2021-12-16 06:13:39Z

1

Replace to missing values empty strigs, then back filling missing values and select first column, last convert to integers if necessary and to one column DataFrame:

data = {'Column1':[3, 2, 1, ""],
        'Column2': ["", "", "6", "7"],
        'Column3':["", "", "", 13]}

df = pd.DataFrame(data)

df1 = df.replace('', np.nan).bfill(axis=1).iloc[:, 0].astype(int).to_frame('Column A')
print (df1)
   Column A
0         3
1         2
2         1
3         7

edited Dec 16, 2021 at 6:13

answered Dec 16, 2021 at 6:07

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Comment

Vansh Over a year ago

Thank you for the answer. This solved my problem!

Collectives™ on Stack Overflow

Merge multiple column in one column in python

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