Скачать или смотреть How to Create a UTC Date Range in Pandas

Discover how to create a date range in `UTC` using Pandas with this step-by-step guide that keeps your time data accurate and correctly formatted.
---
This video is based on the question https://stackoverflow.com/q/71632230/ asked by the user 'Mario' ( https://stackoverflow.com/u/1106247/ ) and on the answer https://stackoverflow.com/a/71632272/ provided by the user 'eshirvana' ( https://stackoverflow.com/u/1367454/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Pandas create a date range with UTC time

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Create a UTC Date Range in Pandas

Working with date and time in data processing can sometimes be tricky, especially when dealing with time zones. If you're using the Pandas library in Python and you want to create a date range, it’s essential to ensure that the generated time is in the correct timezone, particularly if you're interested in Coordinated Universal Time (UTC).

The Problem

Let’s say you have the following code to create a date range DataFrame:

[[See Video to Reveal this Text or Code Snippet]]

The issue with this code is that the resulting time is timezone neutral; it’s stored as dtype='datetime64[ns]'. If you check the data type, you will notice that it does not explicitly represent UTC time, appearing as follows:

[[See Video to Reveal this Text or Code Snippet]]

What you want instead is to have this time data represented as dtype='datetime64[ns, UTC]', ensuring it reflects true UTC time without the actual time changing.

The Solution

To solve this problem, you need to specify the timezone when creating the date range. You can accomplish this by using the tz parameter within the pd.date_range() function. Here’s how to do it:

[[See Video to Reveal this Text or Code Snippet]]

Breakdown of the Solution

Using tz='UTC': By adding this parameter, you inform Pandas that you want the date range to be created with UTC as the timezone. This ensures that your datetime index will reflect UTC times.

Output of the new date range: After implementing the fix, the output will look like this:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

By following these simple steps, you can easily generate a date range in Pandas that accurately reflects UTC time without altering the actual time values. This ensures your timestamp data remains consistent and reliable, crucial for any data analysis or application that relies on precise time measurements.

Remember, always define the timezone when working with datetime in Pandas to avoid localization issues. Happy coding!