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

Показать описание
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
ignore_index = True)
print(data_all1) # Print combined DataFrame
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
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
ignore_index = True,
sort = False)
print(data_all4) # Print combined DataFrame
Follow me on Social Media:
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
ignore_index = True)
print(data_all1) # Print combined DataFrame
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
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
ignore_index = True,
sort = False)
print(data_all4) # Print combined DataFrame
Follow me on Social Media: