Book a Demo!
CoCalc Logo Icon
StoreFeaturesDocsShareSupportNewsAboutPoliciesSign UpSign In
pola-rs
GitHub Repository: pola-rs/polars
Path: blob/main/docs/source/src/python/user-guide/transformations/concatenation.py
7890 views
1
# --8<-- [start:setup]
2
import polars as pl
3
4
# --8<-- [end:setup]
5
6
# --8<-- [start:vertical]
7
df_v1 = pl.DataFrame(
8
{
9
"a": [1],
10
"b": [3],
11
}
12
)
13
df_v2 = pl.DataFrame(
14
{
15
"a": [2],
16
"b": [4],
17
}
18
)
19
df_vertical_concat = pl.concat(
20
[
21
df_v1,
22
df_v2,
23
],
24
how="vertical",
25
)
26
print(df_vertical_concat)
27
# --8<-- [end:vertical]
28
29
# --8<-- [start:horizontal]
30
df_h1 = pl.DataFrame(
31
{
32
"l1": [1, 2],
33
"l2": [3, 4],
34
}
35
)
36
df_h2 = pl.DataFrame(
37
{
38
"r1": [5, 6],
39
"r2": [7, 8],
40
"r3": [9, 10],
41
}
42
)
43
df_horizontal_concat = pl.concat(
44
[
45
df_h1,
46
df_h2,
47
],
48
how="horizontal",
49
)
50
print(df_horizontal_concat)
51
# --8<-- [end:horizontal]
52
53
# --8<-- [start:horizontal_different_lengths]
54
df_h1 = pl.DataFrame(
55
{
56
"l1": [1, 2],
57
"l2": [3, 4],
58
}
59
)
60
df_h2 = pl.DataFrame(
61
{
62
"r1": [5, 6, 7],
63
"r2": [8, 9, 10],
64
}
65
)
66
df_horizontal_concat = pl.concat(
67
[
68
df_h1,
69
df_h2,
70
],
71
how="horizontal",
72
)
73
print(df_horizontal_concat)
74
# --8<-- [end:horizontal_different_lengths]
75
76
# --8<-- [start:cross]
77
df_d1 = pl.DataFrame(
78
{
79
"a": [1],
80
"b": [3],
81
}
82
)
83
df_d2 = pl.DataFrame(
84
{
85
"a": [2],
86
"d": [4],
87
}
88
)
89
90
df_diagonal_concat = pl.concat(
91
[
92
df_d1,
93
df_d2,
94
],
95
how="diagonal",
96
)
97
print(df_diagonal_concat)
98
# --8<-- [end:cross]
99
100