PERF: `pandas` takes 8-9 seconds to import in a new environment

[pyrito]

Pandas version checks

• I have checked that this issue has not already been reported.

• I have confirmed this issue exists on the latest version of pandas.

• I have confirmed this issue exists on the main branch of pandas.

Reproducible Example

I did the following steps:

1. conda create --name py39-repro python=3.9
2. conda activate py39-repro
3. pip install ipython; pip install pandas
4. ipython

In [1]: %time import pandas
CPU times: user 277 ms, sys: 146 ms, total: 423 ms
Wall time: 8.67 s

Installed Versions

INSTALLED VERSIONS

commit : 965ceca
python : 3.9.16.final.0
python-bits : 64
OS : Darwin
OS-release : 21.3.0
Version : Darwin Kernel Version 21.3.0: Wed Jan 5 21:37:58 PST 2022; root:xnu-8019.80.24~20/RELEASE_ARM64_T6000
machine : x86_64
processor : i386
byteorder : little
LC_ALL : None
LANG : en_US.UTF-8
LOCALE : en_US.UTF-8

pandas : 2.0.2
numpy : 1.24.3
pytz : 2023.3
dateutil : 2.8.2
setuptools : 67.8.0
pip : 23.0.1
Cython : None
pytest : None
hypothesis : None
sphinx : None
blosc : None
feather : None
xlsxwriter : None
lxml.etree : None
html5lib : None
pymysql : None
psycopg2 : None
jinja2 : None
IPython : 8.13.2
pandas_datareader: None
bs4 : None
bottleneck : None
brotli : None
fastparquet : 2023.4.0
fsspec : 2023.5.0
gcsfs : None
matplotlib : None
numba : None
numexpr : None
odfpy : None
openpyxl : None
pandas_gbq : None
pyarrow : None
pyreadstat : None
pyxlsb : None
s3fs : None
scipy : None
snappy : None
sqlalchemy : None
tables : None
tabulate : None
xarray : None
xlrd : None
zstandard : None
tzdata : 2023.3
qtpy : None
pyqt5 : None

Prior Performance

No response

[lithomas1]

Can you paste output of python -X importtime -c "import pandas as pd"?

[pyrito]

@lithomas1 sure thing!

