/usr/bin/diffoscope --timeout 7200 --html /srv/reproducible-results/rbuild-debian/r-b-build.Pu6nMB64/pandas_1.1.5+dfsg-2.diffoscope.html --text /srv/reproducible-results/rbuild-debian/r-b-build.Pu6nMB64/pandas_1.1.5+dfsg-2.diffoscope.txt --json /srv/reproducible-results/rbuild-debian/r-b-build.Pu6nMB64/pandas_1.1.5+dfsg-2.diffoscope.json --profile=- /srv/reproducible-results/rbuild-debian/r-b-build.Pu6nMB64/b1/pandas_1.1.5+dfsg-2_arm64.changes /srv/reproducible-results/rbuild-debian/r-b-build.Pu6nMB64/b2/pandas_1.1.5+dfsg-2

⊟

75.7 MB

/srv/reproducible-results/rbuild-debian/r-b-build.Pu6nMB64/b1/pandas_1.1.5+dfsg-2_arm64.changes vs.

/srv/reproducible-results/rbuild-debian/r-b-build.Pu6nMB64/b2/pandas_1.1.5+dfsg-2_arm64.changes ¶

⊟

731 B

Files ¶

⊟

2.06 MB

python-pandas-doc_1.1.5+dfsg-2_all.deb ¶

⊟

452 B

file list ¶

⊟

98.0 B

control.tar.xz ¶

⊟

70.0 B

control.tar ¶

⊟

48.0 B

./md5sums ¶

⊟

30.0 B

./md5sums ¶

Files differ

⊟

2.05 MB

data.tar.xz ¶

⊟

2.05 MB

data.tar ¶

⊟

9.09 KB

file list ¶

⊟

32.6 KB

⊟

32.5 KB

⊟

1.86 KB

⊟

515 B

⊟

4.24 KB

⊟

1.32 KB

⊟

6.08 KB

⊟

1.67 KB

⊟

19.7 KB

⊟

7.15 KB

⊟

2.24 KB

⊟

747 B

⊟

2.93 KB

⊟

523 B

⊟

11.2 KB

⊟

3.14 KB

⊟

3.78 KB

⊟

917 B

⊟

832 KB

⊟

2.49 KB

⊟

1.12 MB

⊟

1.12 MB

⊟

1.12 MB

Similarity: 0.9997853087998139% Differences: {"'cells'": "{5: {'outputs': {0: {'data': {'text/html': {insert: [(1, '</style><table " 'id="T_bb7b8aa4_e5c2_11ef_b8f0_1b7d209e8840" ><thead> <tr> <th class="blank ' 'level0" ></th> <th class="col_heading level0 col0" >A</th> <th ' 'class="col_heading level0 col1" >B</th> <th class="col_heading level0 col2" ' '>C</th> <th class="col_heading level0 col3" >D</th> <th ' 'class="col_heading level0 col4" >E</ […]

⊟

3.57 KB

⊟

1.16 KB

⊟

10.4 KB

⊟

2.37 KB

⊟

3.73 KB

⊟

1.01 KB

⊟

2.87 KB

⊟

909 B

⊟

2.4 KB

⊟

740 B

⊟

4.29 KB

⊟

891 B

⊟

6.73 KB

⊟

1.46 KB

⊟

64.4 KB

python3-pandas-lib_1.1.5+dfsg-2_arm64.deb ¶

⊟

452 B

file list ¶

⊟

98.0 B

control.tar.xz ¶

⊟

70.0 B

control.tar ¶

⊟

48.0 B

./md5sums ¶

⊟

30.0 B

./md5sums ¶

Files differ

⊟

63.8 KB

data.tar.xz ¶

⊟

63.7 KB

data.tar ¶

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/groupby.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.5 KB

./usr/lib/python3/dist-packages/pandas/_libs/hashing.cpython-39-aarch64-linux-gnu.so ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/hashtable.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/index.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/indexing.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/internals.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/interval.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.55 KB

./usr/lib/python3/dist-packages/pandas/_libs/join.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.55 KB

./usr/lib/python3/dist-packages/pandas/_libs/json.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.55 KB

./usr/lib/python3/dist-packages/pandas/_libs/lib.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/missing.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.49 KB

./usr/lib/python3/dist-packages/pandas/_libs/ops.cpython-39-aarch64-linux-gnu.so ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.57 KB

./usr/lib/python3/dist-packages/pandas/_libs/ops_dispatch.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/parsers.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.57 KB

./usr/lib/python3/dist-packages/pandas/_libs/properties.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/reduction.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/reshape.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/sparse.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/testing.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslib.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.57 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/base.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

2.19 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/ccalendar.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

430 B

readelf --wide --notes {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

811 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.58 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/conversion.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.57 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/dtypes.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

2.19 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/fields.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

430 B

readelf --wide --notes {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

811 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.57 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/nattype.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.58 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/np_datetime.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.57 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/offsets.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.57 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/parsing.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.57 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/period.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.58 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/strptime.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.58 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/timedeltas.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.58 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/timestamps.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.58 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/timezones.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.58 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/tzconversion.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.52 KB

./usr/lib/python3/dist-packages/pandas/_libs/tslibs/vectorized.cpython-39-aarch64-linux-gnu.so ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.58 KB

./usr/lib/python3/dist-packages/pandas/_libs/window/aggregations.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.58 KB

./usr/lib/python3/dist-packages/pandas/_libs/window/indexers.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/_libs/writers.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

1.56 KB

./usr/lib/python3/dist-packages/pandas/io/sas/_sas.cpython-39-aarch64-linux-gnu.so ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

610 B

readelf --wide --decompress --hex-dump=.gnu_debuglink {} ¶

error from `readelf --wide --decompress --hex-dump=.gnu_debuglink {}`: readelf: Error: no .dynamic section in the dynamic segment

⊟

73.6 MB

python3-pandas-lib-dbgsym_1.1.5+dfsg-2_arm64.deb ¶

⊟

452 B

file list ¶

⊟

5.87 KB

control.tar.xz ¶

⊟

5.84 KB

control.tar ¶

⊟

3.59 KB

./control ¶

⊟

2.22 KB

./md5sums ¶

⊟

30.0 B

./md5sums ¶

Files differ

⊟

2.18 KB

line order ¶

⊟

73.6 MB

data.tar.xz ¶

⊟

73.6 MB

data.tar ¶

⊟

16.2 KB

file list ¶

⊟

1.77 MB

./usr/lib/debug/.build-id/02/93c6b3704b81ec2cc9fb9d7a5ab3069b00a119.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.77 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.21 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.26 MB

./usr/lib/debug/.build-id/0a/04cff83dc663cdd2b2ae3f888d4d91b4f507b5.debug ¶

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

1.25 MB

readelf --wide --debug-dump=info {} ¶

⊟

696 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

253 KB

./usr/lib/debug/.build-id/14/a7aa3198a6f5a5f365559194d0e0c0bc8ba753.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

864 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

248 KB

readelf --wide --debug-dump=info {} ¶

⊟

274 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

279 KB

./usr/lib/debug/.build-id/1a/d7a1ad13c9883bc132c9e2f09c4722461233d2.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

864 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

274 KB

readelf --wide --debug-dump=info {} ¶

⊟

287 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.03 MB

./usr/lib/debug/.build-id/28/332ee2baec006c1e18faeaef952c8b7f0bef9e.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

1.03 MB

readelf --wide --debug-dump=info {} ¶

⊟

595 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

2.28 MB

./usr/lib/debug/.build-id/2c/2c9a6aa81d692bd36d3369d095144b64e33917.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

2.27 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.37 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

372 KB

./usr/lib/debug/.build-id/31/b4023a9737eafe558e60026d379d6f61f17c42.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

369 KB

readelf --wide --debug-dump=info {} ¶

⊟

438 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.35 MB

./usr/lib/debug/.build-id/32/f3d9d3b74bff638acbd19a2670efe2ff7fe3ea.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.34 MB

readelf --wide --debug-dump=info {} ¶

⊟

744 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.08 MB

./usr/lib/debug/.build-id/33/9c86cada48a1142e72b8daad3555180d8b0fd8.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.07 MB

readelf --wide --debug-dump=info {} ¶

⊟

656 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

307 KB

./usr/lib/debug/.build-id/33/eb8b109eced3cd41ed94ff51ddf6abaf001a81.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

304 KB

readelf --wide --debug-dump=info {} ¶

⊟

352 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

2.77 MB

./usr/lib/debug/.build-id/38/9be996052d5cb1002e337269e05b75ed1398d2.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

2.76 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.56 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.31 MB

./usr/lib/debug/.build-id/48/bc47bf4e9c6aac5a20ac809eb3e48d33ccbb30.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

1.31 MB

readelf --wide --debug-dump=info {} ¶

⊟

820 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.5 MB

./usr/lib/debug/.build-id/55/757614ccd91052a6503d83b3cfa473f3b3e58e.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.5 MB

readelf --wide --debug-dump=info {} ¶

⊟

715 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

6.84 MB

./usr/lib/debug/.build-id/5a/96d3f33107ebaeb7298320de9c7e37e26b484f.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

6.84 MB

readelf --wide --debug-dump=info {} ¶

⊟

5.0 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

4.36 MB

./usr/lib/debug/.build-id/74/003a31838e171df71eef6548d318f300f849cc.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

869 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

4.36 MB

readelf --wide --debug-dump=info {} ¶

⊟

2.55 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.52 MB

./usr/lib/debug/.build-id/7a/f849812693a5591b666c11523936d51904efbe.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.51 MB

readelf --wide --debug-dump=info {} ¶

⊟

914 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

2.83 MB

./usr/lib/debug/.build-id/85/90adf4b4bbe1d173a4659aec358b393ba46ac0.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

2.82 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.56 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

4.0 MB

./usr/lib/debug/.build-id/8d/9649325249e06347674f7fe797cbc1b450bcce.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

4.0 MB

readelf --wide --debug-dump=info {} ¶

⊟

2.42 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

593 KB

./usr/lib/debug/.build-id/8e/0cefdd1db1b6c25e66c9a34831adbecab69106.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

590 KB

readelf --wide --debug-dump=info {} ¶

⊟

467 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.2 MB

./usr/lib/debug/.build-id/9b/c7790fd93be180a7bed2817347b2bdf44ea7f1.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.19 MB

readelf --wide --debug-dump=info {} ¶

⊟

717 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

2.61 MB

./usr/lib/debug/.build-id/9f/d6189fb7a6069c37ab5ebbfcfdb0ce92d85c5c.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

2.6 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.46 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

4.36 MB

./usr/lib/debug/.build-id/a1/835175cb5cb323cd025d421670bd5d74c64945.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

868 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

4.35 MB

readelf --wide --debug-dump=info {} ¶

⊟

2.71 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

2.03 MB

./usr/lib/debug/.build-id/a9/006a0b165aa09c1729d8a254ff85c81879ec64.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

2.03 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.21 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

2.17 MB

./usr/lib/debug/.build-id/ad/a3ed928c2f16992fa0ec1bd85d422e94a0de65.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

2.16 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.01 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.44 MB

./usr/lib/debug/.build-id/bf/b3cc7ba4f47701b6e34e35646e56691377c31f.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.44 MB

readelf --wide --debug-dump=info {} ¶

⊟

826 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

3.31 MB

./usr/lib/debug/.build-id/c2/514acd4fe31f12e5f27524ebf38901a1dbacc8.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

3.31 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.67 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.13 MB

./usr/lib/debug/.build-id/c4/c20a372f7d544f8f6c985b4f4f0dfeb8dbe7b9.debug ¶

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.13 MB

readelf --wide --debug-dump=info {} ¶

⊟

585 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

2.37 MB

./usr/lib/debug/.build-id/ce/c5a8e3d1830f208f8436f671c06f6ed19ce7ce.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

2.36 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.39 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.12 MB

./usr/lib/debug/.build-id/d7/9c1ff062544e96d6bac996b5f8652964d9c335.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.11 MB

readelf --wide --debug-dump=info {} ¶

⊟

675 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

670 KB

./usr/lib/debug/.build-id/db/267facd9dd790c195647645c835e788e92168a.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

665 KB

readelf --wide --debug-dump=info {} ¶

⊟

614 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.42 MB

./usr/lib/debug/.build-id/dd/731bd104a09f6be95c5073fd6787df8e234fe8.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.41 MB

readelf --wide --debug-dump=info {} ¶

⊟

883 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

236 KB

./usr/lib/debug/.build-id/e1/f0dff1f5b33ce4dc54cb6634069e0085b4007f.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

234 KB

readelf --wide --debug-dump=info {} ¶

⊟

333 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

181 KB

./usr/lib/debug/.build-id/e2/57935e25ea7f6a2b29a920bc0c0833b44c9fac.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

178 KB

readelf --wide --debug-dump=info {} ¶

⊟

402 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.29 MB

./usr/lib/debug/.build-id/e9/a34a6731e326e9e4f70a2f04864062ce84721c.debug ¶

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

1.29 MB

readelf --wide --debug-dump=info {} ¶

⊟

721 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

342 KB

./usr/lib/debug/.build-id/ea/f1cd0eeb413da9877afa64fbd9539833fe6af0.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

1.48 KB

readelf --wide --sections {} ¶

⊟

339 KB

readelf --wide --debug-dump=info {} ¶

⊟

363 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

5.17 MB

./usr/lib/debug/.build-id/f4/5620496acef927839542e3b7bc0f60e6d0b961.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

868 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

5.16 MB

readelf --wide --debug-dump=info {} ¶

⊟

3.55 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

2.26 MB

./usr/lib/debug/.build-id/f7/d08b4ccec5c553822972fa3ac18acd995285f5.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

2.25 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.41 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.79 MB

./usr/lib/debug/.build-id/fd/4acfd0332253ed3b0db6e0d7ad08d2adc766ec.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

1.78 MB

readelf --wide --debug-dump=info {} ¶

⊟

1.22 KB

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

1.03 MB

./usr/lib/debug/.dwz/aarch64-linux-gnu/python3-pandas-lib.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied.

⊟

855 B

readelf --wide --file-header {} ¶

⊟

1.6 KB

readelf --wide --sections {} ¶

⊟

430 B

readelf --wide --notes {} ¶

⊟

815 KB

readelf --wide --debug-dump=info {} ¶

⊟

368 B

strings --all --bytes=8 {} ¶

⊟

236 KB

readelf --wide --decompress --string-dump=.debug_str {} ¶

⊟

1.41 MB

./usr/lib/debug/.build-id/a5/ba021a08857e7220fa656c99026d233bcd27e2.debug vs.

./usr/lib/debug/.build-id/b6/96ddf98283967a65cf0bca3d9e623ccdc9ff82.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied. Files 8% similar despite different names

⊟

866 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

430 B

readelf --wide --notes {} ¶

⊟

1.4 MB

readelf --wide --debug-dump=info {} ¶

⊟

822 B

strings --all --bytes=8 {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶

⊟

384 KB

./usr/lib/debug/.build-id/b8/4d72bd5f519e22917c13284bc07abe11a9aeff.debug vs.

./usr/lib/debug/.build-id/50/8f2836b8e6c104fd42fc3a1068213d5251ccb6.debug ¶

File has been modified after NT_GNU_BUILD_ID has been applied. Files 10% similar despite different names

⊟

864 B

readelf --wide --file-header {} ¶

⊟

3.29 KB

readelf --wide --sections {} ¶

⊟

430 B

readelf --wide --notes {} ¶

⊟

2.29 KB

readelf --wide --debug-dump=rawline {} ¶

⊟

368 KB

readelf --wide --debug-dump=info {} ¶

⊟

507 B

strings --all --bytes=8 {} ¶

⊟

8.03 KB

readelf --wide --decompress --string-dump=.debug_str {} ¶

⊟

757 B

readelf --wide --decompress --hex-dump=.gnu_debugaltlink {} ¶


Offset 1, 5 lines modified		Offset 1, 5 lines modified

1	·cbf7c279849491693369c14b0a9e93a4·8197596·doc·optional·python-pandas-doc_1.1.5+dfsg-2_all.deb
2	·941d91ec953aac99a2f0764e0a71ec63·24487264·debug·optional·python3-pandas-lib-dbgsym_1.1.5+dfsg-2_arm64.deb
3	·b~~0d660a2eea65c7~~0~~e41ebc8af2ee1267~~·291329~~6·pyth~~on·optional·python3-pandas-~~lib~~_1.1.5+dfsg-2_arm64.deb	1	·bf18897e3d10ba80c9d9a5d096baa4bb·8197168·doc·optional·python-pandas-doc_1.1.5+dfsg-2_all.deb
		2	·ed14c26f7aefc7c84a583fc1ff8a1611·24487204·debug·optional·python3-pandas-lib-dbgsym_1.1.5+dfsg-2_arm64.deb
		3	·243eb357c709de1d37da891287d95412·2913584·python·optional·python3-pandas-lib_1.1.5+dfsg-2_arm64.deb
4	·e6541380ee2e4732c3cfb039a92ab3e3·2095828·python·optional·python3-pandas_1.1.5+dfsg-2_all.deb	4	·e6541380ee2e4732c3cfb039a92ab3e3·2095828·python·optional·python3-pandas_1.1.5+dfsg-2_all.deb


Offset 1, 3 lines modified		Offset 1, 3 lines modified
1	-rw-r--r--···0········0········0········4·2021-01-12·21:06:04.000000·debian-binary	1	-rw-r--r--···0········0········0········4·2021-01-12·21:06:04.000000·debian-binary
2	-rw-r--r--···0········0········0···146852·2021-01-12·21:06:04.000000·control.tar.xz	2	-rw-r--r--···0········0········0···146848·2021-01-12·21:06:04.000000·control.tar.xz
3	-rw-r--r--···0········0········0··8050~~552~~·2021-01-12·21:06:04.000000·data.tar.xz	3	-rw-r--r--···0········0········0··8050128·2021-01-12·21:06:04.000000·data.tar.xz


Offset 2468, 15 lines modified		Offset 2468, 14 lines modified
2468	········"005383":·2218,	2468	········"005383":·2218,
2469	········"005446":·2217,	2469	········"005446":·2217,
2470	········"005518":·2203,	2470	········"005518":·2203,
2471	········"005654":·2190,	2471	········"005654":·2190,
2472	········"005696":·2199,	2472	········"005696":·2199,
2473	········"005707":·2199,	2473	········"005707":·2199,
2474	········"005979":·2187,	2474	········"005979":·2187,
2475	········"006":·2193,
2476	········"0061535699":·2199,	2475	········"0061535699":·2199,
2477	········"006154":·[2186,·2197,·2199,·2202,·2203,·2213,·2255],	2476	········"006154":·[2186,·2197,·2199,·2202,·2203,·2213,·2255],
2478	········"006349":·2195,	2477	········"006349":·2195,
2479	········"006438":·2213,	2478	········"006438":·2213,
2480	········"006549":·[180,·761],	2479	········"006549":·[180,·761],
2481	········"006695":·2187,	2480	········"006695":·2187,
2482	········"006733":·2203,	2481	········"006733":·2203,
Offset 2605, 15 lines modified		Offset 2604, 14 lines modified
2605	········"023100":·2195,	2604	········"023100":·2195,
2606	········"023167":·12,	2605	········"023167":·12,
2607	········"023640":·2228,	2606	········"023640":·2228,
2608	········"023688":·[12,·2186,·2192,·2197],	2607	········"023688":·[12,·2186,·2192,·2197],
2609	········"023751":·2199,	2608	········"023751":·2199,
2610	········"023888":·2187,	2609	········"023888":·2187,
2611	········"023898":·2195,	2610	········"023898":·2195,
2612	········"023c5c1de6d6":·2210,
2613	········"024180":·[2186,·2197,·2202,·2203,·2213],	2611	········"024180":·[2186,·2197,·2202,·2203,·2213],
2614	········"024180e":·2203,	2612	········"024180e":·2203,
2615	········"024320":·2209,	2613	········"024320":·2209,
2616	········"02458":·2195,	2614	········"02458":·2195,
2617	········"024580":·[2185,·2195,·2212],	2615	········"024580":·[2185,·2195,·2212],
2618	········"024721":·2190,	2616	········"024721":·2190,
2619	········"024738":·[96,·1158],	2617	········"024738":·[96,·1158],
Offset 2648, 23 lines modified		Offset 2646, 24 lines modified
2648	········"029630":·2195,	2646	········"029630":·2195,
2649	········"029766":·2197,	2647	········"029766":·2197,
2650	········"02c58371e730":·14,	2648	········"02c58371e730":·14,
2651	········"02d":·2204,	2649	········"02d":·2204,
2652	········"02t00":·[2199,·2209,·2233,·2259],	2650	········"02t00":·[2199,·2209,·2233,·2259],
2653	········"02t02":·2233,	2651	········"02t02":·2233,
2654	········"02t05":·[910,·2209],	2652	········"02t05":·[910,·2209],
2655	········"030":·[1369,·2~~193,·2~~200,·2230],	2653	········"030":·[1369,·2200,·2230],
2656	········"0300":·2269,	2654	········"0300":·2269,
2657	········"030000":·14,	2655	········"030000":·14,
2658	········"030004":·2199,	2656	········"030004":·2199,
2659	········"030045":·2187,	2657	········"030045":·2187,
2660	········"030579":·2199,	2658	········"030579":·2199,
2661	········"030711":·2192,	2659	········"030711":·2192,
2662	········"030874":·2217,	2660	········"030874":·2217,
2663	········"030876":·2187,	2661	········"030876":·2187,
		2662	········"031":·2193,
2664	········"031345":·2204,	2663	········"031345":·2204,
2665	········"031393":·2226,	2664	········"031393":·2226,
2666	········"03162":·2255,	2665	········"03162":·2255,
2667	········"031709":·2199,	2666	········"031709":·2199,
2668	········"031743":·2190,	2667	········"031743":·2190,
2669	········"031912":·2190,	2668	········"031912":·2190,
2670	········"032652":·2187,	2669	········"032652":·2187,
Offset 2722, 27 lines modified		Offset 2721, 27 lines modified
2722	········"040863":·2187,	2721	········"040863":·2187,
2723	········"041":·[1369,·2200,·2230],	2722	········"041":·[1369,·2200,·2230],
2724	········"041242":·2199,	2723	········"041242":·2199,
2725	········"041290":·2197,	2724	········"041290":·2197,
2726	········"041575":·2217,	2725	········"041575":·2217,
2727	········"041933":·2185,	2726	········"041933":·2185,
2728	········"041965":·2192,	2727	········"041965":·2192,
2729	········"042":·2193,
2730	········"042065":·2190,	2728	········"042065":·2190,
2731	········"042239":·2190,	2729	········"042239":·2190,
2732	········"042379":·[2185,·2195,·2212],	2730	········"042379":·[2185,·2195,·2212],
2733	········"0424":·2255,	2731	········"0424":·2255,
2734	········"042487":·2190,	2732	········"042487":·2190,
2735	········"042745":·2186,	2733	········"042745":·2186,
2736	········"042856":·2216,	2734	········"042856":·2216,
2737	········"043263":·2209,	2735	········"043263":·2209,
2738	········"043312":·2186,	2736	········"043312":·2186,
2739	········"043530":·2199,	2737	········"043530":·2199,
2740	········"043605":·2199,	2738	········"043605":·2199,
2741	········"043719":·2187,	2739	········"043719":·2187,
		2740	········"044":·2193,
2742	········"044057":·2185,	2741	········"044057":·2185,
2743	········"044171":·2199,	2742	········"044171":·2199,
2744	········"0442":·[2185,·2187],	2743	········"0442":·[2185,·2187],
2745	········"0442359662799567":·2199,	2744	········"0442359662799567":·2199,
2746	········"044236":·[13,·14,·15,·2185,·2186,·2187,·2192,·2195,·2197,·2199,·2201,·2202,·2203,·2209,·2212,·2213,·2214,·2216,·2218,·2223,·2233,·2239,·2258],	2745	········"044236":·[13,·14,·15,·2185,·2186,·2187,·2192,·2195,·2197,·2199,·2201,·2202,·2203,·2209,·2212,·2213,·2214,·2216,·2218,·2223,·2233,·2239,·2258],
2747	········"044273":·2195,	2746	········"044273":·2195,
2748	········"044522":·588,	2747	········"044522":·588,
Offset 2783, 25 lines modified		Offset 2782, 23 lines modified
2783	········"050390":·2187,	2782	········"050390":·2187,
2784	········"050976":·2195,	2783	········"050976":·2195,
2785	········"051443":·2186,	2784	········"051443":·2186,
2786	········"051514":·2187,	2785	········"051514":·2187,
2787	········"051539":·2233,	2786	········"051539":·2233,
2788	········"051686":·2187,	2787	········"051686":·2187,
2789	········"051742":·2190,	2788	········"051742":·2190,
2790	········"051890":·2226,
2791	········"051928":·2187,	2789	········"051928":·2187,
2792	········"052021":·2209,	2790	········"052021":·2209,
2793	········"052075":·2199,	2791	········"052075":·2199,
2794	········"052440e":·2203,	2792	········"052440e":·2203,
2795	········"052533":·2190,	2793	········"052533":·2190,
2796	········"052580":·2195,	2794	········"052580":·2195,
2797	········"052599":·2187,	2795	········"052599":·2187,
2798	········"052607":·2199,	2796	········"052607":·2199,
2799	········"052721":·2217,	2797	········"052721":·2217,
2800	········"052954":·2226,
2801	········"0530":·2244,	2798	········"0530":·2244,
2802	········"053136":·2192,	2799	········"053136":·2192,
2803	········"053365":·[180,·761],	2800	········"053365":·[180,·761],
2804	········"053434":·2199,	2801	········"053434":·2199,
2805	········"053785":·2217,	2802	········"053785":·2217,
2806	········"053897":·2195,	2803	········"053897":·2195,
2807	········"054001":·2190,	2804	········"054001":·2190,
Offset 2845, 23 lines modified		Offset 2842, 23 lines modified
2845	········"060843":·2203,	2842	········"060843":·2203,
2846	········"061068":·2209,	2843	········"061068":·2209,
2847	········"061465":·2199,	2844	········"061465":·2199,
2848	········"061645":·2193,	2845	········"061645":·2193,
2849	········"061867":·2190,	2846	········"061867":·2190,
2850	········"061876":·[180,·761],	2847	········"061876":·[180,·761],
2851	········"061932":·2187,	2848	········"061932":·2187,
2852	········"062":·2193,
2853	········"062191":·2228,	2849	········"062191":·2228,
2854	········"062993":·2197,	2850	········"062993":·2197,
2855	········"063123":·2209,	2851	········"063123":·2209,
2856	········"063327":·[2186,·2197,·2203],	2852	········"063327":·[2186,·2197,·2203],
2857	········"063328":·[2206,·2233],	2853	········"063328":·[2206,·2233],
2858	········"063367":·2214,	2854	········"063367":·2214,
2859	········"063465":·2199,	2855	········"063465":·2199,
Max diff block lines reached; 29681/33273 bytes (89.20%) of diff not shown.


Offset 1211, 15 lines modified		Offset 1211, 15 lines modified
1211	<span·class="gp">In·[138]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">figure</span><span·class="p">()</span>	1211	<span·class="gp">In·[138]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">figure</span><span·class="p">()</span>
1212	<span·class="gh">Out[138]:·</span><span·class="go"><Figure·size·640x480·with·0·Axes></span>	1212	<span·class="gh">Out[138]:·</span><span·class="go"><Figure·size·640x480·with·0·Axes></span>

1213	<span·class="gp">In·[139]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">()</span>	1213	<span·class="gp">In·[139]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">()</span>
1214	<span·class="gh">Out[139]:·</span><span·class="go"><AxesSubplot:></span>	1214	<span·class="gh">Out[139]:·</span><span·class="go"><AxesSubplot:></span>

1215	<span·class="gp">In·[140]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">legend</span><span·class="p">(</span><span·class="n">loc</span><span·class="o">=</span><span·class="s1">'best'</span><span·class="p">)</span>	1215	<span·class="gp">In·[140]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">legend</span><span·class="p">(</span><span·class="n">loc</span><span·class="o">=</span><span·class="s1">'best'</span><span·class="p">)</span>
1216	<span·class="gh">Out[140]:·</span><span·class="go"><matplotlib.legend.Legend·at·0xffff7c9~~d216~~0></span>	1216	<span·class="gh">Out[140]:·</span><span·class="go"><matplotlib.legend.Legend·at·0xffff669f7e80></span>
1217	</pre></div>	1217	</pre></div>
1218	</div>	1218	</div>
1219	<img·alt="../_images/frame_plot_basic.png"·src="../_images/frame_plot_basic.png"·/>	1219	<img·alt="../_images/frame_plot_basic.png"·src="../_images/frame_plot_basic.png"·/>
1220	</div>	1220	</div>
1221	<div·class="section"·id="getting-data-in-out">	1221	<div·class="section"·id="getting-data-in-out">
1222	<h2>Getting·data·in/out<a·class="headerlink"·href="#getting-data-in-out"·title="Permalink·to·this·headline">¶</a></h2>	1222	<h2>Getting·data·in/out<a·class="headerlink"·href="#getting-data-in-out"·title="Permalink·to·this·headline">¶</a></h2>
1223	<div·class="section"·id="csv">	1223	<div·class="section"·id="csv">


Offset 978, 15 lines modified		Offset 978, 15 lines modified
978	In·[138]:·plt.figure()	978	In·[138]:·plt.figure()
979	Out[138]:·<Figure·size·640x480·with·0·Axes>	979	Out[138]:·<Figure·size·640x480·with·0·Axes>

980	In·[139]:·df.plot()	980	In·[139]:·df.plot()
981	Out[139]:·<AxesSubplot:>	981	Out[139]:·<AxesSubplot:>

982	In·[140]:·plt.legend(loc='best')	982	In·[140]:·plt.legend(loc='best')
983	Out[140]:·<matplotlib.legend.Legend·at·0xffff7c9~~d216~~0>	983	Out[140]:·<matplotlib.legend.Legend·at·0xffff669f7e80>
984	[../_images/frame_plot_basic.png]	984	[../_images/frame_plot_basic.png]
985	***·Getting·data·in/outÂ¶·***	985	***·Getting·data·in/outÂ¶·***
986	**·CSVÂ¶·**	986	**·CSVÂ¶·**
987	Writing_to_a_csv_file.	987	Writing_to_a_csv_file.
988	In·[141]:·df.to_csv('foo.csv')	988	In·[141]:·df.to_csv('foo.csv')
989	Reading_from_a_csv_file.	989	Reading_from_a_csv_file.
990	In·[142]:·pd.read_csv('foo.csv')	990	In·[142]:·pd.read_csv('foo.csv')


Offset 1295, 25 lines modified		Offset 1295, 25 lines modified
1295	<span·class="gp">In·[141]:·</span><span·class="n">indexer</span>·<span·class="o">=</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">arange</span><span·class="p">(</span><span·class="mi">10000</span><span·class="p">)</span>	1295	<span·class="gp">In·[141]:·</span><span·class="n">indexer</span>·<span·class="o">=</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">arange</span><span·class="p">(</span><span·class="mi">10000</span><span·class="p">)</span>

1296	<span·class="gp">In·[142]:·</span><span·class="n">random</span><span·class="o">.</span><span·class="n">shuffle</span><span·class="p">(</span><span·class="n">indexer</span><span·class="p">)</span>	1296	<span·class="gp">In·[142]:·</span><span·class="n">random</span><span·class="o">.</span><span·class="n">shuffle</span><span·class="p">(</span><span·class="n">indexer</span><span·class="p">)</span>

1297	<span·class="gp">In·[143]:·</span><span·class="o">%</span><span·class="k">timeit</span>·arr[indexer]	1297	<span·class="gp">In·[143]:·</span><span·class="o">%</span><span·class="k">timeit</span>·arr[indexer]
1298	<span·class="gp">···.....:·</span><span·class="o">%</span><span·class="k">timeit</span>·arr.take(indexer,·axis=0)	1298	<span·class="gp">···.....:·</span><span·class="o">%</span><span·class="k">timeit</span>·arr.take(indexer,·axis=0)
1299	<span·class="gp">···.....:·</span>	1299	<span·class="gp">···.....:·</span>
1300	<span·class="go">146·us·+-·1.2·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)</span>	1300	<span·class="go">158·us·+-·6.22·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)</span>
1301	<span·class="go">66·us·+-·~~228~~·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)</span>	1301	<span·class="go">66.3·us·+-·87.5·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)</span>
1302	</pre></div>	1302	</pre></div>
1303	</div>	1303	</div>
1304	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[144]:·</span><span·class="n">ser</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">Series</span><span·class="p">(</span><span·class="n">arr</span><span·class="p">[:,</span>·<span·class="mi">0</span><span·class="p">])</span>	1304	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[144]:·</span><span·class="n">ser</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">Series</span><span·class="p">(</span><span·class="n">arr</span><span·class="p">[:,</span>·<span·class="mi">0</span><span·class="p">])</span>

