Concatenation

Great! You've learned different ways of joining columns. Can we join two dataframes by rows? Surely, we can.

To join two dataframe, use the .concat() method of pandas, passing list of dataframes you want to join as the parameter. To perform this operation, both dataframes must have the same column names. Let's use splitted into two parts one of the dataframes used before and perform rows joining.

Note that .concat() is method of pandas, unlike the .merge() method. So you need to use pd.concat().


              12345678910
            
# Importing library
import pandas as pd

# Loading data
data1 = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/f2947b09-5f0d-4ad9-992f-ec0b87cd4b3f/section5/data_concat_1.csv')
data2 = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/f2947b09-5f0d-4ad9-992f-ec0b87cd4b3f/section5/data_concat_2.csv')

# Perform a left join
df_res = pd.concat([data1, data2])
print(df_res)

Tudo estava claro?

Obrigado pelo seu feedback!

Seção 5. Capítulo 6

Pergunte à IA

Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo

Conteúdo do Curso

Data Manipulation using pandas

1. Preprocessing Data: Part I

What is Data Preprocessing?Types consistency Poor Data Presentation Manipulating Strings Challenge Replacing Specific Elements Simultaneous Replacement Challenge

2. Preprocessing Data: Part II

Logical Inconsistency Removing Rows Challenge Outliers Challenge Missing Values Filling NA values Challenge

3. Grouping Data

What is Grouping Data?Grouping in pandas [1/2]Challenge Grouping in pandas [2/2]Challenge Grouping by Several Columns Challenge

4. Aggregating and Visualizing Data

Advanced Aggregation [1/2]Challenge Advanced Aggregation [2/2]Challenge Histograms Challenge Bar and Scatter Plots Other Types of Graphs Challenge 1 Challenge 2

5. Joining Data