HomeLanguagesHow to Use rbind in Python?

How to Use rbind in Python?

In this article, we will discuss rbind() in python.

Method 1: Use rbind() function with equal columns

Here we have to take 2 dataframes with equal columns and apply concat() function. This will combine the rows based on columns.

Syntax:

pandas.concat([dataframe1, dataframe2])

where

  • dataframe1 is the first dataframe
  • dataframe2 is the second dataframe

Example:

Python3




# import pandas module
import pandas as pd
  
# create first dataframe
data1 = pd.DataFrame({'fruits': ['apple', 'guava', 'mango', 'banana'],
                      'cost': [34, 56, 65, 45]})
  
# create second dataframe
data2 = pd.DataFrame({'fruits': ['cuatard apple', 'guava', 'mango', 'papaya'],
                      'cost': [314, 86, 65, 51]})
  
# concat two columns
pd.concat([data1, data2])


Output:

Method 2: Use rbind() function with unequal columns 

Here the two dataframes columns are not equal, In this scenario, the unmatched column will get NAN replaced rows in its column.

Syntax:

pandas.concat([dataframe1, dataframe2])

where,

  • dataframe1 is the first dataframe
  • dataframe2 is the second dataframe

Example:

Python3




# import pandas module
import pandas as pd
  
# create first dataframe with 2 columns
data1 = pd.DataFrame({'fruits': ['apple', 'guava', 'mango', 'banana'],
                      'cost': [34, 56, 65, 45]})
  
# create second dataframe with 3 columns
data2 = pd.DataFrame({'fruits': ['cuatard apple', 'guava', 'mango', 'papaya'],
                      'cost': [314, 86, 65, 51],
                      'city': ['guntur', 'tenali', 'ponnur', 'hyd']})
  
# concat two columns
pd.concat([data1, data2])


Output:

Here we observed that the index of the rows again starts from 0, in order to avoid this, we have to use the .reset_index() method. This will reset the index of the new dataframe.

Syntax:

pandas.concat([dataframe1, dataframe2]).reset_index(drop=True)

Example:

Python3




# import pandas module
import pandas as pd
  
# create first dataframe with 2 columns
data1 = pd.DataFrame({'fruits': ['apple', 'guava', 'mango', 'banana'],
                      'cost': [34, 56, 65, 45]})
  
# create second dataframe with 3 columns
data2 = pd.DataFrame({'fruits': ['cuatard apple', 'guava', 'mango', 'papaya'],
                      'cost': [314, 86, 65, 51],
                      'city': ['guntur', 'tenali', 'ponnur', 'hyd']})
  
# concat two columns
pd.concat([data1, data2]).reset_index(drop=True)


Output:

Dominic
Dominichttp://wardslaus.com
infosec,malicious & dos attacks generator, boot rom exploit philanthropist , wild hacker , game developer,
RELATED ARTICLES

3 COMMENTS

Most Popular

Dominic
32688 POSTS0 COMMENTS
Milvus
131 POSTS0 COMMENTS
Nango Kala
7057 POSTS0 COMMENTS
Nicole Veronica
12198 POSTS0 COMMENTS
Nokonwaba Nkukhwana
12293 POSTS0 COMMENTS
Shaida Kate Naidoo
7182 POSTS0 COMMENTS
Ted Musemwa
7447 POSTS0 COMMENTS
Thapelo Manthata
7160 POSTS0 COMMENTS
Umr Jansen
7150 POSTS0 COMMENTS