Category "datetime"

ForeignKey error in ormar has no attribute 'get_column_alias'

I'm testing out ormar to avoid having to create models for both api and database and ran into an issue with foreignkey assignment I can't seem to figure out. Th

Plotly chart is a mess of lines after index converted to pandas datetime

My plotly chart is just a mess of zig-zagging lines (see chart here). This only happens after I use df['Date'] = pd.to_datetime(df.index) to convert the index t

Datetime + String from a Pandas table into a new table. One line of code

I'm a beginner at python. I'm moving specific cells/scalars from one Dataframe to another. I'm trying to work out why my first block of code didn't work but my

JS how to add hours and minutes to scheduled date

I need to be able to let clients schedule a certain type of meeting for a future date, the meeting duration I get back from the database is in minutes. I need t

(Python) Convert float to datetime

I have a dataset like this: df = pd.DataFrame({'name': ['Amy', 'Chris', 'Sam'], 'date': [1.597104e+12, 1.600906e+12, np.nan]}) print(df) name date

How to calculate from a date to another date?

I am creating a workday calendar which calculates which date the workday ends. I have a code that sets daily worktime from e.g 8:00-16:00 (workDayStartStop). An

Getting the start of the day in a different timezone

I have a Date. It is in the local timezone. I want a new Date that is at the beginning of the dayin a different timezone. Here are some things I do not want: A

How can I get the difference between two month-year dates in streamlit?

Here's the thing, I'm building a streamlit app to get the cohorts data. Just like explained here: https://towardsdatascience.com/a-step-by-step-introduction-to-

Removing the time from datetime output (Python)

Remove the time from this code. Current Code: from datetime import datetime, timedelta date = datetime.today() - timedelta(days=1) print("Today's date:",

postgres time conversion hh:mm:ss.us to hh:mm

Using PostgreSQL database for my attendance application. I have a table with IN and out times (hh:mm:ss.us format). When I subtract the times (OUT -IN) to ca

Algorithm to find the most frequent words [closed]

I can't think of an algorithm for my code. Please help me out. We have two files. The first one has text (Text length is n-words). The second

List is printing datetime.datetime

I have a result list that contains something like [(datetime.datetime(2013, 1, 1, 0, 1, 14),), (datetime.datetime(2013, 1, 1, 1, 33, 50),)] How does one prin

Converting datetime only to time in pandas

I would like to ask a question regarding converting datetime only to time. I have values 'Date Created" that include Dates and Times in one column and I would l

Sliding Window Date Range for pandas

Pandas date_range function allows us to make Rolling Windows with a frequency. pd.date_range(start='2019-06-01', end='2019-07-01', freq='3D') # Output Datetim

datetime expected float, got string

I'm trying to make a pyautogui script that adds the users input to the current time using the datetime/timedelta module. I want the pyautogui part to use typewr

datetime expected float, got string

I'm trying to make a pyautogui script that adds the users input to the current time using the datetime/timedelta module. I want the pyautogui part to use typewr

Pandas resample by integration over time with non equidistant data

I have a DataFrame with a Datetimeindex with non equidistant timestamps. I want to get the mean for each hour. But by using resample.mean(), the time distance b

retrieve only months with at least 28 sample days - pandas dataframe

Hello to the people of the web, I have a dataframe containing 'DATE' (datetime) as index and TMAX as column with values: tmax dataframe What i'm trying to do is

ValueError: time data '02/03/2022' does not match format '%d/%m/%y '

How to return values only within a specific date range? I am new to python My code is: for report_date in REPORT_DATE_TYPES:

Python gives wrong result with .seconds attribute of timedelta data

>>>print(today - date, (today - date).seconds) [1] 63 days, 8:45:34.250649 31534 ↑ This is far away from the righ