How to combine two pandas DataFrames vertically in the Python programming language. More details: https://statisticsglobe.com/append-pa...
Python code of this video:
import pandas as pd # Load pandas
data1 = pd.DataFrame({"x1":["x", "y", "x", "y", "y", "x", "y"], # Create first pandas DataFrame
"x2":range(3, 10),
"x3":["a", "b", "c", "d", "e", "f", "g"],
"x4":range(22, 15, - 1)})
print(data1) # Print first pandas DataFrame
data2 = pd.DataFrame({"x1":["a", "b", "a", "a", "a", "b", "b"], # Create second pandas DataFrame
"x2":range(103, 110),
"x3":["a", "b", "c", "d", "e", "f", "g"],
"x4":range(1, 8)})
print(data2) # Print second pandas DataFrame
data_all1 = data1.append(data2, # Append DataFrames
ignore_index = True)
print(data_all1) # Print combined DataFrame
data_all2 = pd.concat([data1, data2], # Append DataFrames
ignore_index = True,
sort = False)
print(data_all2) # Print combined DataFrame
data3 = pd.DataFrame({"x1":["z", "zz", "zzz"], # Create third pandas DataFrame
"x2":range(0, 3),
"x3":["a", "b", "c"],
"x4":range(3, 0, - 1)})
print(data3) # Print third pandas DataFrame
data_all3 = pd.concat([data1, data2, data3], # Append DataFrames
ignore_index = True,
sort = False)
print(data_all3) # Print combined DataFrame
data4 = pd.DataFrame({"x1":["a", "b", "c"], # Create fourth pandas DataFrame
"x3":["d", "e", "f"],
"x5":["g", "h", "i"]})
print(data4) # Print fourth pandas DataFrame
data_all4 = pd.concat([data1, data4], # Append DataFrames
ignore_index = True,
sort = False)
print(data_all4) # Print combined DataFrame
Follow me on Social Media:
Facebook – Statistics Globe Page: / statisticsglobecom
Facebook – Group for Discussions & Questions: / statisticsglobe
LinkedIn – Statistics Globe Page: / statisticsglobe
LinkedIn – Group for Discussions & Questions: / 12555223
Twitter: / joachimschork
Music by bensound.com
Auf dieser Seite können Sie das Online-Video Append pandas DataFrame in Python (4 Examples) | Concatenate & Combine Vertically | Stack DataFrames mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Statistics Globe 13 April 2022 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 720 Mal angesehen und es wurde von 15 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!