71,473 questions
1
vote
3
answers
71
views
Move time 1 hour back on range of rows in pandas
I have a dataset with a 'Time' column; for 2 dates the time is incorrect and I need to move it back by 1 hour.
This is what my dataframe looks like:
Date Time
05.01.2026 17:00
06.01.2026 ...
- 161
0
votes
2
answers
76
views
Date-time string with time span where ISO 8601 is expected
I'm developing an Android app, and I need to parse some external data. This data includes date-time values, and claims these values to be ISO 8601 compatible. While most of examples I encountered were ...
- 9
1
vote
1
answer
43
views
Plotly Express facets show no lines when setting x-axis range and custom tick labels
I have a dataframe with these columns:
id_pair (pair of sensors)
rssi_mean (detection strength)
contact_day (day of the detection as string, e.g. 'Monday')
study_week (week of the detection as ...
- 1,339
0
votes
0
answers
58
views
Swift decoding error on date type based on user settings preferences (time format) [duplicate]
Recently I have noticed that an API which return a reponse that contains some date type are failing if I have a 12 hour format (AM/PM) on my phone enable iOS 17.6.1. If I switch to 24 hour format the ...
2
votes
2
answers
183
views
C++ hinnant date lib - not parsing string to date under Linux, works on Windows
If I do:
#include <chrono>
#include "./date/date.h"
#include "./date/tz.h"
using UtcTime = std::chrono::time_point<std::chrono::system_clock>;
UtcTime xParseRfc822(...
- 9,665
1
vote
2
answers
88
views
Why does Matplotlib DatetimeIndex plot misalign dates?
Why does matplotlib round to the nearest month sometimes and not other times depending on the order lines are plotted and which dates are used. ax3 and ax4 are particularly interesting because they ...
- 546
Tooling
1
vote
3
replies
65
views
Python delta time series conversion to time data type
I have a column named ride_length that is the difference between two datetime columns. It has a data type of time delta series. How can I convert it into a time data type?
Current format 1 day 12:58:...
1
vote
1
answer
96
views
How to find corrupted date entry when date column type is (object) [closed]
I am trying to convert a column of time stamps that are currently of type object to proper datetime. When using pd.to_datetime() on the column I got this error
OutOfBoundsDatetime: Out of bounds ...
- 1,329
1
vote
1
answer
63
views
wrong results with DateTime/IntlDateFormatter on certain Dates
I try to introduce an alternative way to localize Date expressions using IntlDateFormatter with DateTime.
There is a strange behaviour depending on the day that I use. So I must have done an error in ...
- 15
0
votes
0
answers
64
views
VB Net WinForms Chart Zoom In with DateTime as X Axis
I am a newbie at VB.NET coding. I am currently trying to make a real time line chart in WinForms, but I am struggling with zooming in the chart. My chart has the range of random number generated by a ...
- 11
1
vote
1
answer
110
views
Calculations from Timestamp based on Checkbox Iterative now() in Google Sheets
I don't want to use Google Apps Scripts, just formulas so that this can be display/edited on a mobile device while offline.
[
- 25
-1
votes
1
answer
102
views
ParseExact Exception [closed]
I have power shell code which extracts a date from a different source and converts it:
$dtStart = [DateTime]::ParseExact($StartDate.toString().Substring(0, 10).Trim(), 'M/d/yyyy', $null).ToString('dd/...
- 3,344
1
vote
1
answer
119
views
Polars parse multiple datetime format [duplicate]
I have string column in polars dataframe with multiple datetime formats and I am using following code to convert datatype of column from string into datetime.
import polars as pl
df = pl.from_dict({'...
- 3,135
2
votes
1
answer
138
views
Problem converting a column to datetime format
I have a data frame and I am trying to convert the time column into a datetime format. The first step I did was:
data['time'] = data.time
data['time']=pd.to_datetime(data['time'], format='%H:%M:%S.%f')...
- 11
2
votes
4
answers
230
views
Flag rows if the time in a column falls within a specified window of another column
I have a dataframe where each row represents a detection of a fish. The fish can be either, Brown Trout (Fish.ID starts with TB_) or Salmon/Parr (Fish.ID starts with TA_). I want to create a new ...
- 756