How to Use Date Formats in R

How to Extract Year from Date in R

Last Updated : 22 Feb, 2022

In this article, we are going to see how to extract the year from the date in R Programming Language.

Method 1: Extract Year from a Vector

In this method, the as.POSIXct is a Date-time Conversion Functions that is used to manipulate objects of classes. To extract the year from vector we need to create a vector with some dates and then arrange the date with as.POSIXct() and get year with format() methods.

R

Date <- c("01/12/2011 12:40:00", "11/12/2015 11:40:00",
          "01/02/2012 05:40:00", "01/04/2021 09:44:00" ,
          "01/02/2020 01:43:00", "01/12/2014 04:41:00")

print("Vector Date:")
print(Date)

# formatted date
print("Extract Year:")
Date <- as.POSIXct(Date, format = "%m/%d/%Y %H:%M:%S")
format(Date, format="%Y")

Output:

[1] "Vector Date:"
[1] "01/12/2011 12:40:00" "11/12/2015 11:40:00" "01/02/2012 05:40:00"
[4] "01/04/2021 09:44:00" "01/02/2020 01:43:00" "01/12/2014 04:41:00"

[1] "Extract Year:"
'2011' '2015' '2012' '2021' '2020' '2014'

Method 2: Extract Year from a Column in a Dataframe

To extract the year from the column, we will create a dataframe with date columns and then separate the year from DateTime using format() methods and extract the year and convert to a numeric format.

R

# declaring a data frame
data_frame = data.frame(Rank = c(5:8) ,
                        Time = c("2021-05-05 01:04:34",
                                 "2021-03-06 03:14:44",
                                 "2021-03-11 07:22:48",
                                 "2021-02-02 11:54:56"))
  
print ("Original dataframe")
data_frame

# data_frame$year <- as.Date(data_frame$Time, "%Y")
# data_frame

data_frame$Time <- as.Date(data_frame$Time)

print("Extract year")
# extract the year and convert to numeric format
data_frame$year <- as.numeric(format(data_frame$Time, "%Y"))
data_frame

Output:

[1] "Original dataframe"
Rank    Time
5    2021-05-05 01:04:34
6    2021-03-06 03:14:44
7    2021-03-11 07:22:48
8    2021-02-02 11:54:56

Extract year
Rank    Time    year
5    2021-05-05    2021
6    2021-03-06    2021
7    2021-03-11    2021
8    2021-02-02    2021

How to Use Date Formats in R

skrg141

Improve

Article Tags :

Similar Reads

How to Extract Characters from a String in R

Strings are one of R's most commonly used data types, and manipulating them is essential in many data analysis and cleaning tasks. Extracting specific characters or substrings from a string is a crucial operation. In this article, weâ€™ll explore different methods to extract characters from a string i

How to Use Date Formats in R

In this article, we will be looking at the approaches to using the date formats in the R programming language, R programming language provides several functions that deal with date and time. These functions are used to format and convert the date from one form to another form. R provides a format fu

Extract time from datetime in Python

In this article, we are going to see how to extract time from DateTime in Python. In Python, there is no such type of datatype as DateTime, first, we have to create our data into DateTime format and then we will convert our DateTime data into time. A Python module is used to convert the data into Da

How to Read a CSV from URL into R?

In this article, we are going to see how to read CSV files from URL using R Programming Language. Method 1: Using Base RÂ Here we are using read.csv() methods, which is an inbuilt function in R programming. This function is similar to Python because it read the CSV file and returns the data into dat

How to Change Date Format in Excel

You know that Excel is one of the best spreadsheets you can work on. Excel is the first preference of many users to create an impressive data set. Have you tried filling in the Date on the sheet? Date with the data is a common practice done by users in Excel to get information timeline. To help orga

How to calculate Years between Dates in R ?

To calculate the number of years between two dates we have several methods. In this article, we will discuss all the methods and their examples of how to calculate the number of years or the difference of years between two dates in the R Programming Language. Table of ContentMethod 1: Using the seq(

How to Address format Error in R

The format() function is an important tool for data transformation and presentation in the world of R Programming Language. Nevertheless, mistakes might happen to users during formatting. in this article, we will handle those errors. Cause of the ErrorThis article aims to explain common causes of er

How to Export DataFrame to CSV in R ?

R Programming language allows us to read and write data into various files like CSV, Excel, XML, etc. In this article, we are going to discuss how to Export DataFrame to CSV file in R Programming Language. Approach:Â Write Data in column wise formatCreate DataFrame for these dataWrite Data to the CS

How to Get Week Numbers from Dates in R?

Week number is the number of weeks within a year or in a set period. It indicates that people of different countries and organizations may have other ways to account for the weeks however, the most popular one is the ISO 8601. In this standard. When it comes to the extraction of week numbers in R, t

How to Extract the Model Equation from Model Object in R?

Extracting the model equation from a model object in R allows you to understand the relationship between the dependent variable and the independent variables. This process is particularly useful when interpreting results from linear, logistic regression, or other statistical models. R provides funct