Python Pandas - Create A Datetime With DateTimeIndex

• Home
• Whiteboard
• Online Compilers
• Practice
• Articles
• AI Assistant
• Jobs
• Tools
• Corporate Training
• Courses
• Certifications

Menu Categories Login

• Switch theme

• SQL
• HTML
• CSS
• Javascript
• Python
• Java
• C
• C++
• PHP
• Scala
• C#
• Tailwind CSS
• Node.js
• MySQL
• MongoDB
• PL/SQL
• Swift
• Bootstrap
• R
• Machine Learning
• Blockchain
• Angular
• React Native
• Computer Fundamentals
• Compiler Design
• Operating System
• Data Structure and Algorithms
• Computer Network
• DBMS
• Excel

• Data Structure
• Networking
• RDBMS
• Operating System
• Java
• MS Excel
• iOS
• HTML
• CSS
• Android
• Python
• C Programming
• C++
• C#
• MongoDB
• MySQL
• Javascript
• PHP

• Selected Reading
• UPSC IAS Exams Notes
• Developer's Best Practices
• Questions and Answers
• Effective Resume Writing
• HR Interview Questions
• Computer Glossary
• Who is Who

Python Pandas - Create a datetime with DateTimeIndex PythonServer Side ProgrammingProgramming

To create a datetime, we will use the date_range(). The periods and the time zone will also be set with the frequency. At first, import the required libraries −

import pandas as pd

DatetimeIndex with period 8 and frequency as M i.e. months. The timezone is Australia/Sydney −

datetime = pd.date_range('2021-09-24 02:35:55', periods=8, tz='Australia/Sydney', freq='M')

Display the datetime −

print("DateTime...\n", datetime)

Example

Following is the code −

import pandas as pd # DatetimeIndex with period 8 and frequency as M i.e. months # timezone is Australia/Sydney datetime = pd.date_range('2021-09-24 02:35:55', periods=8, tz='Australia/Sydney', freq='M') # display print("DateTime...\n", datetime) # get the day name print("\nGetting the day name..\n",datetime.day_name()) # get the month name print("\nGetting the month name..\n",datetime.month_name()) # get the year print("\nGetting the year name..\n",datetime.year) # get the hour print("\nGetting the hour..\n",datetime.hour) # get the minutes print("\nGetting the minutes..\n",datetime.minute) # get the seconds print("\nGetting the seconds..\n",datetime.second)

Output

This will produce the following output −

DateTime... DatetimeIndex(['2021-09-30 02:35:55+10:00', '2021-10-31 02:35:55+11:00',                '2021-11-30 02:35:55+11:00', '2021-12-31 02:35:55+11:00',                '2022-01-31 02:35:55+11:00', '2022-02-28 02:35:55+11:00',                '2022-03-31 02:35:55+11:00', '2022-04-30 02:35:55+10:00'],                dtype='datetime64[ns, Australia/Sydney]', freq='M') Getting the day name.. Index(['Thursday', 'Sunday', 'Tuesday', 'Friday', 'Monday', 'Monday','Thursday', 'Saturday'], dtype='object') Getting the month name.. Index(['September', 'October', 'November', 'December', 'January', 'February','March', 'April'], dtype='object') Getting the year name..    Int64Index([2021, 2021, 2021, 2021, 2022, 2022, 2022, 2022], dtype='int64') Getting the hour..    Int64Index([2, 2, 2, 2, 2, 2, 2, 2], dtype='int64') Getting the minutes..    Int64Index([35, 35, 35, 35, 35, 35, 35, 35], dtype='int64') Getting the seconds..    Int64Index([55, 55, 55, 55, 55, 55, 55, 55], dtype='int64') AmitDiwan Updated on: 2021-10-19T08:38:54+05:30

5K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started Print Page Previous Next Advertisements