I have the following DF I want to extract the month name and year in a simple way in the following format: I have used the df.Date.dt.to_period(“M”) which return “2018-01” format. Answer Cast you date from object to actual datetime and use dt to access what you need. Visual Format with…
Tag: datetime
How can I use datetime.strptime on a string in the format ‘0000-00-00T00:00:00+00:00’?
Due to my application’s circumstances, I would prefer to use datetime.strptime instead of dateutil.parser. After looking at the docs, I thought that %Y-%m-%dT%H:%M:%S%z may be the proper format for parsing a date string like this. Yet it still gives me an error. Example Answer The easiest way to deal wi…
Cleaning up data frame and date time
I am working with data frame. One of the columns contains date where the format of cell are mixed between date, time and string. The sample date frame is as follow: I want to create a new column that contains the text of date column. The expected output is as follows: How can I do that? Answer IIUC using to_d…
Finding day of the week for a datetime64
Apologies if this is an easy one but I can’t see anything in the numpy documentation. I have a datetime64 and I’d like to find out which day of the week it is. Unlike python datetime, datetime64 doesn’t seem to have a .weekday() function. However it does have a busday_offset() function, whic…
Delete rows with date’s before the required date point based on key value
I have a pd.dataframe that looks like this: So now based on the key_value, I want to drop all the rows that have their date column value before 2018-04-01 I want to have an end output like this: Answer You can just filter your dataframe using Boolean indexing. There is no groupwise operation here. Just rememb…
Convert date object in normal format
When I am using a Python object, I get: This is not the format I need. We need to convert to this data format: How can I convert this in Python/Django? Example: It’s working fine, but how can I pass 2018-05-18 10:05:06 as database but database giving? It’s giving 2018-05-18 08:38:58+00:00. How can I check dat…
Set the format for pd.to_datetime
Hi already referred to this post but I could not get through my issue. I have a column in my CSV which is string and the sample values are below (note that the month and year positioning are sometimes reversed). What format do I need to set in my to_datetime? I tried all the below approaches I get the error
python pandas merge multiple csv files
I have around 600 csv file datasets, all have the very same column names [‘DateTime’, ‘Actual’, ‘Consensus’, ‘Previous’, ‘Revised’], all economic indicators and all-time series data sets. the aim is to merge them all together in one csv file. With ‘DateTime’ as an index. The way I wanted this file to indexed …
How do I force Django queryset return datetime field in current timezone?
I have Django model: When I get created_at value by queryset, it always return to me the datetime value with tzinfo=<UTC> like this: How do I force queryset return datetime value in current timezone (e.g Asia/Ho_Chi_Minh)? Answer Django always saves datetimes in UTC, and they are usually returned in UTC…
Seconds until end of day in python
There’s another question here that asks how many seconds since midnight – this question is the opposite. How do I get the seconds until the end of the day, from the current time, using python? Answer The cleanest way I found to accomplish this is Taken from http://wontonst.blogspot.com/2017/08/tim…