Append pandas DataFrame in Python (4 Examples) | Concatenate & Combine Vertically | Stack DataFrames
Автор: Statistics Globe
Загружено: 2022-04-13
Просмотров: 803
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