1305	<span·class="gp">In·[145]:·</span><span·class="o">%</span><span·class="k">timeit</span>·ser.iloc[indexer]	1305	<span·class="gp">In·[145]:·</span><span·class="o">%</span><span·class="k">timeit</span>·ser.iloc[indexer]
1306	<span·class="gp">···.....:·</span><span·class="o">%</span><span·class="k">timeit</span>·ser.take(indexer)	1306	<span·class="gp">···.....:·</span><span·class="o">%</span><span·class="k">timeit</span>·ser.take(indexer)
1307	<span·class="gp">···.....:·</span>	1307	<span·class="gp">···.....:·</span>
1308	<span·class="go">77.2·us·+-·192·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)</span>	1308	<span·class="go">79·us·+-·191·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)</span>
1309	<span·class="go">68.4·us·+-·7~~5.7~~·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)</span>	1309	<span·class="go">69.8·us·+-·139·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)</span>
1310	</pre></div>	1310	</pre></div>
1311	</div>	1311	</div>
1312	</div>	1312	</div>
1313	<div·class="section"·id="index-types">	1313	<div·class="section"·id="index-types">
1314	<span·id="indexing-index-types"></span><h2>Index·types<a·class="headerlink"·href="#index-types"·title="Permalink·to·this·headline">¶</a></h2>	1314	<span·id="indexing-index-types"></span><h2>Index·types<a·class="headerlink"·href="#index-types"·title="Permalink·to·this·headline">¶</a></h2>
1315	<p>We·have·discussed·<code·class="docutils·literal·notranslate"><span·class="pre">MultiIndex</span></code>·in·the·previous·sections·pretty·extensively.	1315	<p>We·have·discussed·<code·class="docutils·literal·notranslate"><span·class="pre">MultiIndex</span></code>·in·the·previous·sections·pretty·extensively.
1316	Documentation·about·<code·class="docutils·literal·notranslate"><span·class="pre">DatetimeIndex</span></code>·and·<code·class="docutils·literal·notranslate"><span·class="pre">PeriodIndex</span></code>·are·shown·<a·class="reference·internal"·href="timeseries.html#timeseries-overview"><span·class="std·std-ref">here</span></a>,	1316	Documentation·about·<code·class="docutils·literal·notranslate"><span·class="pre">DatetimeIndex</span></code>·and·<code·class="docutils·literal·notranslate"><span·class="pre">PeriodIndex</span></code>·are·shown·<a·class="reference·internal"·href="timeseries.html#timeseries-overview"><span·class="std·std-ref">here</span></a>,


Offset 1113, 23 lines modified		Offset 1113, 23 lines modified
1113	In·[141]:·indexer·=·np.arange(10000)	1113	In·[141]:·indexer·=·np.arange(10000)

1114	In·[142]:·random.shuffle(indexer)	1114	In·[142]:·random.shuffle(indexer)

1115	In·[143]:·%timeit·arr[indexer]	1115	In·[143]:·%timeit·arr[indexer]
1116	···.....:·%timeit·arr.take(indexer,·axis=0)	1116	···.....:·%timeit·arr.take(indexer,·axis=0)
1117	···.....:	1117	···.....:
1118	146·us·+-·1.2·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)	1118	158·us·+-·6.22·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)
1119	66·us·+-·~~228~~·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)	1119	66.3·us·+-·87.5·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)
1120	In·[144]:·ser·=·pd.Series(arr[:,·0])	1120	In·[144]:·ser·=·pd.Series(arr[:,·0])

1121	In·[145]:·%timeit·ser.iloc[indexer]	1121	In·[145]:·%timeit·ser.iloc[indexer]
1122	···.....:·%timeit·ser.take(indexer)	1122	···.....:·%timeit·ser.take(indexer)
1123	···.....:	1123	···.....:
1124	77.2·us·+-·192·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)	1124	79·us·+-·191·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)
1125	68.4·us·+-·7~~5.7~~·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)	1125	69.8·us·+-·139·ns·per·loop·(mean·+-·std.·dev.·of·7·runs,·10000·loops·each)
1126	***·Index·typesÂ¶·***	1126	***·Index·typesÂ¶·***
1127	We·have·discussed·MultiIndex·in·the·previous·sections·pretty·extensively.	1127	We·have·discussed·MultiIndex·in·the·previous·sections·pretty·extensively.
1128	Documentation·about·DatetimeIndex·and·PeriodIndex·are·shown·here,·and	1128	Documentation·about·DatetimeIndex·and·PeriodIndex·are·shown·here,·and
1129	documentation·about·TimedeltaIndex·is·found·here.	1129	documentation·about·TimedeltaIndex·is·found·here.
1130	In·the·following·sub-sections·we·will·highlight·some·other·index·types.	1130	In·the·following·sub-sections·we·will·highlight·some·other·index·types.
1131	**·CategoricalIndexÂ¶·**	1131	**·CategoricalIndexÂ¶·**
1132	CategoricalIndex·is·a·type·of·index·that·is·useful·for·supporting·indexing·with	1132	CategoricalIndex·is·a·type·of·index·that·is·useful·for·supporting·indexing·with


Offset 1043, 19 lines modified		Offset 1043, 19 lines modified
1043	<span·class="go">max····3.000000</span>	1043	<span·class="go">max····3.000000</span>
1044	</pre></div>	1044	</pre></div>
1045	</div>	1045	</div>
1046	<p>This·behavior·can·be·controlled·by·providing·a·list·of·types·as·<code·class="docutils·literal·notranslate"><span·class="pre">include</span></code>/<code·class="docutils·literal·notranslate"><span·class="pre">exclude</span></code>	1046	<p>This·behavior·can·be·controlled·by·providing·a·list·of·types·as·<code·class="docutils·literal·notranslate"><span·class="pre">include</span></code>/<code·class="docutils·literal·notranslate"><span·class="pre">exclude</span></code>
1047	arguments.·The·special·value·<code·class="docutils·literal·notranslate"><span·class="pre">all</span></code>·can·also·be·used:</p>	1047	arguments.·The·special·value·<code·class="docutils·literal·notranslate"><span·class="pre">all</span></code>·can·also·be·used:</p>
1048	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[104]:·</span><span·class="n">frame</span><span·class="o">.</span><span·class="n">describe</span><span·class="p">(</span><span·class="n">include</span><span·class="o">=</span><span·class="p">[</span><span·class="s1">'object'</span><span·class="p">])</span>	1048	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[104]:·</span><span·class="n">frame</span><span·class="o">.</span><span·class="n">describe</span><span·class="p">(</span><span·class="n">include</span><span·class="o">=</span><span·class="p">[</span><span·class="s1">'object'</span><span·class="p">])</span>
1049	<span·class="gh">Out[104]:·</span><span·class="go"></span>	1049	<span·class="gh">Out[104]:·</span><span·class="go"></span>
1050	<span·class="go">··········a</span>	1050	<span·class="go">·········a</span>
1051	<span·class="go">count·····4</span>	1051	<span·class="go">count····4</span>
1052	<span·class="go">unique····2</span>	1052	<span·class="go">unique···2</span>
1053	<span·class="go">top·····Yes</span>	1053	<span·class="go">top·····No</span>
1054	<span·class="go">freq······2</span>	1054	<span·class="go">freq·····2</span>

1055	<span·class="gp">In·[105]:·</span><span·class="n">frame</span><span·class="o">.</span><span·class="n">describe</span><span·class="p">(</span><span·class="n">include</span><span·class="o">=</span><span·class="p">[</span><span·class="s1">'number'</span><span·class="p">])</span>	1055	<span·class="gp">In·[105]:·</span><span·class="n">frame</span><span·class="o">.</span><span·class="n">describe</span><span·class="p">(</span><span·class="n">include</span><span·class="o">=</span><span·class="p">[</span><span·class="s1">'number'</span><span·class="p">])</span>
1056	<span·class="gh">Out[105]:·</span><span·class="go"></span>	1056	<span·class="gh">Out[105]:·</span><span·class="go"></span>
1057	<span·class="go">··············b</span>	1057	<span·class="go">··············b</span>
1058	<span·class="go">count··4.000000</span>	1058	<span·class="go">count··4.000000</span>
1059	<span·class="go">mean···1.500000</span>	1059	<span·class="go">mean···1.500000</span>
1060	<span·class="go">std····1.290994</span>	1060	<span·class="go">std····1.290994</span>
Offset 1066, 15 lines modified		Offset 1066, 15 lines modified
1066	<span·class="go">max····3.000000</span>	1066	<span·class="go">max····3.000000</span>

1067	<span·class="gp">In·[106]:·</span><span·class="n">frame</span><span·class="o">.</span><span·class="n">describe</span><span·class="p">(</span><span·class="n">include</span><span·class="o">=</span><span·class="s1">'all'</span><span·class="p">)</span>	1067	<span·class="gp">In·[106]:·</span><span·class="n">frame</span><span·class="o">.</span><span·class="n">describe</span><span·class="p">(</span><span·class="n">include</span><span·class="o">=</span><span·class="s1">'all'</span><span·class="p">)</span>
1068	<span·class="gh">Out[106]:·</span><span·class="go"></span>	1068	<span·class="gh">Out[106]:·</span><span·class="go"></span>
1069	<span·class="go">··········a·········b</span>	1069	<span·class="go">··········a·········b</span>
1070	<span·class="go">count·····4··4.000000</span>	1070	<span·class="go">count·····4··4.000000</span>
1071	<span·class="go">unique····2·······NaN</span>	1071	<span·class="go">unique····2·······NaN</span>
1072	<span·class="go">top·····~~Yes~~·······NaN</span>	1072	<span·class="go">top······No·······NaN</span>
1073	<span·class="go">freq······2·······NaN</span>	1073	<span·class="go">freq······2·······NaN</span>
1074	<span·class="go">mean····NaN··1.500000</span>	1074	<span·class="go">mean····NaN··1.500000</span>
1075	<span·class="go">std·····NaN··1.290994</span>	1075	<span·class="go">std·····NaN··1.290994</span>
1076	<span·class="go">min·····NaN··0.000000</span>	1076	<span·class="go">min·····NaN··0.000000</span>
1077	<span·class="go">25%·····NaN··0.750000</span>	1077	<span·class="go">25%·····NaN··0.750000</span>
1078	<span·class="go">50%·····NaN··1.500000</span>	1078	<span·class="go">50%·····NaN··1.500000</span>
1079	<span·class="go">75%·····NaN··2.250000</span>	1079	<span·class="go">75%·····NaN··2.250000</span>
Offset 3551, 20 lines modified		Offset 3551, 20 lines modified
3551	</pre></div>	3551	</pre></div>
3552	</div>	3552	</div>
3553	<p>The·number·of·columns·of·each·type·in·a·<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame</span></code>·can·be·found·by·calling	3553	<p>The·number·of·columns·of·each·type·in·a·<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame</span></code>·can·be·found·by·calling
3554	<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame.dtypes.value_counts()</span></code>.</p>	3554	<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame.dtypes.value_counts()</span></code>.</p>
3555	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[352]:·</span><span·class="n">dft</span><span·class="o">.</span><span·class="n">dtypes</span><span·class="o">.</span><span·class="n">value_counts</span><span·class="p">()</span>	3555	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[352]:·</span><span·class="n">dft</span><span·class="o">.</span><span·class="n">dtypes</span><span·class="o">.</span><span·class="n">value_counts</span><span·class="p">()</span>
3556	<span·class="gh">Out[352]:·</span><span·class="go"></span>	3556	<span·class="gh">Out[352]:·</span><span·class="go"></span>
3557	<span·class="go">bool··············1</span>	3557	<span·class="go">bool··············1</span>
3558	<span·class="go">int8··············1</span>
3559	<span·class="go">float32···········1</span>	3558	<span·class="go">float32···········1</span>
		3559	<span·class="go">object············1</span>
3560	<span·class="go">float64···········1</span>	3560	<span·class="go">float64···········1</span>
3561	<span·class="go">int64·············1</span>	3561	<span·class="go">int64·············1</span>
		3562	<span·class="go">int8··············1</span>
