One of the common tasks that you might encounter while working with Pandas is converting DateTime to a date string. This requirement often arises when you are only interested in the date part of the DateTime object, excluding the time information. In this article, we will learn about some easy ways to convert a DateTime object to a date string in Pandas.<\/p>\n\n\n\n
Before learning about methods, let’s revise the concept of DateTime. It is a set of dates and times combined into one unit. It follows the format of “yyyy-mm-dd HH:MM:SS”, where “yyyy-mm-dd” represents the date, and “HH:MM:SS” represents the time.<\/p>\n\n\n\n
DateTime objects can be used in a lot of places in our projects. We can also query the specific Year, Month, Day, Hour, Minute, or even Second from the object. However, many times we are not able to directly use the DateTime object. <\/p>\n\n\n\n
Let us first see an example of creating a DateTime object:<\/p>\n\n\n\n
from datetime import datetime\n\n# Using the now() method to get current time and date\ncurrent_time = datetime.now()\nprint(current_time)<\/pre><\/div>\n\n\n\nOutput:<\/strong><\/p>\n\n\n\n
2023-12-28 03:59:30.858756<\/code><\/pre>\n\n\n\nThe datetime.now() function returns a DateTime object representing the current date and time. You can then access various components of the date and time using attributes like year, month, day, hour, minute, second, and microsecond.<\/p>\n\n\n\n
When you are grouping data based on date values, converting datetime to date allows you to focus on the date component alone. This is particularly useful when summarizing or analyzing data on a daily, monthly, or yearly basis. Also, when merging dataframes on date columns, conversion of datetime to date can facilitate matching records with the same date, even if they have different time components.<\/p>\n\n\n\n
Now, let us discuss the various methods we can use to convert the DateTime to date.<\/p>\n\n\n\n
1) Using the .date() Function<\/strong><\/h3>\n\n\n\n
The date() function<\/strong> is an in-built function that is used to convert the DateTime object into a date string. It is a simple and direct way to extract the date from a DateTime object. <\/strong><\/p>\n\n\n\n
Let us see an example:<\/p>\n\n\n\n
import pandas as pd\nfrom datetime import datetime\n\n# Create a custom sample dataset\ndata = {'Timestamp': [datetime(2023, 1, 15, 8, 30),\n datetime(2023, 1, 16, 12, 45),\n datetime(2023, 1, 17, 10, 0),\n datetime(2023, 1, 18, 14, 15)]}\n\n# Create a DataFrame from the sample dataset\ndf = pd.DataFrame(data)\n\n# Display the original DataFrame\nprint("Original DataFrame:")\nprint(df)\n\n# Convert Datetime object to date string using .date()\ndf['Date'] = df['Timestamp'].dt.date\n\n# Display the DataFrame with the new 'Date' column\nprint("\\nDataFrame with Date String:")\nprint(df[['Date']])<\/pre><\/div>\n\n\n\nOutput<\/strong>:<\/p>\n\n\n\n
Original DataFrame:\n Timestamp\n0 2023-01-15 08:30:00\n1 2023-01-16 12:45:00\n2 2023-01-17 10:00:00\n3 2023-01-18 14:15:00\n\nDataFrame with Date String:\n Date\n0 2023-01-15\n1 2023-01-16\n2 2023-01-17\n3 2023-01-18\n<\/code><\/pre>\n\n\n\n2) Using the normalize() Method<\/strong><\/h3>\n\n\n\n
Another built-in Python function that we can use for this conversion is the .normalize() method. It is particularly useful when you need to normalize the data by extracting the date from DateTime. Let’s see how it works:<\/p>\n\n\n\n
import pandas as pd\nfrom datetime import datetime\n\n# Create a custom sample dataset\ndata = {'Timestamp': [datetime(2023, 1, 15, 8, 30),\n datetime(2023, 1, 16, 12, 45),\n datetime(2023, 1, 17, 10, 0),\n datetime(2023, 1, 18, 14, 15)]}\n\n# Create a DataFrame from the sample dataset\ndf = pd.DataFrame(data)\n\n# Display the original DataFrame\nprint("Original DataFrame:")\nprint(df)\n\n# Convert Datetime object to date string using .normalize()\ndf['Date'] = df['Timestamp'].dt.normalize()\n\n# Display the DataFrame with the new 'Date' column\nprint("\\nDataFrame with Date String:")\nprint(df[['Date']])<\/pre><\/div>\n\n\n\nOutput:<\/strong><\/p>\n\n\n\n
Original DataFrame:\n Timestamp\n0 2023-01-15 08:30:00\n1 2023-01-16 12:45:00\n2 2023-01-17 10:00:00\n3 2023-01-18 14:15:00\n\nDataFrame with Date String:\n Date\n0 2023-01-15\n1 2023-01-16\n2 2023-01-17\n3 2023-01-18\n<\/code><\/pre>\n\n\n\n3) Using a Custom Function<\/strong><\/h3>\n\n\n\n
Aside from the built-in functions provided by Pandas, you can also create a custom function to convert Pandas datetime to date. This can be particularly helpful when you have specific requirements that can’t be met by the built-in functions. This method provides more flexibility and control over the formatting of the date, making it a useful tool when working with complex datasets.<\/p>\n\n\n\n
The following example will help you better understand it:<\/p>\n\n\n\n
import pandas as pd\nfrom datetime import datetime\n\n# Create a custom sample dataset\ndata = {'Timestamp': [datetime(2023, 1, 15, 8, 30),\n datetime(2023, 1, 16, 12, 45),\n datetime(2023, 1, 17, 10, 0),\n datetime(2023, 1, 18, 14, 15)]}\n\n# Create a DataFrame from the sample dataset\ndf = pd.DataFrame(data)\n\n# Custom Function to extract the date\ndef extract_date(dt):\n return dt.date()\n\n# Display the original DataFrame\nprint("Original DataFrame:")\nprint(df)\n\n# Convert Datetime object to date string using custom function\ndf['Date'] = df['Timestamp'].apply(extract_date)\n\n# Display the DataFrame with the new 'Date' column\nprint("\\nDataFrame with Date String:")\nprint(df[['Date']])<\/pre><\/div>\n\n\n\nOutput:<\/strong><\/p>\n\n\n\n
Original DataFrame:\n Timestamp\n0 2023-01-15 08:30:00\n1 2023-01-16 12:45:00\n2 2023-01-17 10:00:00\n3 2023-01-18 14:15:00\n\nDataFrame with Date String:\n Date\n0 2023-01-15\n1 2023-01-16\n2 2023-01-17\n3 2023-01-18\n<\/code><\/pre>\n\n\n\n