Introduction to R: Dealing With Dates

Date and datetime data is often loaded into R as strings by default, but to work with dates effectively they need to be converted to date formats that allow for exaction of useful information like the day of the week. In this lesson we cover the basics of working with dates in R.
This is lesson 16 of a 30-part introduction to the R programming language for data analysis and predictive modeling. Link to the code notebook below:
Introduction to R: Dealing With Dates www.kaggle.com/hamelg/intro-t...
This guide does not assume any prior exposure to R, programming or data science. It is intended for beginners with an interest in data science and those who might know other programming languages and would like to learn R.
I will create the videos for this guide such that you should be able to learn a lot just watching on KZbin, but to get the most out of the guide, it is recommended that you create a Kaggle account so that you can fork and edit each lesson so that you can follow along and run code yourself.
Follow DataDaft on social media for news and updates:
Twitter: / datadaft
Introduction to R Playlist:
• Introduction to R

[@pimpmatic2k2]

That was a great explanation of POSIXct and POSXlt. I finally really understand it.

[@fatmashehab6236]

I have finally understand how to convert to time date format , thanks a lot for your clear and detailed explanation

[@Reborn8849]

Thank you so much! I'm new to R and was getting really frustrated in finding an explanation that is easy to understand until I found this video!

[@apetiteindian2634]

Very well explained. Thank you

[@Kicsa]

This is just I needed, thank you.

[@samzambabal2069]

Very helpful video, thanks :)

[@thanhbuixuan6580]

Really helpful video. Thank you

[@wafamehaba5692]

You saved my day thank you

[@larter_larter]

Thanks for the dating tips! 😉

[@vinicioalvarado2262]

Thank you, very helpful Posixlt in 5:29

[@paulodeoliveira376]

Your video is very helpful :)

[@heyybigdaddy6988]

Hello, thanks so much for this lesson. Would you be able to explain how to cane the times zones? For example from UTC to EST

[@cookie.lover007]

Thank you for that video! However, I'm still stuck... I'd like to convert a column extracted from Excel that is in numerical time (0.54036, 0.55625) to a proper date-time format (13:02, 13:21...). I use data from public transit data sources, in such way that 1.00833 is 00:12. Would you have the code to do that?

[@juja2819]

Thanks a lot!

[@noahrudd3043]

Thank you!!!!!!

[@raymilan2301]

Thank you! I have one question, if I have two columns, date1 and date2, and I want to find the minimum date between the 2 columns, is there a specific function?

[@vinodkukanur]

Thanks very much for making such wonderful videos. I learned many packages from watching your videos. I have a small query, can you please explain how to extract a month from the year-week format date? Ex: "2018-3" (%Y-%W) to Month. I tried searching the net unable to find the answer.

[@stevep742]

Your video sounds good, but my date variable format is a “chr” with values like “35357” after importing from Access. How can these variables be converted to a date format? Thanks!

[@eldelbharadri2282]

Hi there! I need to take out the maximum values from a diary data serie. I have to extract the maximum values from each year. How could i do It?

[@ciroweinstein8627]

Any suggestion to what to do if the collumn name are the dates and the data is across...

[@poojamahesh8594]

great explaination! i have a dataset containing time period, I want to categorise it into early morning, morning, mid-day, afternoon, evening... kindly suggest me a line of code for it..

[@vincenzo4259]

Thanks

[@poojamahesh8594]

I have a variable "ACCIDENT_TIME" , it is in chr class..how should I convert it to the proper class

[@jaldipkarangiya8973]

Hi I want to convert date column in data file from DDMMYYYY to YYYYMMDD, how I can do?

[@pink1274]

What if we want to convert date time to just date

[@poojamahesh8594]

I would like to convert these dates with format YYYYMMDD to a Date class. dates

[@slainiae]

I'm no expert in R, but I think you should have it as "%d-%m-%Y".

[@claire2247]

What do we do if the data is not formatted in one of those ways? For example, my data is in the format: 1/1/2021. Thank you!

[@DataDaft]

You have to use the appropriate date format codes to match your format. For a date in numeric month/numeric day/four digit year format you would use: as.Date("1/1/2021", format="%m/%d/%Y") (Basically the same as the first one shown, but using %Y instead of %y) Some common codes: # %d - Day # %m - Numeric Month # %b - Abbreviated Month # %B - Full Month # %y - 2-digit year # %Y - 4-digit year This blog post has a list of format more codes: www.r-bloggers.com/2013/08/date-formats-in-r/

[@claire2247]

@@DataDaft Thank you!

[@Jonpaulim]

Hi Great video can I ask you a question please

[@DataDaft]

Sure, but I can't promise to have a good (or any) answer depending on what it is.

[@jaldipkarangiya8973]

shall we deal with DDMMYYYY date format?

[@ahmed007Jaber]

Thank u for this. What to do if u had a column with mixed date format Ddmmyyy Mmddyyyy Yyyymmdd

[@khayryazzez]

Hi , How can i convert this date 1.671792856490282E15