What are some examples of joining DataFrames in Pandas?

What are some examples of joining DataFrames in Pandas?

In Pandas, you can join DataFrames using methods like merge(), join(), and concat(). Would you like to see specific examples?

Yes, please provide an example using the merge() function.

Sure! Here's a simple example:

import pandas as pd

df1 = pd.DataFrame({'key': ['A', 'B', 'C'], 'value1': [1, 2, 3]})
df2 = pd.DataFrame({'key': ['B', 'C', 'D'], 'value2': [4, 5, 6]})

result = pd.merge(df1, df2, on='key', how='inner')
print(result)

This will merge the two DataFrames on the 'key' column using an inner join.

What about using the join() method?

The join() method is used to join DataFrames based on their index. Here's an example:

import pandas as pd

df1 = pd.DataFrame({'value1': [1, 2, 3]}, index=['A', 'B', 'C'])
df2 = pd.DataFrame({'value2': [4, 5, 6]}, index=['B', 'C', 'D'])

result = df1.join(df2, how='inner')
print(result)

This will join the DataFrames on their indices.