3562	<span·class="go">datetime64[ns]····1</span>	3563	<span·class="go">datetime64[ns]····1</span>
3563	<span·class="go">object············1</span>
3564	<span·class="go">dtype:·int64</span>	3564	<span·class="go">dtype:·int64</span>
3565	</pre></div>	3565	</pre></div>
3566	</div>	3566	</div>
3567	<p>Numeric·dtypes·will·propagate·and·can·coexist·in·DataFrames.	3567	<p>Numeric·dtypes·will·propagate·and·can·coexist·in·DataFrames.
3568	If·a·dtype·is·passed·(either·directly·via·the·<code·class="docutils·literal·notranslate"><span·class="pre">dtype</span></code>·keyword,·a·passed·<code·class="docutils·literal·notranslate"><span·class="pre">ndarray</span></code>,	3568	If·a·dtype·is·passed·(either·directly·via·the·<code·class="docutils·literal·notranslate"><span·class="pre">dtype</span></code>·keyword,·a·passed·<code·class="docutils·literal·notranslate"><span·class="pre">ndarray</span></code>,
3569	or·a·passed·<code·class="docutils·literal·notranslate"><span·class="pre">Series</span></code>),·then·it·will·be·preserved·in·DataFrame·operations.·Furthermore,	3569	or·a·passed·<code·class="docutils·literal·notranslate"><span·class="pre">Series</span></code>),·then·it·will·be·preserved·in·DataFrame·operations.·Furthermore,
3570	different·numeric·dtypes·will·<strong>NOT</strong>·be·combined.·The·following·example·will·give·you·a·taste.</p>	3570	different·numeric·dtypes·will·<strong>NOT</strong>·be·combined.·The·following·example·will·give·you·a·taste.</p>


Offset 788, 19 lines modified		Offset 788, 19 lines modified
788	50%····1.500000	788	50%····1.500000
789	75%····2.250000	789	75%····2.250000
790	max····3.000000	790	max····3.000000
791	This·behavior·can·be·controlled·by·providing·a·list·of·types·as·include/exclude	791	This·behavior·can·be·controlled·by·providing·a·list·of·types·as·include/exclude
792	arguments.·The·special·value·all·can·also·be·used:	792	arguments.·The·special·value·all·can·also·be·used:
793	In·[104]:·frame.describe(include=['object'])	793	In·[104]:·frame.describe(include=['object'])
794	Out[104]:	794	Out[104]:
795	··········a	795	·········a
796	count·····4	796	count····4
797	unique····2	797	unique···2
798	top·····Yes	798	top·····No
799	freq······2	799	freq·····2

800	In·[105]:·frame.describe(include=['number'])	800	In·[105]:·frame.describe(include=['number'])
801	Out[105]:	801	Out[105]:
802	··············b	802	··············b
803	count··4.000000	803	count··4.000000
804	mean···1.500000	804	mean···1.500000
805	std····1.290994	805	std····1.290994
Offset 811, 15 lines modified		Offset 811, 15 lines modified
811	max····3.000000	811	max····3.000000

812	In·[106]:·frame.describe(include='all')	812	In·[106]:·frame.describe(include='all')
813	Out[106]:	813	Out[106]:
814	··········a·········b	814	··········a·········b
815	count·····4··4.000000	815	count·····4··4.000000
816	unique····2·······NaN	816	unique····2·······NaN
817	top·····~~Yes~~·······NaN	817	top······No·······NaN
818	freq······2·······NaN	818	freq······2·······NaN
819	mean····NaN··1.500000	819	mean····NaN··1.500000
820	std·····NaN··1.290994	820	std·····NaN··1.290994
821	min·····NaN··0.000000	821	min·····NaN··0.000000
822	25%·····NaN··0.750000	822	25%·····NaN··0.750000
823	50%·····NaN··1.500000	823	50%·····NaN··1.500000
824	75%·····NaN··2.250000	824	75%·····NaN··2.250000
Offset 2908, 20 lines modified		Offset 2908, 20 lines modified
2908	4····foo	2908	4····foo
2909	dtype:·object	2909	dtype:·object
2910	The·number·of·columns·of·each·type·in·a·DataFrame·can·be·found·by·calling	2910	The·number·of·columns·of·each·type·in·a·DataFrame·can·be·found·by·calling
2911	DataFrame.dtypes.value_counts().	2911	DataFrame.dtypes.value_counts().
2912	In·[352]:·dft.dtypes.value_counts()	2912	In·[352]:·dft.dtypes.value_counts()
2913	Out[352]:	2913	Out[352]:
2914	bool··············1	2914	bool··············1
2915	int8··············1
2916	float32···········1	2915	float32···········1
		2916	object············1
2917	float64···········1	2917	float64···········1
2918	int64·············1	2918	int64·············1
		2919	int8··············1
2919	datetime64[ns]····1	2920	datetime64[ns]····1
2920	object············1
2921	dtype:·int64	2921	dtype:·int64
2922	Numeric·dtypes·will·propagate·and·can·coexist·in·DataFrames.·If·a·dtype·is	2922	Numeric·dtypes·will·propagate·and·can·coexist·in·DataFrames.·If·a·dtype·is
2923	passed·(either·directly·via·the·dtype·keyword,·a·passed·ndarray,·or·a·passed	2923	passed·(either·directly·via·the·dtype·keyword,·a·passed·ndarray,·or·a·passed
2924	Series),·then·it·will·be·preserved·in·DataFrame·operations.·Furthermore,	2924	Series),·then·it·will·be·preserved·in·DataFrame·operations.·Furthermore,
2925	different·numeric·dtypes·will·NOT·be·combined.·The·following·example·will·give	2925	different·numeric·dtypes·will·NOT·be·combined.·The·following·example·will·give
2926	you·a·taste.	2926	you·a·taste.
2927	In·[353]:·df1·=·pd.DataFrame(np.random.randn(8,·1),·columns=['A'],	2927	In·[353]:·df1·=·pd.DataFrame(np.random.randn(8,·1),·columns=['A'],


Offset 78, 25 lines modified		Offset 78, 25 lines modified
78	In·[7]:·%timeit·df.apply(lambda·x:·integrate_f(x['a'],·x['b'],·x['N']),·axis=1)	78	In·[7]:·%timeit·df.apply(lambda·x:·integrate_f(x['a'],·x['b'],·x['N']),·axis=1)
79	10·loops,·best·of·3:·174·ms·per·loop	79	10·loops,·best·of·3:·174·ms·per·loop
80	But·clearly·this·isnât·fast·enough·for·us.·Letâs·take·a·look·and·see·where	80	But·clearly·this·isnât·fast·enough·for·us.·Letâs·take·a·look·and·see·where
81	the·time·is·spent·during·this·operation·(limited·to·the·most·time·consuming	81	the·time·is·spent·during·this·operation·(limited·to·the·most·time·consuming
82	four·calls)·using·the·prun_ipython_magic_function:	82	four·calls)·using·the·prun_ipython_magic_function:
83	In·[5]:·%prun·-l·4·df.apply(lambda·x:·integrate_f(x['a'],·x['b'],·x['N']),	83	In·[5]:·%prun·-l·4·df.apply(lambda·x:·integrate_f(x['a'],·x['b'],·x['N']),
84	axis=1)··#·noqa·E999	84	axis=1)··#·noqa·E999
85	·········622830·function·calls·(622809·primitive·calls)·in·0.198·seconds	85	·········622830·function·calls·(622809·primitive·calls)·in·0.196·seconds

86	···Ordered·by:·internal·time	86	···Ordered·by:·internal·time
87	···List·reduced·from·214·to·4·due·to·restriction·<4>	87	···List·reduced·from·214·to·4·due·to·restriction·<4>

88	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)	88	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)
89	·····1000····0.112····0.000····0.171····0.000·<ipython-input-4-c2a74e076cf0>:1	89	·····1000····0.111····0.000····0.170····0.000·<ipython-input-4-c2a74e076cf0>:1
90	(integrate_f)	90	(integrate_f)
91	···552423····0.059····0.000····0.059····0.000·<ipython-input-3-c138bdd570e3>:1	91	···552423····0.059····0.000····0.059····0.000·<ipython-input-3-c138bdd570e3>:1
92	(f)	92	(f)
93	·····3000····0.004····0.000····0.019····0.000·series.py:868(__getitem__)	93	·····3000····0.003····0.000····0.019····0.000·series.py:868(__getitem__)
94	·····3000····0.002····0.000····0.013····0.000·series.py:973(_get_value)	94	·····3000····0.002····0.000····0.013····0.000·series.py:973(_get_value)
95	By·far·the·majority·of·time·is·spend·inside·either·integrate_f·or·f,·hence	95	By·far·the·majority·of·time·is·spend·inside·either·integrate_f·or·f,·hence
96	weâll·concentrate·our·efforts·cythonizing·these·two·functions.	96	weâll·concentrate·our·efforts·cythonizing·these·two·functions.
97	**·Plain·CythonÂ¶·**	97	**·Plain·CythonÂ¶·**
98	First·weâre·going·to·need·to·import·the·Cython·magic·function·to·ipython:	98	First·weâre·going·to·need·to·import·the·Cython·magic·function·to·ipython:
99	In·[6]:·%load_ext·Cython	99	In·[6]:·%load_ext·Cython
100	Now,·letâs·simply·copy·our·functions·over·to·Cython·as·is·(the·suffix·is·here	100	Now,·letâs·simply·copy·our·functions·over·to·Cython·as·is·(the·suffix·is·here
Offset 136, 24 lines modified		Offset 136, 24 lines modified
136	axis=1)	136	axis=1)
137	10·loops,·best·of·3:·20.3·ms·per·loop	137	10·loops,·best·of·3:·20.3·ms·per·loop
138	Now,·weâre·talking!·Itâs·now·over·ten·times·faster·than·the·original·python	138	Now,·weâre·talking!·Itâs·now·over·ten·times·faster·than·the·original·python
139	implementation,·and·we·havenât·really·modified·the·code.·Letâs·have·another	139	implementation,·and·we·havenât·really·modified·the·code.·Letâs·have·another
140	look·at·whatâs·eating·up·time:	140	look·at·whatâs·eating·up·time:
141	In·[9]:·%prun·-l·4·df.apply(lambda·x:·integrate_f_typed(x['a'],·x['b'],·x	141	In·[9]:·%prun·-l·4·df.apply(lambda·x:·integrate_f_typed(x['a'],·x['b'],·x
142	['N']),·axis=1)	142	['N']),·axis=1)
143	·········70396·function·calls·(70375·primitive·calls)·in·0.062·seconds	143	·········70396·function·calls·(70375·primitive·calls)·in·0.064·seconds

144	···Ordered·by:·internal·time	144	···Ordered·by:·internal·time
145	···List·reduced·from·208·to·4·due·to·restriction·<4>	145	···List·reduced·from·208·to·4·due·to·restriction·<4>

146	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)	146	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)
147	·····3000····0.008····0.000····0.042····0.000·series.py:868(__getitem__)	147	·····3000····0.008····0.000····0.044····0.000·series.py:868(__getitem__)
148	·····3000····0.006····0.000····0.030····0.000·series.py:973(_get_value)	148	·····3000····0.005····0.000····0.031····0.000·series.py:973(_get_value)
149	·····3000····0.004····0.000····0.008····0.000·base.py:4979(_maybe_cast_indexer)
150	·····3000····0.004····0.000····0.014····0.000·base.py:2854(get_loc)	149	·····3000····0.004····0.000····0.014····0.000·base.py:2854(get_loc)
		150	·····3000····0.004····0.000····0.008····0.000·base.py:4979(_maybe_cast_indexer)
151	**·Using·ndarrayÂ¶·**	151	**·Using·ndarrayÂ¶·**
152	Itâs·calling·seriesâ¦·a·lot!·Itâs·creating·a·Series·from·each·row,·and	152	Itâs·calling·seriesâ¦·a·lot!·Itâs·creating·a·Series·from·each·row,·and
153	get-ting·from·both·the·index·and·the·series·(three·times·for·each·row).	153	get-ting·from·both·the·index·and·the·series·(three·times·for·each·row).
154	Function·calls·are·expensive·in·Python,·so·maybe·we·could·minimize·these·by	154	Function·calls·are·expensive·in·Python,·so·maybe·we·could·minimize·these·by
155	cythonizing·the·apply·part.	155	cythonizing·the·apply·part.
156	Note	156	Note
157	We·are·now·passing·ndarrays·into·the·Cython·function,·fortunately·Cython·plays	157	We·are·now·passing·ndarrays·into·the·Cython·function,·fortunately·Cython·plays
Offset 214, 16 lines modified		Offset 214, 16 lines modified
214	···Ordered·by:·internal·time	214	···Ordered·by:·internal·time
215	···List·reduced·from·59·to·4·due·to·restriction·<4>	215	···List·reduced·from·59·to·4·due·to·restriction·<4>

216	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)	216	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)
217	········1····0.003····0.003····0.003····0.003·{built-in·method	217	········1····0.003····0.003····0.003····0.003·{built-in·method
218	_cython_magic_7dc7064016b351e6f537d7542a365f15.apply_integrate_f}	218	_cython_magic_7dc7064016b351e6f537d7542a365f15.apply_integrate_f}
219	········3····0.000····0.000····0.001····0.000·frame.py:2869(__getitem__)	219	········3····0.000····0.000····0.001····0.000·frame.py:2869(__getitem__)
220	········1····0.000····0.000····0.005····0.005·{built-in·method·builtins.exec}
221	········3····0.000····0.000····0.000····0.000·managers.py:993(iget)	220	········3····0.000····0.000····0.000····0.000·managers.py:993(iget)
		221	········1····0.000····0.000····0.005····0.005·{built-in·method·builtins.exec}
222	As·one·might·expect,·the·majority·of·the·time·is·now·spent·in	222	As·one·might·expect,·the·majority·of·the·time·is·now·spent·in
223	apply_integrate_f,·so·if·we·wanted·to·make·anymore·efficiencies·we·must	223	apply_integrate_f,·so·if·we·wanted·to·make·anymore·efficiencies·we·must
224	continue·to·concentrate·our·efforts·here.	224	continue·to·concentrate·our·efforts·here.
225	**·More·advanced·techniquesÂ¶·**	225	**·More·advanced·techniquesÂ¶·**
226	There·is·still·hope·for·improvement.·Hereâs·an·example·of·using·some·more	226	There·is·still·hope·for·improvement.·Hereâs·an·example·of·using·some·more
227	advanced·Cython·techniques:	227	advanced·Cython·techniques:
228	In·[12]:·%%cython	228	In·[12]:·%%cython
Offset 420, 29 lines modified		Offset 420, 29 lines modified
420	In·[13]:·nrows,·ncols·=·20000,·100	420	In·[13]:·nrows,·ncols·=·20000,·100

421	In·[14]:·df1,·df2,·df3,·df4·=·[pd.DataFrame(np.random.randn(nrows,·ncols))·for	421	In·[14]:·df1,·df2,·df3,·df4·=·[pd.DataFrame(np.random.randn(nrows,·ncols))·for
422	_·in·range(4)]	422	_·in·range(4)]
423	Now·letâs·compare·adding·them·together·using·plain·olâ·Python·versus·eval	423	Now·letâs·compare·adding·them·together·using·plain·olâ·Python·versus·eval
424	():	424	():
425	In·[15]:·%timeit·df1·+·df2·+·df3·+·df4	425	In·[15]:·%timeit·df1·+·df2·+·df3·+·df4
426	~~10.3~~·ms·+-·179·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	426	9.86·ms·+-·122·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
427	In·[16]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4')	427	In·[16]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4')
428	9.12·ms·+-·82.1·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	428	8.99·ms·+-·236·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
429	Now·letâs·do·the·same·thing·but·with·comparisons:	429	Now·letâs·do·the·same·thing·but·with·comparisons:
430	In·[17]:·%timeit·(df1·>·0)·&·(df2·>·0)·&·(df3·>·0)·&·(df4·>·0)	430	In·[17]:·%timeit·(df1·>·0)·&·(df2·>·0)·&·(df3·>·0)·&·(df4·>·0)
431	30.3·ms·+-·274·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)	431	27.9·ms·+-·1.43·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)
432	In·[18]:·%timeit·pd.eval('(df1·>·0)·&·(df2·>·0)·&·(df3·>·0)·&·(df4·>·0)')	432	In·[18]:·%timeit·pd.eval('(df1·>·0)·&·(df2·>·0)·&·(df3·>·0)·&·(df4·>·0)')
433	15.5·ms·+-·~~445~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	433	15·ms·+-·584·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
434	eval()·also·works·with·unaligned·pandas·objects:	434	eval()·also·works·with·unaligned·pandas·objects:
435	In·[19]:·s·=·pd.Series(np.random.randn(50))	435	In·[19]:·s·=·pd.Series(np.random.randn(50))

436	In·[20]:·%timeit·df1·+·df2·+·df3·+·df4·+·s	436	In·[20]:·%timeit·df1·+·df2·+·df3·+·df4·+·s
437	21.6·ms·+-·~~170~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)	437	22·ms·+-·331·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)
438	In·[21]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4·+·s')	438	In·[21]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4·+·s')
439	11.1·ms·+-·~~151~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	439	10.8·ms·+-·379·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
440	Note	440	Note
441	Operations·such·as	441	Operations·such·as
442	·····1·and·2··#·would·parse·to·1·&·2,·but·should·evaluate·to·2	442	·····1·and·2··#·would·parse·to·1·&·2,·but·should·evaluate·to·2
443	·····3·or·4··#·would·parse·to·3·\|·4,·but·should·evaluate·to·3	443	·····3·or·4··#·would·parse·to·3·\|·4,·but·should·evaluate·to·3
444	·····~1··#·this·is·okay,·but·slower·when·using·eval	444	·····~1··#·this·is·okay,·but·slower·when·using·eval
445	should·be·performed·in·Python.·An·exception·will·be·raised·if·you·try·to	445	should·be·performed·in·Python.·An·exception·will·be·raised·if·you·try·to
446	perform·any·boolean/bitwise·operations·with·scalar·operands·that·are·not·of	446	perform·any·boolean/bitwise·operations·with·scalar·operands·that·are·not·of
Offset 667, 17 lines modified		Offset 667, 17 lines modified
667	Note	667	Note
668	Using·the·'python'·engine·is·generally·not·useful,·except·for·testing·other	668	Using·the·'python'·engine·is·generally·not·useful,·except·for·testing·other
669	evaluation·engines·against·it.·You·will·achieve·no·performance·benefits·using	669	evaluation·engines·against·it.·You·will·achieve·no·performance·benefits·using
670	eval()·with·engine='python'·and·in·fact·may·incur·a·performance·hit.	670	eval()·with·engine='python'·and·in·fact·may·incur·a·performance·hit.
671	You·can·see·this·by·using·pandas.eval()·with·the·'python'·engine.·It·is·a·bit	671	You·can·see·this·by·using·pandas.eval()·with·the·'python'·engine.·It·is·a·bit
672	slower·(not·by·much)·than·evaluating·the·same·expression·in·Python	672	slower·(not·by·much)·than·evaluating·the·same·expression·in·Python
673	In·[62]:·%timeit·df1·+·df2·+·df3·+·df4	673	In·[62]:·%timeit·df1·+·df2·+·df3·+·df4
674	10.4·ms·+-·43.5·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	674	10.3·ms·+-·42·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
675	In·[63]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4',·engine='python')	675	In·[63]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4',·engine='python')
676	12.4·ms·+-·~~133~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	676	12.5·ms·+-·424·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
677	**·pandas.eval()·performanceÂ¶·**	677	**·pandas.eval()·performanceÂ¶·**
678	eval()·is·intended·to·speed·up·certain·kinds·of·operations.·In·particular,	678	eval()·is·intended·to·speed·up·certain·kinds·of·operations.·In·particular,
679	those·operations·involving·complex·expressions·with·large·DataFrame/Series	679	those·operations·involving·complex·expressions·with·large·DataFrame/Series
680	objects·should·see·a·significant·performance·benefit.·Here·is·a·plot·showing	680	objects·should·see·a·significant·performance·benefit.·Here·is·a·plot·showing
681	the·running·time·of·pandas.eval()·as·function·of·the·size·of·the·frame·involved	681	the·running·time·of·pandas.eval()·as·function·of·the·size·of·the·frame·involved
682	in·the·computation.·The·two·lines·are·two·different·engines.	682	in·the·computation.·The·two·lines·are·two·different·engines.
683	[../_images/eval-perf.png]	683	[../_images/eval-perf.png]


Offset 559, 15 lines modified		Offset 559, 15 lines modified
559	<span·class="gp">In·[59]:·</span><span·class="n">grouped_C</span>·<span·class="o">=</span>·<span·class="n">grouped</span><span·class="p">[</span><span·class="s1">'C'</span><span·class="p">]</span>	559	<span·class="gp">In·[59]:·</span><span·class="n">grouped_C</span>·<span·class="o">=</span>·<span·class="n">grouped</span><span·class="p">[</span><span·class="s1">'C'</span><span·class="p">]</span>

560	<span·class="gp">In·[60]:·</span><span·class="n">grouped_D</span>·<span·class="o">=</span>·<span·class="n">grouped</span><span·class="p">[</span><span·class="s1">'D'</span><span·class="p">]</span>	560	<span·class="gp">In·[60]:·</span><span·class="n">grouped_D</span>·<span·class="o">=</span>·<span·class="n">grouped</span><span·class="p">[</span><span·class="s1">'D'</span><span·class="p">]</span>
561	</pre></div>	561	</pre></div>
562	</div>	562	</div>
563	<p>This·is·mainly·syntactic·sugar·for·the·alternative·and·much·more·verbose:</p>	563	<p>This·is·mainly·syntactic·sugar·for·the·alternative·and·much·more·verbose:</p>
564	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[61]:·</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'C'</span><span·class="p">]</span><span·class="o">.</span><span·class="n">groupby</span><span·class="p">(</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'A'</span><span·class="p">])</span>	564	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[61]:·</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'C'</span><span·class="p">]</span><span·class="o">.</span><span·class="n">groupby</span><span·class="p">(</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'A'</span><span·class="p">])</span>
565	<span·class="gh">Out[61]:·</span><span·class="go"><pandas.core.groupby.generic.SeriesGroupBy·object·at·0xffff~~78d~~c~~534~~0></span>	565	<span·class="gh">Out[61]:·</span><span·class="go"><pandas.core.groupby.generic.SeriesGroupBy·object·at·0xffff669c6df0></span>
566	</pre></div>	566	</pre></div>
567	</div>	567	</div>
568	<p>Additionally·this·method·avoids·recomputing·the·internal·grouping·information	568	<p>Additionally·this·method·avoids·recomputing·the·internal·grouping·information
569	derived·from·the·passed·key.</p>	569	derived·from·the·passed·key.</p>
570	</div>	570	</div>
571	</div>	571	</div>
572	<div·class="section"·id="iterating-through-groups">	572	<div·class="section"·id="iterating-through-groups">


Offset 444, 15 lines modified		Offset 444, 15 lines modified
444	In·[58]:·grouped·=·df.groupby(['A'])	444	In·[58]:·grouped·=·df.groupby(['A'])

445	In·[59]:·grouped_C·=·grouped['C']	445	In·[59]:·grouped_C·=·grouped['C']

