{"id":8634,"date":"2021-06-12T10:55:41","date_gmt":"2021-06-12T05:25:41","guid":{"rendered":"https:\/\/python-programs.com\/?p=8634"},"modified":"2021-11-22T18:40:39","modified_gmt":"2021-11-22T13:10:39","slug":"pandas-how-to-merge-dataframes-using-dataframe-merge-in-python-part-1","status":"publish","type":"post","link":"https:\/\/python-programs.com\/pandas-how-to-merge-dataframes-using-dataframe-merge-in-python-part-1\/","title":{"rendered":"Pandas : How to Merge Dataframes using Dataframe.merge() in Python \u2013 Part 1"},"content":{"rendered":"
In this article, we will learn to merge two different DataFrames into a single one using function Dataframe class of Python’s Pandas library provide a function i.e. Arguments:-<\/strong><\/p>\n Let’s see one by one<\/p>\n If we have two DataFrames of two common columns, by directly calling Let’s see the below program to understand it clearly.<\/p>\n In above case, inner join occured for key columns i.e. ‘JersyN’ & ‘Sponsered’. During inner join the common columns of two dataframes are picked and merged. We can also explicitly do inner join by passing While merging columns we can include all rows from left DataFrame and NaN from which values are missing in right DataFrame.<\/p>\n Let’s see the below program to understand it clearly.<\/p>\n While merging columns we can include all rows from right DataFrame and NaN from which values are missing in left DataFrame.<\/p>\n Let’s see the below program to understand it clearly.<\/p>\n While merging columns of two dataframes, we can even include all rows of two DataFrames and add NaN for the values missing in left or right DataFrame.<\/p>\n Let’s see the below program to understand it clearly.<\/p>\n Want to expert in the python programming language? Exploring\u00a0Python Data Analysis using Pandas<\/a>\u00a0tutorial changes your knowledge from basic to advance level in python concepts.<\/p>\n Read more Articles on Python Data Analysis Using Padas<\/strong><\/p>\n Merging Dataframes using Dataframe.merge() in Python In this article, we will learn to merge two different DataFrames into a single one using function Dataframe.merge(). Dataframe.merge() : Dataframe class of Python’s Pandas library provide a function i.e. merge() which helps in merging of two DataFrames. Syntax:- DataFrame.merge(right, how=’inner’, on=None, leftOn=None, rightOn=None, left_index=False, right_index=False, sort=False, suffix=(‘_x’, ‘_y’), …<\/p>\nDataframe.merge()<\/code>.<\/p>\n
Dataframe.merge() :<\/h3>\n
merge()<\/code> which helps in merging of two DataFrames.<\/p>\n
Syntax<\/u>:- DataFrame.merge(right, how='inner', on=None, leftOn=None, rightOn=None, left_index=False, right_index=False, sort=False, suffix=('_x', '_y'), copy=True, indicate=False, validate=None)<\/pre>\n
\n
\n
<\/a>Merge DataFrames on common columns (Default Inner Join) :<\/h3>\n
merge()<\/code> \u00a0function the two columns will be merged considering common columns as join keys and the dissimilar columns would just be copied from one dataframe to another dataframe.<\/p>\n
import pandas as sc\r\n# List of Tuples\r\nplayers = [(15,'Smith','Pune', 17,12000),\r\n (99,'Rana', 'Mumbai', 20,2000),\r\n (51,'Jaydev','Kolkata', 22,25640),\r\n (31,'Shikhar','Hyderabad', 28,85410),\r\n (12,'Sanju','Rajasthan', 21,63180),\r\n (35,'Raina','Gujarat', 18,62790)\r\n ]\r\n# Creation of DataFrame object\r\nplayDFObj = sc.DataFrame(players, columns=['JersyN','Name', 'Team', 'Age','Sponsered'], index=['I', 'II', 'III', 'IV', 'V', 'VI'])\r\nprint('DataFrame 1 : ')\r\nprint(playDFObj)\r\nmoreInfo = [(15, 13, 180000, 12000) ,\r\n (99, 2, 195200, 2000) ,\r\n (51, 7, 15499, 25640) ,\r\n (31, 17, 654000, 85410) ,\r\n (12, 5, 201000, 63180) ,\r\n (35, 14, 741000, 62790)\r\n ]\r\n# Creation of DataFrame object\r\nmoreinfoObj = sc.DataFrame(moreInfo, columns=['JersyN', 'PLayingSince' , 'Salary', 'Sponsered'], index=['I', 'II', 'III', 'IV', 'V', 'VI'])\r\nprint('DataFrame 2 : ')\r\nprint(moreinfoObj)\r\n# Merge two Dataframes on basis of common column by default INNER JOIN\r\nmergedDataf = playDFObj.merge(moreinfoObj)\r\nprint(mergedDataf)\r\n<\/pre>\n
Output :\r\nDataFrame 1 :\r\n \u00a0\u00a0\u00a0 JersyN\u00a0\u00a0\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Team\u00a0 Age\u00a0 Sponsered\r\nI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0\u00a0 Smith\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pune\u00a0\u00a0 17\u00a0\u00a0\u00a0\u00a0\u00a0 12000\r\nII\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0 Rana\u00a0\u00a0\u00a0\u00a0 Mumbai\u00a0\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2000\r\nIII\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0 Jaydev\u00a0\u00a0\u00a0 Kolkata\u00a0\u00a0 22\u00a0\u00a0\u00a0\u00a0\u00a0 25640\r\nIV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0 Shikhar\u00a0 Hyderabad\u00a0\u00a0 28\u00a0\u00a0\u00a0\u00a0\u00a0 85410\r\nV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0 Sanju\u00a0 Rajasthan\u00a0\u00a0 21\u00a0\u00a0\u00a0\u00a0\u00a0 63180\r\nVI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0 Raina\u00a0\u00a0\u00a0 Gujarat\u00a0\u00a0 18\u00a0\u00a0\u00a0\u00a0\u00a0 62790\r\nDataFrame 2 :\r\n \u00a0\u00a0\u00a0 JersyN\u00a0 PLayingSince\u00a0 Salary\u00a0 Sponsered\r\nI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13\u00a0 180000\u00a0\u00a0\u00a0\u00a0\u00a0 12000\r\nII\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0 195200\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2000\r\nIII\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0 15499\u00a0\u00a0\u00a0\u00a0\u00a0 25640\r\nIV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17\u00a0 654000\u00a0\u00a0\u00a0\u00a0\u00a0 85410\r\nV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0 201000\u00a0\u00a0\u00a0\u00a0\u00a0 63180\r\nVI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0 741000\u00a0\u00a0\u00a0\u00a0\u00a0 62790\r\n \u00a0 JersyN\u00a0\u00a0\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Team\u00a0 Age\u00a0 Sponsered\u00a0 PLayingSince\u00a0 Salary\r\n0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0\u00a0 Smith\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pune\u00a0\u00a0 17\u00a0\u00a0\u00a0\u00a0\u00a0 12000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13\u00a0 180000\r\n1\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0 Rana\u00a0\u00a0\u00a0\u00a0 Mumbai\u00a0\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0 195200\r\n2\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0 Jaydev\u00a0\u00a0\u00a0 Kolkata\u00a0\u00a0 22\u00a0\u00a0\u00a0\u00a0\u00a0 25640\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0 15499\r\n3\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0 Shikhar\u00a0 Hyderabad\u00a0\u00a0 28\u00a0\u00a0\u00a0\u00a0\u00a0 85410\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17\u00a0 654000\r\n4\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0 Sanju\u00a0 Rajasthan\u00a0\u00a0 21\u00a0\u00a0\u00a0\u00a0\u00a0 63180\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0 201000\r\n5\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0 Raina\u00a0\u00a0\u00a0 Gujarat\u00a0\u00a0 18\u00a0\u00a0\u00a0\u00a0\u00a0 62790\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0 741000<\/pre>\n
What is Inner Join ?<\/h3>\n
how<\/code> argument with values as
inner<\/code>. After implementing both the cases will have same result.<\/p>\n
<\/a>Merge Dataframes using Left Join :<\/h3>\n
What is left join ?<\/h4>\n
import pandas as sc\r\n# List of Tuples\r\nplayers = [(15,'Smith','Pune', 17,12000),\r\n (99,'Rana', 'Mumbai', 20,2000),\r\n (51,'Jaydev','Kolkata', 22,25640),\r\n (31,'Shikhar','Hyderabad', 28,85410),\r\n (12,'Sanju','Rajasthan', 21,63180),\r\n (35,'Raina','Gujarat', 18,62790)\r\n ]\r\n# Creation of DataFrame object\r\nplayDFObj = sc.DataFrame(players, columns=['JersyN','Name', 'Team', 'Age','Sponsered'], index=['I', 'II', 'III', 'IV', 'V', 'VI'])\r\nprint('DataFrame 1 : ')\r\nprint(playDFObj)\r\nmoreInfo = [(15, 13, 180000, 12000) ,\r\n (99, 2, 2000) ,\r\n (51, 7, 15499, 25640) ,\r\n (31, 17, 654000) ,\r\n (12, 5, 201000, 63180) ,\r\n (35, 14, 741000, 62790)\r\n ]\r\n# Creation of DataFrame object\r\nmoreinfoObj = sc.DataFrame(moreInfo, columns=['JersyN', 'PLayingSince' , 'Salary', 'Sponsered'], index=['I', 'II', 'III', 'IV', 'V', 'VI'])\r\nprint('DataFrame 2 : ')\r\nprint(moreinfoObj)\r\n# Merge two Dataframes on basis of common column by default INNER JOIN\r\nmergedDataf = playDFObj.merge(moreinfoObj, how='left')\r\nprint('After merging: ')\r\nprint(mergedDataf)\r\n<\/pre>\n
Output :\r\nDataFrame 1 :\r\n \u00a0\u00a0\u00a0 JersyN\u00a0\u00a0\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Team\u00a0 Age\u00a0 Sponsered\r\nI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0\u00a0 Smith\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pune\u00a0\u00a0 17\u00a0\u00a0\u00a0\u00a0\u00a0 12000\r\nII\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0 Rana\u00a0\u00a0\u00a0\u00a0 Mumbai\u00a0\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2000\r\nIII\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0 Jaydev\u00a0\u00a0\u00a0 Kolkata\u00a0\u00a0 22\u00a0\u00a0\u00a0\u00a0\u00a0 25640\r\nIV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0 Shikhar\u00a0 Hyderabad\u00a0\u00a0 28\u00a0\u00a0\u00a0\u00a0\u00a0 85410\r\nV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0 Sanju\u00a0 Rajasthan\u00a0\u00a0 21\u00a0\u00a0\u00a0\u00a0\u00a0 63180\r\nVI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0 Raina\u00a0\u00a0\u00a0 Gujarat\u00a0\u00a0 18\u00a0\u00a0\u00a0\u00a0\u00a0 62790\r\nDataFrame 2 :\r\n \u00a0\u00a0\u00a0 JersyN\u00a0 PLayingSince\u00a0 Salary\u00a0 Sponsered\r\nI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13\u00a0 180000\u00a0\u00a0\u00a0 12000.0\r\nII\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0 2000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\r\nIII\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0 15499\u00a0\u00a0\u00a0 25640.0\r\nIV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17\u00a0 654000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\r\nV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0 201000\u00a0\u00a0\u00a0 63180.0\r\nVI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0 741000\u00a0\u00a0\u00a0 62790.0\r\nAfter merging:\r\n \u00a0 JersyN\u00a0\u00a0\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Team\u00a0 Age Sponsered\u00a0 PLayingSince\u00a0\u00a0\u00a0 Salary\r\n0 \u00a0\u00a0\u00a0\u00a0\u00a015\u00a0\u00a0\u00a0 Smith\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pune\u00a0\u00a0 17\u00a0\u00a0\u00a0\u00a0 12000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13.0\u00a0 180000.0\r\n1\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0 Rana\u00a0\u00a0\u00a0\u00a0 Mumbai\u00a0\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0 2000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\r\n2\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0 Jaydev\u00a0\u00a0\u00a0 Kolkata\u00a0\u00a0 22\u00a0\u00a0\u00a0\u00a0 25640\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7.0\u00a0\u00a0 15499.0\r\n3\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0 Shikhar\u00a0 Hyderabad\u00a0\u00a0 28\u00a0\u00a0\u00a0\u00a0 85410\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\r\n4\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0 Sanju\u00a0 Rajasthan\u00a0\u00a0 21\u00a0\u00a0\u00a0\u00a0 63180\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.0\u00a0 201000.0\r\n5\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0 Raina\u00a0\u00a0\u00a0 Gujarat\u00a0\u00a0 18\u00a0\u00a0\u00a0\u00a0 62790\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14.0\u00a0 741000.0<\/pre>\n
<\/a>Merge DataFrames using Right Join :<\/h3>\n
What is Right join ?<\/h4>\n
import pandas as sc\r\n# List of Tuples\r\nplayers = [(15,'Smith','Pune', 17,12000),\r\n (99,'Rana', 'Mumbai', 20,2000),\r\n (51,'Jaydev','Kolkata', 22,25640),\r\n (31,'Shikhar','Hyderabad', 28,85410),\r\n (12,'Sanju','Rajasthan', 21,63180),\r\n (35,'Raina','Gujarat', 18,62790)\r\n ]\r\n# Creation of DataFrame object\r\nplayDFObj = sc.DataFrame(players, columns=['JersyN','Name', 'Team', 'Age','Sponsered'], index=['I', 'II', 'III', 'IV', 'V', 'VI'])\r\nprint('DataFrame 1 : ')\r\nprint(playDFObj)\r\nmoreInfo = [(15, 13, 180000, 12000) ,\r\n (99, 2, 2000) ,\r\n (51, 7, 15499, 25640) ,\r\n (31, 17, 654000) ,\r\n (12, 5, 201000, 63180) ,\r\n (35, 14, 741000, 62790)\r\n ]\r\n# Creation of DataFrame object\r\nmoreinfoObj = sc.DataFrame(moreInfo, columns=['JersyN', 'PLayingSince' , 'Salary', 'Sponsered'], index=['I', 'II', 'III', 'IV', 'V', 'VI'])\r\nprint('DataFrame 2 : ')\r\nprint(moreinfoObj)\r\n# Merge two Dataframes on basis of common column by default INNER JOIN\r\nmergedDataf = playDFObj.merge(moreinfoObj, how='right')\r\nprint('After merging: ')\r\nprint(mergedDataf)\r\n<\/pre>\n
Output :\r\nDataFrame 1 :\r\n \u00a0\u00a0\u00a0 JersyN\u00a0\u00a0\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Team\u00a0 Age\u00a0 Sponsered\r\nI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0\u00a0 Smith\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pune\u00a0\u00a0 17\u00a0\u00a0\u00a0\u00a0\u00a0 12000\r\nII\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0 Rana\u00a0\u00a0\u00a0\u00a0 Mumbai\u00a0\u00a0 20\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a02000\r\nIII\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0 Jaydev\u00a0\u00a0\u00a0 Kolkata\u00a0\u00a0 22\u00a0\u00a0\u00a0\u00a0\u00a0 25640\r\nIV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0 Shikhar\u00a0 Hyderabad\u00a0\u00a0 28\u00a0\u00a0\u00a0\u00a0\u00a0 85410\r\nV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0 Sanju\u00a0 Rajasthan\u00a0\u00a0 21\u00a0\u00a0\u00a0\u00a0\u00a0 63180\r\nVI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0 Raina\u00a0\u00a0\u00a0 Gujarat\u00a0\u00a0 18\u00a0\u00a0\u00a0\u00a0\u00a0 62790\r\nDataFrame 2 :\r\n \u00a0\u00a0\u00a0 JersyN\u00a0 PLayingSince\u00a0 Salary\u00a0 Sponsered\r\nI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13\u00a0 180000\u00a0\u00a0\u00a0 12000.0\r\nII\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0 2000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\r\nIII\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0 15499\u00a0\u00a0\u00a0 25640.0\r\nIV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17\u00a0 654000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\r\nV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0 201000\u00a0\u00a0\u00a0 63180.0\r\nVI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0 741000\u00a0\u00a0\u00a0 62790.0\r\nAfter merging:\r\n \u00a0 JersyN\u00a0\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Team\u00a0\u00a0 Age\u00a0 Sponsered\u00a0 PLayingSince\u00a0 Salary\r\n0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0 Smith\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pune\u00a0 17.0\u00a0\u00a0\u00a0 12000.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13\u00a0 180000\r\n1\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0 Jaydev\u00a0\u00a0\u00a0 Kolkata\u00a0 22.0\u00a0\u00a0\u00a0 25640.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0 15499\r\n2\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0 Sanju\u00a0 Rajasthan\u00a0 21.0\u00a0\u00a0\u00a0 63180.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0 201000\r\n3\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0 Raina\u00a0\u00a0\u00a0 Gujarat\u00a0 18.0\u00a0\u00a0\u00a0 62790.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0 741000\r\n4\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a02\u00a0\u00a0\u00a0 2000\r\n5\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17\u00a0 654000<\/pre>\n
<\/a>Merge DataFrames using Outer Join :<\/h3>\n
What is Outer join ?<\/h4>\n
import pandas as sc\r\n# List of Tuples\r\nplayers = [(15,'Smith','Pune', 17,12000),\r\n (99,'Rana', 'Mumbai', 20,2000),\r\n (51,'Jaydev','Kolkata', 22,25640),\r\n (31,'Shikhar','Hyderabad', 28,85410),\r\n (12,'Sanju','Rajasthan', 21,63180),\r\n (35,'Raina','Gujarat', 18,62790)\r\n ]\r\n# Creation of DataFrame object\r\nplayDFObj = sc.DataFrame(players, columns=['JersyN','Name', 'Team', 'Age','Sponsered'], index=['I', 'II', 'III', 'IV', 'V', 'VI'])\r\nprint('DataFrame 1 : ')\r\nprint(playDFObj)\r\nmoreInfo = [(15, 13, 180000, 12000) ,\r\n (99, 2, 2000) ,\r\n (51, 7, 15499, 25640) ,\r\n (31, 17, 654000) ,\r\n (12, 5, 201000, 63180) ,\r\n (35, 14, 741000, 62790)\r\n ]\r\n# Creation of DataFrame object\r\nmoreinfoObj = sc.DataFrame(moreInfo, columns=['JersyN', 'PLayingSince' , 'Salary', 'Sponsered'], index=['I', 'II', 'III', 'IV', 'V', 'VI'])\r\nprint('DataFrame 2 : ')\r\nprint(moreinfoObj)\r\n# Merge two Dataframes on basis of common column by default INNER JOIN\r\nmergedDataf = playDFObj.merge(moreinfoObj, how='outer')\r\nprint('After merging: ')\r\nprint(mergedDataf)\r\n<\/pre>\n
Output :\r\nDataFrame 1 :\r\n \u00a0\u00a0\u00a0 JersyN\u00a0\u00a0\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Team\u00a0 Age\u00a0 Sponsered\r\nI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a015\u00a0\u00a0\u00a0 Smith\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pune\u00a0\u00a0 17\u00a0\u00a0\u00a0\u00a0\u00a0 12000\r\nII\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0 Rana\u00a0\u00a0\u00a0\u00a0 Mumbai\u00a0\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2000\r\nIII\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0 Jaydev\u00a0\u00a0\u00a0 Kolkata\u00a0\u00a0 22\u00a0\u00a0\u00a0\u00a0\u00a0 25640\r\nIV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0 Shikhar\u00a0 Hyderabad\u00a0\u00a0 28\u00a0\u00a0\u00a0\u00a0\u00a0 85410\r\nV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0 Sanju\u00a0 Rajasthan\u00a0\u00a0 21\u00a0\u00a0\u00a0\u00a0\u00a0 63180\r\nVI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0 Raina\u00a0\u00a0\u00a0 Gujarat\u00a0\u00a0 18\u00a0\u00a0\u00a0\u00a0\u00a0 62790\r\nDataFrame 2 :\r\n \u00a0\u00a0\u00a0 JersyN\u00a0 PLayingSince\u00a0 Salary\u00a0 Sponsered\r\nI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13\u00a0 180000\u00a0\u00a0\u00a0 12000.0\r\nII\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0 2000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\r\nIII\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0 15499\u00a0\u00a0\u00a0 25640.0\r\nIV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17\u00a0 654000\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0NaN\r\nV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0 201000\u00a0\u00a0\u00a0 63180.0\r\nVI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0 741000\u00a0\u00a0\u00a0 62790.0\r\nAfter merging:\r\n \u00a0 JersyN\u00a0\u00a0\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Team\u00a0\u00a0 Age\u00a0 Sponsered\u00a0 PLayingSince\u00a0\u00a0\u00a0 Salary\r\n0\u00a0\u00a0\u00a0\u00a0\u00a0 15\u00a0\u00a0\u00a0 Smith\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pune\u00a0 17.0\u00a0\u00a0\u00a0 12000.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13.0\u00a0 180000.0\r\n1\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0 Rana\u00a0\u00a0\u00a0\u00a0 Mumbai\u00a0 20.0\u00a0\u00a0\u00a0\u00a0 2000.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\r\n2\u00a0\u00a0\u00a0\u00a0\u00a0 51\u00a0\u00a0 Jaydev\u00a0\u00a0\u00a0 Kolkata\u00a0 22.0\u00a0\u00a0\u00a0 25640.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7.0\u00a0\u00a0 15499.0\r\n3\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0 Shikhar\u00a0 Hyderabad\u00a0 28.0\u00a0\u00a0\u00a0 85410.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\r\n4\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0 Sanju\u00a0 Rajasthan\u00a0 21.0\u00a0\u00a0\u00a0 63180.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.0\u00a0 201000.0\r\n5\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0 Raina\u00a0\u00a0\u00a0 Gujarat\u00a0 18.0\u00a0\u00a0\u00a0 62790.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14.0\u00a0 741000.0\r\n6\u00a0\u00a0\u00a0\u00a0\u00a0 99\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.0\u00a0\u00a0\u00a0 2000.0\r\n7\u00a0\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NaN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17.0\u00a0 654000.0<\/pre>\n
\n