Append pandas DataFrame in Python (4 Examples) | Concatenate & Combine Vertically | Stack DataFrames

Publié le: 13 avril 2022
sur la chaîne: Statistics Globe
720
15

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


Sur cette page du site, vous pouvez voir la vidéo en ligne Append pandas DataFrame in Python (4 Examples) | Concatenate & Combine Vertically | Stack DataFrames durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Statistics Globe 13 avril 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 720 fois et il a aimé 15 téléspectateurs. Bon visionnage!