pandas pd.DataFrame.diff(axis=1) NotImplementationError

Question

I have a dataframe that generates from pd.pivot_table with columns having datetime.

I want to calculate the time difference along columns. So I used df.diff(axis=1). I got NotImplementedError.

I came across this pull request in Github: https://github.com/pandas-dev/pandas/pull/19773

I guess the problem has been solved? Why I still get NonImplementedError?

Data Sample: Please ignore the "Text". Typo.

What version of pandas are you running? Maybe just need to upgrade? — Chris Adams
– Chris Adams, Commented Mar 9, 2020 at 7:57
Hmmm, I'm using the same. Working for me with datetime types. What about versions for numpy and python-dateutil ? — Chris Adams
– Chris Adams, Commented Mar 9, 2020 at 8:03
@ChrisA I got it works by removing the timezone: data['date'] = data['date'].dt.tz_convert(None) — JOHN
– JOHN, Commented Mar 9, 2020 at 8:22

JOHN · Accepted Answer · 2020-03-09 08:31:01Z

2

I tried to remove the timezone in datetime64[ns, UTC] columns. It works!

data['date'] = data['date'].dt.tz_convert(None)

answered Mar 9, 2020 at 8:31

JOHN

1,5215 gold badges26 silver badges45 bronze badges

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

1 Comment

K.-Michael Aye Over a year ago

gosh, i appreciate the ability to work with timezones, but they really screw up all the formatting. i wish the default would have stayed at not having them. suddenly, CSV readings produce different outputs... :(

Collectives™ on Stack Overflow

pandas pd.DataFrame.diff(axis=1) NotImplementationError

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related