446	In·[60]:·grouped_D·=·grouped['D']	446	In·[60]:·grouped_D·=·grouped['D']
447	This·is·mainly·syntactic·sugar·for·the·alternative·and·much·more·verbose:	447	This·is·mainly·syntactic·sugar·for·the·alternative·and·much·more·verbose:
448	In·[61]:·df['C'].groupby(df['A'])	448	In·[61]:·df['C'].groupby(df['A'])
449	Out[61]:·<pandas.core.groupby.generic.SeriesGroupBy·object·at·0xffff~~78d~~c~~534~~0>	449	Out[61]:·<pandas.core.groupby.generic.SeriesGroupBy·object·at·0xffff669c6df0>
450	Additionally·this·method·avoids·recomputing·the·internal·grouping·information	450	Additionally·this·method·avoids·recomputing·the·internal·grouping·information
451	derived·from·the·passed·key.	451	derived·from·the·passed·key.
452	***·Iterating·through·groupsÂ¶·***	452	***·Iterating·through·groupsÂ¶·***
453	With·the·GroupBy·object·in·hand,·iterating·through·the·grouped·data·is·very	453	With·the·GroupBy·object·in·hand,·iterating·through·the·grouped·data·is·very
454	natural·and·functions·similarly·to·itertools.groupby():	454	natural·and·functions·similarly·to·itertools.groupby():
455	In·[62]:·grouped·=·df.groupby('A')	455	In·[62]:·grouped·=·df.groupby('A')


Offset 2069, 15 lines modified		Offset 2069, 15 lines modified
2069	<span·class="go">9···0.732206··0.419540··0.604675</span>	2069	<span·class="go">9···0.732206··0.419540··0.604675</span>
2070	<span·class="go">10··0.604466··0.848974··0.896165</span>	2070	<span·class="go">10··0.604466··0.848974··0.896165</span>
2071	<span·class="go">11··0.589168··0.920046··0.732716</span>	2071	<span·class="go">11··0.589168··0.920046··0.732716</span>

2072	<span·class="gp">In·[230]:·</span><span·class="n">expr</span>·<span·class="o">=</span>·<span·class="s1">'0.0·<=·a·<=·c·<=·0.5'</span>	2072	<span·class="gp">In·[230]:·</span><span·class="n">expr</span>·<span·class="o">=</span>·<span·class="s1">'0.0·<=·a·<=·c·<=·0.5'</span>

2073	<span·class="gp">In·[231]:·</span><span·class="nb">map</span><span·class="p">(</span><span·class="k">lambda</span>·<span·class="n">frame</span><span·class="p">:</span>·<span·class="n">frame</span><span·class="o">.</span><span·class="n">query</span><span·class="p">(</span><span·class="n">expr</span><span·class="p">),</span>·<span·class="p">[</span><span·class="n">df</span><span·class="p">,</span>·<span·class="n">df2</span><span·class="p">])</span>	2073	<span·class="gp">In·[231]:·</span><span·class="nb">map</span><span·class="p">(</span><span·class="k">lambda</span>·<span·class="n">frame</span><span·class="p">:</span>·<span·class="n">frame</span><span·class="o">.</span><span·class="n">query</span><span·class="p">(</span><span·class="n">expr</span><span·class="p">),</span>·<span·class="p">[</span><span·class="n">df</span><span·class="p">,</span>·<span·class="n">df2</span><span·class="p">])</span>
2074	<span·class="gh">Out[231]:·</span><span·class="go"><map·at·0xffff~~78aa57c~~0></span>	2074	<span·class="gh">Out[231]:·</span><span·class="go"><map·at·0xffff637cfe80></span>
2075	</pre></div>	2075	</pre></div>
2076	</div>	2076	</div>
2077	</div>	2077	</div>
2078	<div·class="section"·id="query-python-versus-pandas-syntax-comparison">	2078	<div·class="section"·id="query-python-versus-pandas-syntax-comparison">
2079	<h3><a·class="reference·internal"·href="../reference/api/pandas.DataFrame.query.html#pandas.DataFrame.query"·title="pandas.DataFrame.query"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">query()</span></code></a>·Python·versus·pandas·Syntax·Comparison<a·class="headerlink"·href="#query-python-versus-pandas-syntax-comparison"·title="Permalink·to·this·headline">¶</a></h3>	2079	<h3><a·class="reference·internal"·href="../reference/api/pandas.DataFrame.query.html#pandas.DataFrame.query"·title="pandas.DataFrame.query"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">query()</span></code></a>·Python·versus·pandas·Syntax·Comparison<a·class="headerlink"·href="#query-python-versus-pandas-syntax-comparison"·title="Permalink·to·this·headline">¶</a></h3>
2080	<p>Full·numpy-like·syntax:</p>	2080	<p>Full·numpy-like·syntax:</p>
2081	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[232]:·</span><span·class="n">df</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">DataFrame</span><span·class="p">(</span><span·class="n">np</span><span·class="o">.</span><span·class="n">random</span><span·class="o">.</span><span·class="n">randint</span><span·class="p">(</span><span·class="n">n</span><span·class="p">,</span>·<span·class="n">size</span><span·class="o">=</span><span·class="p">(</span><span·class="n">n</span><span·class="p">,</span>·<span·class="mi">3</span><span·class="p">)),</span>·<span·class="n">columns</span><span·class="o">=</span><span·class="nb">list</span><span·class="p">(</span><span·class="s1">'abc'</span><span·class="p">))</span>	2081	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[232]:·</span><span·class="n">df</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">DataFrame</span><span·class="p">(</span><span·class="n">np</span><span·class="o">.</span><span·class="n">random</span><span·class="o">.</span><span·class="n">randint</span><span·class="p">(</span><span·class="n">n</span><span·class="p">,</span>·<span·class="n">size</span><span·class="o">=</span><span·class="p">(</span><span·class="n">n</span><span·class="p">,</span>·<span·class="mi">3</span><span·class="p">)),</span>·<span·class="n">columns</span><span·class="o">=</span><span·class="nb">list</span><span·class="p">(</span><span·class="s1">'abc'</span><span·class="p">))</span>


Offset 1773, 15 lines modified		Offset 1773, 15 lines modified
1773	9···0.732206··0.419540··0.604675	1773	9···0.732206··0.419540··0.604675
1774	10··0.604466··0.848974··0.896165	1774	10··0.604466··0.848974··0.896165
1775	11··0.589168··0.920046··0.732716	1775	11··0.589168··0.920046··0.732716

1776	In·[230]:·expr·=·'0.0·<=·a·<=·c·<=·0.5'	1776	In·[230]:·expr·=·'0.0·<=·a·<=·c·<=·0.5'

1777	In·[231]:·map(lambda·frame:·frame.query(expr),·[df,·df2])	1777	In·[231]:·map(lambda·frame:·frame.query(expr),·[df,·df2])
1778	Out[231]:·<map·at·0xffff~~78aa57c~~0>	1778	Out[231]:·<map·at·0xffff637cfe80>
1779	**·query()·Python·versus·pandas·Syntax·ComparisonÂ¶·**	1779	**·query()·Python·versus·pandas·Syntax·ComparisonÂ¶·**
1780	Full·numpy-like·syntax:	1780	Full·numpy-like·syntax:
1781	In·[232]:·df·=·pd.DataFrame(np.random.randint(n,·size=(n,·3)),·columns=list	1781	In·[232]:·df·=·pd.DataFrame(np.random.randint(n,·size=(n,·3)),·columns=list
1782	('abc'))	1782	('abc'))

1783	In·[233]:·df	1783	In·[233]:·df
1784	Out[233]:	1784	Out[233]:


Offset 6267, 42 lines modified		Offset 6267, 42 lines modified
6267	-rw-r--r--···0·root·········(0)·root·········(0)····20758·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reference/resampling.html	6267	-rw-r--r--···0·root·········(0)·root·········(0)····20758·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reference/resampling.html
6268	-rw-r--r--···0·root·········(0)·root·········(0)···141536·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reference/series.html	6268	-rw-r--r--···0·root·········(0)·root·········(0)···141536·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reference/series.html
6269	-rw-r--r--···0·root·········(0)·root·········(0)····19226·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reference/style.html	6269	-rw-r--r--···0·root·········(0)·root·········(0)····19226·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reference/style.html
6270	-rw-r--r--···0·root·········(0)·root·········(0)····26916·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reference/window.html	6270	-rw-r--r--···0·root·········(0)·root·········(0)····26916·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reference/window.html
6271	-rw-r--r--···0·root·········(0)·root·········(0)······244·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/release.html	6271	-rw-r--r--···0·root·········(0)·root·········(0)······244·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/release.html
6272	-rw-r--r--···0·root·········(0)·root·········(0)······269·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reshaping.html	6272	-rw-r--r--···0·root·········(0)·root·········(0)······269·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/reshaping.html
6273	-rw-r--r--···0·root·········(0)·root·········(0)·····3935·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/search.html	6273	-rw-r--r--···0·root·········(0)·root·········(0)·····3935·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/search.html
6274	-rw-r--r--···0·root·········(0)·root·········(0)··1182473·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/searchindex.js	6274	-rw-r--r--···0·root·········(0)·root·········(0)··1182487·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/searchindex.js
6275	-rw-r--r--···0·root·········(0)·root·········(0)······259·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/sparse.html	6275	-rw-r--r--···0·root·········(0)·root·········(0)······259·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/sparse.html
6276	-rw-r--r--···0·root·········(0)·root·········(0)······244·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/style.html	6276	-rw-r--r--···0·root·········(0)·root·········(0)······244·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/style.html
6277	-rw-r--r--···0·root·········(0)·root·········(0)······255·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/text.html	6277	-rw-r--r--···0·root·········(0)·root·········(0)······255·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/text.html
6278	-rw-r--r--···0·root·········(0)·root·········(0)······256·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/timedeltas.html	6278	-rw-r--r--···0·root·········(0)·root·········(0)······256·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/timedeltas.html
6279	-rw-r--r--···0·root·········(0)·root·········(0)······277·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/timeseries.html	6279	-rw-r--r--···0·root·········(0)·root·········(0)······277·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/timeseries.html
6280	-rw-r--r--···0·root·········(0)·root·········(0)······272·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/tutorials.html	6280	-rw-r--r--···0·root·········(0)·root·········(0)······272·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/tutorials.html
6281	drwxr-xr-x···0·root·········(0)·root·········(0)········0·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/	6281	drwxr-xr-x···0·root·········(0)·root·········(0)········0·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/
6282	-rw-r--r--···0·root·········(0)·root·········(0)···126476·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/10min.html	6282	-rw-r--r--···0·root·········(0)·root·········(0)···126476·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/10min.html
6283	-rw-r--r--···0·root·········(0)·root·········(0)···220585·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/advanced.html	6283	-rw-r--r--···0·root·········(0)·root·········(0)···220586·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/advanced.html
6284	-rw-r--r--···0·root·········(0)·root·········(0)···414845·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/basics.html	6284	-rw-r--r--···0·root·········(0)·root·········(0)···414840·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/basics.html
6285	-rw-r--r--···0·root·········(0)·root·········(0)····20303·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/boolean.html	6285	-rw-r--r--···0·root·········(0)·root·········(0)····20303·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/boolean.html
6286	-rw-r--r--···0·root·········(0)·root·········(0)···197142·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/categorical.html	6286	-rw-r--r--···0·root·········(0)·root·········(0)···197142·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/categorical.html
6287	-rw-r--r--···0·root·········(0)·root·········(0)···163238·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/computation.html	6287	-rw-r--r--···0·root·········(0)·root·········(0)···163238·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/computation.html
6288	-rw-r--r--···0·root·········(0)·root·········(0)·····4519·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/cookbook.html	6288	-rw-r--r--···0·root·········(0)·root·········(0)·····4519·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/cookbook.html
6289	-rw-r--r--···0·root·········(0)·root·········(0)···125192·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/dsintro.html	6289	-rw-r--r--···0·root·········(0)·root·········(0)···125192·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/dsintro.html
6290	-rw-r--r--···0·root·········(0)·root·········(0)····93138·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/enhancingperf.html	6290	-rw-r--r--···0·root·········(0)·root·········(0)····93132·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/enhancingperf.html
6291	-rw-r--r--···0·root·········(0)·root·········(0)····50499·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/gotchas.html	6291	-rw-r--r--···0·root·········(0)·root·········(0)····50499·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/gotchas.html
6292	-rw-r--r--···0·root·········(0)·root·········(0)···237879·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/groupby.html	6292	-rw-r--r--···0·root·········(0)·root·········(0)···237879·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/groupby.html
6293	-rw-r--r--···0·root·········(0)·root·········(0)····35919·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/index.html	6293	-rw-r--r--···0·root·········(0)·root·········(0)····35919·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/index.html
6294	-rw-r--r--···0·root·········(0)·root·········(0)···296753·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/indexing.html	6294	-rw-r--r--···0·root·········(0)·root·········(0)···296753·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/indexing.html
6295	-rw-r--r--···0·root·········(0)·root·········(0)····24994·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/integer_na.html	6295	-rw-r--r--···0·root·········(0)·root·········(0)····24994·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/integer_na.html
6296	-rw-r--r--···0·root·········(0)·root·········(0)···807710·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/io.html	6296	-rw-r--r--···0·root·········(0)·root·········(0)···807710·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/io.html
6297	-rw-r--r--···0·root·········(0)·root·········(0)···196130·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/merging.html	6297	-rw-r--r--···0·root·········(0)·root·········(0)···196130·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/merging.html
6298	-rw-r--r--···0·root·········(0)·root·········(0)···147153·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/missing_data.html	6298	-rw-r--r--···0·root·········(0)·root·········(0)···147153·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/missing_data.html
6299	-rw-r--r--···0·root·········(0)·root·········(0)····75718·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/options.html	6299	-rw-r--r--···0·root·········(0)·root·········(0)····75718·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/options.html
6300	-rw-r--r--···0·root·········(0)·root·········(0)···163917·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/reshaping.html	6300	-rw-r--r--···0·root·········(0)·root·········(0)···163917·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/reshaping.html
6301	-rw-r--r--···0·root·········(0)·root·········(0)····73911·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/scale.html	6301	-rw-r--r--···0·root·········(0)·root·········(0)····73913·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/scale.html
6302	-rw-r--r--···0·root·········(0)·root·········(0)····59379·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/sparse.html	6302	-rw-r--r--···0·root·········(0)·root·········(0)····59379·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/sparse.html
6303	-rw-r--r--···0·root·········(0)·root·········(0)···542658·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/style.html	6303	-rw-r--r--···0·root·········(0)·root·········(0)···542658·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/style.html
6304	-rw-r--r--···0·root·········(0)·root·········(0)····39335·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/style.ipynb.gz	6304	-rw-r--r--···0·root·········(0)·root·········(0)····39335·2021-01-12·21:06:04.000000·./usr/share/doc/python-pandas-doc/html/user_guide/style.ipynb.gz


Offset 122, 23 lines modified		Offset 122, 23 lines modified
122	<span·class="go">10·loops,·best·of·3:·174·ms·per·loop</span>	122	<span·class="go">10·loops,·best·of·3:·174·ms·per·loop</span>
123	</pre></div>	123	</pre></div>
124	</div>	124	</div>
125	<p>But·clearly·this·isn’t·fast·enough·for·us.·Let’s·take·a·look·and·see·where·the	125	<p>But·clearly·this·isn’t·fast·enough·for·us.·Let’s·take·a·look·and·see·where·the
126	time·is·spent·during·this·operation·(limited·to·the·most·time·consuming	126	time·is·spent·during·this·operation·(limited·to·the·most·time·consuming
127	four·calls)·using·the·<a·class="reference·external"·href="https://ipython.readthedocs.io/en/stable/interactive/magics.html#magic-prun">prun·ipython·magic·function</a>:</p>	127	four·calls)·using·the·<a·class="reference·external"·href="https://ipython.readthedocs.io/en/stable/interactive/magics.html#magic-prun">prun·ipython·magic·function</a>:</p>
128	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[5]:·</span><span·class="o">%</span><span·class="k">prun</span>·-l·4·df.apply(lambda·x:·integrate_f(x['a'],·x['b'],·x['N']),·axis=1)··#·noqa·E999	128	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[5]:·</span><span·class="o">%</span><span·class="k">prun</span>·-l·4·df.apply(lambda·x:·integrate_f(x['a'],·x['b'],·x['N']),·axis=1)··#·noqa·E999
129	<span·class="go">·········622830·function·calls·(622809·primitive·calls)·in·0.198·seconds</span>	129	<span·class="go">·········622830·function·calls·(622809·primitive·calls)·in·0.196·seconds</span>

130	<span·class="go">···Ordered·by:·internal·time</span>	130	<span·class="go">···Ordered·by:·internal·time</span>
131	<span·class="go">···List·reduced·from·214·to·4·due·to·restriction·<4></span>	131	<span·class="go">···List·reduced·from·214·to·4·due·to·restriction·<4></span>

132	<span·class="go">···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)</span>	132	<span·class="go">···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)</span>
133	<span·class="go">·····1000····0.112····0.000····0.171····0.000·<ipython-input-4-c2a74e076cf0>:1(integrate_f)</span>	133	<span·class="go">·····1000····0.111····0.000····0.170····0.000·<ipython-input-4-c2a74e076cf0>:1(integrate_f)</span>
134	<span·class="go">···552423····0.059····0.000····0.059····0.000·<ipython-input-3-c138bdd570e3>:1(f)</span>	134	<span·class="go">···552423····0.059····0.000····0.059····0.000·<ipython-input-3-c138bdd570e3>:1(f)</span>
135	<span·class="go">·····3000····0.004····0.000····0.019····0.000·series.py:868(__getitem__)</span>	135	<span·class="go">·····3000····0.003····0.000····0.019····0.000·series.py:868(__getitem__)</span>
136	<span·class="go">·····3000····0.002····0.000····0.013····0.000·series.py:973(_get_value)</span>	136	<span·class="go">·····3000····0.002····0.000····0.013····0.000·series.py:973(_get_value)</span>
137	</pre></div>	137	</pre></div>
138	</div>	138	</div>
139	<p>By·far·the·majority·of·time·is·spend·inside·either·<code·class="docutils·literal·notranslate"><span·class="pre">integrate_f</span></code>·or·<code·class="docutils·literal·notranslate"><span·class="pre">f</span></code>,	139	<p>By·far·the·majority·of·time·is·spend·inside·either·<code·class="docutils·literal·notranslate"><span·class="pre">integrate_f</span></code>·or·<code·class="docutils·literal·notranslate"><span·class="pre">f</span></code>,
140	hence·we’ll·concentrate·our·efforts·cythonizing·these·two·functions.</p>	140	hence·we’ll·concentrate·our·efforts·cythonizing·these·two·functions.</p>
141	</div>	141	</div>
142	<div·class="section"·id="plain-cython">	142	<div·class="section"·id="plain-cython">
Offset 193, 24 lines modified		Offset 193, 24 lines modified
193	<span·class="go">10·loops,·best·of·3:·20.3·ms·per·loop</span>	193	<span·class="go">10·loops,·best·of·3:·20.3·ms·per·loop</span>
194	</pre></div>	194	</pre></div>
195	</div>	195	</div>
196	<p>Now,·we’re·talking!·It’s·now·over·ten·times·faster·than·the·original·python	196	<p>Now,·we’re·talking!·It’s·now·over·ten·times·faster·than·the·original·python
197	implementation,·and·we·haven’t·<em>really</em>·modified·the·code.·Let’s·have·another	197	implementation,·and·we·haven’t·<em>really</em>·modified·the·code.·Let’s·have·another
198	look·at·what’s·eating·up·time:</p>	198	look·at·what’s·eating·up·time:</p>
199	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[9]:·</span><span·class="o">%</span><span·class="k">prun</span>·-l·4·df.apply(lambda·x:·integrate_f_typed(x['a'],·x['b'],·x['N']),·axis=1)	199	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[9]:·</span><span·class="o">%</span><span·class="k">prun</span>·-l·4·df.apply(lambda·x:·integrate_f_typed(x['a'],·x['b'],·x['N']),·axis=1)
200	<span·class="go">·········70396·function·calls·(70375·primitive·calls)·in·0.062·seconds</span>	200	<span·class="go">·········70396·function·calls·(70375·primitive·calls)·in·0.064·seconds</span>

201	<span·class="go">···Ordered·by:·internal·time</span>	201	<span·class="go">···Ordered·by:·internal·time</span>
202	<span·class="go">···List·reduced·from·208·to·4·due·to·restriction·<4></span>	202	<span·class="go">···List·reduced·from·208·to·4·due·to·restriction·<4></span>

203	<span·class="go">···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)</span>	203	<span·class="go">···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)</span>
204	<span·class="go">·····3000····0.008····0.000····0.042····0.000·series.py:868(__getitem__)</span>	204	<span·class="go">·····3000····0.008····0.000····0.044····0.000·series.py:868(__getitem__)</span>


Offset 2085, 15 lines modified		Offset 2085, 15 lines modified
2085	</pre></div>	2085	</pre></div>
2086	</div>	2086	</div>
2087	<p>By·specifying·a·<code·class="docutils·literal·notranslate"><span·class="pre">chunksize</span></code>·to·<code·class="docutils·literal·notranslate"><span·class="pre">read_csv</span></code>,·the·return	2087	<p>By·specifying·a·<code·class="docutils·literal·notranslate"><span·class="pre">chunksize</span></code>·to·<code·class="docutils·literal·notranslate"><span·class="pre">read_csv</span></code>,·the·return
2088	value·will·be·an·iterable·object·of·type·<code·class="docutils·literal·notranslate"><span·class="pre">TextFileReader</span></code>:</p>	2088	value·will·be·an·iterable·object·of·type·<code·class="docutils·literal·notranslate"><span·class="pre">TextFileReader</span></code>:</p>
2089	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[190]:·</span><span·class="n">reader</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">read_csv</span><span·class="p">(</span><span·class="s1">'tmp.sv'</span><span·class="p">,</span>·<span·class="n">sep</span><span·class="o">=</span><span·class="s1">'\|'</span><span·class="p">,</span>·<span·class="n">chunksize</span><span·class="o">=</span><span·class="mi">4</span><span·class="p">)</span>	2089	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[190]:·</span><span·class="n">reader</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">read_csv</span><span·class="p">(</span><span·class="s1">'tmp.sv'</span><span·class="p">,</span>·<span·class="n">sep</span><span·class="o">=</span><span·class="s1">'\|'</span><span·class="p">,</span>·<span·class="n">chunksize</span><span·class="o">=</span><span·class="mi">4</span><span·class="p">)</span>

2090	<span·class="gp">In·[191]:·</span><span·class="n">reader</span>	2090	<span·class="gp">In·[191]:·</span><span·class="n">reader</span>
2091	<span·class="gh">Out[191]:·</span><span·class="go"><pandas.io.parsers.TextFileReader·at·0xffff~~74af03a~~0></span>	2091	<span·class="gh">Out[191]:·</span><span·class="go"><pandas.io.parsers.TextFileReader·at·0xffff5f128850></span>

