How to get a combined column with NULL string as well if exists in a python dataframe

Question

I have a dataframe with firstname, middlename, lastname. How do I merge these columns so that I have one column with fullname including NULL for middlenname in between if it is not there in data ex: john?

df
  first_name middle_name last_name
0        bob           K     smith
1       john                 smith
2       bill           R     smith

output

  full_name
0 bobKsmith
1 john smith
2 billRsmith

import pandas as pd data = {'first_name': ['bob', 'john', 'bill'], 'middle_name': ['K','', 'R'], 'last_name': ['smith', 'smith', 'smith']} df = pd.DataFrame(data) — Neha
– Neha, Commented Sep 2, 2020 at 22:07

Multivac · Accepted Answer · 2020-09-02 22:53:42Z

1

This works as expected:

df.replace('', " ", inplace = True)
df["concat"] = df.sum(axis = 1)

answered Sep 2, 2020 at 22:53

Multivac

8557 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

How to get a combined column with NULL string as well if exists in a python dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related