AttributeError: 'Timestamp' object has no attribute 'timestamp'

Question

I am struggling to get my code running. There seems to be a problem with the timestamp. Do you have any suggestions to how I could change my code? I saw that this had been asked before, but did not manage to make it work.

This is the error I get when running the code: 'Timestamp' object has no attribute 'timestamp'

My code:

import quandl, math, datetime

last_date = df.iloc[-1].name
last_unix = last_date.timestamp()
one_day = 86400 #Seconds in a day
next_unix = last_unix + one_day


for i in forecast_set: 
    next_date = datetime.datetime.fromtimestamp(next_unix)
    next_unix += one_day
    df.loc[next_date]=[np.nan for _ in range(len(df.columns)-1)]+[i]
    #Loop to replace all numbers on x axis with dates

"saw that this had been asked before" - where? "but did not manage to make it work" - be more specific. — jonrsharpe
– jonrsharpe, Commented Nov 7, 2016 at 19:58
I agree with jonrsharpe, and please clean your code so it is an (else) working example. Is df a pandas data frame? Then you might add pandas as a tag. Where does it fail? - I guess in last_date.timestamp()? Then the rest of the code would not be relevant here. — Dr. V
– Dr. V, Commented Nov 7, 2016 at 20:07
You might have a look at github.com/pandas-dev/pandas/issues/17329 — Femto Trader
– Femto Trader, Commented Aug 24, 2017 at 19:55

Mikebarson · Accepted Answer · 2017-03-06 08:04:22Z

6

You can try this:

import time
.....
last_unix = time.mktime(last_date.timetuple())

That worked for me!

answered Mar 6, 2017 at 8:04

Mikebarson

6129 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Mr. Concolato Over a year ago

Nice! This is the correct answer. @Mikebarson Do you know why?

Mikebarson Over a year ago

@Mr.Concolato Hi! It's been a while since I've posted this answer. And I'm so sorry, but right now I've forgotten why this worked. If you can help me remember that would be great!

Mr. Concolato Over a year ago

Not completely sure, but I think it has something to do with the version (2.7 vs. 3.0) of python you are running. The above answer worked for me in 2.7.

Mikebarson Over a year ago

@Mr.Concolato I see. I'll check this out soon and hopefully give a more detailed explanation as to why it worked.

Jean-Pierre Schnyder Over a year ago

It was the correct way to obtain the timestamp in the qpython interpreter running on an Android smartphone. Currently, the qpython environment executes python 3.2, which causes this kind of headache !

derasd · Accepted Answer · 2017-05-12 08:03:29Z

2

I had the same problem but with Python 3.4 and I used the following solution.

last_unix = (last_date - datetime.datetime(1970,1,1)).total_seconds()

answered May 12, 2017 at 8:03

derasd

5312 bronze badges

Comments

mksm · Accepted Answer · 2017-09-01 14:07:32Z

1

I've had the same problem. I've needed to provide an access to timestamp in both: python2 and python3 environments (timestamps wasn't the main purpose of my module).

After several attempts to provide compatibility, I have installed arrow package. It is already tested, pypi-published, and it works on many version of Python.

Install

Install from PyPI

pip install arrow

Or add to dependencies

Use in code

import arrow
import quandl, math, datetime

last_date = df.iloc[-1].name
# use arrow
last_unix = arrow.get(last_date).timestamp
one_day = 86400 #Seconds in a day
next_unix = last_unix + one_day

# ... your code ...

Also, there are a lot of nifty and useful features (for example - no more tortures with time zones).

edited Sep 1, 2017 at 14:07

answered Sep 1, 2017 at 13:55

mksm

4,6275 gold badges41 silver badges58 bronze badges

Collectives™ on Stack Overflow

AttributeError: 'Timestamp' object has no attribute 'timestamp'

3 Answers 3

5 Comments

Comments

Install

Use in code

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Install

Use in code

Comments

Your Answer

Sign up or log in

Post as a guest

Related