2092	<span·class="gp">In·[192]:·</span><span·class="k">for</span>·<span·class="n">chunk</span>·<span·class="ow">in</span>·<span·class="n">reader</span><span·class="p">:</span>	2092	<span·class="gp">In·[192]:·</span><span·class="k">for</span>·<span·class="n">chunk</span>·<span·class="ow">in</span>·<span·class="n">reader</span><span·class="p">:</span>
2093	<span·class="gp">···.....:·</span>····<span·class="nb">print</span><span·class="p">(</span><span·class="n">chunk</span><span·class="p">)</span>	2093	<span·class="gp">···.....:·</span>····<span·class="nb">print</span><span·class="p">(</span><span·class="n">chunk</span><span·class="p">)</span>
2094	<span·class="gp">···.....:·</span>	2094	<span·class="gp">···.....:·</span>
2095	<span·class="go">···Unnamed:·0·········0·········1·········2·········3</span>	2095	<span·class="go">···Unnamed:·0·········0·········1·········2·········3</span>
2096	<span·class="go">0···········0··0.469112·-0.282863·-1.509059·-1.135632</span>	2096	<span·class="go">0···········0··0.469112·-0.282863·-1.509059·-1.135632</span>
2097	<span·class="go">1···········1··1.212112·-0.173215··0.119209·-1.044236</span>	2097	<span·class="go">1···········1··1.212112·-0.173215··0.119209·-1.044236</span>
Offset 2679, 31 lines modified		Offset 2679, 31 lines modified

2679	<span·class="gp">In·[249]:·</span><span·class="n">dffloats</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">DataFrame</span><span·class="p">(</span><span·class="n">randfloats</span><span·class="p">,</span>·<span·class="n">columns</span><span·class="o">=</span><span·class="nb">list</span><span·class="p">(</span><span·class="s1">'ABCDEFGHIJ'</span><span·class="p">))</span>	2679	<span·class="gp">In·[249]:·</span><span·class="n">dffloats</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">DataFrame</span><span·class="p">(</span><span·class="n">randfloats</span><span·class="p">,</span>·<span·class="n">columns</span><span·class="o">=</span><span·class="nb">list</span><span·class="p">(</span><span·class="s1">'ABCDEFGHIJ'</span><span·class="p">))</span>

2680	<span·class="gp">In·[250]:·</span><span·class="n">jsonfloats</span>·<span·class="o">=</span>·<span·class="n">dffloats</span><span·class="o">.</span><span·class="n">to_json</span><span·class="p">()</span>	2680	<span·class="gp">In·[250]:·</span><span·class="n">jsonfloats</span>·<span·class="o">=</span>·<span·class="n">dffloats</span><span·class="o">.</span><span·class="n">to_json</span><span·class="p">()</span>
2681	</pre></div>	2681	</pre></div>
2682	</div>	2682	</div>
2683	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[251]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.read_json(jsonfloats)	2683	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[251]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.read_json(jsonfloats)
2684	<span·class="go">11.1·ms·+-·83.9·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>	2684	<span·class="go">10.7·ms·+-·30.2·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>
2685	</pre></div>	2685	</pre></div>
2686	</div>	2686	</div>
2687	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[252]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.read_json(jsonfloats,·numpy=True)	2687	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[252]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.read_json(jsonfloats,·numpy=True)
2688	<span·class="go">7.61·ms·+-·34.2·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>	2688	<span·class="go">7.27·ms·+-·18.4·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>
2689	</pre></div>	2689	</pre></div>
2690	</div>	2690	</div>
2691	<p>The·speedup·is·less·noticeable·for·smaller·datasets:</p>	2691	<p>The·speedup·is·less·noticeable·for·smaller·datasets:</p>
2692	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[253]:·</span><span·class="n">jsonfloats</span>·<span·class="o">=</span>·<span·class="n">dffloats</span><span·class="o">.</span><span·class="n">head</span><span·class="p">(</span><span·class="mi">100</span><span·class="p">)</span><span·class="o">.</span><span·class="n">to_json</span><span·class="p">()</span>	2692	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[253]:·</span><span·class="n">jsonfloats</span>·<span·class="o">=</span>·<span·class="n">dffloats</span><span·class="o">.</span><span·class="n">head</span><span·class="p">(</span><span·class="mi">100</span><span·class="p">)</span><span·class="o">.</span><span·class="n">to_json</span><span·class="p">()</span>
2693	</pre></div>	2693	</pre></div>
2694	</div>	2694	</div>
2695	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[254]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.read_json(jsonfloats)	2695	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[254]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.read_json(jsonfloats)
2696	<span·class="go">6.21·ms·+-·72.7·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>	2696	<span·class="go">5.98·ms·+-·44.2·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>
2697	</pre></div>	2697	</pre></div>
2698	</div>	2698	</div>


Offset 1717, 15 lines modified		Offset 1717, 15 lines modified
1717	8···········8··1.075770·-0.109050··1.643563·-1.469388	1717	8···········8··1.075770·-0.109050··1.643563·-1.469388
1718	9···········9··0.357021·-0.674600·-1.776904·-0.968914	1718	9···········9··0.357021·-0.674600·-1.776904·-0.968914
1719	By·specifying·a·chunksize·to·read_csv,·the·return·value·will·be·an·iterable	1719	By·specifying·a·chunksize·to·read_csv,·the·return·value·will·be·an·iterable
1720	object·of·type·TextFileReader:	1720	object·of·type·TextFileReader:
1721	In·[190]:·reader·=·pd.read_csv('tmp.sv',·sep='\|',·chunksize=4)	1721	In·[190]:·reader·=·pd.read_csv('tmp.sv',·sep='\|',·chunksize=4)

1722	In·[191]:·reader	1722	In·[191]:·reader
1723	Out[191]:·<pandas.io.parsers.TextFileReader·at·0xffff~~74af03a~~0>	1723	Out[191]:·<pandas.io.parsers.TextFileReader·at·0xffff5f128850>

1724	In·[192]:·for·chunk·in·reader:	1724	In·[192]:·for·chunk·in·reader:
1725	···.....:·····print(chunk)	1725	···.....:·····print(chunk)
1726	···.....:	1726	···.....:
1727	···Unnamed:·0·········0·········1·········2·········3	1727	···Unnamed:·0·········0·········1·········2·········3
1728	0···········0··0.469112·-0.282863·-1.509059·-1.135632	1728	0···········0··0.469112·-0.282863·-1.509059·-1.135632
1729	1···········1··1.212112·-0.173215··0.119209·-1.044236	1729	1···········1··1.212112·-0.173215··0.119209·-1.044236
Offset 2220, 23 lines modified		Offset 2220, 23 lines modified

2220	In·[248]:·randfloats.shape·=·(1000,·10)	2220	In·[248]:·randfloats.shape·=·(1000,·10)

2221	In·[249]:·dffloats·=·pd.DataFrame(randfloats,·columns=list('ABCDEFGHIJ'))	2221	In·[249]:·dffloats·=·pd.DataFrame(randfloats,·columns=list('ABCDEFGHIJ'))

2222	In·[250]:·jsonfloats·=·dffloats.to_json()	2222	In·[250]:·jsonfloats·=·dffloats.to_json()
2223	In·[251]:·%timeit·pd.read_json(jsonfloats)	2223	In·[251]:·%timeit·pd.read_json(jsonfloats)
2224	11.1·ms·+-·83.9·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	2224	10.7·ms·+-·30.2·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
2225	In·[252]:·%timeit·pd.read_json(jsonfloats,·numpy=True)	2225	In·[252]:·%timeit·pd.read_json(jsonfloats,·numpy=True)
2226	7.61·ms·+-·34.2·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	2226	7.27·ms·+-·18.4·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
2227	The·speedup·is·less·noticeable·for·smaller·datasets:	2227	The·speedup·is·less·noticeable·for·smaller·datasets:
2228	In·[253]:·jsonfloats·=·dffloats.head(100).to_json()	2228	In·[253]:·jsonfloats·=·dffloats.head(100).to_json()
2229	In·[254]:·%timeit·pd.read_json(jsonfloats)	2229	In·[254]:·%timeit·pd.read_json(jsonfloats)
2230	6.21·ms·+-·72.7·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	2230	5.98·ms·+-·44.2·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
2231	In·[255]:·%timeit·pd.read_json(jsonfloats,·numpy=True)	2231	In·[255]:·%timeit·pd.read_json(jsonfloats,·numpy=True)
2232	5.11·ms·+-·57.9·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	2232	4.91·ms·+-·47.4·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
2233	Warning	2233	Warning
2234	Direct·NumPy·decoding·makes·a·number·of·assumptions·and·may·fail·or·produce	2234	Direct·NumPy·decoding·makes·a·number·of·assumptions·and·may·fail·or·produce
2235	unexpected·output·if·these·assumptions·are·not·satisfied:	2235	unexpected·output·if·these·assumptions·are·not·satisfied:
2236	·········*·data·is·numeric.	2236	·········*·data·is·numeric.
2237	·········*·data·is·uniform.·The·dtype·is·sniffed·from·the·first·value	2237	·········*·data·is·uniform.·The·dtype·is·sniffed·from·the·first·value
2238	···········decoded.·A·ValueError·may·be·raised,·or·incorrect·output·may·be	2238	···········decoded.·A·ValueError·may·be·raised,·or·incorrect·output·may·be


Offset 314, 16 lines modified		Offset 314, 16 lines modified
314	<span·class="gp">···....:·</span><span·class="n">files</span>·<span·class="o">=</span>·<span·class="n">pathlib</span><span·class="o">.</span><span·class="n">Path</span><span·class="p">(</span><span·class="s2">"data/timeseries/"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">glob</span><span·class="p">(</span><span·class="s2">"ts*.parquet"</span><span·class="p">)</span>	314	<span·class="gp">···....:·</span><span·class="n">files</span>·<span·class="o">=</span>·<span·class="n">pathlib</span><span·class="o">.</span><span·class="n">Path</span><span·class="p">(</span><span·class="s2">"data/timeseries/"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">glob</span><span·class="p">(</span><span·class="s2">"ts*.parquet"</span><span·class="p">)</span>
315	<span·class="gp">···....:·</span><span·class="n">counts</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">Series</span><span·class="p">(</span><span·class="n">dtype</span><span·class="o">=</span><span·class="nb">int</span><span·class="p">)</span>	315	<span·class="gp">···....:·</span><span·class="n">counts</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">Series</span><span·class="p">(</span><span·class="n">dtype</span><span·class="o">=</span><span·class="nb">int</span><span·class="p">)</span>
316	<span·class="gp">···....:·</span><span·class="k">for</span>·<span·class="n">path</span>·<span·class="ow">in</span>·<span·class="n">files</span><span·class="p">:</span>	316	<span·class="gp">···....:·</span><span·class="k">for</span>·<span·class="n">path</span>·<span·class="ow">in</span>·<span·class="n">files</span><span·class="p">:</span>
317	<span·class="gp">···....:·</span>····<span·class="n">df</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">read_parquet</span><span·class="p">(</span><span·class="n">path</span><span·class="p">)</span>	317	<span·class="gp">···....:·</span>····<span·class="n">df</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">read_parquet</span><span·class="p">(</span><span·class="n">path</span><span·class="p">)</span>
318	<span·class="gp">···....:·</span>····<span·class="n">counts</span>·<span·class="o">=</span>·<span·class="n">counts</span><span·class="o">.</span><span·class="n">add</span><span·class="p">(</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'name'</span><span·class="p">]</span><span·class="o">.</span><span·class="n">value_counts</span><span·class="p">(),</span>·<span·class="n">fill_value</span><span·class="o">=</span><span·class="mi">0</span><span·class="p">)</span>	318	<span·class="gp">···....:·</span>····<span·class="n">counts</span>·<span·class="o">=</span>·<span·class="n">counts</span><span·class="o">.</span><span·class="n">add</span><span·class="p">(</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'name'</span><span·class="p">]</span><span·class="o">.</span><span·class="n">value_counts</span><span·class="p">(),</span>·<span·class="n">fill_value</span><span·class="o">=</span><span·class="mi">0</span><span·class="p">)</span>
319	<span·class="gp">···....:·</span><span·class="n">counts</span><span·class="o">.</span><span·class="n">astype</span><span·class="p">(</span><span·class="nb">int</span><span·class="p">)</span>	319	<span·class="gp">···....:·</span><span·class="n">counts</span><span·class="o">.</span><span·class="n">astype</span><span·class="p">(</span><span·class="nb">int</span><span·class="p">)</span>
320	<span·class="gp">···....:·</span>	320	<span·class="gp">···....:·</span>
321	<span·class="go">CPU·times:·user·848·us,·sys:·147·us,·total:·995·us</span>	321	<span·class="go">CPU·times:·user·849·us,·sys:·137·us,·total:·986·us</span>
322	<span·class="go">Wall·time:·1·ms</span>	322	<span·class="go">Wall·time:·995·us</span>
323	<span·class="gh">Out[19]:·</span><span·class="go">Series([],·dtype:·int64)</span>	323	<span·class="gh">Out[19]:·</span><span·class="go">Series([],·dtype:·int64)</span>
324	</pre></div>	324	</pre></div>
325	</div>	325	</div>
326	<p>Some·readers,·like·<a·class="reference·internal"·href="../reference/api/pandas.read_csv.html#pandas.read_csv"·title="pandas.read_csv"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">pandas.read_csv()</span></code></a>,·offer·parameters·to·control·the	326	<p>Some·readers,·like·<a·class="reference·internal"·href="../reference/api/pandas.read_csv.html#pandas.read_csv"·title="pandas.read_csv"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">pandas.read_csv()</span></code></a>,·offer·parameters·to·control·the
327	<code·class="docutils·literal·notranslate"><span·class="pre">chunksize</span></code>·when·reading·a·single·file.</p>	327	<code·class="docutils·literal·notranslate"><span·class="pre">chunksize</span></code>·when·reading·a·single·file.</p>
328	<p>Manually·chunking·is·an·OK·option·for·workflows·that·don’t	328	<p>Manually·chunking·is·an·OK·option·for·workflows·that·don’t
329	require·too·sophisticated·of·operations.·Some·operations,·like·<code·class="docutils·literal·notranslate"><span·class="pre">groupby</span></code>,·are	329	require·too·sophisticated·of·operations.·Some·operations,·like·<code·class="docutils·literal·notranslate"><span·class="pre">groupby</span></code>,·are


Offset 279, 16 lines modified		Offset 279, 16 lines modified
279	···....:·files·=·pathlib.Path("data/timeseries/").glob("ts*.parquet")	279	···....:·files·=·pathlib.Path("data/timeseries/").glob("ts*.parquet")
280	···....:·counts·=·pd.Series(dtype=int)	280	···....:·counts·=·pd.Series(dtype=int)
281	···....:·for·path·in·files:	281	···....:·for·path·in·files:
282	···....:·····df·=·pd.read_parquet(path)	282	···....:·····df·=·pd.read_parquet(path)
283	···....:·····counts·=·counts.add(df['name'].value_counts(),·fill_value=0)	283	···....:·····counts·=·counts.add(df['name'].value_counts(),·fill_value=0)
284	···....:·counts.astype(int)	284	···....:·counts.astype(int)
285	···....:	285	···....:
286	CPU·times:·user·848·us,·sys:·147·us,·total:·995·us	286	CPU·times:·user·849·us,·sys:·137·us,·total:·986·us
287	Wall·time:·1·ms	287	Wall·time:·995·us
288	Out[19]:·Series([],·dtype:·int64)	288	Out[19]:·Series([],·dtype:·int64)
289	Some·readers,·like·pandas.read_csv(),·offer·parameters·to·control·the·chunksize	289	Some·readers,·like·pandas.read_csv(),·offer·parameters·to·control·the·chunksize
290	when·reading·a·single·file.	290	when·reading·a·single·file.
291	Manually·chunking·is·an·OK·option·for·workflows·that·donât·require·too	291	Manually·chunking·is·an·OK·option·for·workflows·that·donât·require·too
292	sophisticated·of·operations.·Some·operations,·like·groupby,·are·much·harder·to	292	sophisticated·of·operations.·Some·operations,·like·groupby,·are·much·harder·to
293	do·chunkwise.·In·these·cases,·you·may·be·better·switching·to·a·different	293	do·chunkwise.·In·these·cases,·you·may·be·better·switching·to·a·different
294	library·that·implements·these·out-of-core·algorithms·for·you.	294	library·that·implements·these·out-of-core·algorithms·for·you.


