[PYTHON] Conversion of time data in 25 o'clock notation

Late-night TV programs may be marked as starting at 25:00 or 26:00. Since the data I'm dealing with has a date string and a time in 25 o'clock notation, make a note of how to convert it to DateTime format.

test.py


df["Date and time"] = pd.to_datetime(df["date"]) + pd.to_timedelta(df["Times of Day"])

By converting the time to Timedelta format, the time in 25 o'clock was treated as 25 hours (1 day and 1 hour) and added to datetime.

Digression

What should I call the 25 o'clock notation? ..

Recommended Posts

Conversion of time data in 25 o'clock notation
Memory-saving matrix conversion of log data
Differentiation of time series data (discrete)
Time series analysis 3 Preprocessing of time series data
Preprocessing in machine learning 4 Data conversion
Conversion of string <-> date (date, datetime) in Python
Comparison of Japanese conversion module in Python3
Get JST current time in ISO 8601 notation
Separation of design and data in matplotlib
Python: Preprocessing in machine learning: Data conversion
Power of forecasting methods in time series data analysis Semi-optimization (SARIMA) [Memo]
Memory-saving conversion of log data to sequential category features in chronological order
Plot CSV of time series data with unixtime value in Python (matplotlib)
Get time series data from k-db.com in Python
measurement of time
Memorandum (acquisition / conversion of "user-defined" time, cross tabulation)
Real-time visualization of thermography AMG8833 data in Python
[Python] Conversion memo between time data and numerical data
Smoothing of time series and waveform data 3 methods (smoothing)
The story of reading HSPICE data in Python
View details of time series data with Remotte
How to read time series data in PyTorch
A well-prepared record of data analysis in Python
Summary of tools needed to analyze data in Python
Full-width and half-width processing of CSV data in Python
Power BI visualization of Salesforce data entirely in Python
Anomaly detection of time series data by LSTM (Keras)
About the inefficiency of data transfer in luigi on-memory
Not being aware of the contents of the data in python
List of Python code used in big data analysis
Let's use the open data of "Mamebus" in Python
Numerical summary of data
Sampling in imbalanced data
[Question] How to get data of textarea data in real time using Python web framework bottle
How to calculate the sum or average of time series csv data in an instant
What you should not do in the process of time series data analysis (including reflection)
Preprocessing of prefecture data
Measurement of execution time
Selection of measurement data
Class notation in Python
Try scraping the data of COVID-19 in Tokyo with Python
Basic summary of data manipulation in Python Pandas-Second half: Data aggregation
Analyzing data on the number of corona patients in Japan
Summary of stumbling blocks in Django for the first time
How to generate exponential pulse time series data in python
[Understand in the shortest time] Python basics for data analysis
[Python] Strengths and weaknesses of DataFrame in terms of time required
Graph time series data in Python using pandas and matplotlib
Comparison of data frame handling in Python (pandas), R, Pig
A story about clustering time series data of foreign exchange
How to get an overview of your data in Pandas
Django Changed to save lots of data in one go