Python Playground

I have a LocationHistory.json file that has location data stored. The data looks like this: { '… Read more Python: How To Change All Instances Of "timestamp" In .json File To A Date-time Object

I have a pandas DF with c. 160k dated observations over 10 years, and want to remove all those from… Read more Most Efficient Way To Remove Particular Dates (29 Feb) From Time Series

I have a pandas Series with a (tz-localized) DateTimeIndex with one value per day: tmpr Out[38]: 2… Read more Keep 24h For Each Day When Resampling `pandas` `series` (from Daily To Hourly)

I have the following: import psycopg2 from openpyxl import Workbook wb = Workbook() wb.active =0 ws… Read more Python Script Keeps Converting Dates To Utc

I have a date that is either in German for e.g, 2. Okt. 2009 and also perhaps as 2. Oct. 2009 How… Read more Handling International Dates In Python

I am using a combination of Python and Amazon Redshift. I have hits from various users and some dat… Read more How To Get The Local Timezone Given Time And State Info

I'm trying to make a plot where the x-axis is time and the y-axis is a bar chart that will have… Read more Floating Bar Chart

I have two datetime objects having same day, month and year, say: test_date = datetime.datetime(201… Read more Comparing Datetime Objects By Date Only

current_datetime = datetime.now(tz) next_hour = datetime(current_datetime.year, current_datetime.mo… Read more How Do I Find The Next 7am In A Timezone

How can I convert: u'2012-11-07T13:25:10.703Z' to Python datetime? EDIT I intend to use som… Read more How To Convert The Following String To Python Date?

I would like to have a list of date every year from an end date spaced in given month amount. For e… Read more Moving Backwards In Time Until Specific Dates With A Given Frequency (month) In Python

Ive got a dataframe with strange hourly timestamps. It has both 00:00:00 and 24:00:00. It is as fol… Read more Changing All Time Stamps With Yyyy-mm-dd 24-mm-ss To Yyyy-mm-dd+1 00-mm-ss

I need to subtract all elements in one column of pandas dataframe by its first value. In this code,… Read more Subtract A Column In Pandas Dataframe By Its First Value

I have a script that loads a CSV into a pandas dataframe, cleanses the resulting table (eg removes … Read more How Can I Export To Sqlite (or Another Format) And Retain The Date Datatype?

I'm trying to perform the following query in Sqlalchemy. Select * from 'Mytable' where … Read more Make Sqlalchemy Use Date In Filter Using Postgresql

In Python 2.7.2 I am getting the seconds since epoch using: sec_since_epoch = (date_obj - datetime(… Read more Round Timestamp To Nearest Day In Python

My data looks like this : 900324492 900405679 900472531 1 2017-04-03 08:04:09 2017-04-03… Read more Python: Plot Dataframe Of Datetime Entries

I have a datetime list and would like to convert it into a date using the following code: dates = (… Read more Convert Datetime List Into Date Python

I need to find the difference between two dates in terms of days by getting date as a user input. I… Read more How To Find Difference Between Two Dates In Terms Of Day By Getting Date As User Input

I am using the following code to use the date in a specific format and running into following error… Read more Attributeerror: 'str' Object Has No Attribute 'strftime'