Offset 77, 38 lines modified		Offset 77, 38 lines modified
77	The·above·output·looks·very·similar·to·the·standard·DataFrame·HTML	77	The·above·output·looks·very·similar·to·the·standard·DataFrame·HTML
78	representation.·But·weâve·done·some·work·behind·the·scenes·to·attach·CSS	78	representation.·But·weâve·done·some·work·behind·the·scenes·to·attach·CSS
79	classes·to·each·cell.·We·can·view·these·by·calling·the·.render·method.	79	classes·to·each·cell.·We·can·view·these·by·calling·the·.render·method.
80	[4]:	80	[4]:
81	df.style.highlight_null().render().split('\n')[:10]	81	df.style.highlight_null().render().split('\n')[:10]
82	[4]:	82	[4]:
83	['<style··type="text/css"·>',	83	['<style··type="text/css"·>',
84	·'#T_7f8~~bc90~~8_acc7_11ee_b~~3a1~~_17~~eea7123~~400row0_col2,#T_7f8~~bc90~~8_acc7_11ee_b~~3a1~~_17~~eea7123~~400row3_col3	84	·'#T_bb81e818_e5c2_11ef_b8f0_1b7d209e8840row0_col2,#T_bb81e818_e5c2_11ef_b8f0_1b7d209e8840row3_col3
85	{',	85	{',
86	·'············background-color:··red;',	86	·'············background-color:··red;',
87	·'········}</style><table·id="T_7f8~~bc90~~8_acc7_11ee_b~~3a1~~_17~~eea7123~~400"·><thead>	87	·'········}</style><table·id="T_bb81e818_e5c2_11ef_b8f0_1b7d209e8840"·><thead>
88	<tr>········<th·class="blank·level0"·></th>········<th·class="col_heading	88	<tr>········<th·class="blank·level0"·></th>········<th·class="col_heading
89	level0·col0"·>A</th>········<th·class="col_heading·level0·col1"·>B</th>	89	level0·col0"·>A</th>········<th·class="col_heading·level0·col1"·>B</th>
90	<th·class="col_heading·level0·col2"·>C</th>········<th·class="col_heading	90	<th·class="col_heading·level0·col2"·>C</th>········<th·class="col_heading
91	level0·col3"·>D</th>········<th·class="col_heading·level0·col4"·>E</th>····</	91	level0·col3"·>D</th>········<th·class="col_heading·level0·col4"·>E</th>····</
92	tr></thead><tbody>',	92	tr></thead><tbody>',
93	·'················<tr>',	93	·'················<tr>',
94	·'························<th	94	·'························<th
95	id="T_7f8~~bc90~~8_acc7_11ee_b~~3a1~~_17~~eea7123~~400level0_row0"·class="row_heading	95	id="T_bb81e818_e5c2_11ef_b8f0_1b7d209e8840level0_row0"·class="row_heading
96	level0·row0"·>0</th>',	96	level0·row0"·>0</th>',
97	·'························<td	97	·'························<td
98	id="T_7f8~~bc90~~8_acc7_11ee_b~~3a1~~_17~~eea7123~~400row0_col0"·class="data·row0·col0"	98	id="T_bb81e818_e5c2_11ef_b8f0_1b7d209e8840row0_col0"·class="data·row0·col0"
99	>1.000000</td>',	99	>1.000000</td>',
100	·'························<td	100	·'························<td
101	id="T_7f8~~bc90~~8_acc7_11ee_b~~3a1~~_17~~eea7123~~400row0_col1"·class="data·row0·col1"	101	id="T_bb81e818_e5c2_11ef_b8f0_1b7d209e8840row0_col1"·class="data·row0·col1"
102	>1.329212</td>',	102	>1.329212</td>',
103	·'························<td	103	·'························<td
104	id="T_7f8~~bc90~~8_acc7_11ee_b~~3a1~~_17~~eea7123~~400row0_col2"·class="data·row0·col2"	104	id="T_bb81e818_e5c2_11ef_b8f0_1b7d209e8840row0_col2"·class="data·row0·col2"
105	>nan</td>',	105	>nan</td>',
106	·'························<td	106	·'························<td
107	id="T_7f8~~bc90~~8_acc7_11ee_b~~3a1~~_17~~eea7123~~400row0_col3"·class="data·row0·col3"·>-	107	id="T_bb81e818_e5c2_11ef_b8f0_1b7d209e8840row0_col3"·class="data·row0·col3"·>-
108	0.316280</td>']	108	0.316280</td>']
109	The·row0_col2·is·the·identifier·for·that·particular·cell.·Weâve·also	109	The·row0_col2·is·the·identifier·for·that·particular·cell.·Weâve·also
110	prepended·each·row/column·identifier·with·a·UUID·unique·to·each·DataFrame·so	110	prepended·each·row/column·identifier·with·a·UUID·unique·to·each·DataFrame·so
111	that·the·style·from·one·doesnât·collide·with·the·styling·from·another·within	111	that·the·style·from·one·doesnât·collide·with·the·styling·from·another·within
112	the·same·notebook·or·page·(you·can·set·the·uuid·if·youâd·like·to·tie·together	112	the·same·notebook·or·page·(you·can·set·the·uuid·if·youâd·like·to·tie·together
113	the·styling·of·two·DataFrames).	113	the·styling·of·two·DataFrames).
114	When·writing·style·functions,·you·take·care·of·producing·the·CSS·attribute·/	114	When·writing·style·functions,·you·take·care·of·producing·the·CSS·attribute·/


Offset 2344, 24 lines modified		Offset 2344, 24 lines modified
2344	<span·class="gp">···.....:·</span>	2344	<span·class="gp">···.....:·</span>

2345	<span·class="gp">In·[271]:·</span><span·class="n">cal</span>·<span·class="o">=</span>·<span·class="n">get_calendar</span><span·class="p">(</span><span·class="s1">'ExampleCalendar'</span><span·class="p">)</span>	2345	<span·class="gp">In·[271]:·</span><span·class="n">cal</span>·<span·class="o">=</span>·<span·class="n">get_calendar</span><span·class="p">(</span><span·class="s1">'ExampleCalendar'</span><span·class="p">)</span>

2346	<span·class="gp">In·[272]:·</span><span·class="n">cal</span><span·class="o">.</span><span·class="n">rules</span>	2346	<span·class="gp">In·[272]:·</span><span·class="n">cal</span><span·class="o">.</span><span·class="n">rules</span>
2347	<span·class="gh">Out[272]:·</span><span·class="go"></span>	2347	<span·class="gh">Out[272]:·</span><span·class="go"></span>
2348	<span·class="go">[Holiday:·Memorial·Day·(month=5,·day=31,·offset=<DateOffset:·weekday=MO(-1)>),</span>	2348	<span·class="go">[Holiday:·Memorial·Day·(month=5,·day=31,·offset=<DateOffset:·weekday=MO(-1)>),</span>
2349	<span·class="go">·Holiday:·July·4th·(month=7,·day=4,·observance=<function·nearest_workday·at·0xffff~~6f76ac1~~0>),</span>	2349	<span·class="go">·Holiday:·July·4th·(month=7,·day=4,·observance=<function·nearest_workday·at·0xffff58f89160>),</span>
2350	<span·class="go">·Holiday:·Columbus·Day·(month=10,·day=1,·offset=<DateOffset:·weekday=MO(+2)>)]</span>	2350	<span·class="go">·Holiday:·Columbus·Day·(month=10,·day=1,·offset=<DateOffset:·weekday=MO(+2)>)]</span>

2351	<span·class="gp">In·[273]:·</span><span·class="n">new_cal</span>·<span·class="o">=</span>·<span·class="n">HolidayCalendarFactory</span><span·class="p">(</span><span·class="s1">'NewExampleCalendar'</span><span·class="p">,</span>·<span·class="n">cal</span><span·class="p">,</span>·<span·class="n">USLaborDay</span><span·class="p">)</span>	2351	<span·class="gp">In·[273]:·</span><span·class="n">new_cal</span>·<span·class="o">=</span>·<span·class="n">HolidayCalendarFactory</span><span·class="p">(</span><span·class="s1">'NewExampleCalendar'</span><span·class="p">,</span>·<span·class="n">cal</span><span·class="p">,</span>·<span·class="n">USLaborDay</span><span·class="p">)</span>

2352	<span·class="gp">In·[274]:·</span><span·class="n">new_cal</span><span·class="o">.</span><span·class="n">rules</span>	2352	<span·class="gp">In·[274]:·</span><span·class="n">new_cal</span><span·class="o">.</span><span·class="n">rules</span>
2353	<span·class="gh">Out[274]:·</span><span·class="go"></span>	2353	<span·class="gh">Out[274]:·</span><span·class="go"></span>
2354	<span·class="go">[Holiday:·Labor·Day·(month=9,·day=1,·offset=<DateOffset:·weekday=MO(+1)>),</span>	2354	<span·class="go">[Holiday:·Labor·Day·(month=9,·day=1,·offset=<DateOffset:·weekday=MO(+1)>),</span>
2355	<span·class="go">·Holiday:·Memorial·Day·(month=5,·day=31,·offset=<DateOffset:·weekday=MO(-1)>),</span>	2355	<span·class="go">·Holiday:·Memorial·Day·(month=5,·day=31,·offset=<DateOffset:·weekday=MO(-1)>),</span>
2356	<span·class="go">·Holiday:·July·4th·(month=7,·day=4,·observance=<function·nearest_workday·at·0xffff~~6f76ac1~~0>),</span>	2356	<span·class="go">·Holiday:·July·4th·(month=7,·day=4,·observance=<function·nearest_workday·at·0xffff58f89160>),</span>
2357	<span·class="go">·Holiday:·Columbus·Day·(month=10,·day=1,·offset=<DateOffset:·weekday=MO(+2)>)]</span>	2357	<span·class="go">·Holiday:·Columbus·Day·(month=10,·day=1,·offset=<DateOffset:·weekday=MO(+2)>)]</span>
2358	</pre></div>	2358	</pre></div>
2359	</div>	2359	</div>
2360	</div>	2360	</div>
2361	</div>	2361	</div>
2362	<div·class="section"·id="time-series-related-instance-methods">	2362	<div·class="section"·id="time-series-related-instance-methods">
2363	<span·id="timeseries-advanced-datetime"></span><h2>Time·series-related·instance·methods<a·class="headerlink"·href="#time-series-related-instance-methods"·title="Permalink·to·this·headline">¶</a></h2>	2363	<span·id="timeseries-advanced-datetime"></span><h2>Time·series-related·instance·methods<a·class="headerlink"·href="#time-series-related-instance-methods"·title="Permalink·to·this·headline">¶</a></h2>


Offset 1745, 26 lines modified		Offset 1745, 26 lines modified

1745	In·[271]:·cal·=·get_calendar('ExampleCalendar')	1745	In·[271]:·cal·=·get_calendar('ExampleCalendar')

1746	In·[272]:·cal.rules	1746	In·[272]:·cal.rules
1747	Out[272]:	1747	Out[272]:
1748	[Holiday:·Memorial·Day·(month=5,·day=31,·offset=<DateOffset:·weekday=MO(-1)>),	1748	[Holiday:·Memorial·Day·(month=5,·day=31,·offset=<DateOffset:·weekday=MO(-1)>),
1749	·Holiday:·July·4th·(month=7,·day=4,·observance=<function·nearest_workday·at	1749	·Holiday:·July·4th·(month=7,·day=4,·observance=<function·nearest_workday·at
1750	0xffff~~6f76ac1~~0>),	1750	0xffff58f89160>),
1751	·Holiday:·Columbus·Day·(month=10,·day=1,·offset=<DateOffset:·weekday=MO(+2)>)]	1751	·Holiday:·Columbus·Day·(month=10,·day=1,·offset=<DateOffset:·weekday=MO(+2)>)]

1752	In·[273]:·new_cal·=·HolidayCalendarFactory('NewExampleCalendar',·cal,	1752	In·[273]:·new_cal·=·HolidayCalendarFactory('NewExampleCalendar',·cal,
1753	USLaborDay)	1753	USLaborDay)

1754	In·[274]:·new_cal.rules	1754	In·[274]:·new_cal.rules
1755	Out[274]:	1755	Out[274]:
1756	[Holiday:·Labor·Day·(month=9,·day=1,·offset=<DateOffset:·weekday=MO(+1)>),	1756	[Holiday:·Labor·Day·(month=9,·day=1,·offset=<DateOffset:·weekday=MO(+1)>),
1757	·Holiday:·Memorial·Day·(month=5,·day=31,·offset=<DateOffset:·weekday=MO(-1)>),	1757	·Holiday:·Memorial·Day·(month=5,·day=31,·offset=<DateOffset:·weekday=MO(-1)>),
1758	·Holiday:·July·4th·(month=7,·day=4,·observance=<function·nearest_workday·at	1758	·Holiday:·July·4th·(month=7,·day=4,·observance=<function·nearest_workday·at
1759	0xffff~~6f76ac1~~0>),	1759	0xffff58f89160>),
1760	·Holiday:·Columbus·Day·(month=10,·day=1,·offset=<DateOffset:·weekday=MO(+2)>)]	1760	·Holiday:·Columbus·Day·(month=10,·day=1,·offset=<DateOffset:·weekday=MO(+2)>)]
1761	***·Time·series-related·instance·methodsÂ¶·***	1761	***·Time·series-related·instance·methodsÂ¶·***
1762	**·Shifting·/·laggingÂ¶·**	1762	**·Shifting·/·laggingÂ¶·**
1763	One·may·want·to·shift·or·lag·the·values·in·a·time·series·back·and·forward·in	1763	One·may·want·to·shift·or·lag·the·values·in·a·time·series·back·and·forward·in
1764	time.·The·method·for·this·is·shift(),·which·is·available·on·all·of·the·pandas	1764	time.·The·method·for·this·is·shift(),·which·is·available·on·all·of·the·pandas
1765	objects.	1765	objects.
1766	In·[275]:·ts·=·pd.Series(range(len(rng)),·index=rng)	1766	In·[275]:·ts·=·pd.Series(range(len(rng)),·index=rng)


Offset 856, 15 lines modified		Offset 856, 15 lines modified
856	<div·class="section"·id="plotting-on-a-secondary-y-axis">	856	<div·class="section"·id="plotting-on-a-secondary-y-axis">
857	<h3>Plotting·on·a·secondary·y-axis<a·class="headerlink"·href="#plotting-on-a-secondary-y-axis"·title="Permalink·to·this·headline">¶</a></h3>	857	<h3>Plotting·on·a·secondary·y-axis<a·class="headerlink"·href="#plotting-on-a-secondary-y-axis"·title="Permalink·to·this·headline">¶</a></h3>
858	<p>To·plot·data·on·a·secondary·y-axis,·use·the·<code·class="docutils·literal·notranslate"><span·class="pre">secondary_y</span></code>·keyword:</p>	858	<p>To·plot·data·on·a·secondary·y-axis,·use·the·<code·class="docutils·literal·notranslate"><span·class="pre">secondary_y</span></code>·keyword:</p>
859	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[123]:·</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'A'</span><span·class="p">]</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">()</span>	859	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[123]:·</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'A'</span><span·class="p">]</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">()</span>
860	<span·class="gh">Out[123]:·</span><span·class="go"><AxesSubplot:></span>	860	<span·class="gh">Out[123]:·</span><span·class="go"><AxesSubplot:></span>

861	<span·class="gp">In·[124]:·</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'B'</span><span·class="p">]</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">(</span><span·class="n">secondary_y</span><span·class="o">=</span><span·class="kc">True</span><span·class="p">,</span>·<span·class="n">style</span><span·class="o">=</span><span·class="s1">'g'</span><span·class="p">)</span>	861	<span·class="gp">In·[124]:·</span><span·class="n">df</span><span·class="p">[</span><span·class="s1">'B'</span><span·class="p">]</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">(</span><span·class="n">secondary_y</span><span·class="o">=</span><span·class="kc">True</span><span·class="p">,</span>·<span·class="n">style</span><span·class="o">=</span><span·class="s1">'g'</span><span·class="p">)</span>
862	<span·class="gh">Out[124]:·</span><span·class="go"><AxesSubplot:label='~~cd6b~~5~~5be~~-7baf-4~~b4c~~-~~b716~~-023c~~5c1~~de6d6'></span>	862	<span·class="gh">Out[124]:·</span><span·class="go"><AxesSubplot:label='d4dd59c0-afab-41f8-ad69-09ce9fd61ad5'></span>
863	</pre></div>	863	</pre></div>
864	</div>	864	</div>
865	<img·alt="../_images/series_plot_secondary_y.png"·src="../_images/series_plot_secondary_y.png"·/>	865	<img·alt="../_images/series_plot_secondary_y.png"·src="../_images/series_plot_secondary_y.png"·/>
866	<p>To·plot·some·columns·in·a·<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame</span></code>,·give·the·column·names·to·the·<code·class="docutils·literal·notranslate"><span·class="pre">secondary_y</span></code>	866	<p>To·plot·some·columns·in·a·<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame</span></code>,·give·the·column·names·to·the·<code·class="docutils·literal·notranslate"><span·class="pre">secondary_y</span></code>
867	keyword:</p>	867	keyword:</p>
868	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[125]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">figure</span><span·class="p">()</span>	868	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[125]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">figure</span><span·class="p">()</span>
869	<span·class="gh">Out[125]:·</span><span·class="go"><Figure·size·640x480·with·0·Axes></span>	869	<span·class="gh">Out[125]:·</span><span·class="go"><Figure·size·640x480·with·0·Axes></span>
Offset 1116, 15 lines modified		Offset 1116, 15 lines modified
1116	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[172]:·</span><span·class="kn">from</span>·<span·class="nn">pandas.plotting</span>·<span·class="kn">import</span>·<span·class="n">table</span>	1116	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[172]:·</span><span·class="kn">from</span>·<span·class="nn">pandas.plotting</span>·<span·class="kn">import</span>·<span·class="n">table</span>

1117	<span·class="gp">In·[173]:·</span><span·class="n">fig</span><span·class="p">,</span>·<span·class="n">ax</span>·<span·class="o">=</span>·<span·class="n">plt</span><span·class="o">.</span><span·class="n">subplots</span><span·class="p">(</span><span·class="mi">1</span><span·class="p">,</span>·<span·class="mi">1</span><span·class="p">)</span>	1117	<span·class="gp">In·[173]:·</span><span·class="n">fig</span><span·class="p">,</span>·<span·class="n">ax</span>·<span·class="o">=</span>·<span·class="n">plt</span><span·class="o">.</span><span·class="n">subplots</span><span·class="p">(</span><span·class="mi">1</span><span·class="p">,</span>·<span·class="mi">1</span><span·class="p">)</span>

1118	<span·class="gp">In·[174]:·</span><span·class="n">table</span><span·class="p">(</span><span·class="n">ax</span><span·class="p">,</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">round</span><span·class="p">(</span><span·class="n">df</span><span·class="o">.</span><span·class="n">describe</span><span·class="p">(),</span>·<span·class="mi">2</span><span·class="p">),</span>	1118	<span·class="gp">In·[174]:·</span><span·class="n">table</span><span·class="p">(</span><span·class="n">ax</span><span·class="p">,</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">round</span><span·class="p">(</span><span·class="n">df</span><span·class="o">.</span><span·class="n">describe</span><span·class="p">(),</span>·<span·class="mi">2</span><span·class="p">),</span>
1119	<span·class="gp">···.....:·</span>······<span·class="n">loc</span><span·class="o">=</span><span·class="s1">'upper·right'</span><span·class="p">,</span>·<span·class="n">colWidths</span><span·class="o">=</span><span·class="p">[</span><span·class="mf">0.2</span><span·class="p">,</span>·<span·class="mf">0.2</span><span·class="p">,</span>·<span·class="mf">0.2</span><span·class="p">])</span>	1119	<span·class="gp">···.....:·</span>······<span·class="n">loc</span><span·class="o">=</span><span·class="s1">'upper·right'</span><span·class="p">,</span>·<span·class="n">colWidths</span><span·class="o">=</span><span·class="p">[</span><span·class="mf">0.2</span><span·class="p">,</span>·<span·class="mf">0.2</span><span·class="p">,</span>·<span·class="mf">0.2</span><span·class="p">])</span>
1120	<span·class="gp">···.....:·</span>	1120	<span·class="gp">···.....:·</span>
1121	<span·class="gh">Out[174]:·</span><span·class="go"><matplotlib.table.Table·at·0xffff~~71a~~6~~f8b~~0></span>	1121	<span·class="gh">Out[174]:·</span><span·class="go"><matplotlib.table.Table·at·0xffff5b369580></span>

1122	<span·class="gp">In·[175]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">(</span><span·class="n">ax</span><span·class="o">=</span><span·class="n">ax</span><span·class="p">,</span>·<span·class="n">ylim</span><span·class="o">=</span><span·class="p">(</span><span·class="mi">0</span><span·class="p">,</span>·<span·class="mi">2</span><span·class="p">),</span>·<span·class="n">legend</span><span·class="o">=</span><span·class="kc">None</span><span·class="p">)</span>	1122	<span·class="gp">In·[175]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">(</span><span·class="n">ax</span><span·class="o">=</span><span·class="n">ax</span><span·class="p">,</span>·<span·class="n">ylim</span><span·class="o">=</span><span·class="p">(</span><span·class="mi">0</span><span·class="p">,</span>·<span·class="mi">2</span><span·class="p">),</span>·<span·class="n">legend</span><span·class="o">=</span><span·class="kc">None</span><span·class="p">)</span>
1123	<span·class="gh">Out[175]:·</span><span·class="go"><AxesSubplot:></span>	1123	<span·class="gh">Out[175]:·</span><span·class="go"><AxesSubplot:></span>
1124	</pre></div>	1124	</pre></div>
1125	</div>	1125	</div>
1126	<img·alt="../_images/line_plot_table_describe.png"·src="../_images/line_plot_table_describe.png"·/>	1126	<img·alt="../_images/line_plot_table_describe.png"·src="../_images/line_plot_table_describe.png"·/>
1127	<p><strong>Note</strong>:·You·can·get·table·instances·on·the·axes·using·<code·class="docutils·literal·notranslate"><span·class="pre">axes.tables</span></code>·property·for·further·decorations.·See·the·<a·class="reference·external"·href="https://matplotlib.org/api/axes_api.html#matplotlib.axes.Axes.table">matplotlib·table·documentation</a>·for·more.</p>	1127	<p><strong>Note</strong>:·You·can·get·table·instances·on·the·axes·using·<code·class="docutils·literal·notranslate"><span·class="pre">axes.tables</span></code>·property·for·further·decorations.·See·the·<a·class="reference·external"·href="https://matplotlib.org/api/axes_api.html#matplotlib.axes.Axes.table">matplotlib·table·documentation</a>·for·more.</p>
Offset 1218, 23 lines modified		Offset 1218, 23 lines modified

1218	<span·class="gp">In·[193]:·</span><span·class="n">mstd</span>·<span·class="o">=</span>·<span·class="n">price</span><span·class="o">.</span><span·class="n">rolling</span><span·class="p">(</span><span·class="mi">20</span><span·class="p">)</span><span·class="o">.</span><span·class="n">std</span><span·class="p">()</span>	1218	<span·class="gp">In·[193]:·</span><span·class="n">mstd</span>·<span·class="o">=</span>·<span·class="n">price</span><span·class="o">.</span><span·class="n">rolling</span><span·class="p">(</span><span·class="mi">20</span><span·class="p">)</span><span·class="o">.</span><span·class="n">std</span><span·class="p">()</span>

1219	<span·class="gp">In·[194]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">figure</span><span·class="p">()</span>	1219	<span·class="gp">In·[194]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">figure</span><span·class="p">()</span>
1220	<span·class="gh">Out[194]:·</span><span·class="go"><Figure·size·640x480·with·0·Axes></span>	1220	<span·class="gh">Out[194]:·</span><span·class="go"><Figure·size·640x480·with·0·Axes></span>

1221	<span·class="gp">In·[195]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">(</span><span·class="n">price</span><span·class="o">.</span><span·class="n">index</span><span·class="p">,</span>·<span·class="n">price</span><span·class="p">,</span>·<span·class="s1">'k'</span><span·class="p">)</span>	1221	<span·class="gp">In·[195]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">(</span><span·class="n">price</span><span·class="o">.</span><span·class="n">index</span><span·class="p">,</span>·<span·class="n">price</span><span·class="p">,</span>·<span·class="s1">'k'</span><span·class="p">)</span>
1222	<span·class="gh">Out[195]:·</span><span·class="go">[<matplotlib.lines.Line2D·at·0xffff~~73b789a~~0>]</span>	1222	<span·class="gh">Out[195]:·</span><span·class="go">[<matplotlib.lines.Line2D·at·0xffff5853c8e0>]</span>

1223	<span·class="gp">In·[196]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">(</span><span·class="n">ma</span><span·class="o">.</span><span·class="n">index</span><span·class="p">,</span>·<span·class="n">ma</span><span·class="p">,</span>·<span·class="s1">'b'</span><span·class="p">)</span>	1223	<span·class="gp">In·[196]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">plot</span><span·class="p">(</span><span·class="n">ma</span><span·class="o">.</span><span·class="n">index</span><span·class="p">,</span>·<span·class="n">ma</span><span·class="p">,</span>·<span·class="s1">'b'</span><span·class="p">)</span>
1224	<span·class="gh">Out[196]:·</span><span·class="go">[<matplotlib.lines.Line2D·at·0xffff~~73afe~~460>]</span>	1224	<span·class="gh">Out[196]:·</span><span·class="go">[<matplotlib.lines.Line2D·at·0xffff5856a460>]</span>

1225	<span·class="gp">In·[197]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">fill_between</span><span·class="p">(</span><span·class="n">mstd</span><span·class="o">.</span><span·class="n">index</span><span·class="p">,</span>·<span·class="n">ma</span>·<span·class="o">-</span>·<span·class="mi">2</span>·<span·class="o"></span>·<span·class="n">mstd</span><span·class="p">,</span>·<span·class="n">ma</span>·<span·class="o">+</span>·<span·class="mi">2</span>·<span·class="o"></span>·<span·class="n">mstd</span><span·class="p">,</span>	1225	<span·class="gp">In·[197]:·</span><span·class="n">plt</span><span·class="o">.</span><span·class="n">fill_between</span><span·class="p">(</span><span·class="n">mstd</span><span·class="o">.</span><span·class="n">index</span><span·class="p">,</span>·<span·class="n">ma</span>·<span·class="o">-</span>·<span·class="mi">2</span>·<span·class="o"></span>·<span·class="n">mstd</span><span·class="p">,</span>·<span·class="n">ma</span>·<span·class="o">+</span>·<span·class="mi">2</span>·<span·class="o"></span>·<span·class="n">mstd</span><span·class="p">,</span>
1226	<span·class="gp">···.....:·</span>·················<span·class="n">color</span><span·class="o">=</span><span·class="s1">'b'</span><span·class="p">,</span>·<span·class="n">alpha</span><span·class="o">=</span><span·class="mf">0.2</span><span·class="p">)</span>	1226	<span·class="gp">···.....:·</span>·················<span·class="n">color</span><span·class="o">=</span><span·class="s1">'b'</span><span·class="p">,</span>·<span·class="n">alpha</span><span·class="o">=</span><span·class="mf">0.2</span><span·class="p">)</span>
1227	<span·class="gp">···.....:·</span>	1227	<span·class="gp">···.....:·</span>
1228	<span·class="gh">Out[197]:·</span><span·class="go"><matplotlib.collections.PolyCollection·at·0xffff~~73afe85~~0></span>	1228	<span·class="gh">Out[197]:·</span><span·class="go"><matplotlib.collections.PolyCollection·at·0xffff5856a6d0></span>
1229	</pre></div>	1229	</pre></div>
1230	</div>	1230	</div>
1231	<img·alt="../_images/bollinger.png"·src="../_images/bollinger.png"·/>	1231	<img·alt="../_images/bollinger.png"·src="../_images/bollinger.png"·/>
1232	</div>	1232	</div>
1233	<div·class="section"·id="plotting-backends">	1233	<div·class="section"·id="plotting-backends">
1234	<h2>Plotting·backends<a·class="headerlink"·href="#plotting-backends"·title="Permalink·to·this·headline">¶</a></h2>	1234	<h2>Plotting·backends<a·class="headerlink"·href="#plotting-backends"·title="Permalink·to·this·headline">¶</a></h2>
1235	<p>Starting·in·version·0.25,·pandas·can·be·extended·with·third-party·plotting·backends.·The	1235	<p>Starting·in·version·0.25,·pandas·can·be·extended·with·third-party·plotting·backends.·The


Offset 602, 15 lines modified		Offset 602, 15 lines modified
602	See·also·the·logx·and·loglog·keyword·arguments.	602	See·also·the·logx·and·loglog·keyword·arguments.
603	**·Plotting·on·a·secondary·y-axisÂ¶·**	603	**·Plotting·on·a·secondary·y-axisÂ¶·**
604	To·plot·data·on·a·secondary·y-axis,·use·the·secondary_y·keyword:	604	To·plot·data·on·a·secondary·y-axis,·use·the·secondary_y·keyword:
605	In·[123]:·df['A'].plot()	605	In·[123]:·df['A'].plot()
606	Out[123]:·<AxesSubplot:>	606	Out[123]:·<AxesSubplot:>

