quarter¶

In [ ]:

quarter(expr)

Returns calendar quarter of the specified date as an integer, where the January-March quarter is 1.

Parameters¶

Name	Type	Optional	Description
expr	object	❌	Expression.

Returns¶

str_sql : SQL expression.

Example¶

In [1]:

from verticapy import *
df = tablesample({"x": ['11-03-1993 12:05:10.23', '09-05-1959 03:10:20.12']}).to_vdf()
df["x"].astype("timestamp")
display(df)

	📅 x Timestamp
1	1993-11-03 12:05:10.230000
2	1959-09-05 03:10:20.120000

Rows: 1-2 | Column: x | Type: timestamp

In [2]:

# Importing the stats module
import verticapy.stats as st

# Applying the second function
df["quarter_x"] = st.quarter(df["x"])
display(df)

	📅 x Timestamp	123 quarter_x Integer
1	1993-11-03 12:05:10.230000	4
2	1959-09-05 03:10:20.120000	3

Rows: 1-2 | Columns: 2