Skip to content

Instantly share code, notes, and snippets.

@blbradley
Created February 17, 2015 16:38
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save blbradley/3b0706bb2efe908c7026 to your computer and use it in GitHub Desktop.
Save blbradley/3b0706bb2efe908c7026 to your computer and use it in GitHub Desktop.
vbench results for pandas #9504
Invoked with :
--ncalls: 5
--repeats: 5
-------------------------------------------------------------------------------
Test name | head[ms] | base[ms] | ratio |
-------------------------------------------------------------------------------
period_setitem | 8.4562 | 9.3834 | 0.9012 |
timeseries_iter_periodindex | 682.7468 | 740.5236 | 0.9220 |
timeseries_asof_single | 0.0148 | 0.0158 | 0.9366 |
timeseries_custom_bday_apply_dt64 | 0.0114 | 0.0122 | 0.9373 |
timeseries_iter_periodindex_preexit | 7.0274 | 7.4426 | 0.9442 |
timeseries_large_lookup_value | 0.0124 | 0.0130 | 0.9524 |
timeseries_custom_bday_cal_decr | 0.0180 | 0.0188 | 0.9594 |
timeseries_custom_bday_cal_incr | 0.0150 | 0.0156 | 0.9633 |
timeseries_custom_bday_apply | 0.0100 | 0.0104 | 0.9633 |
timeseries_day_incr | 0.0218 | 0.0226 | 0.9641 |
timeseries_custom_bday_incr | 0.0106 | 0.0110 | 0.9652 |
timeseries_year_incr | 0.0114 | 0.0118 | 0.9676 |
timeseries_custom_bday_cal_incr_neg_n | 0.0182 | 0.0188 | 0.9695 |
datetimeindex_unique | 0.0620 | 0.0638 | 0.9716 |
timeseries_to_datetime_iso8601 | 2.7496 | 2.8266 | 0.9728 |
timeseries_custom_bmonthbegin_incr_n | 0.1640 | 0.1686 | 0.9728 |
groupby_first_datetimes | 7.3250 | 7.5238 | 0.9736 |
timeseries_custom_bday_decr | 0.0176 | 0.0180 | 0.9788 |
reshape_pivot_time_series | 127.0782 | 129.4888 | 0.9814 |
timeseries_slice_minutely | 0.0314 | 0.0320 | 0.9821 |
timeseries_year_apply | 0.0108 | 0.0110 | 0.9827 |
datetime_index_union | 0.0686 | 0.0698 | 0.9829 |
timeseries_custom_bmonthbegin_decr_n | 0.1760 | 0.1786 | 0.9853 |
multiindex_with_datetime_level_full | 15.3946 | 15.6226 | 0.9854 |
timeseries_custom_bday_cal_incr_n | 0.0152 | 0.0154 | 0.9876 |
datetimeindex_add_offset | 0.1968 | 0.1992 | 0.9880 |
timeseries_custom_bmonthend_decr_n | 0.1984 | 0.2004 | 0.9900 |
dtype_infer_timedelta64_1 | 84.0210 | 84.8098 | 0.9907 |
timeseries_day_apply | 0.0212 | 0.0214 | 0.9911 |
frame_assign_timeseries_index | 0.5284 | 0.5322 | 0.9928 |
query_datetime_index | 15.5584 | 15.6688 | 0.9930 |
timedelta_convert_int | 0.1110 | 0.1118 | 0.9932 |
read_csv_infer_datetime_format_iso8601 | 1.2840 | 1.2926 | 0.9933 |
timeseries_custom_bmonthend_incr | 0.1302 | 0.1310 | 0.9934 |
index_datetime_union | 7.9016 | 7.9502 | 0.9939 |
timeseries_timestamp_downsample_mean | 2.7396 | 2.7564 | 0.9939 |
dtype_infer_datetime64 | 9.4976 | 9.5520 | 0.9943 |
timeseries_1min_5min_mean | 0.5698 | 0.5726 | 0.9952 |
datetime_index_intersection | 0.2504 | 0.2516 | 0.9953 |
timeseries_asof_nan | 2.0502 | 2.0598 | 0.9953 |
dtype_infer_timedelta64_2 | 10.8998 | 10.9498 | 0.9954 |
groupby_dt_timegrouper_size | 21.5516 | 21.6484 | 0.9955 |
timeseries_iter_datetimeindex_preexit | 8.2370 | 8.2668 | 0.9964 |
timeseries_1min_5min_ohlc | 0.6468 | 0.6488 | 0.9969 |
sql_datetime_read_and_parse_sqlalchemy | 10.2718 | 10.3022 | 0.9970 |
timeseries_period_downsample_mean | 8.5498 | 8.5654 | 0.9982 |
index_datetime_intersection | 7.9452 | 7.9590 | 0.9983 |
query_datetime_series | 18.0702 | 18.0982 | 0.9985 |
datetimeindex_normalize | 1.4866 | 1.4882 | 0.9989 |
timeseries_is_month_start | 1.8710 | 1.8720 | 0.9995 |
read_csv_infer_datetime_format_ymd | 1.3918 | 1.3924 | 0.9996 |
timeseries_infer_freq | 4.9596 | 4.9602 | 0.9999 |
timeseries_asof | 2.1274 | 2.1262 | 1.0006 |
datetimeindex_infer_dst | 1.4724 | 1.4712 | 1.0008 |
timeseries_iter_datetimeindex | 439.9330 | 439.4776 | 1.0010 |
multiindex_with_datetime_level_sliced | 0.1300 | 0.1298 | 1.0018 |
sql_datetime_read_as_native_sqlalchemy | 13.8738 | 13.8460 | 1.0020 |
timestamp_ops_diff2 | 22.6228 | 22.5746 | 1.0021 |
series_timestamp_compare | 8.7588 | 8.7362 | 1.0026 |
groupby_nth_datetimes_any | 649.3084 | 647.3948 | 1.0030 |
read_csv_infer_datetime_format_custom | 6.6826 | 6.6460 | 1.0055 |
timeseries_custom_bmonthend_incr_n | 0.1684 | 0.1674 | 1.0057 |
sql_datetime_write_sqlalchemy | 86.5980 | 86.0946 | 1.0058 |
timestamp_series_compare | 8.7896 | 8.7322 | 1.0066 |
timedelta_convert_string | 69.9156 | 69.4274 | 1.0070 |
timeseries_sort_index | 6.9350 | 6.8774 | 1.0084 |
groupby_nth_datetimes_none | 306.2858 | 303.6200 | 1.0088 |
timeseries_add_irregular | 10.0248 | 9.9352 | 1.0090 |
timedelta_convert_string_seconds | 77.7814 | 77.0698 | 1.0092 |
timestamp_ops_diff1 | 17.9756 | 17.7392 | 1.0133 |
timeseries_to_datetime_YYYYMMDD | 4.6510 | 4.5838 | 1.0147 |
timeseries_with_format_replace | 630.9962 | 619.0314 | 1.0193 |
timeseries_with_format_no_exact | 469.7476 | 446.6018 | 1.0518 |
groupby_last_datetimes | 7.9134 | 7.5024 | 1.0548 |
-------------------------------------------------------------------------------
Test name | head[ms] | base[ms] | ratio |
-------------------------------------------------------------------------------
Ratio < 1.0 means the target commit is faster then the baseline.
Seed used: 1234
Target [d2e827a] : cythonize bulk Period properties
Base [25cb65a] : Merge pull request #9440 from blbradley/period-refactor-to-cython
PERF: Move Period class and related functions to Cython module
Invoked with :
--ncalls: 5
--repeats: 5
-------------------------------------------------------------------------------
Test name | head[ms] | base[ms] | ratio |
-------------------------------------------------------------------------------
timeseries_iter_periodindex_preexit | 6.6816 | 7.2924 | 0.9162 |
period_setitem | 8.4562 | 9.1728 | 0.9219 |
timeseries_iter_periodindex | 658.8400 | 714.6238 | 0.9219 |
timeseries_year_incr | 0.0114 | 0.0120 | 0.9484 |
timeseries_year_apply | 0.0108 | 0.0114 | 0.9498 |
timeseries_asof_single | 0.0148 | 0.0156 | 0.9511 |
datetime_index_union | 0.0674 | 0.0702 | 0.9606 |
timeseries_slice_minutely | 0.0304 | 0.0316 | 0.9623 |
timeseries_timestamp_downsample_mean | 2.7446 | 2.8492 | 0.9633 |
timeseries_day_apply | 0.0204 | 0.0212 | 0.9640 |
timeseries_custom_bday_incr | 0.0108 | 0.0112 | 0.9660 |
timeseries_large_lookup_value | 0.0122 | 0.0126 | 0.9697 |
timeseries_custom_bday_cal_incr | 0.0154 | 0.0158 | 0.9729 |
timeseries_to_datetime_iso8601 | 2.7518 | 2.8234 | 0.9746 |
timeseries_custom_bmonthbegin_incr_n | 0.1664 | 0.1698 | 0.9798 |
timeseries_custom_bday_apply_dt64 | 0.0118 | 0.0120 | 0.9802 |
groupby_nth_datetimes_any | 651.9256 | 664.8974 | 0.9805 |
timeseries_custom_bmonthbegin_decr_n | 0.1762 | 0.1796 | 0.9811 |
datetimeindex_normalize | 1.4808 | 1.5072 | 0.9825 |
timeseries_1min_5min_ohlc | 0.6440 | 0.6538 | 0.9850 |
timeseries_1min_5min_mean | 0.5698 | 0.5784 | 0.9852 |
groupby_nth_datetimes_none | 305.9728 | 310.4824 | 0.9855 |
datetime_index_intersection | 0.2502 | 0.2538 | 0.9857 |
datetimeindex_add_offset | 0.1958 | 0.1986 | 0.9858 |
timeseries_period_downsample_mean | 8.5200 | 8.6380 | 0.9863 |
query_datetime_series | 17.8532 | 18.0800 | 0.9875 |
timeseries_custom_bmonthend_decr_n | 0.1986 | 0.2008 | 0.9891 |
timeseries_custom_bmonthend_incr_n | 0.1684 | 0.1702 | 0.9894 |
timeseries_custom_bday_decr | 0.0178 | 0.0180 | 0.9894 |
read_csv_infer_datetime_format_iso8601 | 1.2858 | 1.2994 | 0.9895 |
timeseries_custom_bday_cal_incr_neg_n | 0.0182 | 0.0184 | 0.9896 |
multiindex_with_datetime_level_sliced | 0.1300 | 0.1312 | 0.9906 |
sql_datetime_read_and_parse_sqlalchemy | 10.1960 | 10.2912 | 0.9908 |
timedelta_convert_string | 69.3420 | 69.9812 | 0.9909 |
datetimeindex_unique | 0.0624 | 0.0630 | 0.9909 |
sql_datetime_write_sqlalchemy | 85.4170 | 86.1772 | 0.9912 |
timeseries_day_incr | 0.0216 | 0.0218 | 0.9912 |
frame_assign_timeseries_index | 0.5244 | 0.5286 | 0.9921 |
groupby_first_datetimes | 7.2768 | 7.3340 | 0.9922 |
datetimeindex_infer_dst | 1.4752 | 1.4868 | 0.9922 |
timedelta_convert_string_seconds | 77.6448 | 78.2356 | 0.9924 |
index_datetime_union | 7.8908 | 7.9462 | 0.9930 |
timeseries_iter_datetimeindex | 439.7848 | 441.4836 | 0.9962 |
timeseries_add_irregular | 9.9534 | 9.9898 | 0.9964 |
timeseries_iter_datetimeindex_preexit | 8.2416 | 8.2660 | 0.9971 |
timestamp_series_compare | 8.7218 | 8.7458 | 0.9973 |
query_datetime_index | 15.6094 | 15.6482 | 0.9975 |
timeseries_is_month_start | 1.8682 | 1.8728 | 0.9976 |
timedelta_convert_int | 0.1120 | 0.1122 | 0.9979 |
timeseries_custom_bmonthend_incr | 0.1322 | 0.1324 | 0.9982 |
timeseries_sort_index | 6.8058 | 6.8172 | 0.9983 |
timeseries_asof_nan | 2.0600 | 2.0620 | 0.9990 |
series_timestamp_compare | 8.7288 | 8.7362 | 0.9992 |
timestamp_ops_diff2 | 22.6056 | 22.6180 | 0.9995 |
timeseries_custom_bday_cal_decr | 0.0186 | 0.0186 | 1.0000 |
timeseries_custom_bday_apply | 0.0104 | 0.0104 | 1.0000 |
index_datetime_intersection | 7.9042 | 7.9010 | 1.0004 |
timeseries_infer_freq | 4.9558 | 4.9508 | 1.0010 |
groupby_dt_timegrouper_size | 21.5596 | 21.5324 | 1.0013 |
dtype_infer_datetime64 | 9.5080 | 9.4894 | 1.0020 |
read_csv_infer_datetime_format_ymd | 1.3986 | 1.3958 | 1.0020 |
sql_datetime_read_as_native_sqlalchemy | 13.8834 | 13.8528 | 1.0022 |
dtype_infer_timedelta64_1 | 84.9604 | 84.7612 | 1.0023 |
multiindex_with_datetime_level_full | 15.4574 | 15.4068 | 1.0033 |
reshape_pivot_time_series | 128.3480 | 127.6684 | 1.0053 |
timeseries_asof | 2.1512 | 2.1334 | 1.0083 |
dtype_infer_timedelta64_2 | 10.9962 | 10.8904 | 1.0097 |
timestamp_ops_diff1 | 17.9408 | 17.7266 | 1.0121 |
timeseries_custom_bday_cal_incr_n | 0.0156 | 0.0154 | 1.0124 |
timeseries_to_datetime_YYYYMMDD | 4.6516 | 4.5828 | 1.0150 |
groupby_last_datetimes | 7.8658 | 7.5730 | 1.0387 |
read_csv_infer_datetime_format_custom | 7.0676 | 6.6892 | 1.0566 |
timeseries_with_format_replace | 693.1346 | 623.1264 | 1.1123 |
timeseries_with_format_no_exact | 501.8010 | 448.7138 | 1.1183 |
-------------------------------------------------------------------------------
Test name | head[ms] | base[ms] | ratio |
-------------------------------------------------------------------------------
Ratio < 1.0 means the target commit is faster then the baseline.
Seed used: 1234
Target [d2e827a] : cythonize bulk Period properties
Base [25cb65a] : Merge pull request #9440 from blbradley/period-refactor-to-cython
PERF: Move Period class and related functions to Cython module
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment