Combining 2 data series into one

[Paul Barry]

This should do it:

>>> import pandas as pd
>>>
>>> df1 = pd.DataFrame(['bhaskar', 'Rohit'], columns=['first_name'])
>>> df1
  first_name
0    bhaskar
1      Rohit
>>> df2 = pd.DataFrame(['dhariyal', 'Gavval'], columns=['last_name'])
>>> df2
  last_name
0  dhariyal
1    Gavval
>>> df = pd.DataFrame()
>>> df['name'] = df1['first_name'] + ' ' + df2['last_name']
>>> df
               name
0  bhaskar dhariyal
1      Rohit Gavval
>>>

Again, I draw your attention to Jake VanderPlas's excellent book, which is
available for free on the web.  All of these kind of data manipulations are
covered there:  https://github.com/jakevdp/PythonDataScienceHandbook - the
hard copy is worth owning too (if you plan to do a lot of work using
numpy/pandas).

I'd also recommend the upcoming 2nd edition of Wes McKinney's "Python for
Data Analysis" book - I've just finished tech reviewing it for O'Reilly,
and it is very good, too - highly recommended.

Regards.

Paul.

On 28 June 2017 at 07:11, Bhaskar Dhariyal <dhariyalbhaskar at gmail.com>
wrote:

> Hi!
>
> I have 2 dataframe i.e. df1['first_name'] and df2['last_name']. I want to
> make it as df['name']. How to do it using pandas dataframe.
>
> first_name
> ----------
> bhaskar
> Rohit
>
>
> last_name
> -----------
> dhariyal
> Gavval
>
> should appear as
>
> name
> ----------
> bhaskar dhariyal
> Rohit Gavval
>
>
>
> Thanks
> --
> https://mail.python.org/mailman/listinfo/python-list
>



-- 
Paul Barry, t: @barrypj <https://twitter.com/barrypj> - w:
http://paulbarry.itcarlow.ie - e: paul.barry at itcarlow.ie
Lecturer, Computer Networking: Institute of Technology, Carlow, Ireland.