Concatenating data

We call concatenation the process of joining two datasets, whether we're taking their columns and including them in another or combining their rows, resulting in a dataset whose number of rows is equal to the sum of the number of rows of the datasets to be concatenated.

Let's look at an example of row concatenation:

df_a = op.create.dataframe({
    "id": [143, 225, 545],
    "name": ["Alice", "Bob", "Charlie"],
    "city": ["Plymouth", "Bradford", "Norwich"]
})
df_b = op.create.dataframe({
    "id": [765, 329, 152],
    "name": ["Dan", "Erin", "Frank"],
    "city": ["Bath", "Manchester", "Ripon"]
})

df_a and df_b can be concatenated as follows:

df_a...