python两行合并_python pandas将两行或更多行文本合并为一行

I have data frame with text data like below,

name | address | number

1 Bob bob No.56

2 @gmail.com

3 Carly carly@world.com No.90

4 Gorge greg@yahoo

5 .com

6 No.100

and want to make it like this frame.

name | address | number

1 Bob bob@gmail.com No.56

2 Carly carly@world.com No.90

3 Gorge greg@yahoo.com No.100

I am using pandas to read file but not sure how to use merge or concat.

解决方案

In case of name column consists of unique values,

print df

name address number

0 Bob bob No.56

1 NaN @gmail.com NaN

2 Carly carly@world.com No.90

3 Gorge greg@yahoo NaN

4 NaN .com NaN

5 NaN NaN No.100

df['name'] = df['name'].ffill()

print df.fillna('').groupby(['name'], as_index=False).sum()

name address number

0 Bob bob@gmail.com No.56

1 Carly carly@world.com No.90

2 Gorge greg@yahoo.com No.100

you may need ffill(), bfill(), [::-1], .groupby('name').apply(lambda x: ' '.join(x['address'])), strip(), lstrip(), rstrip(), replace() kind of thing to extend above code to more complicated data.