Python | Pandas Series.dt.year



Python | Pandas Series.dt.year

Series.dt can be used to access the values of the series as datetimelike and return several properties. Pandas Series.dt.year attribute return a numpy array containing year of the datetime in the underlying data of the given series object.

Syntax: Series.dt.year

Parameter : None

Returns : numpy array

Example #1: Use Series.dt.year attribute to return the year of the datetime in the underlying data of the given Series object.

# importing pandas as pd
import pandas as pd
 
# Creating the Series
sr = pd.Series(['2012-10-21 09:30', '2019-7-18 12:30', '2008-02-2 10:30',
                '2010-4-22 09:25', '2019-11-8 02:22'])
 
# Creating the index
idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5']
 
# set the index
sr.index = idx
 
# Convert the underlying data to datetime 
sr = pd.to_datetime(sr)
 
# Print the series
print(sr)

Output :

Now we will use Series.dt.year attribute to return the year of the datetime in the underlying data of the given Series object.

# return the year
result = sr.dt.year
 
# print the result
print(result)

Output :

As we can see in the output, the Series.dt.year attribute has successfully accessed and returned the year of the datetime in the underlying data of the given series object.

Example #2 : Use Series.dt.year attribute to return the year of the datetime in the underlying data of the given Series object.

# importing pandas as pd
import pandas as pd
 
# Creating the Series
sr = pd.Series(pd.date_range('2012-12-12 12:12',
                       periods = 5, freq = 'H'))
 
# Creating the index
idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5']
 
# set the index
sr.index = idx
 
# Print the series
print(sr)

Output :

Now we will use Series.dt.year attribute to return the year of the datetime in the underlying data of the given Series object.

# return the year
result = sr.dt.year
 
# print the result
print(result)

Output :

As we can see in the output, the Series.dt.year attribute has successfully accessed and returned the year of the datetime in the underlying data of the given series object.

 

Last Updated on October 23, 2021 by admin

Leave a Reply

Your email address will not be published. Required fields are marked *

Recommended Blogs

Read SQL database table into a Pandas DataFrame using SQLAlchemyRead SQL database table into a Pandas DataFrame using SQLAlchemy



Read SQL database table into a Pandas DataFrame using SQLAlchemy To read sql table into a DataFrame using only the table name, without executing any query we use read_sql_table() method in Pandas. This function does not support DBAPI connections. read_sql_table() Syntax : pandas.read_sql_table(table_name,

Convert given Pandas series into a dataframe with its index as another column on the dataframeConvert given Pandas series into a dataframe with its index as another column on the dataframe



Convert given Pandas series into a dataframe with its index as another column on the dataframe First of all, let we understand that what are pandas series. Pandas Series are the type of array data structure. It is one dimensional data