Combine pandas DataFrames Vertically & Horizontally in Python (Example) | Join & Merge Side-by-Side

Pubblicato il: 31 agosto 2022
sul canale di: Statistics Globe

629

How to merge pandas DataFrames vertically and horizontally in the Python programming language. More details: https://statisticsglobe.com/combine-p...
Python code of this video:

import pandas as pd # Load pandas library

data1a = pd.DataFrame({"ID":range(1, 5), # Create first pandas DataFrame
"x1":range(10, 6, - 1),
"x2":["a", "b", "c", "d"],
"x3":range(26, 22, - 1)})
print(data1a) # Print first pandas DataFrame

data2a = pd.DataFrame({"ID":range(2, 8), # Create second pandas DataFrame
"y1":["x", "y", "y", "x", "y", "y"],
"y2":range(12, 1, - 2)})
print(data2a) # Print second pandas DataFrame

data_horizontal = pd.merge(data1a, # Combine horizontally
data2a,
on = "ID",
how = "outer")
print(data_horizontal) # Print merged DataFrame

data1b = pd.DataFrame({"x1":range(11, 6, - 1),
"x2":["a", "b", "c", "d", "e"],
"x3":range(28, 23, - 1)})
print(data1b) # Print first pandas DataFrame

data2b = pd.DataFrame({"x1":range(1, 8), # Create second pandas DataFrame
"x2":["x", "y", "x", "y", "x", "y", "y"],
"x3":range(14, 1, - 2)})
print(data2b) # Print second pandas DataFrame

data_vertical = pd.concat([data1b, data2b], # Combine vertically
ignore_index = True,
sort = False)
print(data_vertical) # Print combined DataFrame

Follow me on Social Media:
Facebook – Statistics Globe Page:   / statisticsglobecom
Facebook – R Programming Group for Discussions & Questions:   / statisticsglobe
Facebook – Python Programming Group for Discussions & Questions:   / statisticsglobepython
LinkedIn – Statistics Globe Page:   / statisticsglobe
LinkedIn – R Programming Group for Discussions & Questions:   / 12555223
LinkedIn – Python Programming Group for Discussions & Questions:   / 12673534
Twitter:   / joachimschork

Music by bensound.com

In questa pagina del sito puoi guardare il video online Combine pandas DataFrames Vertically & Horizontally in Python (Example) | Join & Merge Side-by-Side della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Statistics Globe 31 agosto 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 629 volte e gli è piaciuto 8 spettatori. Buona visione!

234