607	In·[124]:·df['B'].plot(secondary_y=True,·style='g')	607	In·[124]:·df['B'].plot(secondary_y=True,·style='g')
608	Out[124]:·<AxesSubplot:label='~~cd6b~~5~~5be~~-7baf-4~~b4c~~-~~b716~~-023c~~5c1~~de6d6'>	608	Out[124]:·<AxesSubplot:label='d4dd59c0-afab-41f8-ad69-09ce9fd61ad5'>
609	[../_images/series_plot_secondary_y.png]	609	[../_images/series_plot_secondary_y.png]
610	To·plot·some·columns·in·a·DataFrame,·give·the·column·names·to·the·secondary_y	610	To·plot·some·columns·in·a·DataFrame,·give·the·column·names·to·the·secondary_y
611	keyword:	611	keyword:
612	In·[125]:·plt.figure()	612	In·[125]:·plt.figure()
613	Out[125]:·<Figure·size·640x480·with·0·Axes>	613	Out[125]:·<Figure·size·640x480·with·0·Axes>

614	In·[126]:·ax·=·df.plot(secondary_y=['A',·'B'])	614	In·[126]:·ax·=·df.plot(secondary_y=['A',·'B'])
Offset 827, 15 lines modified		Offset 827, 15 lines modified
827	In·[172]:·from·pandas.plotting·import·table	827	In·[172]:·from·pandas.plotting·import·table

828	In·[173]:·fig,·ax·=·plt.subplots(1,·1)	828	In·[173]:·fig,·ax·=·plt.subplots(1,·1)

829	In·[174]:·table(ax,·np.round(df.describe(),·2),	829	In·[174]:·table(ax,·np.round(df.describe(),·2),
830	···.....:·······loc='upper·right',·colWidths=[0.2,·0.2,·0.2])	830	···.....:·······loc='upper·right',·colWidths=[0.2,·0.2,·0.2])
831	···.....:	831	···.....:
832	Out[174]:·<matplotlib.table.Table·at·0xffff~~71a~~6~~f8b~~0>	832	Out[174]:·<matplotlib.table.Table·at·0xffff5b369580>

833	In·[175]:·df.plot(ax=ax,·ylim=(0,·2),·legend=None)	833	In·[175]:·df.plot(ax=ax,·ylim=(0,·2),·legend=None)
834	Out[175]:·<AxesSubplot:>	834	Out[175]:·<AxesSubplot:>
835	[../_images/line_plot_table_describe.png]	835	[../_images/line_plot_table_describe.png]
836	Note:·You·can·get·table·instances·on·the·axes·using·axes.tables·property·for	836	Note:·You·can·get·table·instances·on·the·axes·using·axes.tables·property·for
837	further·decorations.·See·the·matplotlib_table_documentation·for·more.	837	further·decorations.·See·the·matplotlib_table_documentation·for·more.
838	**·ColormapsÂ¶·**	838	**·ColormapsÂ¶·**
Offset 914, 23 lines modified		Offset 914, 23 lines modified

914	In·[193]:·mstd·=·price.rolling(20).std()	914	In·[193]:·mstd·=·price.rolling(20).std()

915	In·[194]:·plt.figure()	915	In·[194]:·plt.figure()
916	Out[194]:·<Figure·size·640x480·with·0·Axes>	916	Out[194]:·<Figure·size·640x480·with·0·Axes>

917	In·[195]:·plt.plot(price.index,·price,·'k')	917	In·[195]:·plt.plot(price.index,·price,·'k')
918	Out[195]:·[<matplotlib.lines.Line2D·at·0xffff~~73b789a~~0>]	918	Out[195]:·[<matplotlib.lines.Line2D·at·0xffff5853c8e0>]

919	In·[196]:·plt.plot(ma.index,·ma,·'b')	919	In·[196]:·plt.plot(ma.index,·ma,·'b')
920	Out[196]:·[<matplotlib.lines.Line2D·at·0xffff~~73afe~~460>]	920	Out[196]:·[<matplotlib.lines.Line2D·at·0xffff5856a460>]

921	In·[197]:·plt.fill_between(mstd.index,·ma·-·2··mstd,·ma·+·2··mstd,	921	In·[197]:·plt.fill_between(mstd.index,·ma·-·2··mstd,·ma·+·2··mstd,
922	···.....:··················color='b',·alpha=0.2)	922	···.....:··················color='b',·alpha=0.2)
923	···.....:	923	···.....:
924	Out[197]:·<matplotlib.collections.PolyCollection·at·0xffff~~73afe85~~0>	924	Out[197]:·<matplotlib.collections.PolyCollection·at·0xffff5856a6d0>
925	[../_images/bollinger.png]	925	[../_images/bollinger.png]
926	***·Plotting·backendsÂ¶·***	926	***·Plotting·backendsÂ¶·***
927	Starting·in·version·0.25,·pandas·can·be·extended·with·third-party·plotting	927	Starting·in·version·0.25,·pandas·can·be·extended·with·third-party·plotting
928	backends.·The·main·idea·is·letting·users·select·a·plotting·backend·different	928	backends.·The·main·idea·is·letting·users·select·a·plotting·backend·different
929	than·the·provided·one·based·on·Matplotlib.	929	than·the·provided·one·based·on·Matplotlib.
930	This·can·be·done·by·passsing·âbackend.moduleâ·as·the·argument·backend·in	930	This·can·be·done·by·passsing·âbackend.moduleâ·as·the·argument·backend·in
931	plot·function.·For·example:	931	plot·function.·For·example:


Offset 1010, 20 lines modified		Offset 1010, 20 lines modified
1010	<span·class="gp">In·[103]:·</span><span·class="n">df1</span><span·class="p">,</span>·<span·class="n">df2</span><span·class="p">,</span>·<span·class="n">df3</span><span·class="p">,</span>·<span·class="n">df4</span>·<span·class="o">=</span>·<span·class="p">[</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">DataFrame</span><span·class="p">(</span><span·class="n">np</span><span·class="o">.</span><span·class="n">random</span><span·class="o">.</span><span·class="n">randn</span><span·class="p">(</span><span·class="n">nrows</span><span·class="p">,</span>·<span·class="n">ncols</span><span·class="p">))</span>	1010	<span·class="gp">In·[103]:·</span><span·class="n">df1</span><span·class="p">,</span>·<span·class="n">df2</span><span·class="p">,</span>·<span·class="n">df3</span><span·class="p">,</span>·<span·class="n">df4</span>·<span·class="o">=</span>·<span·class="p">[</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">DataFrame</span><span·class="p">(</span><span·class="n">np</span><span·class="o">.</span><span·class="n">random</span><span·class="o">.</span><span·class="n">randn</span><span·class="p">(</span><span·class="n">nrows</span><span·class="p">,</span>·<span·class="n">ncols</span><span·class="p">))</span>
1011	<span·class="gp">···.....:·</span>······················<span·class="k">for</span>·<span·class="n">_</span>·<span·class="ow">in</span>·<span·class="nb">range</span><span·class="p">(</span><span·class="mi">4</span><span·class="p">)]</span>	1011	<span·class="gp">···.....:·</span>······················<span·class="k">for</span>·<span·class="n">_</span>·<span·class="ow">in</span>·<span·class="nb">range</span><span·class="p">(</span><span·class="mi">4</span><span·class="p">)]</span>
1012	<span·class="gp">···.....:·</span>	1012	<span·class="gp">···.....:·</span>
1013	</pre></div>	1013	</pre></div>
1014	</div>	1014	</div>
1015	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·eval·with·NumExpr·backend</span>	1015	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·eval·with·NumExpr·backend</span>
1016	<span·class="gp">In·[104]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.eval('df1·+·df2·+·df3·+·df4')	1016	<span·class="gp">In·[104]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.eval('df1·+·df2·+·df3·+·df4')
1017	<span·class="go">9.09·ms·+-·~~204~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>	1017	<span·class="go">8.87·ms·+-·571·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>
1018	</pre></div>	1018	</pre></div>
1019	</div>	1019	</div>
1020	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·pure·Python·evaluation</span>	1020	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·pure·Python·evaluation</span>
1021	<span·class="gp">In·[105]:·</span><span·class="o">%</span><span·class="k">timeit</span>·df1·+·df2·+·df3·+·df4	1021	<span·class="gp">In·[105]:·</span><span·class="o">%</span><span·class="k">timeit</span>·df1·+·df2·+·df3·+·df4
1022	<span·class="go">10·ms·+-·~~115~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>	1022	<span·class="go">8.85·ms·+-·74.8·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>
1023	</pre></div>	1023	</pre></div>
1024	</div>	1024	</div>
1025	<p>For·more·details,·see·the·<a·class="reference·internal"·href="../user_guide/enhancingperf.html#enhancingperf-eval"><span·class="std·std-ref">the·docs</span></a></p>	1025	<p>For·more·details,·see·the·<a·class="reference·internal"·href="../user_guide/enhancingperf.html#enhancingperf-eval"><span·class="std·std-ref">the·docs</span></a></p>
1026	</li>	1026	</li>
1027	<li><p>Similar·to·<code·class="docutils·literal·notranslate"><span·class="pre">pandas.eval</span></code>,·<a·class="reference·internal"·href="../reference/api/pandas.DataFrame.html#pandas.DataFrame"·title="pandas.DataFrame"><code·class="xref·py·py-class·docutils·literal·notranslate"><span·class="pre">DataFrame</span></code></a>·has·a·new	1027	<li><p>Similar·to·<code·class="docutils·literal·notranslate"><span·class="pre">pandas.eval</span></code>,·<a·class="reference·internal"·href="../reference/api/pandas.DataFrame.html#pandas.DataFrame"·title="pandas.DataFrame"><code·class="xref·py·py-class·docutils·literal·notranslate"><span·class="pre">DataFrame</span></code></a>·has·a·new
1028	<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame.eval</span></code>·method·that·evaluates·an·expression·in·the·context·of	1028	<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame.eval</span></code>·method·that·evaluates·an·expression·in·the·context·of
1029	the·<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame</span></code>.·For·example,</p>	1029	the·<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame</span></code>.·For·example,</p>


Offset 864, 18 lines modified		Offset 864, 18 lines modified

864	······In·[103]:·df1,·df2,·df3,·df4·=·[pd.DataFrame(np.random.randn(nrows,	864	······In·[103]:·df1,·df2,·df3,·df4·=·[pd.DataFrame(np.random.randn(nrows,
865	······ncols))	865	······ncols))
866	·········.....:·······················for·_·in·range(4)]	866	·········.....:·······················for·_·in·range(4)]
867	·········.....:	867	·········.....:
868	······#·eval·with·NumExpr·backend	868	······#·eval·with·NumExpr·backend
869	······In·[104]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4')	869	······In·[104]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4')
870	······9.09·ms·+-·~~204~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	870	······8.87·ms·+-·571·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
871	······#·pure·Python·evaluation	871	······#·pure·Python·evaluation
872	······In·[105]:·%timeit·df1·+·df2·+·df3·+·df4	872	······In·[105]:·%timeit·df1·+·df2·+·df3·+·df4
873	······10·ms·+-·~~115~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	873	······8.85·ms·+-·74.8·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
874	······For·more·details,·see·the·the_docs	874	······For·more·details,·see·the·the_docs
875	····*·Similar·to·pandas.eval,·DataFrame·has·a·new·DataFrame.eval·method·that	875	····*·Similar·to·pandas.eval,·DataFrame·has·a·new·DataFrame.eval·method·that
876	······evaluates·an·expression·in·the·context·of·the·DataFrame.·For·example,	876	······evaluates·an·expression·in·the·context·of·the·DataFrame.·For·example,
877	······In·[106]:·df·=·pd.DataFrame(np.random.randn(10,·2),·columns=['a',·'b'])	877	······In·[106]:·df·=·pd.DataFrame(np.random.randn(10,·2),·columns=['a',·'b'])

878	······In·[107]:·df.eval('a·+·b')	878	······In·[107]:·df.eval('a·+·b')
879	······Out[107]:	879	······Out[107]:


Offset 854, 18 lines modified		Offset 854, 18 lines modified
854	</div>	854	</div>
855	<div·class="admonition·note">	855	<div·class="admonition·note">
856	<p·class="admonition-title">Note</p>	856	<p·class="admonition-title">Note</p>
857	<p>If·you·want·to·perform·calculations·based·on·today’s·date,·use·<code·class="docutils·literal·notranslate"><span·class="pre">Timestamp.now()</span></code>·and·<code·class="docutils·literal·notranslate"><span·class="pre">pandas.tseries.offsets</span></code>.</p>	857	<p>If·you·want·to·perform·calculations·based·on·today’s·date,·use·<code·class="docutils·literal·notranslate"><span·class="pre">Timestamp.now()</span></code>·and·<code·class="docutils·literal·notranslate"><span·class="pre">pandas.tseries.offsets</span></code>.</p>
858	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[66]:·</span><span·class="kn">import</span>·<span·class="nn">pandas.tseries.offsets</span>·<span·class="k">as</span>·<span·class="nn">offsets</span>	858	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[66]:·</span><span·class="kn">import</span>·<span·class="nn">pandas.tseries.offsets</span>·<span·class="k">as</span>·<span·class="nn">offsets</span>

859	<span·class="gp">In·[67]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">Timestamp</span><span·class="o">.</span><span·class="n">now</span><span·class="p">()</span>	859	<span·class="gp">In·[67]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">Timestamp</span><span·class="o">.</span><span·class="n">now</span><span·class="p">()</span>
860	<span·class="gh">Out[67]:·</span><span·class="go">Timestamp('2024-01-06·07:13:13.~~051890~~')</span>	860	<span·class="gh">Out[67]:·</span><span·class="go">Timestamp('2025-02-08·16:17:38.374022')</span>

861	<span·class="gp">In·[68]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">Timestamp</span><span·class="o">.</span><span·class="n">now</span><span·class="p">()</span>·<span·class="o">+</span>·<span·class="n">offsets</span><span·class="o">.</span><span·class="n">DateOffset</span><span·class="p">(</span><span·class="n">years</span><span·class="o">=</span><span·class="mi">1</span><span·class="p">)</span>	861	<span·class="gp">In·[68]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">Timestamp</span><span·class="o">.</span><span·class="n">now</span><span·class="p">()</span>·<span·class="o">+</span>·<span·class="n">offsets</span><span·class="o">.</span><span·class="n">DateOffset</span><span·class="p">(</span><span·class="n">years</span><span·class="o">=</span><span·class="mi">1</span><span·class="p">)</span>
862	<span·class="gh">Out[68]:·</span><span·class="go">Timestamp('2025-01-06·07:13:13.~~052~~954')</span>	862	<span·class="gh">Out[68]:·</span><span·class="go">Timestamp('2026-02-08·16:17:38.374928')</span>
863	</pre></div>	863	</pre></div>
864	</div>	864	</div>
865	</div>	865	</div>
866	</div>	866	</div>
867	</div>	867	</div>
868	<div·class="section"·id="changes-to-index-comparisons">	868	<div·class="section"·id="changes-to-index-comparisons">
869	<h3>Changes·to·Index·comparisons<a·class="headerlink"·href="#changes-to-index-comparisons"·title="Permalink·to·this·headline">¶</a></h3>	869	<h3>Changes·to·Index·comparisons<a·class="headerlink"·href="#changes-to-index-comparisons"·title="Permalink·to·this·headline">¶</a></h3>


Offset 698, 18 lines modified		Offset 698, 18 lines modified
698	freq=None)	698	freq=None)
699	Note	699	Note
700	If·you·want·to·perform·calculations·based·on·todayâs·date,·use·Timestamp.now	700	If·you·want·to·perform·calculations·based·on·todayâs·date,·use·Timestamp.now
701	()·and·pandas.tseries.offsets.	701	()·and·pandas.tseries.offsets.
702	In·[66]:·import·pandas.tseries.offsets·as·offsets	702	In·[66]:·import·pandas.tseries.offsets·as·offsets

703	In·[67]:·pd.Timestamp.now()	703	In·[67]:·pd.Timestamp.now()
704	Out[67]:·Timestamp('2024-01-06·07:13:13.~~051890~~')	704	Out[67]:·Timestamp('2025-02-08·16:17:38.374022')

705	In·[68]:·pd.Timestamp.now()·+·offsets.DateOffset(years=1)	705	In·[68]:·pd.Timestamp.now()·+·offsets.DateOffset(years=1)
706	Out[68]:·Timestamp('2025-01-06·07:13:13.~~052~~954')	706	Out[68]:·Timestamp('2026-02-08·16:17:38.374928')
707	**·Changes·to·Index·comparisonsÂ¶·**	707	**·Changes·to·Index·comparisonsÂ¶·**
708	Operator·equal·on·Index·should·behavior·similarly·to·Series·(GH9947,·GH10637)	708	Operator·equal·on·Index·should·behavior·similarly·to·Series·(GH9947,·GH10637)
709	Starting·in·v0.17.0,·comparing·Index·objects·of·different·lengths·will·raise·a	709	Starting·in·v0.17.0,·comparing·Index·objects·of·different·lengths·will·raise·a
710	ValueError.·This·is·to·be·consistent·with·the·behavior·of·Series.	710	ValueError.·This·is·to·be·consistent·with·the·behavior·of·Series.
711	Previous·behavior:	711	Previous·behavior:
712	In·[2]:·pd.Index([1,·2,·3])·==·pd.Index([1,·4,·5])	712	In·[2]:·pd.Index([1,·2,·3])·==·pd.Index([1,·4,·5])
713	Out[2]:·array([·True,·False,·False],·dtype=bool)	713	Out[2]:·array([·True,·False,·False],·dtype=bool)


Offset 996, 15 lines modified		Offset 996, 15 lines modified
996	</div>	996	</div>
997	<p><strong>New·API</strong>:</p>	997	<p><strong>New·API</strong>:</p>
998	<p>Now,·you·can·write·<code·class="docutils·literal·notranslate"><span·class="pre">.resample(..)</span></code>·as·a·2-stage·operation·like·<code·class="docutils·literal·notranslate"><span·class="pre">.groupby(...)</span></code>,·which	998	<p>Now,·you·can·write·<code·class="docutils·literal·notranslate"><span·class="pre">.resample(..)</span></code>·as·a·2-stage·operation·like·<code·class="docutils·literal·notranslate"><span·class="pre">.groupby(...)</span></code>,·which
999	yields·a·<code·class="docutils·literal·notranslate"><span·class="pre">Resampler</span></code>.</p>	999	yields·a·<code·class="docutils·literal·notranslate"><span·class="pre">Resampler</span></code>.</p>
1000	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[82]:·</span><span·class="n">r</span>·<span·class="o">=</span>·<span·class="n">df</span><span·class="o">.</span><span·class="n">resample</span><span·class="p">(</span><span·class="s1">'2s'</span><span·class="p">)</span>	1000	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[82]:·</span><span·class="n">r</span>·<span·class="o">=</span>·<span·class="n">df</span><span·class="o">.</span><span·class="n">resample</span><span·class="p">(</span><span·class="s1">'2s'</span><span·class="p">)</span>

1001	<span·class="gp">In·[83]:·</span><span·class="n">r</span>	1001	<span·class="gp">In·[83]:·</span><span·class="n">r</span>
1002	<span·class="gh">Out[83]:·</span><span·class="go"><pandas.core.resample.DatetimeIndexResampler·object·at·0xffff6~~d071~~7f0></span>	1002	<span·class="gh">Out[83]:·</span><span·class="go"><pandas.core.resample.DatetimeIndexResampler·object·at·0xffff568cc070></span>
1003	</pre></div>	1003	</pre></div>
1004	</div>	1004	</div>
1005	<div·class="section"·id="downsampling">	1005	<div·class="section"·id="downsampling">
1006	<h4>Downsampling<a·class="headerlink"·href="#downsampling"·title="Permalink·to·this·headline">¶</a></h4>	1006	<h4>Downsampling<a·class="headerlink"·href="#downsampling"·title="Permalink·to·this·headline">¶</a></h4>
1007	<p>You·can·then·use·this·object·to·perform·operations.	1007	<p>You·can·then·use·this·object·to·perform·operations.
1008	These·are·downsampling·operations·(going·from·a·higher·frequency·to·a·lower·one).</p>	1008	These·are·downsampling·operations·(going·from·a·higher·frequency·to·a·lower·one).</p>
1009	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[84]:·</span><span·class="n">r</span><span·class="o">.</span><span·class="n">mean</span><span·class="p">()</span>	1009	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[84]:·</span><span·class="n">r</span><span·class="o">.</span><span·class="n">mean</span><span·class="p">()</span>


Offset 834, 15 lines modified		Offset 834, 15 lines modified
834	2010-01-01·09:00:08··1.020940··1.068634··1.146402··1.613897	834	2010-01-01·09:00:08··1.020940··1.068634··1.146402··1.613897
835	New·API:	835	New·API:
836	Now,·you·can·write·.resample(..)·as·a·2-stage·operation·like·.groupby(...),	836	Now,·you·can·write·.resample(..)·as·a·2-stage·operation·like·.groupby(...),
837	which·yields·a·Resampler.	837	which·yields·a·Resampler.
838	In·[82]:·r·=·df.resample('2s')	838	In·[82]:·r·=·df.resample('2s')

839	In·[83]:·r	839	In·[83]:·r
840	Out[83]:·<pandas.core.resample.DatetimeIndexResampler·object·at·0xffff6~~d071~~7f0>	840	Out[83]:·<pandas.core.resample.DatetimeIndexResampler·object·at·0xffff568cc070>
841	*·DownsamplingÂ¶·*	841	*·DownsamplingÂ¶·*
842	You·can·then·use·this·object·to·perform·operations.·These·are·downsampling	842	You·can·then·use·this·object·to·perform·operations.·These·are·downsampling
843	operations·(going·from·a·higher·frequency·to·a·lower·one).	843	operations·(going·from·a·higher·frequency·to·a·lower·one).
844	In·[84]:·r.mean()	844	In·[84]:·r.mean()
845	Out[84]:	845	Out[84]:
846	····························A·········B·········C·········D	846	····························A·········B·········C·········D
847	2010-01-01·09:00:00··0.485748··0.447351··0.357096··0.793615	847	2010-01-01·09:00:00··0.485748··0.447351··0.357096··0.793615


Offset 256, 17 lines modified		Offset 256, 17 lines modified
256	<span·class="go">2··3··6</span>	256	<span·class="go">2··3··6</span>

257	<span·class="go">[3·rows·x·2·columns]</span>	257	<span·class="go">[3·rows·x·2·columns]</span>

