Skip to content

Instantly share code, notes, and snippets.

@immerrr
Last active August 29, 2015 13:56
Show Gist options
  • Save immerrr/9183742 to your computer and use it in GitHub Desktop.
Save immerrr/9183742 to your computer and use it in GitHub Desktop.
single-axis indexers benchmark (GH#6450)
$ time ./test_perf.sh -H -N3 -u2 -r indexing__
CPU affinity set to 1
*** LOG_FILE = /home/immerrr/sources/pandas/vb_suite.log
Performing 112 benchmarks (3 runs each)
................................................................................................................
***
Invoked with :
--ncalls: 3
--repeats: 3
-------------------------------------------------------------------------------
Test name | #0 | #1 | #2 |
-------------------------------------------------------------------------------
indexing__panel_slice_label_100000sx10sx10s_ax0| 7.7140 | 7.8789 | 7.7656 |
indexing__panel_slice_label_10sx10sx100000s_ax0| 0.1403 | 0.1396 | 0.1430 |
indexing__panel_slice_label_100000sx10sx10s_ax2| 0.1490 | 0.1340 | 0.1343 |
indexing__dataframe_basic_label_100000sx10s | 0.1187 | 0.1297 | 0.1287 |
indexing__dataframe_slice_pos_10sx100000s_ax1| 7.5714 | 8.5313 | 8.3021 |
indexing__dataframe_slice_pos_10sx100000s_ax0| 0.1094 | 0.1130 | 0.1056 |
indexing__panel_arr_pos_100000sx10sx10s | 57.2523 | 57.9356 | 56.6757 |
indexing__dataframe_arr_pos_100000sx10s_ax0 | 26.2963 | 26.3710 | 26.2847 |
indexing__panel_slice_label_10sx10sx100000s_ax2| 0.5550 | 0.5827 | 0.5567 |
indexing__panel_arr_pos_10sx10sx100000s_ax0 | 29.4696 | 29.4446 | 29.4326 |
indexing__panel_loc_mask_100000sx10sx10s_ax0 | 22.6897 | 22.7407 | 22.7520 |
indexing__panel_iloc_mask_10sx10sx100000s_ax2| 29.7560 | 29.7710 | 29.8026 |
indexing__series_loc_mask_100000s_ax0 | 1.9547 | 1.9580 | 1.9467 |
indexing__panel_arr_label_10sx10sx100000s_ax0| 29.3990 | 29.4284 | 29.4090 |
indexing__dataframe_loc_mask_100000sx10s_ax1 | 4.0874 | 4.0894 | 4.0683 |
indexing__panel_arr_label_100000sx10sx10s_ax0| 64.2046 | 64.5357 | 64.4360 |
indexing__panel_slice_pos_10sx10sx100000s_ax2| 0.5267 | 0.5484 | 0.5347 |
indexing__panel_basic_pos_10sx10sx100000s | 0.0873 | 0.0873 | 0.0870 |
indexing__dataframe_loc_mask_100000sx10s | 7.6167 | 7.5953 | 7.6300 |
indexing__panel_iloc_mask_10sx10sx100000s_ax0| 13.0223 | 13.0916 | 13.0507 |
indexing__dataframe_basic_pos_100000sx10s_ax1| 0.1347 | 0.1347 | 0.1350 |
indexing__panel_arr_pos_10sx10sx100000s | 29.2240 | 31.4653 | 29.4073 |
indexing__panel_slice_pos_10sx10sx100000s_ax0| 0.1183 | 0.1173 | 0.1177 |
indexing__panel_basic_label_10sx10sx100000s_ax2| 0.1317 | 0.1311 | 0.1317 |
indexing__panel_slice_pos_100000sx10sx10s_ax2| 0.1103 | 0.1103 | 0.1120 |
indexing__panel_slice_pos_100000sx10sx10s_ax0| 7.5883 | 7.7573 | 8.0760 |
indexing__series_arr_pos_100000s_ax0 | 21.0740 | 21.0910 | 21.2037 |
indexing__panel_basic_label_100000sx10sx10s_ax0| 0.0797 | 0.0797 | 0.0797 |
indexing__series_slice_pos_100000s_ax0 | 0.0490 | 0.0483 | 0.0506 |
indexing__dataframe_arr_label_10sx100000s | 6.9083 | 6.8860 | 7.3987 |
indexing__series_arr_label_100000s_ax0 | 10.2801 | 10.4396 | 10.8077 |
indexing__panel_slice_label_100000sx10sx10s | 10.2734 | 7.5657 | 7.4600 |
indexing__dataframe_basic_label_10sx100000s | 4.9620 | 4.9407 | 4.9467 |
indexing__dataframe_loc_mask_10sx100000s_ax0 | 5.2526 | 5.2617 | 5.2563 |
indexing__dataframe_loc_mask_10sx100000s_ax1 | 13.0200 | 12.9993 | 13.1710 |
indexing__dataframe_arr_pos_100000sx10s | 26.1463 | 26.3973 | 30.5960 |
indexing__dataframe_arr_pos_10sx100000s_ax0 | 8.7633 | 6.9840 | 6.9780 |
indexing__dataframe_slice_label_10sx100000s_ax0| 0.1274 | 0.1273 | 0.1273 |
indexing__panel_basic_pos_100000sx10sx10s_ax0| 0.1527 | 0.1530 | 0.1527 |
indexing__panel_iloc_mask_100000sx10sx10s | 22.4867 | 30.4390 | 22.4833 |
indexing__series_basic_pos_100000s | 0.0150 | 0.0153 | 0.0153 |
indexing__dataframe_basic_label_10sx100000s_ax1| 0.0494 | 0.0500 | 0.0496 |
indexing__dataframe_basic_label_10sx100000s_ax0| 4.8330 | 4.8203 | 5.3446 |
indexing__panel_arr_pos_100000sx10sx10s_ax0 | 76.7110 | 76.7879 | 77.5987 |
indexing__panel_slice_pos_10sx10sx100000s | 0.0799 | 0.0817 | 0.0796 |
indexing__panel_basic_pos_100000sx10sx10s | 0.0870 | 0.0863 | 0.0867 |
indexing__panel_basic_label_100000sx10sx10s_ax2| 0.1307 | 0.1313 | 0.1340 |
indexing__dataframe_arr_label_100000sx10s | 14.6177 | 14.6206 | 14.6003 |
indexing__dataframe_slice_label_100000sx10s | 0.4993 | 0.5030 | 0.5007 |
indexing__panel_arr_label_100000sx10sx10s | 65.2890 | 64.6147 | 65.0814 |
indexing__dataframe_loc_mask_10sx100000s | 5.4131 | 5.4057 | 5.4247 |
indexing__dataframe_slice_pos_100000sx10s | 0.4823 | 0.4860 | 0.4860 |
indexing__panel_loc_mask_10sx10sx100000s_ax0 | 32.5330 | 32.5270 | 32.5530 |
indexing__dataframe_arr_pos_100000sx10s_ax1 | 5.1804 | 5.1676 | 5.1727 |
indexing__panel_loc_mask_100000sx10sx10s_ax2 | 54.2943 | 54.1823 | 53.9749 |
indexing__dataframe_slice_label_100000sx10s_ax1| 0.1373 | 0.1343 | 0.1343 |
indexing__dataframe_iloc_mask_100000sx10s | 7.6346 | 7.6484 | 7.6240 |
indexing__series_iloc_mask_100000s | 2.0053 | 1.9606 | 1.9940 |
indexing__dataframe_basic_label_100000sx10s_ax0| 0.1536 | 0.1513 | 0.1500 |
indexing__dataframe_arr_label_100000sx10s_ax0| 30.6443 | 30.5957 | 30.6803 |
indexing__series_loc_mask_100000s | 1.9593 | 1.9714 | 1.9736 |
indexing__series_basic_pos_100000s_ax0 | 0.0150 | 0.0150 | 0.0153 |
indexing__dataframe_basic_pos_100000sx10s_ax0| 0.1296 | 0.1287 | 0.1327 |
indexing__panel_loc_mask_10sx10sx100000s_ax2 | 30.2610 | 29.9463 | 29.9257 |
indexing__dataframe_loc_mask_100000sx10s_ax0 | 7.6667 | 7.6747 | 7.6567 |
indexing__panel_iloc_mask_100000sx10sx10s_ax2| 53.8174 | 55.2166 | 53.8979 |
indexing__series_slice_label_100000s | 0.0580 | 0.0580 | 0.0583 |
indexing__panel_slice_pos_100000sx10sx10s | 7.4943 | 7.5796 | 7.5573 |
indexing__dataframe_basic_label_100000sx10s_ax1| 0.0510 | 0.0494 | 0.0494 |
indexing__series_iloc_mask_100000s_ax0 | 1.9494 | 1.9440 | 1.9693 |
indexing__series_basic_label_100000s | 0.0367 | 0.0370 | 0.0366 |
indexing__dataframe_slice_pos_100000sx10s_ax1| 0.1101 | 0.1120 | 0.1110 |
indexing__dataframe_slice_label_100000sx10s_ax0| 0.8610 | 0.6210 | 0.5441 |
indexing__panel_arr_pos_100000sx10sx10s_ax2 | 68.4417 | 68.5320 | 69.1873 |
indexing__dataframe_slice_pos_100000sx10s_ax0| 0.8066 | 0.6950 | 0.9690 |
indexing__dataframe_iloc_mask_100000sx10s_ax0| 7.6253 | 7.6680 | 7.6900 |
indexing__series_arr_label_100000s | 9.8517 | 9.9100 | 9.6963 |
indexing__dataframe_slice_pos_10sx100000s | 0.0767 | 0.0764 | 0.0790 |
indexing__dataframe_iloc_mask_100000sx10s_ax1| 4.0390 | 4.2849 | 4.1984 |
indexing__dataframe_arr_pos_10sx100000s | 6.9047 | 6.9314 | 6.9567 |
indexing__panel_loc_mask_10sx10sx100000s | 36.5367 | 32.7344 | 31.9943 |
indexing__dataframe_slice_label_10sx100000s_ax1| 7.7217 | 7.6663 | 7.7060 |
indexing__panel_basic_label_100000sx10sx10s | 0.0220 | 0.0220 | 0.0226 |
indexing__panel_arr_label_10sx10sx100000s_ax2| 93.0556 | 92.8943 | 93.0390 |
indexing__dataframe_basic_pos_100000sx10s | 0.0923 | 0.0920 | 0.0910 |
indexing__panel_arr_label_100000sx10sx10s_ax2| 68.9619 | 68.7583 | 68.8153 |
indexing__series_slice_label_100000s_ax0 | 0.0607 | 0.0590 | 0.0593 |
indexing__dataframe_arr_label_100000sx10s_ax1| 5.2617 | 5.2876 | 5.2933 |
indexing__panel_slice_label_10sx10sx100000s | 0.0913 | 0.0920 | 0.0916 |
indexing__series_arr_pos_100000s | 21.1020 | 21.1097 | 21.0819 |
indexing__panel_iloc_mask_100000sx10sx10s_ax0| 22.6670 | 22.6723 | 22.5783 |
indexing__panel_basic_label_10sx10sx100000s_ax0| 0.0786 | 0.0784 | 0.0790 |
indexing__panel_basic_pos_100000sx10sx10s_ax2| 5.8901 | 5.9070 | 5.8781 |
indexing__panel_basic_pos_10sx10sx100000s_ax2| 0.1353 | 0.1353 | 0.1337 |
indexing__dataframe_arr_pos_10sx100000s_ax1 | 45.9423 | 46.0456 | 46.1120 |
indexing__dataframe_iloc_mask_10sx100000s_ax0| 5.4197 | 5.2197 | 5.2373 |
indexing__dataframe_iloc_mask_10sx100000s_ax1| 13.0500 | 13.1574 | 15.3210 |
indexing__series_slice_pos_100000s | 0.0497 | 0.0533 | 0.0501 |
indexing__panel_basic_pos_10sx10sx100000s_ax0| 0.1504 | 0.1533 | 0.1493 |
indexing__series_basic_label_100000s_ax0 | 0.0364 | 0.0363 | 0.0377 |
indexing__dataframe_slice_label_10sx100000s | 0.0896 | 0.0887 | 0.0923 |
indexing__panel_arr_label_10sx10sx100000s | 46.0450 | 45.9430 | 46.0896 |
indexing__dataframe_arr_label_10sx100000s_ax0| 7.0183 | 7.4383 | 7.0176 |
indexing__dataframe_arr_label_10sx100000s_ax1| 39.5433 | 39.4850 | 39.4153 |
indexing__dataframe_basic_pos_10sx100000s_ax1| 0.1369 | 0.1353 | 0.1480 |
indexing__dataframe_basic_pos_10sx100000s_ax0| 0.9080 | 0.9096 | 0.9057 |
indexing__dataframe_iloc_mask_10sx100000s | 5.2633 | 5.1703 | 5.1743 |
indexing__panel_basic_label_10sx10sx100000s | 0.0217 | 0.0217 | 0.0217 |
indexing__panel_arr_pos_10sx10sx100000s_ax2 | 86.3903 | 86.9674 | 87.4317 |
indexing__dataframe_basic_pos_10sx100000s | 0.9730 | 0.8537 | 0.8653 |
indexing__panel_iloc_mask_10sx10sx100000s | 32.3830 | 32.3207 | 32.3517 |
indexing__panel_loc_mask_100000sx10sx10s | 22.8256 | 22.4550 | 22.5101 |
-------------------------------------------------------------------------------
Test name | #0 | #1 | #2 |
-------------------------------------------------------------------------------
Ratio < 1.0 means the target commit is faster then the baseline.
Seed used: 1234
Target [aef4af3] : BLD: don't contract stats output if it's longer than 60 rows
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment