vDataFrame[].rename

In [ ]:
vDataFrame[].rename(new_name: str)

Renames the vcolumn by dropping the current vcolumn and creating a copy with the specified name.

⚠ Warning: SQL code generation will be slower if the vDataFrame has been transformed multiple times, so it's better practice to use this method when first preparing your data.

Parameters

Name Type Optional Description
new_name
str
❌
The new vcolumn alias.

Returns

vDataFrame : self.parent

Example

In [62]:
from verticapy.datasets import load_titanic
titanic = load_titanic()
display(titanic["sex"])
Abc
sex
Varchar(20)
1female
2male
3female
4male
5male
6male
7male
8male
9male
10male
11male
12male
13male
14male
15male
16male
17male
18male
19male
20male
21male
22male
23male
24male
25male
26male
27male
28male
29male
30male
31male
32male
33male
34male
35female
36male
37male
38male
39male
40male
41male
42male
43male
44male
45male
46male
47male
48male
49male
50male
51male
52male
53male
54male
55male
56male
57female
58male
59male
60male
61male
62male
63male
64male
65male
66male
67male
68male
69male
70male
71male
72male
73male
74male
75male
76male
77male
78male
79male
80male
81male
82male
83male
84male
85male
86male
87male
88male
89male
90male
91male
92male
93male
94male
95male
96male
97male
98male
99male
100male
Rows: 1-100 of 1234 | Column: sex | Type: varchar(20)
In [63]:
titanic["sex"].rename("gender")
display(titanic["gender"])
Abc
gender
Varchar(20)
1female
2male
3female
4male
5male
6male
7male
8male
9male
10male
11male
12male
13male
14male
15male
16male
17male
18male
19male
20male
21male
22male
23male
24male
25male
26male
27male
28male
29male
30male
31male
32male
33male
34male
35female
36male
37male
38male
39male
40male
41male
42male
43male
44male
45male
46male
47male
48male
49male
50male
51male
52male
53male
54male
55male
56male
57female
58male
59male
60male
61male
62male
63male
64male
65male
66male
67male
68male
69male
70male
71male
72male
73male
74male
75male
76male
77male
78male
79male
80male
81male
82male
83male
84male
85male
86male
87male
88male
89male
90male
91male
92male
93male
94male
95male
96male
97male
98male
99male
100male
Rows: 1-100 of 1234 | Column: gender | Type: varchar(20)

See Also

vDataFrame[].add_copy Creates a copy of the vcolumn.