258	<span·class="gp">In·[13]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">rename</span><span·class="p">(</span><span·class="nb">id</span><span·class="p">,</span>·<span·class="n">axis</span><span·class="o">=</span><span·class="s1">'index'</span><span·class="p">)</span>	258	<span·class="gp">In·[13]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">rename</span><span·class="p">(</span><span·class="nb">id</span><span·class="p">,</span>·<span·class="n">axis</span><span·class="o">=</span><span·class="s1">'index'</span><span·class="p">)</span>
259	<span·class="gh">Out[13]:·</span><span·class="go"></span>	259	<span·class="gh">Out[13]:·</span><span·class="go"></span>
260	<span·class="go">·················A··B</span>	260	<span·class="go">·················A··B</span>
261	<span·class="go">281473~~79242~~8304··1··4</span>	261	<span·class="go">281473421764880··1··4</span>
262	<span·class="go">281473~~792428336~~··2··5</span>	262	<span·class="go">281473421764912··2··5</span>
263	<span·class="go">281473~~792428368~~··3··6</span>	263	<span·class="go">281473421764944··3··6</span>

264	<span·class="go">[3·rows·x·2·columns]</span>	264	<span·class="go">[3·rows·x·2·columns]</span>
265	</pre></div>	265	</pre></div>
266	</div>	266	</div>
267	<p>And·<code·class="docutils·literal·notranslate"><span·class="pre">reindex</span></code>:</p>	267	<p>And·<code·class="docutils·literal·notranslate"><span·class="pre">reindex</span></code>:</p>
268	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[14]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">reindex</span><span·class="p">([</span><span·class="s1">'A'</span><span·class="p">,</span>·<span·class="s1">'B'</span><span·class="p">,</span>·<span·class="s1">'C'</span><span·class="p">],</span>·<span·class="n">axis</span><span·class="o">=</span><span·class="s1">'columns'</span><span·class="p">)</span>	268	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[14]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">reindex</span><span·class="p">([</span><span·class="s1">'A'</span><span·class="p">,</span>·<span·class="s1">'B'</span><span·class="p">,</span>·<span·class="s1">'C'</span><span·class="p">],</span>·<span·class="n">axis</span><span·class="o">=</span><span·class="s1">'columns'</span><span·class="p">)</span>
269	<span·class="gh">Out[14]:·</span><span·class="go"></span>	269	<span·class="gh">Out[14]:·</span><span·class="go"></span>
Offset 287, 17 lines modified		Offset 287, 17 lines modified
287	<span·class="go">[3·rows·x·2·columns]</span>	287	<span·class="go">[3·rows·x·2·columns]</span>
288	</pre></div>	288	</pre></div>
289	</div>	289	</div>
290	<p>The·“index,·columns”·style·continues·to·work·as·before.</p>	290	<p>The·“index,·columns”·style·continues·to·work·as·before.</p>
291	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[16]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">rename</span><span·class="p">(</span><span·class="n">index</span><span·class="o">=</span><span·class="nb">id</span><span·class="p">,</span>·<span·class="n">columns</span><span·class="o">=</span><span·class="nb">str</span><span·class="o">.</span><span·class="n">lower</span><span·class="p">)</span>	291	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[16]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">rename</span><span·class="p">(</span><span·class="n">index</span><span·class="o">=</span><span·class="nb">id</span><span·class="p">,</span>·<span·class="n">columns</span><span·class="o">=</span><span·class="nb">str</span><span·class="o">.</span><span·class="n">lower</span><span·class="p">)</span>
292	<span·class="gh">Out[16]:·</span><span·class="go"></span>	292	<span·class="gh">Out[16]:·</span><span·class="go"></span>
293	<span·class="go">·················a··b</span>	293	<span·class="go">·················a··b</span>
294	<span·class="go">281473~~79242~~8304··1··4</span>	294	<span·class="go">281473421764880··1··4</span>
295	<span·class="go">281473~~792428336~~··2··5</span>	295	<span·class="go">281473421764912··2··5</span>
296	<span·class="go">281473~~792428368~~··3··6</span>	296	<span·class="go">281473421764944··3··6</span>

297	<span·class="go">[3·rows·x·2·columns]</span>	297	<span·class="go">[3·rows·x·2·columns]</span>

298	<span·class="gp">In·[17]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">reindex</span><span·class="p">(</span><span·class="n">index</span><span·class="o">=</span><span·class="p">[</span><span·class="mi">0</span><span·class="p">,</span>·<span·class="mi">1</span><span·class="p">,</span>·<span·class="mi">3</span><span·class="p">],</span>·<span·class="n">columns</span><span·class="o">=</span><span·class="p">[</span><span·class="s1">'A'</span><span·class="p">,</span>·<span·class="s1">'B'</span><span·class="p">,</span>·<span·class="s1">'C'</span><span·class="p">])</span>	298	<span·class="gp">In·[17]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">reindex</span><span·class="p">(</span><span·class="n">index</span><span·class="o">=</span><span·class="p">[</span><span·class="mi">0</span><span·class="p">,</span>·<span·class="mi">1</span><span·class="p">,</span>·<span·class="mi">3</span><span·class="p">],</span>·<span·class="n">columns</span><span·class="o">=</span><span·class="p">[</span><span·class="s1">'A'</span><span·class="p">,</span>·<span·class="s1">'B'</span><span·class="p">,</span>·<span·class="s1">'C'</span><span·class="p">])</span>
299	<span·class="gh">Out[17]:·</span><span·class="go"></span>	299	<span·class="gh">Out[17]:·</span><span·class="go"></span>
300	<span·class="go">·····A····B···C</span>	300	<span·class="go">·····A····B···C</span>
301	<span·class="go">0··1.0··4.0·NaN</span>	301	<span·class="go">0··1.0··4.0·NaN</span>


Offset 195, 17 lines modified		Offset 195, 17 lines modified
195	2··3··6	195	2··3··6

196	[3·rows·x·2·columns]	196	[3·rows·x·2·columns]

197	In·[13]:·df.rename(id,·axis='index')	197	In·[13]:·df.rename(id,·axis='index')
198	Out[13]:	198	Out[13]:
199	·················A··B	199	·················A··B
200	281473~~79242~~8304··1··4	200	281473421764880··1··4
201	281473792428336··2··5
202	281473~~792428368~~··3··6	201	281473421764912··2··5
		202	281473421764944··3··6

203	[3·rows·x·2·columns]	203	[3·rows·x·2·columns]
204	And·reindex:	204	And·reindex:
205	In·[14]:·df.reindex(['A',·'B',·'C'],·axis='columns')	205	In·[14]:·df.reindex(['A',·'B',·'C'],·axis='columns')
206	Out[14]:	206	Out[14]:
207	···A··B···C	207	···A··B···C
208	0··1··4·NaN	208	0··1··4·NaN
Offset 222, 17 lines modified		Offset 222, 17 lines modified
222	3··NaN··NaN	222	3··NaN··NaN

223	[3·rows·x·2·columns]	223	[3·rows·x·2·columns]
224	The·âindex,·columnsâ·style·continues·to·work·as·before.	224	The·âindex,·columnsâ·style·continues·to·work·as·before.
225	In·[16]:·df.rename(index=id,·columns=str.lower)	225	In·[16]:·df.rename(index=id,·columns=str.lower)
226	Out[16]:	226	Out[16]:
227	·················a··b	227	·················a··b
228	281473~~79242~~8304··1··4	228	281473421764880··1··4
229	281473792428336··2··5
230	281473~~792428368~~··3··6	229	281473421764912··2··5
		230	281473421764944··3··6

231	[3·rows·x·2·columns]	231	[3·rows·x·2·columns]

232	In·[17]:·df.reindex(index=[0,·1,·3],·columns=['A',·'B',·'C'])	232	In·[17]:·df.reindex(index=[0,·1,·3],·columns=['A',·'B',·'C'])
233	Out[17]:	233	Out[17]:
234	·····A····B···C	234	·····A····B···C
235	0··1.0··4.0·NaN	235	0··1.0··4.0·NaN


Offset 217, 18 lines modified		Offset 217, 18 lines modified
217	a·new·ndarray·of·period·objects·each·time.</p>	217	a·new·ndarray·of·period·objects·each·time.</p>
218	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[18]:·</span><span·class="n">idx</span><span·class="o">.</span><span·class="n">values</span>	218	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[18]:·</span><span·class="n">idx</span><span·class="o">.</span><span·class="n">values</span>
219	<span·class="gh">Out[18]:·</span><span·class="go"></span>	219	<span·class="gh">Out[18]:·</span><span·class="go"></span>
220	<span·class="go">array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),</span>	220	<span·class="go">array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),</span>
221	<span·class="go">·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)</span>	221	<span·class="go">·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)</span>

222	<span·class="gp">In·[19]:·</span><span·class="nb">id</span><span·class="p">(</span><span·class="n">idx</span><span·class="o">.</span><span·class="n">values</span><span·class="p">)</span>	222	<span·class="gp">In·[19]:·</span><span·class="nb">id</span><span·class="p">(</span><span·class="n">idx</span><span·class="o">.</span><span·class="n">values</span><span·class="p">)</span>
223	<span·class="gh">Out[19]:·</span><span·class="go">281472493525632</span>	223	<span·class="gh">Out[19]:·</span><span·class="go">281472243233856</span>

224	<span·class="gp">In·[20]:·</span><span·class="nb">id</span><span·class="p">(</span><span·class="n">idx</span><span·class="o">.</span><span·class="n">values</span><span·class="p">)</span>	224	<span·class="gp">In·[20]:·</span><span·class="nb">id</span><span·class="p">(</span><span·class="n">idx</span><span·class="o">.</span><span·class="n">values</span><span·class="p">)</span>
225	<span·class="gh">Out[20]:·</span><span·class="go">2814725~~43153008~~</span>	225	<span·class="gh">Out[20]:·</span><span·class="go">281472581044864</span>
226	</pre></div>	226	</pre></div>
227	</div>	227	</div>
228	<p>If·you·need·an·actual·NumPy·array,·use·<a·class="reference·internal"·href="../reference/api/pandas.Series.to_numpy.html#pandas.Series.to_numpy"·title="pandas.Series.to_numpy"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">Series.to_numpy()</span></code></a>·or·<a·class="reference·internal"·href="../reference/api/pandas.Index.to_numpy.html#pandas.Index.to_numpy"·title="pandas.Index.to_numpy"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">Index.to_numpy()</span></code></a>.</p>	228	<p>If·you·need·an·actual·NumPy·array,·use·<a·class="reference·internal"·href="../reference/api/pandas.Series.to_numpy.html#pandas.Series.to_numpy"·title="pandas.Series.to_numpy"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">Series.to_numpy()</span></code></a>·or·<a·class="reference·internal"·href="../reference/api/pandas.Index.to_numpy.html#pandas.Index.to_numpy"·title="pandas.Index.to_numpy"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">Index.to_numpy()</span></code></a>.</p>
229	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[21]:·</span><span·class="n">idx</span><span·class="o">.</span><span·class="n">to_numpy</span><span·class="p">()</span>	229	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[21]:·</span><span·class="n">idx</span><span·class="o">.</span><span·class="n">to_numpy</span><span·class="p">()</span>
230	<span·class="gh">Out[21]:·</span><span·class="go"></span>	230	<span·class="gh">Out[21]:·</span><span·class="go"></span>
231	<span·class="go">array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),</span>	231	<span·class="go">array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),</span>
232	<span·class="go">·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)</span>	232	<span·class="go">·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)</span>
Offset 465, 15 lines modified		Offset 465, 15 lines modified

465	<span·class="gp">In·[47]:·</span><span·class="k">def</span>·<span·class="nf">format_and_align</span><span·class="p">(</span><span·class="n">styler</span><span·class="p">):</span>	465	<span·class="gp">In·[47]:·</span><span·class="k">def</span>·<span·class="nf">format_and_align</span><span·class="p">(</span><span·class="n">styler</span><span·class="p">):</span>
466	<span·class="gp">···....:·</span>····<span·class="k">return</span>·<span·class="p">(</span><span·class="n">styler</span><span·class="o">.</span><span·class="n">format</span><span·class="p">({</span><span·class="s1">'N'</span><span·class="p">:</span>·<span·class="s1">'</span><span·class="si">{:,}</span><span·class="s1">'</span><span·class="p">,</span>·<span·class="s1">'X'</span><span·class="p">:</span>·<span·class="s1">'</span><span·class="si">{:.1%}</span><span·class="s1">'</span><span·class="p">})</span>	466	<span·class="gp">···....:·</span>····<span·class="k">return</span>·<span·class="p">(</span><span·class="n">styler</span><span·class="o">.</span><span·class="n">format</span><span·class="p">({</span><span·class="s1">'N'</span><span·class="p">:</span>·<span·class="s1">'</span><span·class="si">{:,}</span><span·class="s1">'</span><span·class="p">,</span>·<span·class="s1">'X'</span><span·class="p">:</span>·<span·class="s1">'</span><span·class="si">{:.1%}</span><span·class="s1">'</span><span·class="p">})</span>
467	<span·class="gp">···....:·</span>··················<span·class="o">.</span><span·class="n">set_properties</span><span·class="p">(</span><span·class="o">**</span><span·class="p">{</span><span·class="s1">'text-align'</span><span·class="p">:</span>·<span·class="s1">'right'</span><span·class="p">}))</span>	467	<span·class="gp">···....:·</span>··················<span·class="o">.</span><span·class="n">set_properties</span><span·class="p">(</span><span·class="o">**</span><span·class="p">{</span><span·class="s1">'text-align'</span><span·class="p">:</span>·<span·class="s1">'right'</span><span·class="p">}))</span>
468	<span·class="gp">···....:·</span>	468	<span·class="gp">···....:·</span>

469	<span·class="gp">In·[48]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">style</span><span·class="o">.</span><span·class="n">pipe</span><span·class="p">(</span><span·class="n">format_and_align</span><span·class="p">)</span><span·class="o">.</span><span·class="n">set_caption</span><span·class="p">(</span><span·class="s1">'Summary·of·results.'</span><span·class="p">)</span>	469	<span·class="gp">In·[48]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">style</span><span·class="o">.</span><span·class="n">pipe</span><span·class="p">(</span><span·class="n">format_and_align</span><span·class="p">)</span><span·class="o">.</span><span·class="n">set_caption</span><span·class="p">(</span><span·class="s1">'Summary·of·results.'</span><span·class="p">)</span>
470	<span·class="gh">Out[48]:·</span><span·class="go"><pandas.io.formats.style.Styler·at·0xffff~~58c~~b~~3bb~~0></span>	470	<span·class="gh">Out[48]:·</span><span·class="go"><pandas.io.formats.style.Styler·at·0xffff70fb0760></span>
471	</pre></div>	471	</pre></div>
472	</div>	472	</div>
473	<p>Similar·methods·already·exist·for·other·classes·in·pandas,·including·<a·class="reference·internal"·href="../reference/api/pandas.DataFrame.pipe.html#pandas.DataFrame.pipe"·title="pandas.DataFrame.pipe"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">DataFrame.pipe()</span></code></a>,	473	<p>Similar·methods·already·exist·for·other·classes·in·pandas,·including·<a·class="reference·internal"·href="../reference/api/pandas.DataFrame.pipe.html#pandas.DataFrame.pipe"·title="pandas.DataFrame.pipe"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">DataFrame.pipe()</span></code></a>,
474	<a·class="reference·internal"·href="../reference/api/pandas.core.groupby.GroupBy.pipe.html#pandas.core.groupby.GroupBy.pipe"·title="pandas.core.groupby.GroupBy.pipe"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">GroupBy.pipe()</span></code></a>,·and·<a·class="reference·internal"·href="../reference/api/pandas.core.resample.Resampler.pipe.html#pandas.core.resample.Resampler.pipe"·title="pandas.core.resample.Resampler.pipe"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">Resampler.pipe()</span></code></a>.</p>	474	<a·class="reference·internal"·href="../reference/api/pandas.core.groupby.GroupBy.pipe.html#pandas.core.groupby.GroupBy.pipe"·title="pandas.core.groupby.GroupBy.pipe"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">GroupBy.pipe()</span></code></a>,·and·<a·class="reference·internal"·href="../reference/api/pandas.core.resample.Resampler.pipe.html#pandas.core.resample.Resampler.pipe"·title="pandas.core.resample.Resampler.pipe"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">Resampler.pipe()</span></code></a>.</p>
475	</div>	475	</div>
476	<div·class="section"·id="renaming-names-in-a-multiindex">	476	<div·class="section"·id="renaming-names-in-a-multiindex">
477	<span·id="whatsnew-0240-enhancements-rename-axis"></span><h3>Renaming·names·in·a·MultiIndex<a·class="headerlink"·href="#renaming-names-in-a-multiindex"·title="Permalink·to·this·headline">¶</a></h3>	477	<span·id="whatsnew-0240-enhancements-rename-axis"></span><h3>Renaming·names·in·a·MultiIndex<a·class="headerlink"·href="#renaming-names-in-a-multiindex"·title="Permalink·to·this·headline">¶</a></h3>


Offset 165, 18 lines modified		Offset 165, 18 lines modified
165	each·time.	165	each·time.
166	In·[18]:·idx.values	166	In·[18]:·idx.values
167	Out[18]:	167	Out[18]:
168	array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),	168	array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),
169	·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)	169	·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)

170	In·[19]:·id(idx.values)	170	In·[19]:·id(idx.values)
171	Out[19]:·281472493525632	171	Out[19]:·281472243233856

172	In·[20]:·id(idx.values)	172	In·[20]:·id(idx.values)
173	Out[20]:·2814725~~43153008~~	173	Out[20]:·281472581044864
174	If·you·need·an·actual·NumPy·array,·use·Series.to_numpy()·or·Index.to_numpy().	174	If·you·need·an·actual·NumPy·array,·use·Series.to_numpy()·or·Index.to_numpy().
175	In·[21]:·idx.to_numpy()	175	In·[21]:·idx.to_numpy()
176	Out[21]:	176	Out[21]:
177	array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),	177	array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),
178	·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)	178	·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)

179	In·[22]:·pd.Series(idx).to_numpy()	179	In·[22]:·pd.Series(idx).to_numpy()
Offset 375, 15 lines modified		Offset 375, 15 lines modified

375	In·[47]:·def·format_and_align(styler):	375	In·[47]:·def·format_and_align(styler):
376	···....:·····return·(styler.format({'N':·'{:,}',·'X':·'{:.1%}'})	376	···....:·····return·(styler.format({'N':·'{:,}',·'X':·'{:.1%}'})
377	···....:···················.set_properties(**{'text-align':·'right'}))	377	···....:···················.set_properties(**{'text-align':·'right'}))
378	···....:	378	···....:

379	In·[48]:·df.style.pipe(format_and_align).set_caption('Summary·of·results.')	379	In·[48]:·df.style.pipe(format_and_align).set_caption('Summary·of·results.')
380	Out[48]:·<pandas.io.formats.style.Styler·at·0xffff~~58c~~b~~3bb~~0>	380	Out[48]:·<pandas.io.formats.style.Styler·at·0xffff70fb0760>
381	Similar·methods·already·exist·for·other·classes·in·pandas,·including	381	Similar·methods·already·exist·for·other·classes·in·pandas,·including
382	DataFrame.pipe(),·GroupBy.pipe(),·and·Resampler.pipe().	382	DataFrame.pipe(),·GroupBy.pipe(),·and·Resampler.pipe().
383	**·Renaming·names·in·a·MultiIndexÂ¶·**	383	**·Renaming·names·in·a·MultiIndexÂ¶·**
384	DataFrame.rename_axis()·now·supports·index·and·columns·arguments·and	384	DataFrame.rename_axis()·now·supports·index·and·columns·arguments·and
385	Series.rename_axis()·supports·index·argument·(GH19978).	385	Series.rename_axis()·supports·index·argument·(GH19978).
386	This·change·allows·a·dictionary·to·be·passed·so·that·some·of·the·names·of·a	386	This·change·allows·a·dictionary·to·be·passed·so·that·some·of·the·names·of·a
387	MultiIndex·can·be·changed.	387	MultiIndex·can·be·changed.


Offset 1, 9 lines modified		Offset 1, 9 lines modified

1	Hex·dump·of·section·'.gnu_debugaltlink':	1	Hex·dump·of·section·'.gnu_debugaltlink':
2	··0x00000000·2f757372·2f6c6962·2f646562·75672f2e·/usr/lib/debug/.	2	··0x00000000·2f757372·2f6c6962·2f646562·75672f2e·/usr/lib/debug/.
3	··0x00000010·64777a2f·61617263·6836342d·6c696e75·dwz/aarch64-linu	3	··0x00000010·64777a2f·61617263·6836342d·6c696e75·dwz/aarch64-linu
4	··0x00000020·782d676e·752f7079·74686f6e·332d7061·x-gnu/python3-pa	4	··0x00000020·782d676e·752f7079·74686f6e·332d7061·x-gnu/python3-pa
5	··0x00000030·6e646173·2d6c6962·2e646562·7567003c·ndas-lib.debug.<	5	··0x00000030·6e646173·2d6c6962·2e646562·756700f0·ndas-lib.debug..
6	··0x00000040·~~9dbf29ad~~·6b~~416af9~~·~~0f3ed7~~c2·~~7779~~c~~c70~~·..).k~~Aj..>.~~.wy.p	6	··0x00000040·540b371b·6b7bdd33·5b5545c2·a4d1c465·T.7.k{.3[UE....e
7	··0x00000050·~~b43277~~······························~~.2w~~	7	··0x00000050·4b8013······························K..


Offset 1, 7 lines modified		Offset 1, 7 lines modified

1	Hex·dump·of·section·'.gnu_debuglink':	1	Hex·dump·of·section·'.gnu_debuglink':
2	··0x00000000·38333531·37356362·35636233·32336364·835175cb5cb323cd	2	··0x00000000·38333531·37356362·35636233·32336364·835175cb5cb323cd
3	··0x00000010·30323564·34323136·37306264·35643734·025d421670bd5d74	3	··0x00000010·30323564·34323136·37306264·35643734·025d421670bd5d74
4	··0x00000020·63363439·34352e64·65627567·00000000·c64945.debug....	4	··0x00000020·63363439·34352e64·65627567·00000000·c64945.debug....
5	··0x00000030·~~e437d285~~····························.7..	5	··0x00000030·17aa2e78····························...x


Offset 1, 4 lines modified		Offset 1, 4 lines modified

1	Displaying·notes·found·in:·.note.gnu.build-id	1	Displaying·notes·found·in:·.note.gnu.build-id
2	··Owner················Data·size·» Description	2	··Owner················Data·size·» Description
3	··GNU··················0x00000014» NT_GNU_BUILD_ID·(unique·build·ID·bitstring)» ····Build·ID:·b8~~4d72~~b~~d5f5~~1~~9e22917~~c132~~84bc07abe11a9aeff~~	3	··GNU··················0x00000014» NT_GNU_BUILD_ID·(unique·build·ID·bitstring)» ····Build·ID:·508f2836b8e6c104fd42fc3a1068213d5251ccb6