Misleading title, they didn't make the packaging library 3x faster, they made reading one attribute of a package 3x faster. The whole library is still very, very slow compared to alternatives.
> _canonicalize_table = str.maketrans(
"ABCDEFGHIJKLMNOPQRSTUVWXYZ_.",
"abcdefghijklmnopqrstuvwxyz--",
)<p>> ...<p>> value = name.translate(_canonicalize_table)<p>> while "--" in value:<p>> value = value.replace("--", "-")<p>translate can be wildly fast compared to some commonly used regexes or replacements.
I would expect however that a regex replacement would be much faster than your N^2 while loop.
That loop isn't N²: if there are long sequences of dashes, every iteration will cut the lengths of those sequences in half. So the loop has at most lg(N) iterations, for a O(N*lg(N)) total runtime.
It would be, if it was a common situation.<p>This loop handles cases like `eggtools._spam` → `eggtools-spam`, which is probably rare (I guess it’s for packages that export namespaced modules, and you probably don’t want to export _private modules; sorry in advance for non-pythonic terminology). Having more than two separator characters in a row is even more unusual.
I am curious, why not .lower().translate('_.', '--')
Unrelated, but I personally am not satisfied with the performance of Panda's XLSX export. As you can see here [0], the code does really strange things. It takes cell.style and throws it into json.dumps() to generate a key for a dictionary so that they can cache the XlsxStyler.convert(cell.style) result. Except, the vast majority of cells do not have any styling whatsoever, so json.dumps is producing the string "null", which is then used to lookup None. The low hanging fruit are jaw dropping. You can easily speed up the code 10%+ by adding a simple check "if cell.style is not None or fmt is not None:" and switching from json.dumps(cell.style) to str(cell.style). If I wanted an easy weekend project that positively impacts many people this is what I'd work on.<p>[0] <a href="https://github.com/pandas-dev/pandas/blob/main/pandas/io/excel/_xlsxwriter.py#L257-L273" rel="nofollow">https://github.com/pandas-dev/pandas/blob/main/pandas/io/exc...</a>
Previously: <a href="https://news.ycombinator.com/item?id=46557542">https://news.ycombinator.com/item?id=46557542</a>
[dead]