DOC: update query/eval figures on performance comparison 
State: closed

Feature reviewed by Joris (https://github.com/jorisvandenbossche) during the EuroScipy 2022 Sprint. 
This feature updates the pandas.eval() performance graphs here: https://pandas.pydata.org/docs/user_guide/enhancingperf.html#technical-minutia-regarding-expression-evaluation and the performance of the query here https://pandas.pydata.org/docs/user_guide/indexing.html#performance-of-query. 

Labels:
name: Docs
name: Benchmark
description: Performance (ASV) benchmarks
name: Stale

Comments:
Hello @carla-alves-24! Thanks for opening this PR. We checked the lines you've touched for [PEP 8](https://www.python.org/dev/peps/pep-0008) issues, and found:

* In the file [`doc/scripts/eval_performance.py`](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py):

> [Line 13:1](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L13): [E302](https://duckduckgo.com/?q=pep8%20E302) expected 2 blank lines, found 1
> [Line 18:1](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L18): [E305](https://duckduckgo.com/?q=pep8%20E305) expected 2 blank lines after class or function definition, found 1
> [Line 20:1](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L20): [E302](https://duckduckgo.com/?q=pep8%20E302) expected 2 blank lines, found 1
> [Line 25:1](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L25): [E302](https://duckduckgo.com/?q=pep8%20E302) expected 2 blank lines, found 1
> [Line 35:28](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L35): [E228](https://duckduckgo.com/?q=pep8%20E228) missing whitespace around modulo operator
> [Line 44:1](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L44): [E302](https://duckduckgo.com/?q=pep8%20E302) expected 2 blank lines, found 1
> [Line 46:1](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L46): [W293](https://duckduckgo.com/?q=pep8%20W293) blank line contains whitespace
> [Line 67:1](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L67): [E305](https://duckduckgo.com/?q=pep8%20E305) expected 2 blank lines after class or function definition, found 1
> [Line 71:89](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L71): [E501](https://duckduckgo.com/?q=pep8%20E501) line too long (93 > 88 characters)
> [Line 79:1](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L79): [W293](https://duckduckgo.com/?q=pep8%20W293) blank line contains whitespace
> [Line 80:33](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L80): [E261](https://duckduckgo.com/?q=pep8%20E261) at least two spaces before inline comment
> [Line 81:1](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L81): [W293](https://duckduckgo.com/?q=pep8%20W293) blank line contains whitespace
> [Line 84:13](https://github.com/pandas-dev/pandas/blob/dc0181df1a2c5a687f762f32f53dc0c4ce099d28/doc/scripts/eval_performance.py#L84): [E128](https://duckduckgo.com/?q=pep8%20E128) continuation line under-indented for visual indent


Hi, could you please fix the linting failures? You can also run pre-commit locally
hmm some tests are failing (although not directly related to this PR): 
```
FAILED pandas/tests/plotting/test_hist_method.py::TestSeriesPlots::test_hist_kde
FAILED pandas/tests/plotting/test_series.py::TestSeriesPlots::test_boxplot_series
FAILED pandas/tests/plotting/test_datetimelike.py::TestTSPlot::test_uhf - Ass...
FAILED pandas/tests/plotting/test_datetimelike.py::TestTSPlot::test_format_date_axis
FAILED pandas/tests/plotting/frame/test_frame.py::TestDataFramePlots::test_errorbar_with_integer_column_names
FAILED pandas/tests/plotting/frame/test_frame.py::TestDataFramePlots::test_errorbar_scatter
```
any clue about how to fix it ? @phofl 
This is because of a matplotlib upgrade. Will be fixed if you merge main 
This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this.
I finished the work, I think you should verify to merge my commits. Thanks!
@carla-alves-24 my apologies for the slow responses. But thanks again for the contribution! 
Taking a final look right now
Did a local run of the script, looks all good! I basically got the same results (same conclusions). The line on the plot was a bit less noisy (I ensured to not have anything else running at the same time), so pushed the version of the figure that I obtained.
> @carla-alves-24 my apologies for the slow responses. But thanks again for the contribution! Taking a final look right now

@jorisvandenbossche thank you very much!
Thanks again!