Category "datetime"

Keep getting "ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()."

data_df.loc[data_df['hotelID'] == sqlIDs[neededId] & to_integer(df.iloc[row, 6]) >= to_integer(MostRecent)] This is the snippet that keeps getting me th

Finding datetime object in pandas df column

I have the following code, where I want to determine if a datetime object exists in a data frame. Here is the code: df_grid['Date'] = pd.to_datetime(df_grid['Da

Datetime parse and format in C++

I'm using time_point the first time. I want to parse datetime from string and found a difference when returning back to string from 1 hour. std::chrono::system_

ParquetSharp's UTC adjustment

I am trying to use the ParquetSharp library (https://github.com/G-Research/ParquetSharp) to write some Parquet files from an SQL server database. As the origina

SQLite-net-pcl Comparing Dates

As stated in the question I am attempting to do a date comparison for tasks that are done within a specific date range. My model has a boolean called "Done" and

Pandas rolling average of a columns of dates

I'm trying to calculate the rolling average of a column of datetime objects. In my scenario, the input data are the last day below freezing each year for ~100 y

How to extract date out of string using date time

if for example I have a string like this import datetime as datetime string = "Hello todays date is 11/02/2022 thanks" How may I use datetime to extract just t

Recurring Event between date range in JavaScript

Basically, I need to create an Event, every event will be associated with the fields startDate and endDate. "name": "First Event", "teamName": "Team A",

Python: Order Dates that are in the format: %B %Y

I have a df with dates in the format %B %Y (e.g. June 2021, December 2022 etc.) Date Price Apr 2022 2 Dec 2021 8 I am trying to sort dates in order of oldest

How to set up only time in date-fns and still keep the timezone in javascript

I currently have the following use case: User receives a date in UTC from the backend This date is transformed into local time for displaying purposes The date

How to remove outliers from the list of timedelta objects? Python 3

I have a list of timedelta objects like timedelta(seconds=345) and I need a pythonic way to remove outliers from it. For instance I may have: timedelta_list = [

How to configure spring.data.convert.CustomConversion for MSSQL date

Recently I noticed that our spring-boot services are logging a warning from org.springframework.data.convert.CustomConversions. The message is this: Registerin

How do I convert a date/time string to a DateTime object in Dart?

Say I have a string "1974-03-20 00:00:00.000" It is created using DateTime.now(), how do I convert the string back to a DateTime object?

MariaDB converting datetime string to date

Trying CONVERT() Trying STR_TO_DATE() Trying CAST() - neither DATE or DATETIME work Trying CAST(STR_TO_DATE()) Hi, I cannot figure out what I'm doing wrong with

changing frequency in a pandas SeriesGroupBy

I'm struggling to find a simple way to change a frequency of a pd.Series that is grouped on some level of a pd.MultiIndex (so it's a pd.core.groupby.generic.Ser

Calculate difference between CET and UTC to handle daylight saving automatically

I am trying to handle daylight saving time (DST) in my code in more automatic way. I want to calculate if difference between current UTC and CET time is one hou

How to use the start function in ts in R when date and time are included?

I am exporting data from a CSV file that has two columns. One has time and the other has power. The time columns has the time in two different formats: mm-dd-yy

How to compare date and time in kotlin android?

I have an app on the PlayStore and I am building a feature where the user will not see ads more than a specific number in one day. I am thinking about comparing

Add hours from input , Datetime/Timedelta (Python)

I'm trying to make a script to go to a website and enter in a time in a 24 hour format. I'm using the pyautogui module to perform the web tasks, and Datetime/Ti

how to "transpose" datas from a date to another one in python

Sorry i had a lot of trouble explaining my problem in the title but i hope it will be more understandable with this example : i have a data source that tells me