import time: self [us] | cumulative | imported package
import time:       473 |        473 |   _io
import time:        43 |         43 |   marshal
import time:       576 |        576 |   posix
import time:       827 |       1917 | _frozen_importlib_external
import time:       689 |        689 |   time
import time:       325 |       1014 | zipimport
import time:        60 |         60 |     _codecs
import time:       517 |        577 |   codecs
import time:       809 |        809 |   encodings.aliases
import time:      1070 |       2455 | encodings
import time:       293 |        293 | encodings.utf_8
import time:       109 |        109 | _signal
import time:       396 |        396 | encodings.latin_1
import time:        45 |         45 |     _abc
import time:       286 |        331 |   abc
import time:       320 |        650 | io
import time:        54 |         54 |       _stat
import time:       197 |        250 |     stat
import time:      1136 |       1136 |     _collections_abc
import time:       187 |        187 |       genericpath
import time:       255 |        441 |     posixpath
import time:       576 |       2402 |   os
import time:       200 |        200 |   _sitebuiltins
import time:        64 |         64 |     _locale
import time:       185 |        248 |   _bootlocale
import time:       593 |        593 |   _distutils_hack
import time:        81 |         81 |   sitecustomize
import time:        63 |         63 |   usercustomize
import time:      1260 |       4844 | site
import time:       375 |        375 |   __future__
import time:       266 |        266 |     warnings
import time:       332 |        332 |         types
import time:       789 |       1120 |       enum
import time:       327 |       1447 |     numpy._globals
import time:       137 |        137 |     numpy.__config__
import time:        86 |         86 |     numpy._distributor_init
import time:        57 |         57 |                   _sre
import time:       318 |        318 |                     sre_constants
import time:       831 |       1149 |                   sre_parse
import time:       315 |       1520 |                 sre_compile
import time:       907 |        907 |                       _heapq
import time:       197 |       1104 |                     heapq
import time:        99 |         99 |                     itertools
import time:       231 |        231 |                     keyword
import time:        60 |         60 |                       _operator
import time:       313 |        372 |                     operator
import time:       188 |        188 |                     reprlib
import time:        51 |         51 |                     _collections
import time:       727 |       2770 |                   collections
import time:        40 |         40 |                   _functools
import time:       814 |       3623 |                 functools
import time:       311 |        311 |                 copyreg
import time:       572 |       6024 |               re
import time:       960 |        960 |                 _json
import time:       528 |       1488 |               json.scanner
import time:       396 |       7907 |             json.decoder
import time:       538 |        538 |             json.encoder
import time:       211 |       8655 |           json
import time:        86 |       8741 |         numpy._version
import time:       184 |       8924 |       numpy.version
import time:       730 |        730 |               math
import time:       661 |        661 |               _datetime
import time:      1299 |       2689 |             datetime
import time:   5012430 |    5015119 |           numpy.core._multiarray_umath
import time:       364 |        364 |               numpy.compat._inspect
import time:       404 |        404 |                   fnmatch
import time:        86 |         86 |                     nt
import time:        63 |         63 |                     nt
import time:        57 |         57 |                     nt
import time:        57 |         57 |                     nt
import time:       578 |        840 |                   ntpath
import time:        56 |         56 |                   errno
import time:       303 |        303 |                     urllib
import time:      1155 |       1457 |                   urllib.parse
import time:      1275 |       4029 |                 pathlib
import time:        78 |         78 |                 pickle5
import time:       680 |        680 |                     _struct
import time:       297 |        976 |                   struct
import time:       440 |        440 |                   _compat_pickle
import time:      1041 |       1041 |                   _pickle
import time:        81 |         81 |                       org
import time:        16 |         96 |                     org.python
import time:        13 |        109 |                   org.python.core
import time:       925 |       3488 |                 pickle
import time:       224 |       7817 |               numpy.compat.py3k
import time:       413 |       8593 |             numpy.compat
import time:        18 |       8611 |           numpy.compat._inspect
import time:       278 |    5024007 |         numpy.core.overrides
import time:       529 |    5024535 |       numpy.core.multiarray
import time:       418 |        418 |       numpy.core.umath
import time:       577 |        577 |         numbers
import time:       268 |        268 |         numpy.core._string_helpers
import time:       196 |        196 |           numpy.core._dtype
import time:       604 |        800 |         numpy.core._type_aliases
import time:       514 |       2158 |       numpy.core.numerictypes
import time:       583 |        583 |               contextlib
import time:       287 |        287 |               numpy.core._exceptions
import time:       297 |        297 |                 collections.abc
import time:       700 |        700 |                   _contextvars
import time:       276 |        976 |                 contextvars
import time:       309 |       1581 |               numpy.core._ufunc_config
import time:       278 |       2728 |             numpy.core._methods
import time:       866 |       3594 |           numpy.core.fromnumeric
import time:       401 |       3994 |         numpy.core.shape_base
import time:       745 |        745 |         numpy.core.arrayprint
import time:       205 |        205 |         numpy.core._asarray
import time:       926 |       5868 |       numpy.core.numeric
import time:       998 |        998 |       numpy.core.defchararray
import time:       477 |        477 |       numpy.core.records
import time:       304 |        304 |       numpy.core.memmap
import time:       324 |        324 |       numpy.core.function_base
import time:       173 |        173 |       numpy.core._machar
import time:       268 |        268 |       numpy.core.getlimits
import time:       334 |        334 |       numpy.core.einsumfunc
import time:     36731 |      36731 |         numpy.core._multiarray_tests
import time:      1252 |      37983 |       numpy.core._add_newdocs
import time:       491 |        491 |       numpy.core._add_newdocs_scalars
import time:       172 |        172 |       numpy.core._dtype_ctypes
import time:       660 |        660 |           _ast
import time:      1044 |       1703 |         ast
import time:      2176 |       2176 |           _ctypes
import time:       469 |        469 |           ctypes._endian
import time:      1124 |       3768 |         ctypes
import time:       850 |       6320 |       numpy.core._internal
import time:       366 |        366 |       numpy._pytesttester
import time:       496 |    5090603 |     numpy.core
import time:       401 |        401 |       numpy.lib.mixins
import time:       319 |        319 |           numpy.lib.ufunclike
import time:      1090 |       1408 |         numpy.lib.type_check
import time:       627 |       2035 |       numpy.lib.scimath
import time:       394 |        394 |                   numpy.lib.stride_tricks
import time:       362 |        756 |                 numpy.lib.twodim_base
import time:     50178 |      50178 |                 numpy.linalg._umath_linalg
import time:       868 |      51802 |               numpy.linalg.linalg
import time:       234 |      52035 |             numpy.linalg
import time:       423 |      52457 |           numpy.matrixlib.defmatrix
import time:       222 |      52678 |         numpy.matrixlib
import time:       509 |        509 |           numpy.lib.histograms
import time:      1174 |       1683 |         numpy.lib.function_base
import time:       475 |      54836 |       numpy.lib.index_tricks
import time:       601 |        601 |       numpy.lib.nanfunctions
import time:       459 |        459 |       numpy.lib.shape_base
import time:       635 |        635 |       numpy.lib.polynomial
import time:      1022 |       1022 |         textwrap
import time:       671 |       1693 |       numpy.lib.utils
import time:       400 |        400 |       numpy.lib.arraysetops
import time:       344 |        344 |           _weakrefset
import time:       589 |        933 |         weakref
import time:       421 |        421 |         numpy.lib.format
import time:       341 |        341 |         numpy.lib._datasource
import time:       468 |        468 |         numpy.lib._iotools
import time:       593 |       2754 |       numpy.lib.npyio
import time:       298 |        298 |       numpy.lib.arrayterator
import time:       331 |        331 |       numpy.lib.arraypad
import time:       196 |        196 |       numpy.lib._version
import time:       569 |      65201 |     numpy.lib
import time:     72762 |      72762 |         numpy.fft._pocketfft_internal
import time:       519 |      73280 |       numpy.fft._pocketfft
import time:       461 |        461 |       numpy.fft.helper
import time:       335 |      74075 |     numpy.fft
import time:       387 |        387 |         numpy.polynomial.polyutils
import time:       438 |        438 |         numpy.polynomial._polybase
import time:       822 |       1647 |       numpy.polynomial.polynomial
import time:       520 |        520 |       numpy.polynomial.chebyshev
import time:       426 |        426 |       numpy.polynomial.legendre
import time:       352 |        352 |       numpy.polynomial.hermite
import time:       452 |        452 |       numpy.polynomial.hermite_e
import time:       565 |        565 |       numpy.polynomial.laguerre
import time:       426 |       4385 |     numpy.polynomial
import time:       128 |        128 |               backports_abc
import time:     51751 |      51878 |             numpy.random._common
import time:      1050 |       1050 |                 binascii
import time:       429 |       1479 |               base64
import time:      1596 |       1596 |                 _hashlib
import time:       460 |        460 |                   _blake2
import time:       446 |        906 |                 hashlib
import time:       413 |       2914 |               hmac
import time:       380 |        380 |                   _bisect
import time:       309 |        689 |                 bisect
import time:       391 |        391 |                 _random
import time:       385 |        385 |                 _sha512
import time:       695 |       2158 |               random
import time:       406 |       6955 |             secrets
import time:      1207 |       1207 |             threading
import time:     42577 |     102617 |           numpy.random.bit_generator
import time:     59999 |      59999 |           numpy.random._bounded_integers
import time:     32288 |      32288 |           numpy.random._mt19937
import time:     68548 |     263450 |         numpy.random.mtrand
import time:     31926 |      31926 |         numpy.random._philox
import time:     99334 |      99334 |         numpy.random._pcg64
import time:     31689 |      31689 |         numpy.random._sfc64
import time:     77153 |      77153 |         numpy.random._generator
import time:       348 |     503897 |       numpy.random._pickle
import time:       388 |     504285 |     numpy.random
import time:       689 |        689 |     numpy.ctypeslib
import time:       558 |        558 |               _opcode
import time:       389 |        947 |             opcode
import time:       650 |       1596 |           dis
import time:       368 |        368 |             importlib
import time:       318 |        685 |           importlib.machinery
import time:       509 |        509 |               token
import time:       901 |       1409 |             tokenize
import time:       289 |       1698 |           linecache
import time:      1408 |       5385 |         inspect
import time:      2491 |       7876 |       numpy.ma.core
import time:      1091 |       1091 |       numpy.ma.extras
import time:       385 |       9351 |     numpy.ma
import time:      3840 |    5754361 |   numpy
import time:       505 |        505 |     pytz.exceptions
import time:       305 |        305 |     pytz.lazy
import time:       775 |        775 |     pytz.tzinfo
import time:       197 |        197 |     pytz.tzfile
import time:       909 |       2690 |   pytz
import time:       292 |        292 |     dateutil._version
import time:       370 |        662 |   dateutil
import time:       878 |        878 |         signal
import time:        48 |         48 |         pwd
import time:       786 |        786 |         grp
import time:        83 |         83 |         msvcrt
import time:       598 |        598 |         _posixsubprocess
import time:       576 |        576 |         select
import time:       689 |        689 |         selectors
import time:       671 |       4326 |       subprocess
import time:      1694 |       6020 |     platform
import time:      1497 |       1497 |       typing
import time:      2195 |       3692 |     pandas._typing
import time:       372 |        372 |     pandas.compat._constants
import time:       314 |        314 |         _compression
import time:       811 |        811 |         _bz2
import time:       389 |       1512 |       bz2
import time:      1472 |       1472 |         _lzma
import time:      1133 |       2604 |       lzma
import time:       342 |       4458 |     pandas.compat.compressors
import time:     52707 |      52707 |                             pandas._libs.tslibs.np_datetime
import time:     56804 |     109511 |                           pandas._libs.tslibs.dtypes
import time:     48111 |      48111 |                             pandas._libs.tslibs.base
import time:     62200 |      62200 |                                 pandas._libs.tslibs.nattype
import time:       279 |        279 |                                       pandas.util._exceptions
import time:      2246 |       2246 |                                       pandas.util.version
import time:       373 |       2897 |                                     pandas.compat._optional
import time:       508 |        508 |                                         sysconfig
import time:       616 |        616 |                                         _sysconfigdata__darwin_darwin
import time:       557 |        557 |                                         _osx_support
import time:      1269 |       2949 |                                       zoneinfo._tzpath
import time:       337 |        337 |                                       zoneinfo._common
import time:       913 |        913 |                                       _zoneinfo
import time:       411 |       4609 |                                     zoneinfo
import time:       541 |        541 |                                             importlib.abc
import time:       359 |        900 |                                           importlib.util
import time:       998 |       1898 |                                         six
import time:        30 |         30 |                                         six.moves
import time:       258 |        258 |                                         dateutil.tz._common
import time:       246 |        246 |                                         dateutil.tz._factories
import time:        19 |         19 |                                           six.moves.winreg
import time:       299 |        317 |                                         dateutil.tz.win
import time:       750 |       3496 |                                       dateutil.tz.tz
import time:       304 |       3800 |                                     dateutil.tz
import time:     61336 |      72641 |                                   pandas._libs.tslibs.timezones
import time:     49927 |      49927 |                                     pandas._libs.tslibs.ccalendar
import time:      1116 |       1116 |                                     locale
import time:       635 |        635 |                                       calendar
import time:       898 |       1533 |                                     _strptime
import time:       962 |        962 |                                         pandas._config.config
import time:       394 |        394 |                                         pandas._config.dates
import time:       160 |        160 |                                         pandas._config.display
import time:       222 |       1737 |                                       pandas._config
import time:       161 |       1897 |                                     pandas._config.localization
import time:     68703 |     123174 |                                   pandas._libs.tslibs.fields
import time:     77791 |     273605 |                                 pandas._libs.tslibs.timedeltas
import time:     63053 |      63053 |                                 pandas._libs.tslibs.tzconversion
import time:       179 |        179 |                                 backports_abc
import time:     77810 |     476844 |                               pandas._libs.tslibs.timestamps
import time:        79 |         79 |                               backports_abc
import time:       358 |        358 |                               dateutil.easter
import time:       304 |        304 |                                 dateutil._common
import time:       431 |        734 |                               dateutil.relativedelta
import time:     54950 |      54950 |                               pandas._libs.properties
import time:    107338 |     640302 |                             pandas._libs.tslibs.offsets
import time:       138 |        138 |                               backports_abc
import time:      1585 |       1585 |                                 _decimal
import time:       384 |       1969 |                               decimal
import time:        39 |         39 |                                     _string
import time:       782 |        821 |                                   string
import time:       775 |       1595 |                                 dateutil.parser._parser
import time:       476 |        476 |                                 dateutil.parser.isoparser
import time:       316 |       2385 |                               dateutil.parser
import time:     63363 |      63363 |                               pandas._libs.tslibs.strptime
import time:     74877 |     142731 |                             pandas._libs.tslibs.parsing
import time:     60596 |     891738 |                           pandas._libs.tslibs.conversion
import time:     67615 |      67615 |                           pandas._libs.tslibs.period
import time:     58137 |      58137 |                           pandas._libs.tslibs.vectorized
import time:       482 |    1127481 |                         pandas._libs.tslibs
import time:        35 |    1127515 |                       pandas._libs.tslibs.nattype
import time:     52422 |      52422 |                       pandas._libs.ops_dispatch
import time:     60445 |    1240381 |                     pandas._libs.missing
import time:    141722 |    1382102 |                   pandas._libs.hashtable
import time:    175403 |     175403 |                   pandas._libs.algos
import time:    113002 |    1670507 |                 pandas._libs.interval
import time:       211 |    1670717 |               pandas._libs
import time:        22 |    1670738 |             pandas._libs.properties
import time:       406 |    1671144 |           pandas.util._decorators
import time:       261 |        261 |               pandas.core
import time:       239 |        499 |             pandas.core.util
import time:     76527 |      76527 |             pandas._libs.lib
import time:     58404 |      58404 |             pandas._libs.hashing
import time:       221 |        221 |               pandas.core.dtypes
import time:       556 |        556 |                 pandas.errors
import time:       322 |        322 |                 pandas.core.dtypes.generic
import time:       389 |       1267 |               pandas.core.dtypes.base
import time:       187 |        187 |                 pandas.core.dtypes.inference
import time:      1047 |       1234 |               pandas.core.dtypes.dtypes
import time:       452 |       3172 |             pandas.core.dtypes.common
import time:       259 |     138858 |           pandas.core.util.hashing
import time:       252 |    1810253 |         pandas.util
import time:        22 |    1810274 |       pandas.util.version
import time:       428 |    1810702 |     pandas.compat.numpy
import time:        97 |         97 |       pyarrow
import time:       156 |        252 |     pandas.compat.pyarrow
import time:       359 |    1825851 |   pandas.compat
import time:     61192 |      61192 |   pandas._libs.tslib
import time:       793 |        793 |   pandas.core.config_init
import time:       211 |        211 |     pandas.core.dtypes.missing
import time:       387 |        387 |       pandas.core.dtypes.cast
import time:       141 |        141 |         pandas.core.dtypes.astype
import time:       164 |        304 |       pandas.core.dtypes.concat
import time:       116 |        116 |         pandas.core.array_algos
import time:       238 |        238 |           pandas.core.common
import time:       160 |        397 |         pandas.core.construction
import time:       266 |        779 |       pandas.core.array_algos.take
import time:       169 |        169 |         pandas.core.indexers.utils
import time:       115 |        284 |       pandas.core.indexers
import time:       712 |       2463 |     pandas.core.algorithms
import time:        69 |         69 |                 org
import time:        12 |         81 |               org.python
import time:        10 |         90 |             org.python.core
import time:       414 |        504 |           copy
import time:       596 |        596 |           unicodedata
import time:       350 |        350 |           pandas.util._validators
import time:       113 |        113 |           pandas.core.roperator
import time:    179370 |     179370 |                   pandas._libs.ops
import time:       271 |        271 |                   pandas.core.computation
import time:       257 |        257 |                     pandas.core.computation.check
import time:       352 |        608 |                   pandas.core.computation.expressions
import time:       150 |        150 |                   pandas.core.ops.missing
import time:       113 |        113 |                   pandas.core.ops.dispatch
import time:       114 |        114 |                   pandas.core.ops.invalid
import time:       360 |     180984 |                 pandas.core.ops.array_ops
import time:       296 |        296 |                 pandas.core.ops.common
import time:       216 |        216 |                 pandas.core.ops.docstrings
import time:       308 |        308 |                 pandas.core.ops.mask_ops
import time:       168 |        168 |                 pandas.core.ops.methods
import time:       363 |     182333 |               pandas.core.ops
import time:        17 |     182350 |             pandas.core.ops.common
import time:       366 |     182715 |           pandas.core.arraylike
import time:       346 |        346 |             pandas.compat.numpy.function
import time:       277 |        277 |             pandas.core.missing
import time:       834 |        834 |             pandas.core.array_algos.quantile
import time:       247 |        247 |             pandas.core.sorting
import time:       679 |       2381 |           pandas.core.arrays.base
import time:       162 |        162 |             pandas.core.strings
import time:       318 |        479 |           pandas.core.strings.base
import time:       384 |        384 |             pandas.tseries
import time:       763 |       1146 |           pandas.tseries.frequencies
import time:       974 |     189253 |         pandas.core.arrays.arrow.array
import time:       216 |        216 |         pandas.core.arrays.arrow.dtype
import time:       163 |     189631 |       pandas.core.arrays.arrow
import time:       129 |        129 |         pandas.core.array_algos.masked_accumulations
import time:       846 |        846 |           pandas.core.nanops
import time:       151 |        151 |           pandas.core.array_algos.masked_reductions
import time:       806 |       1803 |         pandas.core.arrays.masked
import time:       252 |       2183 |       pandas.core.arrays.boolean
import time:       833 |        833 |           _csv
import time:       559 |       1391 |         csv
import time:       778 |        778 |           zlib
import time:      1150 |       1928 |         shutil
import time:     55151 |      55151 |         pandas._libs.arrays
import time:       525 |        525 |         pandas.core.accessor
import time:       124 |        124 |           pandas.core.array_algos.transforms
import time:       599 |        723 |         pandas.core.arrays._mixins
import time:       762 |        762 |         pandas.core.base
import time:       338 |        338 |         pandas.core.strings.object_array
import time:       155 |        155 |           pandas.io
import time:       210 |        365 |         pandas.io.formats
import time:       147 |        147 |         pandas.io.formats.console
import time:       779 |      62105 |       pandas.core.arrays.categorical
import time:       126 |        126 |           pandas.core.array_algos.datetimelike_accumulations
import time:       214 |        214 |             pandas.core.arrays.numeric
import time:       231 |        444 |           pandas.core.arrays.integer
import time:      1238 |       1807 |         pandas.core.arrays.datetimelike
import time:       160 |        160 |         pandas.core.arrays._ranges
import time:       275 |        275 |         pandas.tseries.offsets
import time:       519 |       2760 |       pandas.core.arrays.datetimes
import time:       189 |        189 |       pandas.core.arrays.floating
import time:       371 |        371 |         pandas.core.arrays.timedeltas
import time:      1431 |       1802 |       pandas.core.arrays.interval
import time:       396 |        396 |       pandas.core.arrays.numpy_
import time:       463 |        463 |       pandas.core.arrays.period
import time:    101223 |     101223 |             pandas._libs.sparse
import time:       474 |        474 |             pandas.core.arrays.sparse.dtype
import time:       405 |        405 |             pandas.io.formats.printing
import time:       560 |     102659 |           pandas.core.arrays.sparse.array
import time:       266 |     102925 |         pandas.core.arrays.sparse.accessor
import time:       147 |     103071 |       pandas.core.arrays.sparse
import time:       416 |        416 |       pandas.core.arrays.string_
import time:       230 |        230 |       pandas.core.arrays.string_arrow
import time:       189 |     363430 |     pandas.core.arrays
import time:       109 |        109 |     pandas.core.flags
import time:     54558 |      54558 |         pandas._libs.reduction
import time:       655 |        655 |         pandas.core.apply
import time:        49 |         49 |             gc
import time:     48634 |      48634 |               pandas._libs.indexing
import time:       222 |        222 |                 pandas.core.indexes
import time:     92640 |      92640 |                   pandas._libs.index
import time:       157 |        157 |                     backports_abc
import time:     61677 |      61834 |                   pandas._libs.internals
import time:    190091 |     190091 |                   pandas._libs.join
import time:       264 |        264 |                   pandas.core.array_algos.putmask
import time:       161 |        161 |                   pandas.core.indexes.frozen
import time:      2468 |       2468 |                   pandas.core.strings.accessor
import time:      1799 |     349255 |                 pandas.core.indexes.base
import time:       207 |        207 |                   pandas.core.indexes.extension
import time:       305 |        512 |                 pandas.core.indexes.category
import time:       377 |        377 |                     pandas.core.indexes.range
import time:       122 |        122 |                       pandas.core.tools
import time:       187 |        309 |                     pandas.core.tools.timedeltas
import time:       690 |       1375 |                   pandas.core.indexes.datetimelike
import time:       123 |        123 |                   pandas.core.tools.times
import time:       995 |       2492 |                 pandas.core.indexes.datetimes
import time:      1718 |       1718 |                   pandas.core.indexes.multi
import time:       327 |        327 |                   pandas.core.indexes.timedeltas
import time:       929 |       2974 |                 pandas.core.indexes.interval
import time:       463 |        463 |                 pandas.core.indexes.period
import time:       337 |     356251 |               pandas.core.indexes.api
import time:      1368 |     406252 |             pandas.core.indexing
import time:       161 |        161 |             pandas.core.sample
import time:       132 |        132 |             pandas.core.array_algos.replace
import time:     61246 |      61246 |                   pandas._libs.writers
import time:       637 |      61883 |                 pandas.core.internals.blocks
import time:       168 |      62051 |               pandas.core.internals.api
import time:       287 |        287 |                 pandas.core.internals.base
import time:       559 |        846 |               pandas.core.internals.array_manager
import time:       347 |        347 |                   pandas.core.internals.ops
import time:       822 |       1168 |                 pandas.core.internals.managers
import time:       249 |       1417 |               pandas.core.internals.concat
import time:       163 |      64475 |             pandas.core.internals
import time:       253 |        253 |             pandas.core.internals.construction
import time:       125 |        125 |               pandas.core.methods
import time:        97 |         97 |                 pandas.core.reshape
import time:       431 |        528 |               pandas.core.reshape.concat
import time:       779 |        779 |                   dataclasses
import time:       585 |        585 |                   gzip
import time:       733 |        733 |                   mmap
import time:       953 |        953 |                   tarfile
import time:      1278 |       1278 |                   zipfile
import time:       140 |        140 |                   pandas.core.shared_docs
import time:      1551 |       6016 |                 pandas.io.common
import time:       612 |       6628 |               pandas.io.formats.format
import time:       352 |       7631 |             pandas.core.methods.describe
import time:        99 |         99 |                   pandas._libs.window
import time:     74247 |      74345 |                 pandas._libs.window.aggregations
import time:     55648 |      55648 |                   pandas._libs.window.indexers
import time:       585 |      56232 |                 pandas.core.indexers.objects
import time:       254 |        254 |                 pandas.core.util.numba_
import time:       146 |        146 |                 pandas.core.window.common
import time:       233 |        233 |                 pandas.core.window.doc
import time:       151 |        151 |                 pandas.core.window.numba_
import time:       105 |        105 |                 pandas.core.window.online
import time:       129 |        129 |                   pandas.core._numba
import time:       155 |        155 |                   pandas.core._numba.executor
import time:      2204 |       2487 |                 pandas.core.window.rolling
import time:       607 |     134557 |               pandas.core.window.ewm
import time:       961 |        961 |               pandas.core.window.expanding
import time:       162 |     135679 |             pandas.core.window
import time:      5717 |     620346 |           pandas.core.generic
import time:       341 |        341 |           pandas.core.methods.selectn
import time:       119 |        119 |             pandas.core.reshape.util
import time:       154 |        154 |             pandas.core.tools.numeric
import time:       376 |        649 |           pandas.core.reshape.melt
import time:     62686 |      62686 |             pandas._libs.reshape
import time:       675 |        675 |             pandas.core.indexes.accessors
import time:       143 |        143 |               pandas.arrays
import time:       607 |        749 |             pandas.core.tools.datetimes
import time:       894 |        894 |             pandas.io.formats.info
import time:      1482 |       1482 |               pandas.plotting._core
import time:       299 |        299 |               pandas.plotting._misc
import time:       145 |       1925 |             pandas.plotting
import time:      3674 |      70601 |           pandas.core.series
import time:      7345 |     699280 |         pandas.core.frame
import time:      1054 |       1054 |         pandas.core.groupby.base
import time:       154 |        154 |             backports_abc
import time:    159211 |     159365 |           pandas._libs.groupby
import time:       224 |        224 |           pandas.core.groupby.numba_
import time:       103 |        103 |               pandas.core.groupby.categorical
import time:       318 |        421 |             pandas.core.groupby.grouper
import time:       602 |       1023 |           pandas.core.groupby.ops
import time:       319 |        319 |           pandas.core.groupby.indexing
import time:      2276 |     163205 |         pandas.core.groupby.groupby
import time:      2318 |     921067 |       pandas.core.groupby.generic
import time:       133 |     921199 |     pandas.core.groupby
import time:       219 |    1287629 |   pandas.core.api
import time:       118 |        118 |   pandas.tseries.api
import time:        78 |         78 |           pandas.core.computation.common
import time:       131 |        209 |         pandas.core.computation.align
import time:       583 |        583 |             pprint
import time:       194 |        777 |           pandas.core.computation.scope
import time:       282 |       1058 |         pandas.core.computation.ops
import time:       158 |       1425 |       pandas.core.computation.engines
import time:       105 |        105 |         pandas.core.computation.parsing
import time:       761 |        866 |       pandas.core.computation.expr
import time:       147 |       2437 |     pandas.core.computation.eval
import time:        89 |       2525 |   pandas.core.computation.api
import time:       157 |        157 |     pandas.core.reshape.encoding
import time:       653 |        653 |         _uuid
import time:       660 |       1312 |       uuid
import time:      1388 |       2699 |     pandas.core.reshape.merge
import time:      7373 |       7373 |     pandas.core.reshape.pivot
import time:       314 |        314 |     pandas.core.reshape.tile
import time:       146 |      10688 |   pandas.core.reshape.api
import time:       164 |        164 |     pandas.api.extensions
import time:       107 |        107 |     pandas.api.indexers
import time:        88 |         88 |         pandas.core.interchange
import time:       650 |        737 |       pandas.core.interchange.dataframe_protocol
import time:       140 |        140 |             pandas.core.dtypes.api
import time:       138 |        277 |           pandas.api.types
import time:       132 |        409 |         pandas.core.interchange.utils
import time:       167 |        575 |       pandas.core.interchange.from_dataframe
import time:       108 |       1418 |     pandas.api.interchange
import time:       161 |       1849 |   pandas.api
import time:      1076 |       1076 |           _socket
import time:       906 |        906 |           array
import time:      1399 |       3381 |         socket
import time:       203 |        203 |         pandas._testing._random
import time:       508 |        508 |           tempfile
import time:       188 |        696 |         pandas._testing.contexts
import time:       226 |       4504 |       pandas._testing._io
import time:       129 |        129 |       pandas._testing._warnings
import time:      1120 |       1120 |           cmath
import time:     51368 |      52487 |         pandas._libs.testing
import time:       285 |      52772 |       pandas._testing.asserters
import time:       161 |        161 |       pandas._testing.compat
import time:       851 |      58415 |     pandas._testing
import time:       207 |      58621 |   pandas.testing
import time:       163 |        163 |   pandas.util._print_versions
import time:       127 |        127 |     pandas.io.clipboards
import time:       139 |        139 |           backports_abc
import time:     75160 |      75299 |         pandas._libs.parsers
import time:       217 |        217 |         pandas.io.excel._util
import time:        89 |         89 |               pandas.io._util
import time:       418 |        418 |               pandas.io.parsers.base_parser
import time:       175 |        681 |             pandas.io.parsers.arrow_parser_wrapper
import time:       166 |        166 |             pandas.io.parsers.c_parser_wrapper
import time:       335 |        335 |             pandas.io.parsers.python_parser
import time:      2026 |       3206 |           pandas.io.parsers.readers
import time:       148 |       3354 |         pandas.io.parsers
import time:       307 |        307 |         pandas.io.excel._odfreader
import time:       488 |        488 |         pandas.io.excel._openpyxl
import time:       179 |        179 |         pandas.io.excel._pyxlsb
import time:       169 |        169 |         pandas.io.excel._xlrd
import time:      1718 |      81726 |       pandas.io.excel._base
import time:     33728 |      33728 |         pandas._libs.json
import time:       346 |      34073 |       pandas.io.excel._odswriter
import time:       318 |        318 |       pandas.io.excel._xlsxwriter
import time:       144 |     116260 |     pandas.io.excel
import time:       264 |        264 |     pandas.io.feather_format
import time:       108 |        108 |     pandas.io.gbq
import time:       476 |        476 |     pandas.io.html
import time:       209 |        209 |         pandas.io.json._normalize
import time:       140 |        140 |         pandas.io.json._table_schema
import time:       945 |       1294 |       pandas.io.json._json
import time:       140 |       1434 |     pandas.io.json
import time:       122 |        122 |     pandas.io.orc
import time:       412 |        412 |     pandas.io.parquet
import time:       171 |        171 |       pandas.compat.pickle_compat
import time:       317 |        488 |     pandas.io.pickle
import time:       354 |        354 |       pandas.core.computation.pytables
import time:      1185 |       1538 |     pandas.io.pytables
import time:       268 |        268 |       pandas.io.sas.sasreader
import time:       120 |        388 |     pandas.io.sas
import time:        86 |         86 |     pandas.io.spss
import time:       515 |        515 |     pandas.io.sql
import time:      1555 |       1555 |     pandas.io.stata
import time:       752 |        752 |     pandas.io.xml
import time:       200 |     124717 |   pandas.io.api
import time:        96 |         96 |   pandas.util._tester
import time:        81 |         81 |   pandas._version
import time:     14154 |    9146555 | pandas

[pyrito]

@lithomas1 for further context, it seems like this is a one time cost that we pay in a new environment. I see that a fair amount of time is spent importing numpy, so I'm not sure if there's anything we can do here. Future imports of pandas is much faster, which I presume is some caching done by conda/python.

[lithomas1]

Yeah, the numpy import is taking 5 seconds for some reason.

Ideally pandas should load faster, but the main reason for the slowness is that we load all of our extension modules at import time (which is slow, since some are quite large).

[rhshadrach]

Something indeed seems off; your walltime is significantly higher than your CPU time. This indicates to me that something is blocked (e.g. IO). Is your pandas installation on a networked drive (e.g. an NFS)?

[pyrito]

@rhshadrach no this is all on my local M1 macbook pro.