FIX: clean up unit conversion unpacking of data, particularly for dates and pandas series by jklymak · Pull Request #11664 · matplotlib/matplotlib · GitHub

PR Summary

This does one small thing (run units conversion on the position argument of bxp/boxplot) and two big things:

At unit conversion, run np.asarray on incoming objects to unpack numpy arrays from them. Previously in order to get native pandas support we were unpacking the values field, but running
np.asarray does the same thing and allows the packed values to not necessarily be stored in values. i.e.

dates = np.arange('2005-02', '2005-05', dtype='datetime64[M]')
values = np.sin(np.array(range(len(dates))))
df = pd.DataFrame({'dates': dates, 'z': values})
print(df['dates'])
print(np.asarray(df['dates']))
print(df['dates'].values)

returns:

0   2005-02-01
1   2005-03-01
2   2005-04-01
Name: dates, dtype: datetime64[ns]
['2005-02-01T00:00:00.000000000' '2005-03-01T00:00:00.000000000'
 '2005-04-01T00:00:00.000000000']
['2005-02-01T00:00:00.000000000' '2005-03-01T00:00:00.000000000'
 '2005-04-01T00:00:00.000000000']

This re-does #10638, which unpacked pandas py checking for and using values.

For the pandas tests, this deregisters the pandas converters, because its not clear we should be testing those. With the above, our native date handling should be able to strip pandas series of their date information and convert. This passes all the pandas tests, but I admit this may be a controversial step.

Immediate fix code:

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt

pd.plotting.deregister_matplotlib_converters()

data = np.random.rand(5,2)
years = pd.date_range('1/1/2000',
                      periods=2, freq=pd.DateOffset(years=1)).year
# Does not work
plt.figure()
plt.boxplot(data, positions=years)
plt.show()

failed on master. This fixes...

PR Checklist

Has Pytest style unit tests
Code is PEP 8 compliant
New features are documented, with examples if plot related
Documentation is sphinx and numpydoc compliant
Added an entry to doc/users/next_whats_new/ if major new feature (follow instructions in README.rst there)
Documented in doc/api/api_changes.rst if API changed in a backward-incompatible way

BTW I've used this fix in #10638. Not sure this normalization shouldn't be in cbook somewhere: cbook._check_1d? EDIT: obsolete comment

Are there any better ways to check if something is a pandas Series?

In this case the following (admittedly very constructed) example would fail:

import numpy as np
import matplotlib.pyplot as plt

class Years(list):
    values = True

data = np.random.rand(5,2)

years = Years([1999,2003])

plt.figure()
plt.boxplot(data, positions=years)
plt.show()

Well, its a damned if you do, damned if you don't situation.

Other data types use the values convention as well (xarray for instance). The goal here was to unpack the pandas series w/o having to know what a pandas series is (there is no pandas import in the main library).

If someone tries to pass a class that has values meaning something else, then I guess they will have to unpack before they plot.

FWIW, my preference would be that we only support numpy arrays and basic python lists, and let users and/or downstream libraries do their own unpacking.

I don't like the idea at all that only because some object has a values attribute, matplotlib now thinks that it should use it (and not the actual data in the object, e.g. provided by some iterator).

Or, if you think this is what should always happen, it should actually always happen. As it stands, matplotlib would use the iterator for usual numbers, but the values attribute for dates (#10638) or in boxplots (this PR).

OK, agreed. Stand by for a more holistic solution - though potentially more controversial...

ping @jorisvandenbossche as this is a redo of a PR you helped with previously...

Maybe closes #5896

Rebased, this is still ready to go and waiting for review.

Looks okish, but I'm not deep enough into the numpy/pandas data formats to judge the implications.

Maybe just a very minor change and some explanation or additional comments.

I don't see any point in removing the "copy=False" kwarg. It saves time, and it is logically what is wanted here. A copy was already made via the column_stack call, so nothing done to coords will affect X or Y.

Not sure. Changed back

What is the rationale for returning a list as-is instead of running it through np.asarray? Just that the latter is unnecessary? Or are there cases where the conversion would be an error?

Why is this using issubclass(type(x)... instead of isinstance?

Is the point of this whole addition above to short-circuit some of what would otherwise happen in get_converter? I'm not opposed, just confused.

it seems worse, because calling np.asarray can drop information in some cases, making it unavailable in the call to convert below. Unless I'm missing something...

What case is this whole block covering? Again, I'm confused.

Another place I am confused. Is the comment obsolete?

This seems to be converting anything numlike, which includes things like pint.Quantity, into an array/masked array before calling convert. That seems like it would break pint, though I will note that our unit tests seem to be passing.

Great, I’ll check vs pint when I look at the other comments above. Thanks for the reminder...

Ok, I guess I still don't understand how all of this works. 😉 So is_numlike only returns true for things that are basic numbers (or contain them) and don't need converting. I think I'm ok with this code then. Tests passing is always a good thing too. 😄

OK, somewhat confused about everything I was thinking here, and some of the type checking has moved on since this was written. So I'm going to close. Note #13304 deregisters the pandas converters which I think was an important contribution here. Sorry for the reviewer effort on this...

jklymak added topic: date handling pandas integration labels Jul 15, 2018

jklymak changed the title FIX: let boxplot take pandas position FIX: let boxplot take pandas date as position Jul 15, 2018

jklymak force-pushed the fix-boxplot-pandas-position branch from 12b3b7f to 445047c Compare July 15, 2018 18:21

ImportanceOfBeingErnest reviewed Jul 15, 2018

View reviewed changes

jklymak added the status: work in progress label Jul 15, 2018

jklymak force-pushed the fix-boxplot-pandas-position branch from 445047c to fb7eb0b Compare July 15, 2018 20:55

jklymak added the topic: units and array ducktypes label Jul 15, 2018

jklymak force-pushed the fix-boxplot-pandas-position branch 6 times, most recently from b84c4b5 to 95e4e52 Compare July 16, 2018 03:26

jklymak changed the title FIX: let boxplot take pandas date as position FIX: clean up unit conversion unpacking of data, particularly for dates and pandas series Jul 16, 2018

jklymak force-pushed the fix-boxplot-pandas-position branch 4 times, most recently from d87ac91 to db394cb Compare July 16, 2018 12:46

jklymak removed the status: work in progress label Jul 16, 2018

tacaswell added this to the v3.1 milestone Jul 17, 2018

jklymak mentioned this pull request Jul 24, 2018

Use data argument for scatter plotting timestamps from pandas #11391

Closed

jklymak added 3 commits November 29, 2018 19:34

FIX: let boxplot take pandas position

efe7d7a

TST: add smoketest

4640237

Fix datetime mess

b16c311

jklymak force-pushed the fix-boxplot-pandas-position branch from db394cb to b16c311 Compare November 30, 2018 03:37

jklymak added the status: needs review label Jan 11, 2019

jklymak mentioned this pull request Jan 16, 2019

FIX: bar mixed units, allow ValueError as well #13187

Merged

6 tasks

efiring requested changes Jan 19, 2019

View reviewed changes

tacaswell requested a review from dopplershift January 19, 2019 17:40

dopplershift reviewed Jan 24, 2019

View reviewed changes

jklymak removed the status: needs review label Jan 28, 2019

jklymak closed this Jan 28, 2019

jklymak deleted the fix-boxplot-pandas-position branch January 28, 2019 00:57

jklymak mentioned this pull request Feb 27, 2019

Simplify units.Registry.get_converter. #9314

Merged

6 tasks

                                            "values must have same the length")
                       # check position
+                      if hasattr(positions, 'values'):
+                          positions = positions.values

                       # convert to one dimensional arrays
                       C = C.ravel()
-                      coords = np.column_stack((X, Y)).astype(float, copy=False)
+                      coords = np.column_stack((X, Y)).astype(float)

+                      # some iterables need to be massaged a bit...
                       if munits.ConversionInterface.is_numlike(x):
-                          return x
+                          if isinstance(x, list) or isinstance(x, numbers.Number):

-                          return x
+                          if isinstance(x, list) or isinstance(x, numbers.Number):
+                              return x
+                          if issubclass(type(x), np.ma.MaskedArray):

+                              return x
+                          if issubclass(type(x), np.ma.MaskedArray):
+                              return np.ma.asarray(x)
+                          return np.asarray(x)

+                          if ((isinstance(d, np.ndarray) and
+                                  np.issubdtype(d.dtype, np.datetime64)) or
+                                  isinstance(d, np.datetime64)):
+                              return _dt64_to_ordinalf(d)

		@@ -1477,9 +1479,14 @@ def have_units(self):
		return self.converter is not None or self.units is not None

		def convert_units(self, x):

FIX: clean up unit conversion unpacking of data, particularly for dates and pandas series by jklymak · Pull Request #11664 · matplotlib/matplotlib · GitHub

Repository navigation

FIX: clean up unit conversion unpacking of data, particularly for dates and pandas series - #11664

FIX: clean up unit conversion unpacking of data, particularly for dates and pandas series#11664jklymak wants to merge 3 commits intomatplotlib:mastermatplotlib/matplotlib:masterfrom jklymak:fix-boxplot-pandas-positionjklymak/matplotlib:fix-boxplot-pandas-positionCopy head branch name to clipboard

Conversation

jklymak commented Jul 15, 2018 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

PR Summary

Immediate fix code:

PR Checklist

Uh oh!

jklymak commented Jul 15, 2018 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

ImportanceOfBeingErnest Jul 15, 2018 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

jklymak commented Jul 16, 2018

Uh oh!

jklymak commented Jul 24, 2018

Uh oh!

jklymak commented Nov 30, 2018

Uh oh!

timhoffm commented Dec 4, 2018

Uh oh!

efiring left a comment

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

jklymak commented Jan 28, 2019

Uh oh!

Reviewers

Uh oh!

Assignees

Labels

Projects

Milestone

Development

Uh oh!

6 participants

FIX: clean up unit conversion unpacking of data, particularly for dates and pandas series#11664
jklymak wants to merge 3 commits into
matplotlib:masterfrom
jklymak:fix-boxplot-pandas-position

jklymak commented Jul 15, 2018 •
edited
Loading

jklymak commented Jul 15, 2018 •
edited
Loading

ImportanceOfBeingErnest Jul 15, 2018 •
edited
Loading