/usr/bin/diffoscope --timeout 7200 --html /srv/reproducible-results/rbuild-debian/r-b-build.hN8cf35f/pandas_2.2.3+dfsg-8.diffoscope.html --text /srv/reproducible-results/rbuild-debian/r-b-build.hN8cf35f/pandas_2.2.3+dfsg-8.diffoscope.txt --json /srv/reproducible-results/rbuild-debian/r-b-build.hN8cf35f/pandas_2.2.3+dfsg-8.diffoscope.json --profile=- /srv/reproducible-results/rbuild-debian/r-b-build.hN8cf35f/b1/pandas_2.2.3+dfsg-8_amd64.changes /srv/reproducible-results/rbuild-debian/r-b-build.hN8cf35f/b2/pandas_2.2.3+dfsg-8

⊟

522 KB

/srv/reproducible-results/rbuild-debian/r-b-build.hN8cf35f/b1/pandas_2.2.3+dfsg-8_amd64.changes vs.

/srv/reproducible-results/rbuild-debian/r-b-build.hN8cf35f/b2/pandas_2.2.3+dfsg-8_amd64.changes ¶

⊟

524 B

Files ¶


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

1	·1~~19053e4dbd~~2~~ebf8~~8~~45e73abee5968~~9f·10794~~968~~·doc·optional·python-pandas-doc_2.2.3+dfsg-8_all.deb	1	·44c692f6152084b83cd9468612ef29a6·10794604·doc·optional·python-pandas-doc_2.2.3+dfsg-8_all.deb
2	·f1f9f2170310b8b59540f1504ae4f513·35864748·debug·optional·python3-pandas-lib-dbgsym_2.2.3+dfsg-8_amd64.deb	2	·f1f9f2170310b8b59540f1504ae4f513·35864748·debug·optional·python3-pandas-lib-dbgsym_2.2.3+dfsg-8_amd64.deb
3	·551836e9c52e65c9632807c82058672b·4515236·python·optional·python3-pandas-lib_2.2.3+dfsg-8_amd64.deb	3	·551836e9c52e65c9632807c82058672b·4515236·python·optional·python3-pandas-lib_2.2.3+dfsg-8_amd64.deb
4	·3aeb8fc374254d23864c68b1017c67e2·3096900·python·optional·python3-pandas_2.2.3+dfsg-8_all.deb	4	·3aeb8fc374254d23864c68b1017c67e2·3096900·python·optional·python3-pandas_2.2.3+dfsg-8_all.deb

⊟

521 KB

python-pandas-doc_2.2.3+dfsg-8_all.deb ¶

⊟

452 B

file list ¶


Offset 1, 3 lines modified		Offset 1, 3 lines modified
1	-rw-r--r--···0········0········0········4·2025-02-01·18:39:17.000000·debian-binary	1	-rw-r--r--···0········0········0········4·2025-02-01·18:39:17.000000·debian-binary
2	-rw-r--r--···0········0········0···147~~388~~·2025-02-01·18:39:17.000000·control.tar.xz	2	-rw-r--r--···0········0········0···147404·2025-02-01·18:39:17.000000·control.tar.xz
3	-rw-r--r--···0········0········0·10647388·2025-02-01·18:39:17.000000·data.tar.xz	3	-rw-r--r--···0········0········0·10647008·2025-02-01·18:39:17.000000·data.tar.xz

⊟

604 B

control.tar.xz ¶

⊟

576 B

control.tar ¶

⊟

506 B

./control ¶


Offset 1, 13 lines modified		Offset 1, 13 lines modified
1	Package:·python-pandas-doc	1	Package:·python-pandas-doc
2	Source:·pandas	2	Source:·pandas
3	Version:·2.2.3+dfsg-8	3	Version:·2.2.3+dfsg-8
4	Architecture:·all	4	Architecture:·all
5	Maintainer:·Debian·Science·Team·<debian-science-maintainers@lists.alioth.debian.org>	5	Maintainer:·Debian·Science·Team·<debian-science-maintainers@lists.alioth.debian.org>
6	Installed-Size:·209~~900~~	6	Installed-Size:·209896
7	Depends:·libjs-sphinxdoc·(>=·8.1),·libjs-mathjax	7	Depends:·libjs-sphinxdoc·(>=·8.1),·libjs-mathjax
8	Suggests:·python3-pandas	8	Suggests:·python3-pandas
9	Section:·doc	9	Section:·doc
10	Priority:·optional	10	Priority:·optional
11	Multi-Arch:·foreign	11	Multi-Arch:·foreign
12	Homepage:·https://pandas.pydata.org/	12	Homepage:·https://pandas.pydata.org/
13	Description:·data·structures·for·"relational"·or·"labeled"·data·-·documentation	13	Description:·data·structures·for·"relational"·or·"labeled"·data·-·documentation

⊟

48.0 B

./md5sums ¶

⊟

30.0 B

./md5sums ¶

Files differ

⊟

520 KB

data.tar.xz ¶

⊟

520 KB

data.tar ¶

⊟

13.7 KB

file list ¶

⊟

79.1 KB

./usr/share/doc/python-pandas-doc/html/searchindex.js ¶

⊟

79.0 KB

js-beautify {} ¶


Offset 21500, 15 lines modified		Offset 21500, 15 lines modified
21500	········"00180":·2294,	21500	········"00180":·2294,
21501	········"002":·[2193,·2264],	21501	········"002":·[2193,·2264],
21502	········"002000":·2232,	21502	········"002000":·2232,
21503	········"002040":·2235,	21503	········"002040":·2235,
21504	········"002118":·[2230,·2231],	21504	········"002118":·[2230,·2231],
21505	········"002653":·2207,	21505	········"002653":·2207,
21506	········"002846":·2229,	21506	········"002846":·2229,
21507	········"003":·[2185,·2~~193,·2~~235],	21507	········"003":·[2185,·2235],
21508	········"003144":·2210,	21508	········"003144":·2210,
21509	········"003337":·2207,	21509	········"003337":·2207,
21510	········"003494":·15,	21510	········"003494":·15,
21511	········"003507":·[2209,·2218],	21511	········"003507":·[2209,·2218],
21512	········"003556":·2207,	21512	········"003556":·2207,
21513	········"00360":·2294,	21513	········"00360":·2294,
21514	········"003733":·2207,	21514	········"003733":·2207,
Offset 21523, 15 lines modified		Offset 21523, 15 lines modified
21523	········"004194":·2186,	21523	········"004194":·2186,
21524	········"004201":·2186,	21524	········"004201":·2186,
21525	········"004229":·2186,	21525	········"004229":·2186,
21526	········"004474":·2184,	21526	········"004474":·2184,
21527	········"004580":·2210,	21527	········"004580":·2210,
21528	········"00486":·30,	21528	········"00486":·30,
21529	········"004956":·2207,	21529	········"004956":·2207,
21530	········"005":·2209,	21530	········"005":·[2193,·2209],
21531	········"005000":·2218,	21531	········"005000":·2218,
21532	········"005361":·2207,	21532	········"005361":·2207,
21533	········"005383":·2220,	21533	········"005383":·2220,
21534	········"005446":·2219,	21534	········"005446":·2219,
21535	········"005462":·2191,	21535	········"005462":·2191,
21536	········"005977":·2199,	21536	········"005977":·2199,
21537	········"005979":·2186,	21537	········"005979":·2186,
Offset 21542, 41 lines modified		Offset 21542, 44 lines modified
21542	········"006438":·2215,	21542	········"006438":·2215,
21543	········"006549":·[182,·760],	21543	········"006549":·[182,·760],
21544	········"006695":·2186,	21544	········"006695":·2186,
21545	········"006747":·[2185,·2197,·2199,·2202,·2204,·2215],	21545	········"006747":·[2185,·2197,·2199,·2202,·2204,·2215],
21546	········"006871":·2212,	21546	········"006871":·2212,
21547	········"006888":·2220,	21547	········"006888":·2220,
21548	········"006938":·2207,	21548	········"006938":·2207,
		21549	········"007":·2193,
21549	········"007200":·2184,	21550	········"007200":·2184,
21550	········"007207":·[2184,·2214],	21551	········"007207":·[2184,·2214],
21551	········"007717":·2199,	21552	········"007717":·2199,
21552	········"007824":·15,	21553	········"007824":·15,
21553	········"007952":·2207,	21554	········"007952":·2207,
21554	········"007996":·2186,	21555	········"007996":·2186,
21555	········"007f":·203,	21556	········"007f":·203,
		21557	········"008":·2193,
21556	········"008182":·2204,	21558	········"008182":·2204,
21557	········"008298":·2186,	21559	········"008298":·2186,
21558	········"008344":·2207,	21560	········"008344":·2207,
21559	········"008358":·2207,	21561	········"008358":·2207,
21560	········"008500":·15,	21562	········"008500":·15,
21561	········"008543":·[102,·1158],	21563	········"008543":·[102,·1158],
21562	········"008943":·[102,·1158],	21564	········"008943":·[102,·1158],
		21565	········"009":·2193,
21563	········"009059":·2191,	21566	········"009059":·2191,
21564	········"009207":·2207,	21567	········"009207":·2207,
21565	········"009420":·2195,	21568	········"009420":·2195,
21566	········"009424":·2207,	21569	········"009424":·2207,
21567	········"009572":·2207,	21570	········"009572":·2207,
21568	········"009673":·2195,	21571	········"009673":·2195,
21569	········"009783":·2207,	21572	········"009783":·2207,
21570	········"009797":·2186,	21573	········"009797":·2186,
21571	········"009826":·[102,·1158,·2205],	21574	········"009826":·[102,·1158,·2205],
21572	········"009920":·[2184,·2195,·2214],	21575	········"009920":·[2184,·2195,·2214],
21573	········"00am":·2230,	21576	········"00am":·2230,
21574	········"00index":·2218,	21577	········"00index":·2218,
21575	········"01":·[3,·15,·16,·17,·19,·29,·30,·31,·36,·79,·80,·82,·88,·107,·121,·182,·187,·207,·213,·218,·219,·230,·242,·261,·270,·271,·276,·277,·278,·283,·286,·287,·288,·289,·290,·291,·292,·293,·294,·295,·296,·298,·299,·301,·302,·303,·304,·305,·306,·307,·308,·309,·310,·311,·312,·313,·314,·315,·316,·317,·318,·319,·320,·321,·322,·323,·324,·326,·329,·330,·331,·332,·333,·345,·362,·363,·423,·445,·510,·511,·513,·514,·515,·516,·517,·519,·521,·523,·525,·529,·531,·532,·533,·534,·535,·536,·537,·541,·542,·543,·544,·545,·546,·547,·548,·549,·551,·554,·556,·557,·558,·560,·561,·562,·563,·564,·565,·566,·575,·591,·592,·593,·600,·629,·637,·639,·640,·641,·642,·643,·644,·645,·646,·647,·649,·650,·651,·652,·654,·655,·656,·657,·658,·659,·660,·661,·662,·663,·665,·666,·667,·668,·670,·671,·673,·674,·675,·676,·677,·678,·679,·680,·684,·685,·686,·688,·689,·696,·760,·763,·781,·788,·793,·804,·817,·874,·893,·898,·899,·902,·903,·904,·905,·909,·910,·917,·919,·922,·929,·934,·939,·940,·943,·944,·945,·948,·949,·953,·954,·957,·959,·960,·969,·972,·982,·984,·997,·1000,·1001,·1003,·1004,·1005,·1011,·1014,·1016,·1017,·1020,·1021,·1024,·1051,·1075,·1078,·1106,·1118,·1122,·1141,·1144,·1145,·1147,·1157,·1164,·1170,·1171,·1176,·1180,·1185,·1192,·1195,·1197,·1206,·1214,·1221,·1227,·1228,·1233,·1239,·1245,·1246,·1253,·1256,·1258,·1268,·1269,·1270,·1271,·1272,·1273,·1274,·1275,·1277,·1278,·1279,·1280,·1282,·1283,·1284,·1285,·1286,·1287,·1288,·1290,·1291,·1292,·1293,·1294,·1295,·1296,·1297,·1344,·1345,·1367,·1391,·1392,·1393,·1436,·1447,·1452,·1475,·1488,·1490,·1498,·1500,·1501,·1506,·1524,·1542,·1560,·1620,·1699,·1720,·1741,·1793,·1815,·1857,·1930,·1947,·1982,·2036,·2054,·2090,·2108,·2127,·2163,·2184,·2185,·2186,·2188,·2191,·219~~3,·219~~5,·2197,·2198,·2199,·2200,·2201,·2202,·2204,·2205,·2206,·2207,·2209,·2210,·2212,·2214,·2215,·2216,·2217,·2218,·2219,·2220,·2221,·2222,·2223,·2225,·2226,·2228,·2229,·2230,·2231,·2232,·2235,·2238,·2240,·2241,·2246,·2249,·2261,·2264,·2265,·2271,·2283,·2289,·2294,·2298,·2302,·2307],	21578	········"01":·[3,·15,·16,·17,·19,·29,·30,·31,·36,·79,·80,·82,·88,·107,·121,·182,·187,·207,·213,·218,·219,·230,·242,·261,·270,·271,·276,·277,·278,·283,·286,·287,·288,·289,·290,·291,·292,·293,·294,·295,·296,·298,·299,·301,·302,·303,·304,·305,·306,·307,·308,·309,·310,·311,·312,·313,·314,·315,·316,·317,·318,·319,·320,·321,·322,·323,·324,·326,·329,·330,·331,·332,·333,·345,·362,·363,·423,·445,·510,·511,·513,·514,·515,·516,·517,·519,·521,·523,·525,·529,·531,·532,·533,·534,·535,·536,·537,·541,·542,·543,·544,·545,·546,·547,·548,·549,·551,·554,·556,·557,·558,·560,·561,·562,·563,·564,·565,·566,·575,·591,·592,·593,·600,·629,·637,·639,·640,·641,·642,·643,·644,·645,·646,·647,·649,·650,·651,·652,·654,·655,·656,·657,·658,·659,·660,·661,·662,·663,·665,·666,·667,·668,·670,·671,·673,·674,·675,·676,·677,·678,·679,·680,·684,·685,·686,·688,·689,·696,·760,·763,·781,·788,·793,·804,·817,·874,·893,·898,·899,·902,·903,·904,·905,·909,·910,·917,·919,·922,·929,·934,·939,·940,·943,·944,·945,·948,·949,·953,·954,·957,·959,·960,·969,·972,·982,·984,·997,·1000,·1001,·1003,·1004,·1005,·1011,·1014,·1016,·1017,·1020,·1021,·1024,·1051,·1075,·1078,·1106,·1118,·1122,·1141,·1144,·1145,·1147,·1157,·1164,·1170,·1171,·1176,·1180,·1185,·1192,·1195,·1197,·1206,·1214,·1221,·1227,·1228,·1233,·1239,·1245,·1246,·1253,·1256,·1258,·1268,·1269,·1270,·1271,·1272,·1273,·1274,·1275,·1277,·1278,·1279,·1280,·1282,·1283,·1284,·1285,·1286,·1287,·1288,·1290,·1291,·1292,·1293,·1294,·1295,·1296,·1297,·1344,·1345,·1367,·1391,·1392,·1393,·1436,·1447,·1452,·1475,·1488,·1490,·1498,·1500,·1501,·1506,·1524,·1542,·1560,·1620,·1699,·1720,·1741,·1793,·1815,·1857,·1930,·1947,·1982,·2036,·2054,·2090,·2108,·2127,·2163,·2184,·2185,·2186,·2188,·2191,·2195,·2197,·2198,·2199,·2200,·2201,·2202,·2204,·2205,·2206,·2207,·2209,·2210,·2212,·2214,·2215,·2216,·2217,·2218,·2219,·2220,·2221,·2222,·2223,·2225,·2226,·2228,·2229,·2230,·2231,·2232,·2235,·2238,·2240,·2241,·2246,·2249,·2261,·2264,·2265,·2271,·2283,·2289,·2294,·2298,·2302,·2307],
21576	········"0100":·[575,·893,·957,·970,·997,·1004,·1014,·1016,·1020,·1021,·1498,·2186,·2199,·2210,·2246,·2271],	21579	········"0100":·[575,·893,·957,·970,·997,·1004,·1014,·1016,·1020,·1021,·1498,·2186,·2199,·2210,·2246,·2271],
21577	········"010000":·[954,·1894],	21580	········"010000":·[954,·1894],
21578	········"010010012":·[923,·2209],	21581	········"010010012":·[923,·2209],
21579	········"010026":·2191,	21582	········"010026":·2191,
21580	········"010081":·15,	21583	········"010081":·15,
21581	········"010165":·2199,	21584	········"010165":·2199,
21582	········"010589":·2193,	21585	········"010589":·2193,
Offset 21638, 25 lines modified		Offset 21641, 25 lines modified
21638	········"017106":·2207,	21641	········"017106":·2207,
21639	········"017118":·2199,	21642	········"017118":·2199,
21640	········"017152":·2186,	21643	········"017152":·2186,
21641	········"017263":·2207,	21644	········"017263":·2207,
21642	········"017276":·2191,	21645	········"017276":·2191,
21643	········"017587":·[2184,·2195,·2214],	21646	········"017587":·[2184,·2195,·2214],
21644	········"017796":·2207,	21647	········"017796":·2207,
21645	········"018":·~~[2193,·~~2199],	21648	········"018":·2199,
21646	········"018007":·2207,	21649	········"018007":·2207,
21647	········"018117":·2191,	21650	········"018117":·2191,
21648	········"018193":·2207,	21651	········"018193":·2207,
21649	········"018409":·2207,	21652	········"018409":·2207,
21650	········"018601":·[2184,·2214],	21653	········"018601":·[2184,·2214],
21651	········"018808":·2207,	21654	········"018808":·2207,
21652	········"018904":·2207,	21655	········"018904":·2207,
21653	········"018941":·2207,	21656	········"018941":·2207,
21654	········"018993":·2214,	21657	········"018993":·2214,
21655	········"019":·2207,	21658	········"019":·[2193,·2207],
21656	········"019449":·2207,	21659	········"019449":·2207,
21657	········"019794":·2197,	21660	········"019794":·2197,
21658	········"01t00":·[2163,·2199,·2210,·2235,·2246,·2261],	21661	········"01t00":·[2163,·2199,·2210,·2235,·2246,·2261],
21659	········"01t01":·2210,	21662	········"01t01":·2210,
21660	········"01t03":·2210,	21663	········"01t03":·2210,
21661	········"01t05":·[909,·2210,·2235],	21664	········"01t05":·[909,·2210,·2235],
21662	········"01t07":·1280,	21665	········"01t07":·1280,
Offset 21669, 50 lines modified		Offset 21672, 47 lines modified
21669	········"020208":·2195,	21672	········"020208":·2195,
21670	········"020376":·2207,	21673	········"020376":·2207,
21671	········"020399":·2195,	21674	········"020399":·2195,
21672	········"020485":·2207,	21675	········"020485":·2207,
21673	········"020544":·2186,	21676	········"020544":·2186,
21674	········"020762":·2220,	21677	········"020762":·2220,
21675	········"020940":·2230,	21678	········"020940":·2230,
21676	········"021":·2193,
21677	········"021244":·2207,	21679	········"021244":·2207,
21678	········"021255":·2230,	21680	········"021255":·2230,
21679	········"021292":·2186,	21681	········"021292":·2186,
21680	········"021377":·2207,	21682	········"021377":·2207,
21681	········"021382":·2184,	21683	········"021382":·2184,
21682	········"021499":·2186,	21684	········"021499":·2186,
21683	········"02155":·30,	21685	········"02155":·30,
21684	········"022":·2193,
21685	········"022070":·2184,	21686	········"022070":·2184,
21686	········"022196":·2207,	21687	········"022196":·2207,
21687	········"022777":·2207,	21688	········"022777":·2207,
21688	········"023":·[1447,·2200,·2232],	21689	········"023":·[1447,·2200,·2232],
21689	········"023100":·2195,	21690	········"023100":·2195,
21690	········"023167":·15,	21691	········"023167":·15,
21691	········"023202":·2199,	21692	········"023202":·2199,
21692	········"023526":·2191,	21693	········"023526":·2191,
Max diff block lines reached; 73316/80867 bytes (90.66%) of diff not shown.

⊟

4.63 KB

./usr/share/doc/python-pandas-doc/html/user_guide/advanced.html ¶


Offset 1847, 25 lines modified		Offset 1847, 26 lines modified
1847	<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>	1847	<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>

1848	<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>	1848	<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>

1849	<span·class="gp">In·[143]:·</span><span·class="o">%</span><span·class="k">timeit</span>·arr[indexer]	1849	<span·class="gp">In·[143]:·</span><span·class="o">%</span><span·class="k">timeit</span>·arr[indexer]
1850	<span·class="gp">···.....:·</span><span·class="o">%</span><span·class="k">timeit</span>·arr.take(indexer,·axis=0)	1850	<span·class="gp">···.....:·</span><span·class="o">%</span><span·class="k">timeit</span>·arr.take(indexer,·axis=0)
1851	<span·class="gp">···.....:·</span>	1851	<span·class="gp">···.....:·</span>
1852	<span·class="go">~~544~~·us·+-·4~~9.3~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)</span>	1852	<span·class="go">350·us·+-·169·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)</span>
1853	<span·class="go">122·us·+-·~~6.36~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10,000·loops·each)</span>	1853	<span·class="go">106·us·+-·19.1·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10,000·loops·each)</span>
1854	</pre></div>	1854	</pre></div>
1855	</div>	1855	</div>
1856	<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>	1856	<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>

1857	<span·class="gp">In·[145]:·</span><span·class="o">%</span><span·class="k">timeit</span>·ser.iloc[indexer]	1857	<span·class="gp">In·[145]:·</span><span·class="o">%</span><span·class="k">timeit</span>·ser.iloc[indexer]
1858	<span·class="gp">···.....:·</span><span·class="o">%</span><span·class="k">timeit</span>·ser.take(indexer)	1858	<span·class="gp">···.....:·</span><span·class="o">%</span><span·class="k">timeit</span>·ser.take(indexer)
1859	<span·class="gp">···.....:·</span>	1859	<span·class="gp">···.....:·</span>
1860	<span·class="go">284·us·+-·22.1·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)</span>
1861	<span·class="go">266·us·+-·16.8·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)</span>	1860	<span·class="go">251·us·+-·69.4·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10,000·loops·each)</span>
		1861	<span·class="go">The·slowest·run·took·7.62·times·longer·than·the·fastest.·This·could·mean·that·an·intermediate·result·is·being·cached.</span>
		1862	<span·class="go">499·us·+-·435·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)</span>
1862	</pre></div>	1863	</pre></div>
1863	</div>	1864	</div>
1864	</section>	1865	</section>
1865	<section·id="index-types">	1866	<section·id="index-types">
1866	<span·id="advanced-index-types"></span><h2>Index·types<a·class="headerlink"·href="#index-types"·title="Link·to·this·heading">#</a></h2>	1867	<span·id="advanced-index-types"></span><h2>Index·types<a·class="headerlink"·href="#index-types"·title="Link·to·this·heading">#</a></h2>
1867	<p>We·have·discussed·<code·class="docutils·literal·notranslate"><span·class="pre">MultiIndex</span></code>·in·the·previous·sections·pretty·extensively.	1868	<p>We·have·discussed·<code·class="docutils·literal·notranslate"><span·class="pre">MultiIndex</span></code>·in·the·previous·sections·pretty·extensively.
1868	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>,	1869	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>,

⊟

1.58 KB

html2text {} ¶

⊟

33.5 KB

./usr/share/doc/python-pandas-doc/html/user_guide/enhancingperf.html ¶

⊟

11.3 KB

html2text {} ¶


Offset 110, 33 lines modified		Offset 110, 33 lines modified
110	···...:·····dx·=·(b·-·a)·/·N	110	···...:·····dx·=·(b·-·a)·/·N
111	···...:·····for·i·in·range(N):	111	···...:·····for·i·in·range(N):
112	···...:·········s·+=·f(a·+·i·*·dx)	112	···...:·········s·+=·f(a·+·i·*·dx)
113	···...:·····return·s·*·dx	113	···...:·····return·s·*·dx
114	···...:	114	···...:
115	We·achieve·our·result·by·using·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8a_\x8p_\x8p_\x8l_\x8y_\x8(_\x8)·(row-wise):	115	We·achieve·our·result·by·using·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8a_\x8p_\x8p_\x8l_\x8y_\x8(_\x8)·(row-wise):
116	In·[5]:·%timeit·df.apply(lambda·x:·integrate_f(x["a"],·x["b"],·x["N"]),·axis=1)	116	In·[5]:·%timeit·df.apply(lambda·x:·integrate_f(x["a"],·x["b"],·x["N"]),·axis=1)
117	~~211~~·ms·+-·18.6·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)	117	159·ms·+-·68.7·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)
118	Let’s·take·a·look·and·see·where·the·time·is·spent·during·this·operation·using	118	Let’s·take·a·look·and·see·where·the·time·is·spent·during·this·operation·using
119	the·_\x8p_\x8r_\x8u_\x8n_\x8·_\x8i_\x8p_\x8y_\x8t_\x8h_\x8o_\x8n_\x8·_\x8m_\x8a_\x8g_\x8i_\x8c_\x8·_\x8f_\x8u_\x8n_\x8c_\x8t_\x8i_\x8o_\x8n:	119	the·_\x8p_\x8r_\x8u_\x8n_\x8·_\x8i_\x8p_\x8y_\x8t_\x8h_\x8o_\x8n_\x8·_\x8m_\x8a_\x8g_\x8i_\x8c_\x8·_\x8f_\x8u_\x8n_\x8c_\x8t_\x8i_\x8o_\x8n:
120	#·most·time·consuming·4·calls	120	#·most·time·consuming·4·calls
121	In·[6]:·%prun·-l·4·df.apply(lambda·x:·integrate_f(x["a"],·x["b"],·x["N"]),	121	In·[6]:·%prun·-l·4·df.apply(lambda·x:·integrate_f(x["a"],·x["b"],·x["N"]),
122	axis=1)··#·noqa·E999	122	axis=1)··#·noqa·E999
123	·········605946·function·calls·(605928·primitive·calls)·in·1.~~397~~·seconds	123	·········605946·function·calls·(605928·primitive·calls)·in·0.618·seconds

124	···Ordered·by:·internal·time	124	···Ordered·by:·internal·time
125	···List·reduced·from·159·to·4·due·to·restriction·<4>	125	···List·reduced·from·159·to·4·due·to·restriction·<4>

126	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)	126	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)
127	·····1000····0.~~758~~····0.001····1.~~236~~····0.001·<ipython-input-4-c2a74e076cf0>:1	127	·····1000····0.362····0.000····0.512····0.001·<ipython-input-4-c2a74e076cf0>:1
128	(integrate_f)	128	(integrate_f)
129	···552423····0.~~478~~····0.000····0.~~478~~····0.000·<ipython-input-3-c138bdd570e3>:1	129	···552423····0.150····0.000····0.150····0.000·<ipython-input-3-c138bdd570e3>:1
130	(f)	130	(f)
		131	········1····0.015····0.015····0.615····0.615·apply.py:1070
		132	(apply_series_generator)
131	·····3000····0.025····0.000····0.~~111~~····0.000·series.py:1~~095~~(__get~~item__~~)	133	·····3000····0.014····0.000····0.029····0.000·series.py:1220(_get_value)
132	····16098····0.018····0.000····0.024····0.000·{built-in·method
133	builtins.isinstance}
134	By·far·the·majority·of·time·is·spend·inside·either·integrate_f·or·f,·hence	134	By·far·the·majority·of·time·is·spend·inside·either·integrate_f·or·f,·hence
135	we’ll·concentrate·our·efforts·cythonizing·these·two·functions.	135	we’ll·concentrate·our·efforts·cythonizing·these·two·functions.
136	\x8\x8\x8\x8·P\x8Pl\x8la\x8ai\x8in\x8n·C\x8Cy\x8yt\x8th\x8ho\x8on\x8n_\x8#\x8#·\x8\x8\x8\x8	136	\x8\x8\x8\x8·P\x8Pl\x8la\x8ai\x8in\x8n·C\x8Cy\x8yt\x8th\x8ho\x8on\x8n_\x8#\x8#·\x8\x8\x8\x8
137	First·we’re·going·to·need·to·import·the·Cython·magic·function·to·IPython:	137	First·we’re·going·to·need·to·import·the·Cython·magic·function·to·IPython:
138	In·[7]:·%load_ext·Cython	138	In·[7]:·%load_ext·Cython
139	Now,·let’s·simply·copy·our·functions·over·to·Cython:	139	Now,·let’s·simply·copy·our·functions·over·to·Cython:
140	In·[8]:·%%cython	140	In·[8]:·%%cython
Offset 147, 15 lines modified		Offset 147, 15 lines modified
147	···...:·····dx·=·(b·-·a)·/·N	147	···...:·····dx·=·(b·-·a)·/·N
148	···...:·····for·i·in·range(N):	148	···...:·····for·i·in·range(N):
149	···...:·········s·+=·f_plain(a·+·i·*·dx)	149	···...:·········s·+=·f_plain(a·+·i·*·dx)
150	···...:·····return·s·*·dx	150	···...:·····return·s·*·dx
151	···...:	151	···...:
152	In·[9]:·%timeit·df.apply(lambda·x:·integrate_f_plain(x["a"],·x["b"],·x["N"]),	152	In·[9]:·%timeit·df.apply(lambda·x:·integrate_f_plain(x["a"],·x["b"],·x["N"]),
153	axis=1)	153	axis=1)
154	135·ms·+-·12.6·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)	154	131·ms·+-·42.2·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)
155	This·has·improved·the·performance·compared·to·the·pure·Python·approach·by·one-	155	This·has·improved·the·performance·compared·to·the·pure·Python·approach·by·one-
156	third.	156	third.
157	\x8\x8\x8\x8·D\x8De\x8ec\x8cl\x8la\x8ar\x8ri\x8in\x8ng\x8g·C\x8C·t\x8ty\x8yp\x8pe\x8es\x8s_\x8#\x8#·\x8\x8\x8\x8	157	\x8\x8\x8\x8·D\x8De\x8ec\x8cl\x8la\x8ar\x8ri\x8in\x8ng\x8g·C\x8C·t\x8ty\x8yp\x8pe\x8es\x8s_\x8#\x8#·\x8\x8\x8\x8
158	We·can·annotate·the·function·variables·and·return·types·as·well·as·use·cdef·and	158	We·can·annotate·the·function·variables·and·return·types·as·well·as·use·cdef·and
159	cpdef·to·improve·performance:	159	cpdef·to·improve·performance:
160	In·[10]:·%%cython	160	In·[10]:·%%cython
161	···....:·cdef·double·f_typed(double·x)·except?·-2:	161	···....:·cdef·double·f_typed(double·x)·except?·-2:
Offset 167, 36 lines modified		Offset 167, 35 lines modified
167	···....:·····dx·=·(b·-·a)·/·N	167	···....:·····dx·=·(b·-·a)·/·N
168	···....:·····for·i·in·range(N):	168	···....:·····for·i·in·range(N):
169	···....:·········s·+=·f_typed(a·+·i·*·dx)	169	···....:·········s·+=·f_typed(a·+·i·*·dx)
170	···....:·····return·s·*·dx	170	···....:·····return·s·*·dx
171	···....:	171	···....:
172	In·[11]:·%timeit·df.apply(lambda·x:·integrate_f_typed(x["a"],·x["b"],·x["N"]),	172	In·[11]:·%timeit·df.apply(lambda·x:·integrate_f_typed(x["a"],·x["b"],·x["N"]),
173	axis=1)	173	axis=1)
174	25.7·ms·+-·~~899~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)	174	18.6·ms·+-·634·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)
175	Annotating·the·functions·with·C·types·yields·an·over·ten·times·performance	175	Annotating·the·functions·with·C·types·yields·an·over·ten·times·performance
176	improvement·compared·to·the·original·Python·implementation.	176	improvement·compared·to·the·original·Python·implementation.
177	\x8\x8\x8\x8·U\x8Us\x8si\x8in\x8ng\x8g·n\x8nd\x8da\x8ar\x8rr\x8ra\x8ay\x8y_\x8#\x8#·\x8\x8\x8\x8	177	\x8\x8\x8\x8·U\x8Us\x8si\x8in\x8ng\x8g·n\x8nd\x8da\x8ar\x8rr\x8ra\x8ay\x8y_\x8#\x8#·\x8\x8\x8\x8
178	When·re-profiling,·time·is·spent·creating·a·_\x8S_\x8e_\x8r_\x8i_\x8e_\x8s·from·each·row,·and·calling	178	When·re-profiling,·time·is·spent·creating·a·_\x8S_\x8e_\x8r_\x8i_\x8e_\x8s·from·each·row,·and·calling
179	__getitem__·from·both·the·index·and·the·series·(three·times·for·each·row).	179	__getitem__·from·both·the·index·and·the·series·(three·times·for·each·row).
180	These·Python·function·calls·are·expensive·and·can·be·improved·by·passing·an	180	These·Python·function·calls·are·expensive·and·can·be·improved·by·passing·an
181	np.ndarray.	181	np.ndarray.
182	In·[12]:·%prun·-l·4·df.apply(lambda·x:·integrate_f_typed(x["a"],·x["b"],·x	182	In·[12]:·%prun·-l·4·df.apply(lambda·x:·integrate_f_typed(x["a"],·x["b"],·x
183	["N"]),·axis=1)	183	["N"]),·axis=1)
184	·········52523·function·calls·(52505·primitive·calls)·in·0.~~134~~·seconds	184	·········52523·function·calls·(52505·primitive·calls)·in·0.062·seconds

185	···Ordered·by:·internal·time	185	···Ordered·by:·internal·time
186	···List·reduced·from·157·to·4·due·to·restriction·<4>	186	···List·reduced·from·157·to·4·due·to·restriction·<4>

187	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)	187	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)
188	·····3000····0.022····0.000····0.094····0.000·series.py:1095(__getitem__)	188	·····3000····0.009····0.000····0.039····0.000·series.py:1095(__getitem__)
		189	·····3000····0.008····0.000····0.009····0.000·base.py:3777(get_loc)
		190	·····3000····0.007····0.000····0.019····0.000·series.py:1220(_get_value)
189	····16098····0.015····0.000····0.021····0.000·{built-in·method	191	····16098····0.005····0.000····0.007····0.000·{built-in·method
190	builtins.isinstance}	192	builtins.isinstance}
191	·····3000····0.015····0.000····0.038····0.000·series.py:1220(_get_value)
192	·····3000····0.014····0.000····0.024····0.000·indexing.py:2765
193	(check_dict_or_set_indexers)
194	In·[13]:·%%cython	193	In·[13]:·%%cython
195	···....:·cimport·numpy·as·np	194	···....:·cimport·numpy·as·np
196	···....:·import·numpy·as·np	195	···....:·import·numpy·as·np
197	···....:·cdef·double·f_typed(double·x)·except?·-2:	196	···....:·cdef·double·f_typed(double·x)·except?·-2:
198	···....:·····return·x·*·(x·-·1)	197	···....:·····return·x·*·(x·-·1)
199	···....:·cpdef·double·integrate_f_typed(double·a,·double·b,·int·N):	198	···....:·cpdef·double·integrate_f_typed(double·a,·double·b,·int·N):
200	···....:·····cdef·int·i	199	···....:·····cdef·int·i
Offset 237, 32 lines modified		Offset 236, 32 lines modified
237	This·implementation·creates·an·array·of·zeros·and·inserts·the·result·of	236	This·implementation·creates·an·array·of·zeros·and·inserts·the·result·of
238	integrate_f_typed·applied·over·each·row.·Looping·over·an·ndarray·is·faster·in	237	integrate_f_typed·applied·over·each·row.·Looping·over·an·ndarray·is·faster·in
239	Cython·than·looping·over·a·_\x8S_\x8e_\x8r_\x8i_\x8e_\x8s·object.	238	Cython·than·looping·over·a·_\x8S_\x8e_\x8r_\x8i_\x8e_\x8s·object.
240	Since·apply_integrate_f·is·typed·to·accept·an·np.ndarray,·_\x8S_\x8e_\x8r_\x8i_\x8e_\x8s_\x8._\x8t_\x8o_\x8__\x8n_\x8u_\x8m_\x8p_\x8y_\x8(_\x8)	239	Since·apply_integrate_f·is·typed·to·accept·an·np.ndarray,·_\x8S_\x8e_\x8r_\x8i_\x8e_\x8s_\x8._\x8t_\x8o_\x8__\x8n_\x8u_\x8m_\x8p_\x8y_\x8(_\x8)
241	calls·are·needed·to·utilize·this·function.	240	calls·are·needed·to·utilize·this·function.
242	In·[14]:·%timeit·apply_integrate_f(df["a"].to_numpy(),·df["b"].to_numpy(),·df	241	In·[14]:·%timeit·apply_integrate_f(df["a"].to_numpy(),·df["b"].to_numpy(),·df
243	["N"].to_numpy())	242	["N"].to_numpy())
244	2.14·ms·+-·2~~3.7~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	243	1.69·ms·+-·153·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
245	Performance·has·improved·from·the·prior·implementation·by·almost·ten·times.	244	Performance·has·improved·from·the·prior·implementation·by·almost·ten·times.
246	\x8\x8\x8\x8·D\x8Di\x8is\x8sa\x8ab\x8bl\x8li\x8in\x8ng\x8g·c\x8co\x8om\x8mp\x8pi\x8il\x8le\x8er\x8r·d\x8di\x8ir\x8re\x8ec\x8ct\x8ti\x8iv\x8ve\x8es\x8s_\x8#\x8#·\x8\x8\x8\x8	245	\x8\x8\x8\x8·D\x8Di\x8is\x8sa\x8ab\x8bl\x8li\x8in\x8ng\x8g·c\x8co\x8om\x8mp\x8pi\x8il\x8le\x8er\x8r·d\x8di\x8ir\x8re\x8ec\x8ct\x8ti\x8iv\x8ve\x8es\x8s_\x8#\x8#·\x8\x8\x8\x8
247	The·majority·of·the·time·is·now·spent·in·apply_integrate_f.·Disabling·Cython’s	246	The·majority·of·the·time·is·now·spent·in·apply_integrate_f.·Disabling·Cython’s
248	boundscheck·and·wraparound·checks·can·yield·more·performance.	247	boundscheck·and·wraparound·checks·can·yield·more·performance.
249	In·[15]:·%prun·-l·4·apply_integrate_f(df["a"].to_numpy(),·df["b"].to_numpy(),	248	In·[15]:·%prun·-l·4·apply_integrate_f(df["a"].to_numpy(),·df["b"].to_numpy(),
250	df["N"].to_numpy())	249	df["N"].to_numpy())
251	·········78·function·calls·in·0.003·seconds	250	·········78·function·calls·in·0.002·seconds

252	···Ordered·by:·internal·time	251	···Ordered·by:·internal·time
253	···List·reduced·from·21·to·4·due·to·restriction·<4>	252	···List·reduced·from·21·to·4·due·to·restriction·<4>

254	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)	253	···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)
255	········1····0.002····0.002····0.002····0.002·<string>:1(<module>)	254	········1····0.002····0.002····0.002····0.002·<string>:1(<module>)
256	········1····0.000····0.000····0.000····0.000·{method·'disable'·of	255	········1····0.000····0.000····0.000····0.000·{method·'disable'·of
257	'_lsprof.Profiler'·objects}	256	'_lsprof.Profiler'·objects}
258	········1····0.000····0.000····0.003····0.003·{built-in·method·builtins.exec}	257	········1····0.000····0.000····0.002····0.002·{built-in·method·builtins.exec}
259	········3····0.000····0.000····0.000····0.000·managers.py:~~1993~~(dtype)	258	········3····0.000····0.000····0.000····0.000·frame.py:4062(__getitem__)
260	In·[16]:·%%cython	259	In·[16]:·%%cython
261	···....:·cimport·cython	260	···....:·cimport·cython
262	···....:·cimport·numpy·as·np	261	···....:·cimport·numpy·as·np
263	···....:·import·numpy·as·np	262	···....:·import·numpy·as·np
264	···....:·cdef·np.float64_t·f_typed(np.float64_t·x)·except?·-2:	263	···....:·cdef·np.float64_t·f_typed(np.float64_t·x)·except?·-2:
265	···....:·····return·x·*·(x·-·1)	264	···....:·····return·x·*·(x·-·1)
266	···....:·cpdef·np.float64_t·integrate_f_typed(np.float64_t·a,·np.float64_t·b,	265	···....:·cpdef·np.float64_t·integrate_f_typed(np.float64_t·a,·np.float64_t·b,
Offset 300, 15 lines modified		Offset 299, 15 lines modified
300	/usr/lib/x86_64-linux-gnu/python3-numpy/numpy/_core/include/numpy/	299	/usr/lib/x86_64-linux-gnu/python3-numpy/numpy/_core/include/numpy/
301	npy_1_7_deprecated_api.h:17:2:·warning:·#warning·"Using·deprecated·NumPy·API,	300	npy_1_7_deprecated_api.h:17:2:·warning:·#warning·"Using·deprecated·NumPy·API,
302	disable·it·with·"·"#define·NPY_NO_DEPRECATED_API·NPY_1_7_API_VERSION"·[-Wcpp]	301	disable·it·with·"·"#define·NPY_NO_DEPRECATED_API·NPY_1_7_API_VERSION"·[-Wcpp]
Max diff block lines reached; 4152/11536 bytes (35.99%) of diff not shown.

⊟

4.07 KB

./usr/share/doc/python-pandas-doc/html/user_guide/scale.html ¶

⊟

1020 B

html2text {} ¶


Offset 644, 16 lines modified		Offset 644, 16 lines modified
644	···....:·files·=·pathlib.Path("data/timeseries/").glob("ts*.parquet")	644	···....:·files·=·pathlib.Path("data/timeseries/").glob("ts*.parquet")
645	···....:·counts·=·pd.Series(dtype=int)	645	···....:·counts·=·pd.Series(dtype=int)
646	···....:·for·path·in·files:	646	···....:·for·path·in·files:
647	···....:·····df·=·pd.read_parquet(path)	647	···....:·····df·=·pd.read_parquet(path)
648	···....:·····counts·=·counts.add(df["name"].value_counts(),·fill_value=0)	648	···....:·····counts·=·counts.add(df["name"].value_counts(),·fill_value=0)
649	···....:·counts.astype(int)	649	···....:·counts.astype(int)
650	···....:	650	···....:
651	CPU·times:·user·~~625~~·us,·sys:·244·us,·total:·~~869~~·us	651	CPU·times:·user·331·us,·sys:·287·us,·total:·618·us
652	Wall·time:·~~879~~·us	652	Wall·time:·627·us
653	Out[32]:·Series([],·dtype:·int64)	653	Out[32]:·Series([],·dtype:·int64)
654	Some·readers,·like·_\x8p_\x8a_\x8n_\x8d_\x8a_\x8s_\x8._\x8r_\x8e_\x8a_\x8d_\x8__\x8c_\x8s_\x8v_\x8(_\x8),·offer·parameters·to·control·the·chunksize	654	Some·readers,·like·_\x8p_\x8a_\x8n_\x8d_\x8a_\x8s_\x8._\x8r_\x8e_\x8a_\x8d_\x8__\x8c_\x8s_\x8v_\x8(_\x8),·offer·parameters·to·control·the·chunksize
655	when·reading·a·single·file.	655	when·reading·a·single·file.
656	Manually·chunking·is·an·OK·option·for·workflows·that·don’t·require·too	656	Manually·chunking·is·an·OK·option·for·workflows·that·don’t·require·too
657	sophisticated·of·operations.·Some·operations,·like·_\x8p_\x8a_\x8n_\x8d_\x8a_\x8s_\x8._\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8g_\x8r_\x8o_\x8u_\x8p_\x8b_\x8y_\x8(_\x8),	657	sophisticated·of·operations.·Some·operations,·like·_\x8p_\x8a_\x8n_\x8d_\x8a_\x8s_\x8._\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8g_\x8r_\x8o_\x8u_\x8p_\x8b_\x8y_\x8(_\x8),
658	are·much·harder·to·do·chunkwise.·In·these·cases,·you·may·be·better·switching·to	658	are·much·harder·to·do·chunkwise.·In·these·cases,·you·may·be·better·switching·to
659	a·different·library·that·implements·these·out-of-core·algorithms·for·you.	659	a·different·library·that·implements·these·out-of-core·algorithms·for·you.

⊟

89.1 KB

./usr/share/doc/python-pandas-doc/html/user_guide/style.ipynb.gz ¶

⊟

88.9 KB

style.ipynb ¶

⊟

88.9 KB

Pretty-printed ¶

Similarity: 0.9985610875706213% Differences: {"'cells'": "{1: {'metadata': {'execution': {'iopub.execute_input': '2026-04-12T08:06:59.315130Z', " "'iopub.status.busy': '2026-04-12T08:06:59.314874Z', 'iopub.status.idle': " "'2026-04-12T08:06:59.674203Z', 'shell.execute_reply': " "'2026-04-12T08:06:59.673472Z'}}}, 3: {'metadata': {'execution': " "{'iopub.execute_input': '2026-04-12T08:06:59.677437Z', 'iopub.status.busy': " "'2026-04-12T08:06:59.676672Z', 'iopub.status.idle': '2026-04-12T08:06:5 […]


Offset 39, 18 lines modified		Offset 39, 18 lines modified
39	············]	39	············]
40	········},	40	········},
41	········{	41	········{
42	············"cell_type":·"code",	42	············"cell_type":·"code",
43	············"execution_count":·1,	43	············"execution_count":·1,
44	············"metadata":·{	44	············"metadata":·{
45	················"execution":·{	45	················"execution":·{
46	····················"iopub.execute_input":·"2025-03-10T00:14:26.~~077877~~Z",	46	····················"iopub.execute_input":·"2026-04-12T08:06:59.315130Z",
47	····················"iopub.status.busy":·"2025-03-10T00:14:26.~~077533~~Z",	47	····················"iopub.status.busy":·"2026-04-12T08:06:59.314874Z",
48	····················"iopub.status.idle":·"2025-03-10T00:14:26.722736Z",	48	····················"iopub.status.idle":·"2026-04-12T08:06:59.674203Z",
49	····················"shell.execute_reply":·"2025-03-10T00:14:26.7~~215~~47Z"	49	····················"shell.execute_reply":·"2026-04-12T08:06:59.673472Z"
50	················},	50	················},
51	················"nbsphinx":·"hidden"	51	················"nbsphinx":·"hidden"
52	············},	52	············},
53	············"outputs":·[],	53	············"outputs":·[],
54	············"source":·[	54	············"source":·[
55	················"import·matplotlib.pyplot\n",	55	················"import·matplotlib.pyplot\n",
56	················"#·We·have·this·here·to·trigger·matplotlib's·font·cache·stuff.\n",	56	················"#·We·have·this·here·to·trigger·matplotlib's·font·cache·stuff.\n",
Offset 77, 36 lines modified		Offset 77, 36 lines modified
77	············]	77	············]
78	········},	78	········},
79	········{	79	········{
80	············"cell_type":·"code",	80	············"cell_type":·"code",
81	············"execution_count":·2,	81	············"execution_count":·2,
82	············"metadata":·{	82	············"metadata":·{
83	················"execution":·{	83	················"execution":·{
84	····················"iopub.execute_input":·"2025-03-10T00:14:26.~~7269~~30Z",	84	····················"iopub.execute_input":·"2026-04-12T08:06:59.677437Z",
85	····················"iopub.status.busy":·"2025-03-10T00:14:26.726471Z",	85	····················"iopub.status.busy":·"2026-04-12T08:06:59.676672Z",
86	····················"iopub.status.idle":·"2025-03-10T00:14:27.107788Z",	86	····················"iopub.status.idle":·"2026-04-12T08:06:59.910277Z",
87	····················"shell.execute_reply":·"2025-03-10T00:14:27.10~~6646~~Z"	87	····················"shell.execute_reply":·"2026-04-12T08:06:59.909550Z"
88	················}	88	················}
89	············},	89	············},
90	············"outputs":·[],	90	············"outputs":·[],
91	············"source":·[	91	············"source":·[
92	················"import·pandas·as·pd\n",	92	················"import·pandas·as·pd\n",
93	················"import·numpy·as·np\n",	93	················"import·numpy·as·np\n",
94	················"import·matplotlib·as·mpl\n"	94	················"import·matplotlib·as·mpl\n"
95	············]	95	············]
96	········},	96	········},
97	········{	97	········{
98	············"cell_type":·"code",	98	············"cell_type":·"code",
99	············"execution_count":·3,	99	············"execution_count":·3,
100	············"metadata":·{	100	············"metadata":·{
101	················"execution":·{	101	················"execution":·{
102	····················"iopub.execute_input":·"2025-03-10T00:14:27.11~~3754~~Z",	102	····················"iopub.execute_input":·"2026-04-12T08:06:59.912896Z",
103	····················"iopub.status.busy":·"2025-03-10T00:14:27.113258Z",	103	····················"iopub.status.busy":·"2026-04-12T08:06:59.912501Z",
104	····················"iopub.status.idle":·"2025-03-10T00:14:27.~~3087~~22Z",	104	····················"iopub.status.idle":·"2026-04-12T08:07:00.031423Z",
105	····················"shell.execute_reply":·"2025-03-10T00:14:27.307617Z"	105	····················"shell.execute_reply":·"2026-04-12T08:07:00.030723Z"
106	················},	106	················},
107	················"nbsphinx":·"hidden"	107	················"nbsphinx":·"hidden"
108	············},	108	············},
109	············"outputs":·[],	109	············"outputs":·[],
110	············"source":·[	110	············"source":·[
111	················"#·For·reproducibility·-·this·doesn't·respect·uuid_len·or·positionally-passed·uuid·but·the·places·here·that·use·that·coincidentally·bypass·this·anyway\n",	111	················"#·For·reproducibility·-·this·doesn't·respect·uuid_len·or·positionally-passed·uuid·but·the·places·here·that·use·that·coincidentally·bypass·this·anyway\n",
112	················"from·pandas.io.formats.style·import·Styler\n",	112	················"from·pandas.io.formats.style·import·Styler\n",
Offset 123, 18 lines modified		Offset 123, 18 lines modified
123	············]	123	············]
124	········},	124	········},
125	········{	125	········{
126	············"cell_type":·"code",	126	············"cell_type":·"code",
127	············"execution_count":·4,	127	············"execution_count":·4,
128	············"metadata":·{	128	············"metadata":·{
129	················"execution":·{	129	················"execution":·{
130	····················"iopub.execute_input":·"2025-03-10T00:14:27.~~312900~~Z",	130	····················"iopub.execute_input":·"2026-04-12T08:07:00.033871Z",
131	····················"iopub.status.busy":·"2025-03-10T00:14:27.~~312389~~Z",	131	····················"iopub.status.busy":·"2026-04-12T08:07:00.033551Z",
132	····················"iopub.status.idle":·"2025-03-10T00:14:27.~~32854~~7Z",	132	····················"iopub.status.idle":·"2026-04-12T08:07:00.043357Z",
133	····················"shell.execute_reply":·"2025-03-10T00:14:27.327436Z"	133	····················"shell.execute_reply":·"2026-04-12T08:07:00.042793Z"
134	················}	134	················}
135	············},	135	············},
136	············"outputs":·[	136	············"outputs":·[
137	················{	137	················{
138	····················"data":·{	138	····················"data":·{
139	························"text/html":·[	139	························"text/html":·[
140	····························"<style·type=\"text/css\">\n",	140	····························"<style·type=\"text/css\">\n",
Offset 193, 18 lines modified		Offset 193, 18 lines modified
193	············]	193	············]
194	········},	194	········},
195	········{	195	········{
196	············"cell_type":·"code",	196	············"cell_type":·"code",
197	············"execution_count":·5,	197	············"execution_count":·5,
198	············"metadata":·{	198	············"metadata":·{
199	················"execution":·{	199	················"execution":·{
200	····················"iopub.execute_input":·"2025-03-10T00:14:27.~~393356~~Z",	200	····················"iopub.execute_input":·"2026-04-12T08:07:00.078288Z",
201	····················"iopub.status.busy":·"2025-03-10T00:14:27.~~392~~917Z",	201	····················"iopub.status.busy":·"2026-04-12T08:07:00.077966Z",
202	····················"iopub.status.idle":·"2025-03-10T00:14:27.~~41169~~3Z",	202	····················"iopub.status.idle":·"2026-04-12T08:07:00.090253Z",
203	····················"shell.execute_reply":·"2025-03-10T00:14:27.~~410~~656Z"	203	····················"shell.execute_reply":·"2026-04-12T08:07:00.089652Z"
204	················}	204	················}
205	············},	205	············},
206	············"outputs":·[	206	············"outputs":·[
207	················{	207	················{
208	····················"data":·{	208	····················"data":·{
209	························"text/html":·[	209	························"text/html":·[
210	····························"<div>\n",	210	····························"<div>\n",
Offset 327, 18 lines modified		Offset 327, 18 lines modified
327	············]	327	············]
328	········},	328	········},
329	········{	329	········{
330	············"cell_type":·"code",	330	············"cell_type":·"code",
331	············"execution_count":·6,	331	············"execution_count":·6,
332	············"metadata":·{	332	············"metadata":·{
333	················"execution":·{	333	················"execution":·{
334	····················"iopub.execute_input":·"2025-03-10T00:14:27.~~41504~~7Z",	334	····················"iopub.execute_input":·"2026-04-12T08:07:00.092637Z",
335	····················"iopub.status.busy":·"2025-03-10T00:14:27.~~414650~~Z",	335	····················"iopub.status.busy":·"2026-04-12T08:07:00.092013Z",
336	····················"iopub.status.idle":·"2025-03-10T00:14:27.~~432974~~Z",	336	····················"iopub.status.idle":·"2026-04-12T08:07:00.103826Z",
337	····················"shell.execute_reply":·"2025-03-10T00:14:27.431942Z"	337	····················"shell.execute_reply":·"2026-04-12T08:07:00.103254Z"
338	················}	338	················}
339	············},	339	············},
340	············"outputs":·[	340	············"outputs":·[
341	················{	341	················{
342	····················"data":·{	342	····················"data":·{
343	························"text/html":·[	343	························"text/html":·[
344	····························"<style·type=\"text/css\">\n",	344	····························"<style·type=\"text/css\">\n",
Offset 448, 18 lines modified		Offset 448, 18 lines modified
448	············]	448	············]
449	········},	449	········},
450	········{	450	········{
451	············"cell_type":·"code",	451	············"cell_type":·"code",
452	············"execution_count":·7,	452	············"execution_count":·7,
453	············"metadata":·{	453	············"metadata":·{
454	················"execution":·{	454	················"execution":·{
455	····················"iopub.execute_input":·"2025-03-10T00:14:27.~~436468~~Z",	455	····················"iopub.execute_input":·"2026-04-12T08:07:00.105803Z",
456	····················"iopub.status.busy":·"2025-03-10T00:14:27.~~436105~~Z",	456	····················"iopub.status.busy":·"2026-04-12T08:07:00.105560Z",
457	····················"iopub.status.idle":·"2025-03-10T00:14:27.~~447975~~Z",	457	····················"iopub.status.idle":·"2026-04-12T08:07:00.112650Z",
458	····················"shell.execute_reply":·"2025-03-10T00:14:27.~~44695~~3Z"	458	····················"shell.execute_reply":·"2026-04-12T08:07:00.112083Z"
459	················}	459	················}
460	············},	460	············},
461	············"outputs":·[	461	············"outputs":·[
Max diff block lines reached; 83518/90470 bytes (92.32%) of diff not shown.

⊟

4.03 KB

./usr/share/doc/python-pandas-doc/html/whatsnew/v0.13.0.html ¶


Offset 1613, 20 lines modified		Offset 1613, 21 lines modified
1613	<span·class="gp">In·[94]:·</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>	1613	<span·class="gp">In·[94]:·</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>
1614	<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>	1614	<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>
1615	<span·class="gp">···....:·</span>	1615	<span·class="gp">···....:·</span>
1616	</pre></div>	1616	</pre></div>
1617	</div>	1617	</div>
1618	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·eval·with·NumExpr·backend</span>	1618	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·eval·with·NumExpr·backend</span>
1619	<span·class="gp">In·[95]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.eval('df1·+·df2·+·df3·+·df4')	1619	<span·class="gp">In·[95]:·</span><span·class="o">%</span><span·class="k">timeit</span>·pd.eval('df1·+·df2·+·df3·+·df4')
		1620	<span·class="go">The·slowest·run·took·4.05·times·longer·than·the·fastest.·This·could·mean·that·an·intermediate·result·is·being·cached.</span>
1620	<span·class="go">13.6·ms·+-·~~397~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>	1621	<span·class="go">12.1·ms·+-·6.53·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>
1621	</pre></div>	1622	</pre></div>
1622	</div>	1623	</div>
1623	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·pure·Python·evaluation</span>	1624	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·pure·Python·evaluation</span>
1624	<span·class="gp">In·[96]:·</span><span·class="o">%</span><span·class="k">timeit</span>·df1·+·df2·+·df3·+·df4	1625	<span·class="gp">In·[96]:·</span><span·class="o">%</span><span·class="k">timeit</span>·df1·+·df2·+·df3·+·df4
1625	<span·class="go">18.6·ms·+-·~~955~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)</span>	1626	<span·class="go">16.1·ms·+-·2.06·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)</span>
1626	</pre></div>	1627	</pre></div>
1627	</div>	1628	</div>
1628	<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>	1629	<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>
1629	</li>	1630	</li>
1630	<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	1631	<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
1631	<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame.eval</span></code>·method·that·evaluates·an·expression·in·the·context·of	1632	<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame.eval</span></code>·method·that·evaluates·an·expression·in·the·context·of
1632	the·<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame</span></code>.·For·example,</p>	1633	the·<code·class="docutils·literal·notranslate"><span·class="pre">DataFrame</span></code>.·For·example,</p>

⊟

1.17 KB

html2text {} ¶

⊟

2.96 KB

./usr/share/doc/python-pandas-doc/html/whatsnew/v0.17.0.html ¶


Offset 1458, 18 lines modified		Offset 1458, 18 lines modified
1458	</div>	1458	</div>
1459	<div·class="admonition·note">	1459	<div·class="admonition·note">
1460	<p·class="admonition-title">Note</p>	1460	<p·class="admonition-title">Note</p>
1461	<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>	1461	<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>
1462	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[65]:·</span><span·class="kn">import</span>·<span·class="nn">pandas.tseries.offsets</span>·<span·class="k">as</span>·<span·class="nn">offsets</span>	1462	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[65]:·</span><span·class="kn">import</span>·<span·class="nn">pandas.tseries.offsets</span>·<span·class="k">as</span>·<span·class="nn">offsets</span>

1463	<span·class="gp">In·[66]:·</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>	1463	<span·class="gp">In·[66]:·</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>
1464	<span·class="gh">Out[66]:·</span><span·class="go">Timestamp('2025-03-09·12:11:19.~~491572~~')</span>	1464	<span·class="gh">Out[66]:·</span><span·class="go">Timestamp('2026-04-12·22:04:33.209014')</span>

1465	<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>·<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>	1465	<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>·<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>
1466	<span·class="gh">Out[67]:·</span><span·class="go">Timestamp('2026-03-09·12:11:19.~~495556~~')</span>	1466	<span·class="gh">Out[67]:·</span><span·class="go">Timestamp('2027-04-12·22:04:33.210783')</span>
1467	</pre></div>	1467	</pre></div>
1468	</div>	1468	</div>
1469	</div>	1469	</div>
1470	</section>	1470	</section>
1471	</section>	1471	</section>
1472	<section·id="changes-to-index-comparisons">	1472	<section·id="changes-to-index-comparisons">
1473	<h3>Changes·to·Index·comparisons<a·class="headerlink"·href="#changes-to-index-comparisons"·title="Link·to·this·heading">#</a></h3>	1473	<h3>Changes·to·Index·comparisons<a·class="headerlink"·href="#changes-to-index-comparisons"·title="Link·to·this·heading">#</a></h3>

⊟

1010 B

html2text {} ¶


Offset 814, 18 lines modified		Offset 814, 18 lines modified
814	freq=None)	814	freq=None)
815	Note	815	Note
816	If·you·want·to·perform·calculations·based·on·today’s·date,·use·Timestamp.now()	816	If·you·want·to·perform·calculations·based·on·today’s·date,·use·Timestamp.now()
817	and·pandas.tseries.offsets.	817	and·pandas.tseries.offsets.
818	In·[65]:·import·pandas.tseries.offsets·as·offsets	818	In·[65]:·import·pandas.tseries.offsets·as·offsets

819	In·[66]:·pd.Timestamp.now()	819	In·[66]:·pd.Timestamp.now()
820	Out[66]:·Timestamp('2025-03-09·12:11:19.~~491572~~')	820	Out[66]:·Timestamp('2026-04-12·22:04:33.209014')

821	In·[67]:·pd.Timestamp.now()·+·offsets.DateOffset(years=1)	821	In·[67]:·pd.Timestamp.now()·+·offsets.DateOffset(years=1)
822	Out[67]:·Timestamp('2026-03-09·12:11:19.~~495556~~')	822	Out[67]:·Timestamp('2027-04-12·22:04:33.210783')
823	\x8\x8\x8\x8·C\x8Ch\x8ha\x8an\x8ng\x8ge\x8es\x8s·t\x8to\x8o·I\x8In\x8nd\x8de\x8ex\x8x·c\x8co\x8om\x8mp\x8pa\x8ar\x8ri\x8is\x8so\x8on\x8ns\x8s_\x8#\x8#·\x8\x8\x8\x8	823	\x8\x8\x8\x8·C\x8Ch\x8ha\x8an\x8ng\x8ge\x8es\x8s·t\x8to\x8o·I\x8In\x8nd\x8de\x8ex\x8x·c\x8co\x8om\x8mp\x8pa\x8ar\x8ri\x8is\x8so\x8on\x8ns\x8s_\x8#\x8#·\x8\x8\x8\x8
824	Operator·equal·on·Index·should·behavior·similarly·to·Series·(_\x8G_\x8H_\x8·_\x89_\x89_\x84_\x87,·_\x8G_\x8H_\x8·_\x81_\x80_\x86_\x83_\x87)	824	Operator·equal·on·Index·should·behavior·similarly·to·Series·(_\x8G_\x8H_\x8·_\x89_\x89_\x84_\x87,·_\x8G_\x8H_\x8·_\x81_\x80_\x86_\x83_\x87)
825	Starting·in·v0.17.0,·comparing·Index·objects·of·different·lengths·will·raise·a	825	Starting·in·v0.17.0,·comparing·Index·objects·of·different·lengths·will·raise·a
826	ValueError.·This·is·to·be·consistent·with·the·behavior·of·Series.	826	ValueError.·This·is·to·be·consistent·with·the·behavior·of·Series.
827	Previous·behavior:	827	Previous·behavior:
828	In·[2]:·pd.Index([1,·2,·3])·==·pd.Index([1,·4,·5])	828	In·[2]:·pd.Index([1,·2,·3])·==·pd.Index([1,·4,·5])
829	Out[2]:·array([·True,·False,·False],·dtype=bool)	829	Out[2]:·array([·True,·False,·False],·dtype=bool)

⊟

21.4 KB

./usr/share/doc/python-pandas-doc/html/whatsnew/v0.18.1.html ¶

⊟

4.95 KB

html2text {} ¶


Offset 281, 16 lines modified		Offset 281, 14 lines modified
281	Out[12]:	281	Out[12]:
282	············group··val	282	············group··val
283	date	283	date
284	2016-01-03······1····5	284	2016-01-03······1····5
285	2016-01-10······1····6	285	2016-01-10······1····6
286	2016-01-17······2····7	286	2016-01-17······2····7
287	2016-01-24······2····8	287	2016-01-24······2····8

288	[4·rows·x·2·columns]
289	In[1]:·df.groupby("group").apply(lambda·x:·x.resample("1D").ffill())	288	In[1]:·df.groupby("group").apply(lambda·x:·x.resample("1D").ffill())
290	Out[1]:	289	Out[1]:
291	··················group··val	290	··················group··val
292	group·date	291	group·date
293	1·····2016-01-03······1····5	292	1·····2016-01-03······1····5
294	······2016-01-04······1····5	293	······2016-01-04······1····5
295	······2016-01-05······1····5	294	······2016-01-05······1····5
Offset 340, 47 lines modified		Offset 338, 41 lines modified

340	In·[14]:·df.where(lambda·x:·x·>·4,·lambda·x:·x·+·10)	338	In·[14]:·df.where(lambda·x:·x·>·4,·lambda·x:·x·+·10)
341	Out[14]:	339	Out[14]:
342	····A···B··C	340	····A···B··C
343	0··11··14··7	341	0··11··14··7
344	1··12···5··8	342	1··12···5··8
345	2··13···6··9	343	2··13···6··9

346	[3·rows·x·3·columns]
347	\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8ds\x8s·.\x8.l\x8lo\x8oc\x8c[\x8[]\x8],\x8,·.\x8.i\x8il\x8lo\x8oc\x8c[\x8[]\x8],\x8,·.\x8.i\x8ix\x8x[\x8[]\x8]_\x8#\x8#·\x8\x8\x8	344	\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8ds\x8s·.\x8.l\x8lo\x8oc\x8c[\x8[]\x8],\x8,·.\x8.i\x8il\x8lo\x8oc\x8c[\x8[]\x8],\x8,·.\x8.i\x8ix\x8x[\x8[]\x8]_\x8#\x8#·\x8\x8\x8
348	These·can·accept·a·callable,·and·a·tuple·of·callable·as·a·slicer.·The·callable	345	These·can·accept·a·callable,·and·a·tuple·of·callable·as·a·slicer.·The·callable
349	can·return·a·valid·boolean·indexer·or·anything·which·is·valid·for·these	346	can·return·a·valid·boolean·indexer·or·anything·which·is·valid·for·these
350	indexer’s·input.	347	indexer’s·input.
351	#·callable·returns·bool·indexer	348	#·callable·returns·bool·indexer
352	In·[15]:·df.loc[lambda·x:·x.A·>=·2,·lambda·x:·x.sum()·>·10]	349	In·[15]:·df.loc[lambda·x:·x.A·>=·2,·lambda·x:·x.sum()·>·10]
353	Out[15]:	350	Out[15]:
354	···B··C	351	···B··C
355	1··5··8	352	1··5··8
356	2··6··9	353	2··6··9

357	[2·rows·x·2·columns]

358	#·callable·returns·list·of·labels	354	#·callable·returns·list·of·labels
359	In·[16]:·df.loc[lambda·x:·[1,·2],·lambda·x:·["A",·"B"]]	355	In·[16]:·df.loc[lambda·x:·[1,·2],·lambda·x:·["A",·"B"]]
360	Out[16]:	356	Out[16]:
361	···A··B	357	···A··B
362	1··2··5	358	1··2··5
363	2··3··6	359	2··3··6

364	[2·rows·x·2·columns]
365	\x8\x8\x8·I\x8In\x8nd\x8de\x8ex\x8xi\x8in\x8ng\x8g·w\x8wi\x8it\x8th\x8h·[\x8[]\x8]_\x8#\x8#·\x8\x8\x8	360	\x8\x8\x8·I\x8In\x8nd\x8de\x8ex\x8xi\x8in\x8ng\x8g·w\x8wi\x8it\x8th\x8h·[\x8[]\x8]_\x8#\x8#·\x8\x8\x8
366	Finally,·you·can·use·a·callable·in·[]·indexing·of·Series,·DataFrame·and·Panel.	361	Finally,·you·can·use·a·callable·in·[]·indexing·of·Series,·DataFrame·and·Panel.
367	The·callable·must·return·a·valid·input·for·[]·indexing·depending·on·its·class	362	The·callable·must·return·a·valid·input·for·[]·indexing·depending·on·its·class
368	and·index·type.	363	and·index·type.
369	In·[17]:·df[lambda·x:·"A"]	364	In·[17]:·df[lambda·x:·"A"]
370	Out[17]:	365	Out[17]:
371	0····1	366	0····1
372	1····2	367	1····2
373	2····3	368	2····3
374	Name:·A,·~~Length:·3,·~~dtype:·int64	369	Name:·A,·dtype:·int64
375	Using·these·methods·/·indexers,·you·can·chain·data·selection·operations·without	370	Using·these·methods·/·indexers,·you·can·chain·data·selection·operations·without
376	using·temporary·variable.	371	using·temporary·variable.
377	In·[18]:·bb·=·pd.read_csv("data/baseball.csv",·index_col="id")	372	In·[18]:·bb·=·pd.read_csv("data/baseball.csv",·index_col="id")

378	In·[19]:·(bb.groupby(["year",·"team"]).sum(numeric_only=True).loc[lambda·df:	373	In·[19]:·(bb.groupby(["year",·"team"]).sum(numeric_only=True).loc[lambda·df:
379	df.r·>·100])	374	df.r·>·100])
380	Out[19]:	375	Out[19]:
Offset 486, 28 lines modified		Offset 478, 26 lines modified
486	···....:	478	···....:

487	In·[21]:·df	479	In·[21]:·df
488	Out[21]:	480	Out[21]:
489	···year··month··day··hour	481	···year··month··day··hour
490	0··2015······2····4·····2	482	0··2015······2····4·····2
491	1··2016······3····5·····3	483	1··2016······3····5·····3

492	[2·rows·x·4·columns]
493	Assembling·using·the·passed·frame.	484	Assembling·using·the·passed·frame.
494	In·[22]:·pd.to_datetime(df)	485	In·[22]:·pd.to_datetime(df)
495	Out[22]:	486	Out[22]:
496	0···2015-02-04·02:00:00	487	0···2015-02-04·02:00:00
497	1···2016-03-05·03:00:00	488	1···2016-03-05·03:00:00
498	~~Length:·2,·~~dtype:·datetime64[ns]	489	dtype:·datetime64[ns]
499	You·can·pass·only·the·columns·that·you·need·to·assemble.	490	You·can·pass·only·the·columns·that·you·need·to·assemble.
500	In·[23]:·pd.to_datetime(df[["year",·"month",·"day"]])	491	In·[23]:·pd.to_datetime(df[["year",·"month",·"day"]])
501	Out[23]:	492	Out[23]:
502	0···2015-02-04	493	0···2015-02-04
503	1···2016-03-05	494	1···2016-03-05
504	~~Length:·2,·~~dtype:·datetime64[ns]	495	dtype:·datetime64[ns]
505	\x8\x8\x8\x8·O\x8Ot\x8th\x8he\x8er\x8r·e\x8en\x8nh\x8ha\x8an\x8nc\x8ce\x8em\x8me\x8en\x8nt\x8ts\x8s_\x8#\x8#·\x8\x8\x8\x8	496	\x8\x8\x8\x8·O\x8Ot\x8th\x8he\x8er\x8r·e\x8en\x8nh\x8ha\x8an\x8nc\x8ce\x8em\x8me\x8en\x8nt\x8ts\x8s_\x8#\x8#·\x8\x8\x8\x8
506	····*·pd.read_csv()·now·supports·delim_whitespace=True·for·the·Python·engine	497	····*·pd.read_csv()·now·supports·delim_whitespace=True·for·the·Python·engine
507	······(_\x8G_\x8H_\x8·_\x81_\x82_\x89_\x85_\x88)	498	······(_\x8G_\x8H_\x8·_\x81_\x82_\x89_\x85_\x88)
508	····*·pd.read_csv()·now·supports·opening·ZIP·files·that·contains·a·single·CSV,	499	····*·pd.read_csv()·now·supports·opening·ZIP·files·that·contains·a·single·CSV,
509	······via·extension·inference·or·explicit·compression='zip'·(_\x8G_\x8H_\x8·_\x81_\x82_\x81_\x87_\x85)	500	······via·extension·inference·or·explicit·compression='zip'·(_\x8G_\x8H_\x8·_\x81_\x82_\x81_\x87_\x85)
510	····*·pd.read_csv()·now·supports·opening·files·using·xz·compression,·via	501	····*·pd.read_csv()·now·supports·opening·files·using·xz·compression,·via
511	······extension·inference·or·explicit·compression='xz'·is·specified;·xz	502	······extension·inference·or·explicit·compression='xz'·is·specified;·xz
Offset 599, 16 lines modified		Offset 589, 14 lines modified

599	In·[30]:·df	589	In·[30]:·df
600	Out[30]:	590	Out[30]:
601	···A··B	591	···A··B
602	0··a··1	592	0··a··1
603	1··b··2	593	1··b··2
604	2··a··3	594	2··a··3

605	[3·rows·x·2·columns]
606	Previous·behavior:	595	Previous·behavior:
607	In·[3]:·df.groupby('A',·as_index=True)['B'].nth(0)	596	In·[3]:·df.groupby('A',·as_index=True)['B'].nth(0)
608	Out[3]:	597	Out[3]:
609	0····1	598	0····1
610	1····2	599	1····2
611	Name:·B,·dtype:·int64	600	Name:·B,·dtype:·int64

Offset 618, 21 lines modified		Offset 606, 21 lines modified
618	1····2	606	1····2
619	Name:·B,·dtype:·int64	607	Name:·B,·dtype:·int64
620	New·behavior:	608	New·behavior:
621	In·[31]:·df.groupby("A",·as_index=True)["B"].nth(0)	609	In·[31]:·df.groupby("A",·as_index=True)["B"].nth(0)
622	Out[31]:	610	Out[31]:
623	0····1	611	0····1
624	1····2	612	1····2
625	Name:·B,·~~Length:·2,·~~dtype:·int64	613	Name:·B,·dtype:·int64

626	In·[32]:·df.groupby("A",·as_index=False)["B"].nth(0)	614	In·[32]:·df.groupby("A",·as_index=False)["B"].nth(0)
627	Out[32]:	615	Out[32]:
628	0····1	616	0····1
629	1····2	617	1····2
630	Name:·B,·~~Length:·2,·~~dtype:·int64	618	Name:·B,·dtype:·int64
631	Furthermore,·previously,·a·.groupby·would·always·sort,·regardless·if·sort=False	619	Furthermore,·previously,·a·.groupby·would·always·sort,·regardless·if·sort=False
632	was·passed·with·.nth().	620	was·passed·with·.nth().
Max diff block lines reached; 1469/5041 bytes (29.14%) of diff not shown.

⊟

72.3 KB

./usr/share/doc/python-pandas-doc/html/whatsnew/v0.19.0.html ¶

⊟

19.8 KB

html2text {} ¶


Offset 207, 45 lines modified		Offset 207, 37 lines modified
207	In·[3]:·left	207	In·[3]:·left
208	Out[3]:	208	Out[3]:
209	····a·left_val	209	····a·left_val
210	0···1········a	210	0···1········a
211	1···5········b	211	1···5········b
212	2··10········c	212	2··10········c

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

214	In·[4]:·right	213	In·[4]:·right
215	Out[4]:	214	Out[4]:
216	···a··right_val	215	···a··right_val
217	0··1··········1	216	0··1··········1
218	1··2··········2	217	1··2··········2
219	2··3··········3	218	2··3··········3
220	3··6··········6	219	3··6··········6
221	4··7··········7	220	4··7··········7

222	[5·rows·x·2·columns]
223	We·typically·want·to·match·exactly·when·possible,·and·use·the·most·recent·value	221	We·typically·want·to·match·exactly·when·possible,·and·use·the·most·recent·value
224	otherwise.	222	otherwise.
225	In·[5]:·pd.merge_asof(left,·right,·on="a")	223	In·[5]:·pd.merge_asof(left,·right,·on="a")
226	Out[5]:	224	Out[5]:
227	····a·left_val··right_val	225	····a·left_val··right_val
228	0···1········a··········1	226	0···1········a··········1
229	1···5········b··········3	227	1···5········b··········3
230	2··10········c··········7	228	2··10········c··········7

231	[3·rows·x·3·columns]
232	We·can·also·match·rows·ONLY·with·prior·data,·and·not·an·exact·match.	229	We·can·also·match·rows·ONLY·with·prior·data,·and·not·an·exact·match.
233	In·[6]:·pd.merge_asof(left,·right,·on="a",·allow_exact_matches=False)	230	In·[6]:·pd.merge_asof(left,·right,·on="a",·allow_exact_matches=False)
234	Out[6]:	231	Out[6]:
235	····a·left_val··right_val	232	····a·left_val··right_val
236	0···1········a········NaN	233	0···1········a········NaN
237	1···5········b········3.0	234	1···5········b········3.0
238	2··10········c········7.0	235	2··10········c········7.0

239	[3·rows·x·3·columns]
240	In·a·typical·time-series·example,·we·have·trades·and·quotes·and·we·want·to	236	In·a·typical·time-series·example,·we·have·trades·and·quotes·and·we·want·to
241	asof-join·them.·This·also·illustrates·using·the·by·parameter·to·group·data	237	asof-join·them.·This·also·illustrates·using·the·by·parameter·to·group·data
242	before·merging.	238	before·merging.
243	In·[7]:·trades·=·pd.DataFrame(	239	In·[7]:·trades·=·pd.DataFrame(
244	···...:·····{	240	···...:·····{
245	···...:·········"time":·pd.to_datetime(	241	···...:·········"time":·pd.to_datetime(
246	···...:·············[	242	···...:·············[
Offset 293, 43 lines modified		Offset 285, 37 lines modified
293	·····················time·ticker···price··quantity	285	·····················time·ticker···price··quantity
294	0·2016-05-25·13:30:00.023···MSFT···51.95········75	286	0·2016-05-25·13:30:00.023···MSFT···51.95········75
295	1·2016-05-25·13:30:00.038···MSFT···51.95·······155	287	1·2016-05-25·13:30:00.038···MSFT···51.95·······155
296	2·2016-05-25·13:30:00.048···GOOG··720.77·······100	288	2·2016-05-25·13:30:00.048···GOOG··720.77·······100
297	3·2016-05-25·13:30:00.048···GOOG··720.92·······100	289	3·2016-05-25·13:30:00.048···GOOG··720.92·······100
298	4·2016-05-25·13:30:00.048···AAPL···98.00·······100	290	4·2016-05-25·13:30:00.048···AAPL···98.00·······100

299	[5·rows·x·4·columns]

300	In·[10]:·quotes	291	In·[10]:·quotes
301	Out[10]:	292	Out[10]:
302	·····················time·ticker·····bid·····ask	293	·····················time·ticker·····bid·····ask
303	0·2016-05-25·13:30:00.023···GOOG··720.50··720.93	294	0·2016-05-25·13:30:00.023···GOOG··720.50··720.93
304	1·2016-05-25·13:30:00.023···MSFT···51.95···51.96	295	1·2016-05-25·13:30:00.023···MSFT···51.95···51.96
305	2·2016-05-25·13:30:00.030···MSFT···51.97···51.98	296	2·2016-05-25·13:30:00.030···MSFT···51.97···51.98
306	3·2016-05-25·13:30:00.041···MSFT···51.99···52.00	297	3·2016-05-25·13:30:00.041···MSFT···51.99···52.00
307	4·2016-05-25·13:30:00.048···GOOG··720.50··720.93	298	4·2016-05-25·13:30:00.048···GOOG··720.50··720.93
308	5·2016-05-25·13:30:00.049···AAPL···97.99···98.01	299	5·2016-05-25·13:30:00.049···AAPL···97.99···98.01
309	6·2016-05-25·13:30:00.072···GOOG··720.50··720.88	300	6·2016-05-25·13:30:00.072···GOOG··720.50··720.88
310	7·2016-05-25·13:30:00.075···MSFT···52.01···52.03	301	7·2016-05-25·13:30:00.075···MSFT···52.01···52.03

311	[8·rows·x·4·columns]
312	An·asof·merge·joins·on·the·on,·typically·a·datetimelike·field,·which·is	302	An·asof·merge·joins·on·the·on,·typically·a·datetimelike·field,·which·is
313	ordered,·and·in·this·case·we·are·using·a·grouper·in·the·by·field.·This·is·like	303	ordered,·and·in·this·case·we·are·using·a·grouper·in·the·by·field.·This·is·like
314	a·left-outer·join,·except·that·forward·filling·happens·automatically·taking·the	304	a·left-outer·join,·except·that·forward·filling·happens·automatically·taking·the
315	most·recent·non-NaN·value.	305	most·recent·non-NaN·value.
316	In·[11]:·pd.merge_asof(trades,·quotes,·on="time",·by="ticker")	306	In·[11]:·pd.merge_asof(trades,·quotes,·on="time",·by="ticker")
317	Out[11]:	307	Out[11]:
318	·····················time·ticker···price··quantity·····bid·····ask	308	·····················time·ticker···price··quantity·····bid·····ask
319	0·2016-05-25·13:30:00.023···MSFT···51.95········75···51.95···51.96	309	0·2016-05-25·13:30:00.023···MSFT···51.95········75···51.95···51.96
320	1·2016-05-25·13:30:00.038···MSFT···51.95·······155···51.97···51.98	310	1·2016-05-25·13:30:00.038···MSFT···51.95·······155···51.97···51.98
321	2·2016-05-25·13:30:00.048···GOOG··720.77·······100··720.50··720.93	311	2·2016-05-25·13:30:00.048···GOOG··720.77·······100··720.50··720.93
322	3·2016-05-25·13:30:00.048···GOOG··720.92·······100··720.50··720.93	312	3·2016-05-25·13:30:00.048···GOOG··720.92·······100··720.50··720.93
323	4·2016-05-25·13:30:00.048···AAPL···98.00·······100·····NaN·····NaN	313	4·2016-05-25·13:30:00.048···AAPL···98.00·······100·····NaN·····NaN

324	[5·rows·x·6·columns]
325	This·returns·a·merged·DataFrame·with·the·entries·in·the·same·order·as·the	314	This·returns·a·merged·DataFrame·with·the·entries·in·the·same·order·as·the
326	original·left·passed·DataFrame·(trades·in·this·case),·with·the·fields·of·the	315	original·left·passed·DataFrame·(trades·in·this·case),·with·the·fields·of·the
327	quotes·merged.	316	quotes·merged.
328	\x8\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8d·.\x8.r\x8ro\x8ol\x8ll\x8li\x8in\x8ng\x8g(\x8()\x8)·i\x8is\x8s·n\x8no\x8ow\x8w·t\x8ti\x8im\x8me\x8e-\x8-s\x8se\x8er\x8ri\x8ie\x8es\x8s·a\x8aw\x8wa\x8ar\x8re\x8e_\x8#\x8#·\x8\x8\x8\x8	317	\x8\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8d·.\x8.r\x8ro\x8ol\x8ll\x8li\x8in\x8ng\x8g(\x8()\x8)·i\x8is\x8s·n\x8no\x8ow\x8w·t\x8ti\x8im\x8me\x8e-\x8-s\x8se\x8er\x8ri\x8ie\x8es\x8s·a\x8aw\x8wa\x8ar\x8re\x8e_\x8#\x8#·\x8\x8\x8\x8
329	.rolling()·objects·are·now·time-series·aware·and·can·accept·a·time-series	318	.rolling()·objects·are·now·time-series·aware·and·can·accept·a·time-series
330	offset·(or·convertible)·for·the·window·argument·(_\x8G_\x8H_\x8·_\x81_\x83_\x83_\x82_\x87,·_\x8G_\x8H_\x8·_\x81_\x82_\x89_\x89_\x85).·See·the	319	offset·(or·convertible)·for·the·window·argument·(_\x8G_\x8H_\x8·_\x81_\x83_\x83_\x82_\x87,·_\x8G_\x8H_\x8·_\x81_\x82_\x89_\x89_\x85).·See·the
331	full·documentation·_\x8h_\x8e_\x8r_\x8e.	320	full·documentation·_\x8h_\x8e_\x8r_\x8e.
Offset 343, 51 lines modified		Offset 329, 43 lines modified
343	Out[13]:	329	Out[13]:
344	·······················B	330	·······················B
345	2013-01-01·09:00:00··0.0	331	2013-01-01·09:00:00··0.0
346	2013-01-01·09:00:01··1.0	332	2013-01-01·09:00:01··1.0
347	2013-01-01·09:00:02··2.0	333	2013-01-01·09:00:02··2.0
348	2013-01-01·09:00:03··NaN	334	2013-01-01·09:00:03··NaN
349	2013-01-01·09:00:04··4.0	335	2013-01-01·09:00:04··4.0

350	[5·rows·x·1·columns]
351	This·is·a·regular·frequency·index.·Using·an·integer·window·parameter·works·to	336	This·is·a·regular·frequency·index.·Using·an·integer·window·parameter·works·to
352	roll·along·the·window·frequency.	337	roll·along·the·window·frequency.
353	In·[14]:·dft.rolling(2).sum()	338	In·[14]:·dft.rolling(2).sum()
354	Out[14]:	339	Out[14]:
355	·······················B	340	·······················B
356	2013-01-01·09:00:00··NaN	341	2013-01-01·09:00:00··NaN
357	2013-01-01·09:00:01··1.0	342	2013-01-01·09:00:01··1.0
358	2013-01-01·09:00:02··3.0	343	2013-01-01·09:00:02··3.0
359	2013-01-01·09:00:03··NaN	344	2013-01-01·09:00:03··NaN
360	2013-01-01·09:00:04··NaN	345	2013-01-01·09:00:04··NaN

361	[5·rows·x·1·columns]

362	In·[15]:·dft.rolling(2,·min_periods=1).sum()	346	In·[15]:·dft.rolling(2,·min_periods=1).sum()
363	Out[15]:	347	Out[15]:
364	·······················B	348	·······················B
365	2013-01-01·09:00:00··0.0	349	2013-01-01·09:00:00··0.0
366	2013-01-01·09:00:01··1.0	350	2013-01-01·09:00:01··1.0
367	2013-01-01·09:00:02··3.0	351	2013-01-01·09:00:02··3.0
368	2013-01-01·09:00:03··2.0	352	2013-01-01·09:00:03··2.0
369	2013-01-01·09:00:04··4.0	353	2013-01-01·09:00:04··4.0

370	[5·rows·x·1·columns]
371	Specifying·an·offset·allows·a·more·intuitive·specification·of·the·rolling	354	Specifying·an·offset·allows·a·more·intuitive·specification·of·the·rolling
372	frequency.	355	frequency.
373	In·[16]:·dft.rolling("2s").sum()	356	In·[16]:·dft.rolling("2s").sum()
374	Out[16]:	357	Out[16]:
375	·······················B	358	·······················B
Max diff block lines reached; 15983/20242 bytes (78.96%) of diff not shown.

⊟

73.4 KB

./usr/share/doc/python-pandas-doc/html/whatsnew/v0.20.0.html ¶

⊟

19.8 KB

html2text {} ¶


Offset 235, 45 lines modified		Offset 235, 39 lines modified
235	2000-01-04·······NaN·······NaN·······NaN	235	2000-01-04·······NaN·······NaN·······NaN
236	2000-01-05·······NaN·······NaN·······NaN	236	2000-01-05·······NaN·······NaN·······NaN
237	2000-01-06·······NaN·······NaN·······NaN	237	2000-01-06·······NaN·······NaN·······NaN
238	2000-01-07·······NaN·······NaN·······NaN	238	2000-01-07·······NaN·······NaN·······NaN
239	2000-01-08··0.113648·-1.478427··0.524988	239	2000-01-08··0.113648·-1.478427··0.524988
240	2000-01-09··0.404705··0.577046·-1.715002	240	2000-01-09··0.404705··0.577046·-1.715002
241	2000-01-10·-1.039268·-0.370647·-1.157892	241	2000-01-10·-1.039268·-0.370647·-1.157892

242	[10·rows·x·3·columns]
243	One·can·operate·using·string·function·names,·callables,·lists,·or·dictionaries	242	One·can·operate·using·string·function·names,·callables,·lists,·or·dictionaries
244	of·these.	243	of·these.
245	Using·a·single·function·is·equivalent·to·.apply.	244	Using·a·single·function·is·equivalent·to·.apply.
246	In·[4]:·df.agg('sum')	245	In·[4]:·df.agg('sum')
247	Out[4]:	246	Out[4]:
248	A···-1.068226	247	A···-1.068226
249	B···-1.387015	248	B···-1.387015
250	C···-4.892029	249	C···-4.892029
251	~~Length:·3,·~~dtype:·float64	250	dtype:·float64
252	Multiple·aggregations·with·a·list·of·functions.	251	Multiple·aggregations·with·a·list·of·functions.
253	In·[5]:·df.agg(['sum',·'min'])	252	In·[5]:·df.agg(['sum',·'min'])
254	Out[5]:	253	Out[5]:
255	············A·········B·········C	254	············A·········B·········C
256	sum·-1.068226·-1.387015·-4.892029	255	sum·-1.068226·-1.387015·-4.892029
257	min·-1.135632·-1.478427·-1.715002	256	min·-1.135632·-1.478427·-1.715002

258	[2·rows·x·3·columns]
259	Using·a·dict·provides·the·ability·to·apply·specific·aggregations·per·column.	257	Using·a·dict·provides·the·ability·to·apply·specific·aggregations·per·column.
260	You·will·get·a·matrix-like·output·of·all·of·the·aggregators.·The·output·has·one	258	You·will·get·a·matrix-like·output·of·all·of·the·aggregators.·The·output·has·one
261	column·per·unique·function.·Those·functions·applied·to·a·particular·column·will	259	column·per·unique·function.·Those·functions·applied·to·a·particular·column·will
262	be·NaN:	260	be·NaN:
263	In·[6]:·df.agg({'A':·['sum',·'min'],·'B':·['min',·'max']})	261	In·[6]:·df.agg({'A':·['sum',·'min'],·'B':·['min',·'max']})
264	Out[6]:	262	Out[6]:
265	············A·········B	263	············A·········B
266	sum·-1.068226·······NaN	264	sum·-1.068226·······NaN
267	min·-1.135632·-1.478427	265	min·-1.135632·-1.478427
268	max·······NaN··1.212112	266	max·······NaN··1.212112

269	[3·rows·x·2·columns]
270	The·API·also·supports·a·.transform()·function·for·broadcasting·results.	267	The·API·also·supports·a·.transform()·function·for·broadcasting·results.
271	In·[7]:·df.transform(['abs',·lambda·x:·x·-·x.min()])	268	In·[7]:·df.transform(['abs',·lambda·x:·x·-·x.min()])
272	Out[7]:	269	Out[7]:
273	···················A···················B···················C	270	···················A···················B···················C
274	·················abs··<lambda>·······abs··<lambda>·······abs··<lambda>	271	·················abs··<lambda>·······abs··<lambda>·······abs··<lambda>
275	2000-01-01··0.469112··1.604745··0.282863··1.195563··1.509059··0.205944	272	2000-01-01··0.469112··1.604745··0.282863··1.195563··1.509059··0.205944
276	2000-01-02··1.135632··0.000000··1.212112··2.690539··0.173215··1.541787	273	2000-01-02··1.135632··0.000000··1.212112··2.690539··0.173215··1.541787
Offset 281, 16 lines modified		Offset 275, 14 lines modified
281	2000-01-04·······NaN·······NaN·······NaN·······NaN·······NaN·······NaN	275	2000-01-04·······NaN·······NaN·······NaN·······NaN·······NaN·······NaN
282	2000-01-05·······NaN·······NaN·······NaN·······NaN·······NaN·······NaN	276	2000-01-05·······NaN·······NaN·······NaN·······NaN·······NaN·······NaN
283	2000-01-06·······NaN·······NaN·······NaN·······NaN·······NaN·······NaN	277	2000-01-06·······NaN·······NaN·······NaN·······NaN·······NaN·······NaN
284	2000-01-07·······NaN·······NaN·······NaN·······NaN·······NaN·······NaN	278	2000-01-07·······NaN·······NaN·······NaN·······NaN·······NaN·······NaN
285	2000-01-08··0.113648··1.249281··1.478427··0.000000··0.524988··2.239990	279	2000-01-08··0.113648··1.249281··1.478427··0.000000··0.524988··2.239990
286	2000-01-09··0.404705··1.540338··0.577046··2.055473··1.715002··0.000000	280	2000-01-09··0.404705··1.540338··0.577046··2.055473··1.715002··0.000000
287	2000-01-10··1.039268··0.096364··0.370647··1.107780··1.157892··0.557110	281	2000-01-10··1.039268··0.096364··0.370647··1.107780··1.157892··0.557110

288	[10·rows·x·6·columns]
289	When·presented·with·mixed·dtypes·that·cannot·be·aggregated,·.agg()·will·only	282	When·presented·with·mixed·dtypes·that·cannot·be·aggregated,·.agg()·will·only
290	take·the·valid·aggregations.·This·is·similar·to·how·groupby·.agg()·works.·(_\x8G_\x8H	283	take·the·valid·aggregations.·This·is·similar·to·how·groupby·.agg()·works.·(_\x8G_\x8H
291	_\x81_\x85_\x80_\x81_\x85)	284	_\x81_\x85_\x80_\x81_\x85)
292	In·[8]:·df·=·pd.DataFrame({'A':·[1,·2,·3],	285	In·[8]:·df·=·pd.DataFrame({'A':·[1,·2,·3],
293	···...:····················'B':·[1.,·2.,·3.],	286	···...:····················'B':·[1.,·2.,·3.],
294	···...:····················'C':·['foo',·'bar',·'baz'],	287	···...:····················'C':·['foo',·'bar',·'baz'],
295	···...:····················'D':·pd.date_range('20130101',·periods=3)})	288	···...:····················'D':·pd.date_range('20130101',·periods=3)})
Offset 298, 15 lines modified		Offset 290, 15 lines modified

298	In·[9]:·df.dtypes	290	In·[9]:·df.dtypes
299	Out[9]:	291	Out[9]:
300	A·············int64	292	A·············int64
301	B···········float64	293	B···········float64
302	C············object	294	C············object
303	D····datetime64[ns]	295	D····datetime64[ns]
304	~~Length:·4,·~~dtype:·object	296	dtype:·object
305	In·[10]:·df.agg(['min',·'sum'])	297	In·[10]:·df.agg(['min',·'sum'])
306	Out[10]:	298	Out[10]:
307	·····A····B··········C··········D	299	·····A····B··········C··········D
308	min··1··1.0········bar·2013-01-01	300	min··1··1.0········bar·2013-01-01
309	sum··6··6.0··foobarbaz········NaT	301	sum··6··6.0··foobarbaz········NaT
310	\x8\x8\x8\x8·K\x8Ke\x8ey\x8yw\x8wo\x8or\x8rd\x8d·a\x8ar\x8rg\x8gu\x8um\x8me\x8en\x8nt\x8t·d\x8dt\x8ty\x8yp\x8pe\x8e·f\x8fo\x8or\x8r·d\x8da\x8at\x8ta\x8a·I\x8IO\x8O_\x8#\x8#·\x8\x8\x8\x8	302	\x8\x8\x8\x8·K\x8Ke\x8ey\x8yw\x8wo\x8or\x8rd\x8d·a\x8ar\x8rg\x8gu\x8um\x8me\x8en\x8nt\x8t·d\x8dt\x8ty\x8yp\x8pe\x8e·f\x8fo\x8or\x8r·d\x8da\x8at\x8ta\x8a·I\x8IO\x8O_\x8#\x8#·\x8\x8\x8\x8
311	The·'python'·engine·for·_\x8r_\x8e_\x8a_\x8d_\x8__\x8c_\x8s_\x8v_\x8(_\x8),·as·well·as·the·_\x8r_\x8e_\x8a_\x8d_\x8__\x8f_\x8w_\x8f_\x8(_\x8)·function·for	303	The·'python'·engine·for·_\x8r_\x8e_\x8a_\x8d_\x8__\x8c_\x8s_\x8v_\x8(_\x8),·as·well·as·the·_\x8r_\x8e_\x8a_\x8d_\x8__\x8f_\x8w_\x8f_\x8(_\x8)·function·for
Offset 315, 22 lines modified		Offset 307, 22 lines modified
315	(_\x8G_\x8H_\x8·_\x81_\x84_\x82_\x89_\x85).·See·the·_\x8i_\x8o_\x8·_\x8d_\x8o_\x8c_\x8s·for·more·information.	307	(_\x8G_\x8H_\x8·_\x81_\x84_\x82_\x89_\x85).·See·the·_\x8i_\x8o_\x8·_\x8d_\x8o_\x8c_\x8s·for·more·information.
316	In·[10]:·data·=·"a··b\n1··2\n3··4"	308	In·[10]:·data·=·"a··b\n1··2\n3··4"

317	In·[11]:·pd.read_fwf(StringIO(data)).dtypes	309	In·[11]:·pd.read_fwf(StringIO(data)).dtypes
318	Out[11]:	310	Out[11]:
319	a····int64	311	a····int64
320	b····int64	312	b····int64
321	~~Length:·2,·~~dtype:·object	313	dtype:·object

322	In·[12]:·pd.read_fwf(StringIO(data),·dtype={'a':·'float64',·'b':	314	In·[12]:·pd.read_fwf(StringIO(data),·dtype={'a':·'float64',·'b':
323	'object'}).dtypes	315	'object'}).dtypes
324	Out[12]:	316	Out[12]:
325	a····float64	317	a····float64
326	b·····object	318	b·····object
327	~~Length:·2,·~~dtype:·object	319	dtype:·object
328	\x8\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8d·.\x8.t\x8to\x8o_\x8_d\x8da\x8at\x8te\x8et\x8ti\x8im\x8me\x8e(\x8()\x8)·h\x8ha\x8as\x8s·g\x8ga\x8ai\x8in\x8ne\x8ed\x8d·a\x8an\x8n·o\x8or\x8ri\x8ig\x8gi\x8in\x8n·p\x8pa\x8ar\x8ra\x8am\x8me\x8et\x8te\x8er\x8r_\x8#\x8#·\x8\x8\x8\x8	320	\x8\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8d·.\x8.t\x8to\x8o_\x8_d\x8da\x8at\x8te\x8et\x8ti\x8im\x8me\x8e(\x8()\x8)·h\x8ha\x8as\x8s·g\x8ga\x8ai\x8in\x8ne\x8ed\x8d·a\x8an\x8n·o\x8or\x8ri\x8ig\x8gi\x8in\x8n·p\x8pa\x8ar\x8ra\x8am\x8me\x8et\x8te\x8er\x8r_\x8#\x8#·\x8\x8\x8\x8
329	_\x8t_\x8o_\x8__\x8d_\x8a_\x8t_\x8e_\x8t_\x8i_\x8m_\x8e_\x8(_\x8)·has·gained·a·new·parameter,·origin,·to·define·a·reference·date	321	_\x8t_\x8o_\x8__\x8d_\x8a_\x8t_\x8e_\x8t_\x8i_\x8m_\x8e_\x8(_\x8)·has·gained·a·new·parameter,·origin,·to·define·a·reference·date
330	from·where·to·compute·the·resulting·timestamps·when·parsing·numerical·values	322	from·where·to·compute·the·resulting·timestamps·when·parsing·numerical·values
331	with·a·specific·unit·specified.·(_\x8G_\x8H_\x8·_\x81_\x81_\x82_\x87_\x86,·_\x8G_\x8H_\x8·_\x81_\x81_\x87_\x84_\x85)	323	with·a·specific·unit·specified.·(_\x8G_\x8H_\x8·_\x81_\x81_\x82_\x87_\x86,·_\x8G_\x8H_\x8·_\x81_\x81_\x87_\x84_\x85)
332	For·example,·with·1960-01-01·as·the·starting·date:	324	For·example,·with·1960-01-01·as·the·starting·date:
333	In·[13]:·pd.to_datetime([1,·2,·3],·unit='D',·origin=pd.Timestamp('1960-01-01'))	325	In·[13]:·pd.to_datetime([1,·2,·3],·unit='D',·origin=pd.Timestamp('1960-01-01'))
334	Out[13]:·DatetimeIndex(['1960-01-02',·'1960-01-03',·'1960-01-04'],	326	Out[13]:·DatetimeIndex(['1960-01-02',·'1960-01-03',·'1960-01-04'],
Offset 366, 28 lines modified		Offset 358, 24 lines modified
366	baz···one·····1··2	358	baz···one·····1··2
367	······two·····1··3	359	······two·····1··3
368	foo···one·····2··4	360	foo···one·····2··4
369	······two·····2··5	361	······two·····2··5
370	qux···one·····3··6	362	qux···one·····3··6
371	······two·····3··7	363	······two·····3··7

372	[8·rows·x·2·columns]

373	In·[19]:·df.groupby(['second',·'A']).sum()	364	In·[19]:·df.groupby(['second',·'A']).sum()
374	Out[19]:	365	Out[19]:
375	··········B	366	··········B
376	second·A	367	second·A
377	one····1··2	368	one····1··2
378	·······2··4	369	·······2··4
379	·······3··6	370	·······3··6
380	two····1··4	371	two····1··4
381	·······2··5	372	·······2··5
382	·······3··7	373	·······3··7

383	[6·rows·x·1·columns]
384	\x8\x8\x8\x8·B\x8Be\x8et\x8tt\x8te\x8er\x8r·s\x8su\x8up\x8pp\x8po\x8or\x8rt\x8t·f\x8fo\x8or\x8r·c\x8co\x8om\x8mp\x8pr\x8re\x8es\x8ss\x8se\x8ed\x8d·U\x8UR\x8RL\x8Ls\x8s·i\x8in\x8n·r\x8re\x8ea\x8ad\x8d_\x8_c\x8cs\x8sv\x8v_\x8#\x8#·\x8\x8\x8\x8	374	\x8\x8\x8\x8·B\x8Be\x8et\x8tt\x8te\x8er\x8r·s\x8su\x8up\x8pp\x8po\x8or\x8rt\x8t·f\x8fo\x8or\x8r·c\x8co\x8om\x8mp\x8pr\x8re\x8es\x8ss\x8se\x8ed\x8d·U\x8UR\x8RL\x8Ls\x8s·i\x8in\x8n·r\x8re\x8ea\x8ad\x8d_\x8_c\x8cs\x8sv\x8v_\x8#\x8#·\x8\x8\x8\x8
385	The·compression·code·was·refactored·(_\x8G_\x8H_\x8·_\x81_\x82_\x86_\x88_\x88).·As·a·result,·reading·dataframes	375	The·compression·code·was·refactored·(_\x8G_\x8H_\x8·_\x81_\x82_\x86_\x88_\x88).·As·a·result,·reading·dataframes
386	from·URLs·in·_\x8r_\x8e_\x8a_\x8d_\x8__\x8c_\x8s_\x8v_\x8(_\x8)·or·_\x8r_\x8e_\x8a_\x8d_\x8__\x8t_\x8a_\x8b_\x8l_\x8e_\x8(_\x8)·now·supports·additional·compression	376	from·URLs·in·_\x8r_\x8e_\x8a_\x8d_\x8__\x8c_\x8s_\x8v_\x8(_\x8)·or·_\x8r_\x8e_\x8a_\x8d_\x8__\x8t_\x8a_\x8b_\x8l_\x8e_\x8(_\x8)·now·supports·additional·compression
387	methods:·xz,·bz2,·and·zip·(_\x8G_\x8H_\x8·_\x81_\x84_\x85_\x87_\x80).·Previously,·only·gzip·compression·was	377	methods:·xz,·bz2,·and·zip·(_\x8G_\x8H_\x8·_\x81_\x84_\x85_\x87_\x80).·Previously,·only·gzip·compression·was
Max diff block lines reached; 15104/20263 bytes (74.54%) of diff not shown.

⊟

42.2 KB

./usr/share/doc/python-pandas-doc/html/whatsnew/v0.21.0.html ¶

⊟

10.2 KB

html2text {} ¶


Offset 212, 35 lines modified		Offset 212, 35 lines modified
212	···...:	212	···...:

213	In·[2]:·df.dtypes	213	In·[2]:·df.dtypes
214	Out[2]:	214	Out[2]:
215	A·····int64	215	A·····int64
216	B····object	216	B····object
217	C····object	217	C····object
218	~~Length:·3,·~~dtype:·object	218	dtype:·object

219	In·[3]:·df.infer_objects().dtypes	219	In·[3]:·df.infer_objects().dtypes
220	Out[3]:	220	Out[3]:
221	A·····int64	221	A·····int64
222	B·····int64	222	B·····int64
223	C····object	223	C····object
224	~~Length:·3,·~~dtype:·object	224	dtype:·object
225	Note·that·column·'C'·was·not·converted·-·only·scalar·numeric·types·will·be	225	Note·that·column·'C'·was·not·converted·-·only·scalar·numeric·types·will·be
226	converted·to·a·new·type.·Other·types·of·conversion·should·be·accomplished·using	226	converted·to·a·new·type.·Other·types·of·conversion·should·be·accomplished·using
227	the·_\x8t_\x8o_\x8__\x8n_\x8u_\x8m_\x8e_\x8r_\x8i_\x8c_\x8(_\x8)·function·(or·_\x8t_\x8o_\x8__\x8d_\x8a_\x8t_\x8e_\x8t_\x8i_\x8m_\x8e_\x8(_\x8),·_\x8t_\x8o_\x8__\x8t_\x8i_\x8m_\x8e_\x8d_\x8e_\x8l_\x8t_\x8a_\x8(_\x8)).	227	the·_\x8t_\x8o_\x8__\x8n_\x8u_\x8m_\x8e_\x8r_\x8i_\x8c_\x8(_\x8)·function·(or·_\x8t_\x8o_\x8__\x8d_\x8a_\x8t_\x8e_\x8t_\x8i_\x8m_\x8e_\x8(_\x8),·_\x8t_\x8o_\x8__\x8t_\x8i_\x8m_\x8e_\x8d_\x8e_\x8l_\x8t_\x8a_\x8(_\x8)).
228	In·[4]:·df·=·df.infer_objects()	228	In·[4]:·df·=·df.infer_objects()

229	In·[5]:·df['C']·=·pd.to_numeric(df['C'],·errors='coerce')	229	In·[5]:·df['C']·=·pd.to_numeric(df['C'],·errors='coerce')

230	In·[6]:·df.dtypes	230	In·[6]:·df.dtypes
231	Out[6]:	231	Out[6]:
232	A····int64	232	A····int64
233	B····int64	233	B····int64
234	C····int64	234	C····int64
235	~~Length:·3,·~~dtype:·object	235	dtype:·object
236	\x8\x8\x8\x8·I\x8Im\x8mp\x8pr\x8ro\x8ov\x8ve\x8ed\x8d·w\x8wa\x8ar\x8rn\x8ni\x8in\x8ng\x8gs\x8s·w\x8wh\x8he\x8en\x8n·a\x8at\x8tt\x8te\x8em\x8mp\x8pt\x8ti\x8in\x8ng\x8g·t\x8to\x8o·c\x8cr\x8re\x8ea\x8at\x8te\x8e·c\x8co\x8ol\x8lu\x8um\x8mn\x8ns\x8s_\x8#\x8#·\x8\x8\x8\x8	236	\x8\x8\x8\x8·I\x8Im\x8mp\x8pr\x8ro\x8ov\x8ve\x8ed\x8d·w\x8wa\x8ar\x8rn\x8ni\x8in\x8ng\x8gs\x8s·w\x8wh\x8he\x8en\x8n·a\x8at\x8tt\x8te\x8em\x8mp\x8pt\x8ti\x8in\x8ng\x8g·t\x8to\x8o·c\x8cr\x8re\x8ea\x8at\x8te\x8e·c\x8co\x8ol\x8lu\x8um\x8mn\x8ns\x8s_\x8#\x8#·\x8\x8\x8\x8
237	New·users·are·often·puzzled·by·the·relationship·between·column·operations·and	237	New·users·are·often·puzzled·by·the·relationship·between·column·operations·and
238	attribute·access·on·DataFrame·instances·(_\x8G_\x8H_\x8·_\x87_\x81_\x87_\x85).·One·specific·instance·of	238	attribute·access·on·DataFrame·instances·(_\x8G_\x8H_\x8·_\x87_\x81_\x87_\x85).·One·specific·instance·of
239	this·confusion·is·attempting·to·create·a·new·column·by·setting·an·attribute·on	239	this·confusion·is·attempting·to·create·a·new·column·by·setting·an·attribute·on
240	the·DataFrame:	240	the·DataFrame:
241	In·[1]:·df·=·pd.DataFrame({'one':·[1.,·2.,·3.]})	241	In·[1]:·df·=·pd.DataFrame({'one':·[1.,·2.,·3.]})
242	In·[2]:·df.two·=·[4,·5,·6]	242	In·[2]:·df.two·=·[4,·5,·6]
Offset 264, 91 lines modified		Offset 264, 73 lines modified

264	In·[8]:·df	264	In·[8]:·df
265	Out[8]:	265	Out[8]:
266	···A··B··C··D	266	···A··B··C··D
267	0··0··1··2··3	267	0··0··1··2··3
268	1··4··5··6··7	268	1··4··5··6··7

269	[2·rows·x·4·columns]

270	In·[9]:·df.drop(['B',·'C'],·axis=1)	269	In·[9]:·df.drop(['B',·'C'],·axis=1)
271	Out[9]:	270	Out[9]:
272	···A··D	271	···A··D
273	0··0··3	272	0··0··3
274	1··4··7	273	1··4··7

275	[2·rows·x·2·columns]

276	#·the·following·is·now·equivalent	274	#·the·following·is·now·equivalent
277	In·[10]:·df.drop(columns=['B',·'C'])	275	In·[10]:·df.drop(columns=['B',·'C'])
278	Out[10]:	276	Out[10]:
279	···A··D	277	···A··D
280	0··0··3	278	0··0··3
281	1··4··7	279	1··4··7

282	[2·rows·x·2·columns]
283	\x8\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8ds\x8s·r\x8re\x8en\x8na\x8am\x8me\x8e,\x8,·r\x8re\x8ei\x8in\x8nd\x8de\x8ex\x8x·n\x8no\x8ow\x8w·a\x8al\x8ls\x8so\x8o·a\x8ac\x8cc\x8ce\x8ep\x8pt\x8t·a\x8ax\x8xi\x8is\x8s·k\x8ke\x8ey\x8yw\x8wo\x8or\x8rd\x8d_\x8#\x8#·\x8\x8\x8\x8	280	\x8\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8ds\x8s·r\x8re\x8en\x8na\x8am\x8me\x8e,\x8,·r\x8re\x8ei\x8in\x8nd\x8de\x8ex\x8x·n\x8no\x8ow\x8w·a\x8al\x8ls\x8so\x8o·a\x8ac\x8cc\x8ce\x8ep\x8pt\x8t·a\x8ax\x8xi\x8is\x8s·k\x8ke\x8ey\x8yw\x8wo\x8or\x8rd\x8d_\x8#\x8#·\x8\x8\x8\x8
284	The·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8r_\x8e_\x8n_\x8a_\x8m_\x8e_\x8(_\x8)·and·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8r_\x8e_\x8i_\x8n_\x8d_\x8e_\x8x_\x8(_\x8)·methods·have·gained·the·axis	281	The·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8r_\x8e_\x8n_\x8a_\x8m_\x8e_\x8(_\x8)·and·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8r_\x8e_\x8i_\x8n_\x8d_\x8e_\x8x_\x8(_\x8)·methods·have·gained·the·axis
285	keyword·to·specify·the·axis·to·target·with·the·operation·(_\x8G_\x8H_\x8·_\x81_\x82_\x83_\x89_\x82).	282	keyword·to·specify·the·axis·to·target·with·the·operation·(_\x8G_\x8H_\x8·_\x81_\x82_\x83_\x89_\x82).
286	Here’s·rename:	283	Here’s·rename:
287	In·[11]:·df·=·pd.DataFrame({"A":·[1,·2,·3],·"B":·[4,·5,·6]})	284	In·[11]:·df·=·pd.DataFrame({"A":·[1,·2,·3],·"B":·[4,·5,·6]})

288	In·[12]:·df.rename(str.lower,·axis='columns')	285	In·[12]:·df.rename(str.lower,·axis='columns')
289	Out[12]:	286	Out[12]:
290	···a··b	287	···a··b
291	0··1··4	288	0··1··4
292	1··2··5	289	1··2··5
293	2··3··6	290	2··3··6

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

295	In·[13]:·df.rename(id,·axis='index')	291	In·[13]:·df.rename(id,·axis='index')
296	Out[13]:	292	Out[13]:
297	··········A··B	293	··········A··B
298	10713616··1··4	294	10713616··1··4
299	10713648··2··5	295	10713648··2··5
300	10713680··3··6	296	10713680··3··6

301	[3·rows·x·2·columns]
302	And·reindex:	297	And·reindex:
303	In·[14]:·df.reindex(['A',·'B',·'C'],·axis='columns')	298	In·[14]:·df.reindex(['A',·'B',·'C'],·axis='columns')
304	Out[14]:	299	Out[14]:
305	···A··B···C	300	···A··B···C
306	0··1··4·NaN	301	0··1··4·NaN
307	1··2··5·NaN	302	1··2··5·NaN
308	2··3··6·NaN	303	2··3··6·NaN

309	[3·rows·x·3·columns]

310	In·[15]:·df.reindex([0,·1,·3],·axis='index')	304	In·[15]:·df.reindex([0,·1,·3],·axis='index')
311	Out[15]:	305	Out[15]:
312	·····A····B	306	·····A····B
313	0··1.0··4.0	307	0··1.0··4.0
314	1··2.0··5.0	308	1··2.0··5.0
315	3··NaN··NaN	309	3··NaN··NaN

316	[3·rows·x·2·columns]
317	The·“index,·columns”·style·continues·to·work·as·before.	310	The·“index,·columns”·style·continues·to·work·as·before.
318	In·[16]:·df.rename(index=id,·columns=str.lower)	311	In·[16]:·df.rename(index=id,·columns=str.lower)
319	Out[16]:	312	Out[16]:
320	··········a··b	313	··········a··b
321	10713616··1··4	314	10713616··1··4
322	10713648··2··5	315	10713648··2··5
323	10713680··3··6	316	10713680··3··6

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

325	In·[17]:·df.reindex(index=[0,·1,·3],·columns=['A',·'B',·'C'])	317	In·[17]:·df.reindex(index=[0,·1,·3],·columns=['A',·'B',·'C'])
326	Out[17]:	318	Out[17]:
327	·····A····B···C	319	·····A····B···C
328	0··1.0··4.0·NaN	320	0··1.0··4.0·NaN
329	1··2.0··5.0·NaN	321	1··2.0··5.0·NaN
330	3··NaN··NaN·NaN	322	3··NaN··NaN·NaN

331	[3·rows·x·3·columns]
332	We·h\x8hi\x8ig\x8gh\x8hl\x8ly\x8y·encourage·using·named·arguments·to·avoid·confusion·when·using·either	323	We·h\x8hi\x8ig\x8gh\x8hl\x8ly\x8y·encourage·using·named·arguments·to·avoid·confusion·when·using·either
333	style.	324	style.
334	\x8\x8\x8\x8·C\x8Ca\x8at\x8te\x8eg\x8go\x8or\x8ri\x8ic\x8ca\x8al\x8lD\x8Dt\x8ty\x8yp\x8pe\x8e·f\x8fo\x8or\x8r·s\x8sp\x8pe\x8ec\x8ci\x8if\x8fy\x8yi\x8in\x8ng\x8g·c\x8ca\x8at\x8te\x8eg\x8go\x8or\x8ri\x8ic\x8ca\x8al\x8ls\x8s_\x8#\x8#·\x8\x8\x8\x8	325	\x8\x8\x8\x8·C\x8Ca\x8at\x8te\x8eg\x8go\x8or\x8ri\x8ic\x8ca\x8al\x8lD\x8Dt\x8ty\x8yp\x8pe\x8e·f\x8fo\x8or\x8r·s\x8sp\x8pe\x8ec\x8ci\x8if\x8fy\x8yi\x8in\x8ng\x8g·c\x8ca\x8at\x8te\x8eg\x8go\x8or\x8ri\x8ic\x8ca\x8al\x8ls\x8s_\x8#\x8#·\x8\x8\x8\x8
335	pandas.api.types.CategoricalDtype·has·been·added·to·the·public·API·and·expanded	326	pandas.api.types.CategoricalDtype·has·been·added·to·the·public·API·and·expanded
336	to·include·the·categories·and·ordered·attributes.·A·CategoricalDtype·can·be	327	to·include·the·categories·and·ordered·attributes.·A·CategoricalDtype·can·be
337	used·to·specify·the·set·of·categories·and·orderedness·of·an·array,·independent	328	used·to·specify·the·set·of·categories·and·orderedness·of·an·array,·independent
338	of·the·data.·This·can·be·useful·for·example,·when·converting·string·data·to·a	329	of·the·data.·This·can·be·useful·for·example,·when·converting·string·data·to·a
Max diff block lines reached; 6759/10396 bytes (65.02%) of diff not shown.

⊟

9.76 KB

./usr/share/doc/python-pandas-doc/html/whatsnew/v0.22.0.html ¶


Offset 745, 24 lines modified		Offset 745, 24 lines modified
745	<p><em>pandas·0.22</em></p>	745	<p><em>pandas·0.22</em></p>
746	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[8]:·</span><span·class="n">grouper</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">Categorical</span><span·class="p">([</span><span·class="s2">"a"</span><span·class="p">,</span>·<span·class="s2">"a"</span><span·class="p">],</span>·<span·class="n">categories</span><span·class="o">=</span><span·class="p">[</span><span·class="s2">"a"</span><span·class="p">,</span>·<span·class="s2">"b"</span><span·class="p">])</span>	746	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[8]:·</span><span·class="n">grouper</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">Categorical</span><span·class="p">([</span><span·class="s2">"a"</span><span·class="p">,</span>·<span·class="s2">"a"</span><span·class="p">],</span>·<span·class="n">categories</span><span·class="o">=</span><span·class="p">[</span><span·class="s2">"a"</span><span·class="p">,</span>·<span·class="s2">"b"</span><span·class="p">])</span>

747	<span·class="gp">In·[9]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">Series</span><span·class="p">([</span><span·class="mi">1</span><span·class="p">,</span>·<span·class="mi">2</span><span·class="p">])</span><span·class="o">.</span><span·class="n">groupby</span><span·class="p">(</span><span·class="n">grouper</span><span·class="p">,</span>·<span·class="n">observed</span><span·class="o">=</span><span·class="kc">False</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">()</span>	747	<span·class="gp">In·[9]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">Series</span><span·class="p">([</span><span·class="mi">1</span><span·class="p">,</span>·<span·class="mi">2</span><span·class="p">])</span><span·class="o">.</span><span·class="n">groupby</span><span·class="p">(</span><span·class="n">grouper</span><span·class="p">,</span>·<span·class="n">observed</span><span·class="o">=</span><span·class="kc">False</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">()</span>
748	<span·class="gh">Out[9]:·</span>	748	<span·class="gh">Out[9]:·</span>
749	<span·class="go">a····3</span>	749	<span·class="go">a····3</span>
750	<span·class="go">b····0</span>	750	<span·class="go">b····0</span>
751	<span·class="go">~~Length:·2,·~~dtype:·int64</span>	751	<span·class="go">dtype:·int64</span>
752	</pre></div>	752	</pre></div>
753	</div>	753	</div>
754	<p>To·restore·the·0.21·behavior·of·returning·<code·class="docutils·literal·notranslate"><span·class="pre">NaN</span></code>·for·unobserved·groups,	754	<p>To·restore·the·0.21·behavior·of·returning·<code·class="docutils·literal·notranslate"><span·class="pre">NaN</span></code>·for·unobserved·groups,
755	use·<code·class="docutils·literal·notranslate"><span·class="pre">min_count>=1</span></code>.</p>	755	use·<code·class="docutils·literal·notranslate"><span·class="pre">min_count>=1</span></code>.</p>
756	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[10]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">Series</span><span·class="p">([</span><span·class="mi">1</span><span·class="p">,</span>·<span·class="mi">2</span><span·class="p">])</span><span·class="o">.</span><span·class="n">groupby</span><span·class="p">(</span><span·class="n">grouper</span><span·class="p">,</span>·<span·class="n">observed</span><span·class="o">=</span><span·class="kc">False</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">(</span><span·class="n">min_count</span><span·class="o">=</span><span·class="mi">1</span><span·class="p">)</span>	756	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[10]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">Series</span><span·class="p">([</span><span·class="mi">1</span><span·class="p">,</span>·<span·class="mi">2</span><span·class="p">])</span><span·class="o">.</span><span·class="n">groupby</span><span·class="p">(</span><span·class="n">grouper</span><span·class="p">,</span>·<span·class="n">observed</span><span·class="o">=</span><span·class="kc">False</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">(</span><span·class="n">min_count</span><span·class="o">=</span><span·class="mi">1</span><span·class="p">)</span>
757	<span·class="gh">Out[10]:·</span>	757	<span·class="gh">Out[10]:·</span>
758	<span·class="go">a····3.0</span>	758	<span·class="go">a····3.0</span>
759	<span·class="go">b····NaN</span>	759	<span·class="go">b····NaN</span>
760	<span·class="go">~~Length:·2,·~~dtype:·float64</span>	760	<span·class="go">dtype:·float64</span>
761	</pre></div>	761	</pre></div>
762	</div>	762	</div>
763	</section>	763	</section>
764	<section·id="resample">	764	<section·id="resample">
765	<h3>Resample<a·class="headerlink"·href="#resample"·title="Link·to·this·heading">#</a></h3>	765	<h3>Resample<a·class="headerlink"·href="#resample"·title="Link·to·this·heading">#</a></h3>
766	<p>The·sum·and·product·of·all-<em>NA</em>·bins·has·changed·from·<code·class="docutils·literal·notranslate"><span·class="pre">NaN</span></code>·to·<code·class="docutils·literal·notranslate"><span·class="pre">0</span></code>·for	766	<p>The·sum·and·product·of·all-<em>NA</em>·bins·has·changed·from·<code·class="docutils·literal·notranslate"><span·class="pre">NaN</span></code>·to·<code·class="docutils·literal·notranslate"><span·class="pre">0</span></code>·for
767	sum·and·<code·class="docutils·literal·notranslate"><span·class="pre">1</span></code>·for·product.</p>	767	sum·and·<code·class="docutils·literal·notranslate"><span·class="pre">1</span></code>·for·product.</p>
Offset 787, 23 lines modified		Offset 787, 23 lines modified
787	<p><em>pandas·0.22.0</em></p>	787	<p><em>pandas·0.22.0</em></p>
788	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[11]:·</span><span·class="n">s</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="mi">1</span><span·class="p">,</span>·<span·class="mi">1</span><span·class="p">,</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">nan</span><span·class="p">,</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">nan</span><span·class="p">],</span>·<span·class="n">index</span><span·class="o">=</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">date_range</span><span·class="p">(</span><span·class="s2">"2017"</span><span·class="p">,</span>·<span·class="n">periods</span><span·class="o">=</span><span·class="mi">4</span><span·class="p">))</span>	788	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[11]:·</span><span·class="n">s</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="mi">1</span><span·class="p">,</span>·<span·class="mi">1</span><span·class="p">,</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">nan</span><span·class="p">,</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">nan</span><span·class="p">],</span>·<span·class="n">index</span><span·class="o">=</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">date_range</span><span·class="p">(</span><span·class="s2">"2017"</span><span·class="p">,</span>·<span·class="n">periods</span><span·class="o">=</span><span·class="mi">4</span><span·class="p">))</span>

789	<span·class="gp">In·[12]:·</span><span·class="n">s</span><span·class="o">.</span><span·class="n">resample</span><span·class="p">(</span><span·class="s2">"2d"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">()</span>	789	<span·class="gp">In·[12]:·</span><span·class="n">s</span><span·class="o">.</span><span·class="n">resample</span><span·class="p">(</span><span·class="s2">"2d"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">()</span>
790	<span·class="gh">Out[12]:·</span>	790	<span·class="gh">Out[12]:·</span>
791	<span·class="go">2017-01-01····2.0</span>	791	<span·class="go">2017-01-01····2.0</span>
792	<span·class="go">2017-01-03····0.0</span>	792	<span·class="go">2017-01-03····0.0</span>
793	<span·class="go">Freq:·2D,·~~Length:·2,·~~dtype:·float64</span>	793	<span·class="go">Freq:·2D,·dtype:·float64</span>
794	</pre></div>	794	</pre></div>
795	</div>	795	</div>
796	<p>To·restore·the·0.21·behavior·of·returning·<code·class="docutils·literal·notranslate"><span·class="pre">NaN</span></code>,·use·<code·class="docutils·literal·notranslate"><span·class="pre">min_count>=1</span></code>.</p>	796	<p>To·restore·the·0.21·behavior·of·returning·<code·class="docutils·literal·notranslate"><span·class="pre">NaN</span></code>,·use·<code·class="docutils·literal·notranslate"><span·class="pre">min_count>=1</span></code>.</p>
797	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[13]:·</span><span·class="n">s</span><span·class="o">.</span><span·class="n">resample</span><span·class="p">(</span><span·class="s2">"2d"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">(</span><span·class="n">min_count</span><span·class="o">=</span><span·class="mi">1</span><span·class="p">)</span>	797	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[13]:·</span><span·class="n">s</span><span·class="o">.</span><span·class="n">resample</span><span·class="p">(</span><span·class="s2">"2d"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">(</span><span·class="n">min_count</span><span·class="o">=</span><span·class="mi">1</span><span·class="p">)</span>
798	<span·class="gh">Out[13]:·</span>	798	<span·class="gh">Out[13]:·</span>
799	<span·class="go">2017-01-01····2.0</span>	799	<span·class="go">2017-01-01····2.0</span>
800	<span·class="go">2017-01-03····NaN</span>	800	<span·class="go">2017-01-03····NaN</span>
801	<span·class="go">Freq:·2D,·~~Length:·2,·~~dtype:·float64</span>	801	<span·class="go">Freq:·2D,·dtype:·float64</span>
802	</pre></div>	802	</pre></div>
803	</div>	803	</div>
804	<p>In·particular,·upsampling·and·taking·the·sum·or·product·is·affected,·as	804	<p>In·particular,·upsampling·and·taking·the·sum·or·product·is·affected,·as
805	upsampling·introduces·missing·values·even·if·the·original·series·was	805	upsampling·introduces·missing·values·even·if·the·original·series·was
806	entirely·valid.</p>	806	entirely·valid.</p>
807	<p><em>pandas·0.21.x</em></p>	807	<p><em>pandas·0.21.x</em></p>
808	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[14]:·</span><span·class="n">idx</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">DatetimeIndex</span><span·class="p">([</span><span·class="s1">'2017-01-01'</span><span·class="p">,</span>·<span·class="s1">'2017-01-02'</span><span·class="p">])</span>	808	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[14]:·</span><span·class="n">idx</span>·<span·class="o">=</span>·<span·class="n">pd</span><span·class="o">.</span><span·class="n">DatetimeIndex</span><span·class="p">([</span><span·class="s1">'2017-01-01'</span><span·class="p">,</span>·<span·class="s1">'2017-01-02'</span><span·class="p">])</span>
Offset 856, 15 lines modified		Offset 856, 15 lines modified
856	<p><em>pandas·0.22.0</em></p>	856	<p><em>pandas·0.22.0</em></p>
857	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[14]:·</span><span·class="n">s</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">np</span><span·class="o">.</span><span·class="n">nan</span><span·class="p">,</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">nan</span><span·class="p">])</span>	857	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[14]:·</span><span·class="n">s</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">np</span><span·class="o">.</span><span·class="n">nan</span><span·class="p">,</span>·<span·class="n">np</span><span·class="o">.</span><span·class="n">nan</span><span·class="p">])</span>

858	<span·class="gp">In·[15]:·</span><span·class="n">s</span><span·class="o">.</span><span·class="n">rolling</span><span·class="p">(</span><span·class="mi">2</span><span·class="p">,</span>·<span·class="n">min_periods</span><span·class="o">=</span><span·class="mi">0</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">()</span>	858	<span·class="gp">In·[15]:·</span><span·class="n">s</span><span·class="o">.</span><span·class="n">rolling</span><span·class="p">(</span><span·class="mi">2</span><span·class="p">,</span>·<span·class="n">min_periods</span><span·class="o">=</span><span·class="mi">0</span><span·class="p">)</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">()</span>
859	<span·class="gh">Out[15]:·</span>	859	<span·class="gh">Out[15]:·</span>
860	<span·class="go">0····0.0</span>	860	<span·class="go">0····0.0</span>
861	<span·class="go">1····0.0</span>	861	<span·class="go">1····0.0</span>
862	<span·class="go">~~Length:·2,·~~dtype:·float64</span>	862	<span·class="go">dtype:·float64</span>
863	</pre></div>	863	</pre></div>
864	</div>	864	</div>
865	<p>The·default·behavior·of·<code·class="docutils·literal·notranslate"><span·class="pre">min_periods=None</span></code>,·implying·that·<code·class="docutils·literal·notranslate"><span·class="pre">min_periods</span></code>	865	<p>The·default·behavior·of·<code·class="docutils·literal·notranslate"><span·class="pre">min_periods=None</span></code>,·implying·that·<code·class="docutils·literal·notranslate"><span·class="pre">min_periods</span></code>
866	equals·the·window·size,·is·unchanged.</p>	866	equals·the·window·size,·is·unchanged.</p>
867	</section>	867	</section>
868	</section>	868	</section>
869	<section·id="compatibility">	869	<section·id="compatibility">

⊟

2.26 KB

html2text {} ¶


Offset 192, 22 lines modified		Offset 192, 22 lines modified
192	p\x8pa\x8an\x8nd\x8da\x8as\x8s·0\x80.\x8.2\x822\x82	192	p\x8pa\x8an\x8nd\x8da\x8as\x8s·0\x80.\x8.2\x822\x82
193	In·[8]:·grouper·=·pd.Categorical(["a",·"a"],·categories=["a",·"b"])	193	In·[8]:·grouper·=·pd.Categorical(["a",·"a"],·categories=["a",·"b"])

194	In·[9]:·pd.Series([1,·2]).groupby(grouper,·observed=False).sum()	194	In·[9]:·pd.Series([1,·2]).groupby(grouper,·observed=False).sum()
195	Out[9]:	195	Out[9]:
196	a····3	196	a····3
197	b····0	197	b····0
198	~~Length:·2,·~~dtype:·int64	198	dtype:·int64
199	To·restore·the·0.21·behavior·of·returning·NaN·for·unobserved·groups,·use	199	To·restore·the·0.21·behavior·of·returning·NaN·for·unobserved·groups,·use
200	min_count>=1.	200	min_count>=1.
201	In·[10]:·pd.Series([1,·2]).groupby(grouper,·observed=False).sum(min_count=1)	201	In·[10]:·pd.Series([1,·2]).groupby(grouper,·observed=False).sum(min_count=1)
202	Out[10]:	202	Out[10]:
203	a····3.0	203	a····3.0
204	b····NaN	204	b····NaN
205	~~Length:·2,·~~dtype:·float64	205	dtype:·float64
206	\x8\x8\x8\x8·R\x8Re\x8es\x8sa\x8am\x8mp\x8pl\x8le\x8e_\x8#\x8#·\x8\x8\x8\x8	206	\x8\x8\x8\x8·R\x8Re\x8es\x8sa\x8am\x8mp\x8pl\x8le\x8e_\x8#\x8#·\x8\x8\x8\x8
207	The·sum·and·product·of·all-N\x8NA\x8A·bins·has·changed·from·NaN·to·0·for·sum·and·1·for	207	The·sum·and·product·of·all-N\x8NA\x8A·bins·has·changed·from·NaN·to·0·for·sum·and·1·for
208	product.	208	product.
209	p\x8pa\x8an\x8nd\x8da\x8as\x8s·0\x80.\x8.2\x821\x81.\x8.x\x8x	209	p\x8pa\x8an\x8nd\x8da\x8as\x8s·0\x80.\x8.2\x821\x81.\x8.x\x8x
210	In·[11]:·s·=·pd.Series([1,·1,·np.nan,·np.nan],	210	In·[11]:·s·=·pd.Series([1,·1,·np.nan,·np.nan],
211	···....:···············index=pd.date_range('2017',·periods=4))	211	···....:···············index=pd.date_range('2017',·periods=4))
212	···....:·s	212	···....:·s
Offset 227, 21 lines modified		Offset 227, 21 lines modified
227	In·[11]:·s·=·pd.Series([1,·1,·np.nan,·np.nan],·index=pd.date_range("2017",	227	In·[11]:·s·=·pd.Series([1,·1,·np.nan,·np.nan],·index=pd.date_range("2017",
228	periods=4))	228	periods=4))

229	In·[12]:·s.resample("2d").sum()	229	In·[12]:·s.resample("2d").sum()
230	Out[12]:	230	Out[12]:
231	2017-01-01····2.0	231	2017-01-01····2.0
232	2017-01-03····0.0	232	2017-01-03····0.0
233	Freq:·2D,·~~Length:·2,·~~dtype:·float64	233	Freq:·2D,·dtype:·float64
234	To·restore·the·0.21·behavior·of·returning·NaN,·use·min_count>=1.	234	To·restore·the·0.21·behavior·of·returning·NaN,·use·min_count>=1.
235	In·[13]:·s.resample("2d").sum(min_count=1)	235	In·[13]:·s.resample("2d").sum(min_count=1)
236	Out[13]:	236	Out[13]:
237	2017-01-01····2.0	237	2017-01-01····2.0
238	2017-01-03····NaN	238	2017-01-03····NaN
239	Freq:·2D,·~~Length:·2,·~~dtype:·float64	239	Freq:·2D,·dtype:·float64
240	In·particular,·upsampling·and·taking·the·sum·or·product·is·affected,·as	240	In·particular,·upsampling·and·taking·the·sum·or·product·is·affected,·as
241	upsampling·introduces·missing·values·even·if·the·original·series·was·entirely	241	upsampling·introduces·missing·values·even·if·the·original·series·was·entirely
242	valid.	242	valid.
243	p\x8pa\x8an\x8nd\x8da\x8as\x8s·0\x80.\x8.2\x821\x81.\x8.x\x8x	243	p\x8pa\x8an\x8nd\x8da\x8as\x8s·0\x80.\x8.2\x821\x81.\x8.x\x8x
244	In·[14]:·idx·=·pd.DatetimeIndex(['2017-01-01',·'2017-01-02'])	244	In·[14]:·idx·=·pd.DatetimeIndex(['2017-01-01',·'2017-01-02'])

245	In·[15]:·pd.Series([1,·2],·index=idx).resample('12H').sum()	245	In·[15]:·pd.Series([1,·2],·index=idx).resample('12H').sum()
Offset 281, 15 lines modified		Offset 281, 15 lines modified
281	p\x8pa\x8an\x8nd\x8da\x8as\x8s·0\x80.\x8.2\x822\x82.\x8.0\x80	281	p\x8pa\x8an\x8nd\x8da\x8as\x8s·0\x80.\x8.2\x822\x82.\x8.0\x80
282	In·[14]:·s·=·pd.Series([np.nan,·np.nan])	282	In·[14]:·s·=·pd.Series([np.nan,·np.nan])

283	In·[15]:·s.rolling(2,·min_periods=0).sum()	283	In·[15]:·s.rolling(2,·min_periods=0).sum()
284	Out[15]:	284	Out[15]:
285	0····0.0	285	0····0.0
286	1····0.0	286	1····0.0
287	~~Length:·2,·~~dtype:·float64	287	dtype:·float64
288	The·default·behavior·of·min_periods=None,·implying·that·min_periods·equals·the	288	The·default·behavior·of·min_periods=None,·implying·that·min_periods·equals·the
289	window·size,·is·unchanged.	289	window·size,·is·unchanged.
290	\x8\x8\x8\x8\x8·C\x8Co\x8om\x8mp\x8pa\x8at\x8ti\x8ib\x8bi\x8il\x8li\x8it\x8ty\x8y_\x8#\x8#·\x8\x8\x8\x8\x8	290	\x8\x8\x8\x8\x8·C\x8Co\x8om\x8mp\x8pa\x8at\x8ti\x8ib\x8bi\x8il\x8li\x8it\x8ty\x8y_\x8#\x8#·\x8\x8\x8\x8\x8
291	If·you·maintain·a·library·that·should·work·across·pandas·versions,·it·may·be	291	If·you·maintain·a·library·that·should·work·across·pandas·versions,·it·may·be
292	easiest·to·exclude·pandas·0.21·from·your·requirements.·Otherwise,·all·your·sum	292	easiest·to·exclude·pandas·0.21·from·your·requirements.·Otherwise,·all·your·sum
293	()·calls·would·need·to·check·if·the·Series·is·empty·before·summing.	293	()·calls·would·need·to·check·if·the·Series·is·empty·before·summing.
294	With·setuptools,·in·your·setup.py·use:	294	With·setuptools,·in·your·setup.py·use:

⊟

67.3 KB

./usr/share/doc/python-pandas-doc/html/whatsnew/v0.23.0.html ¶

⊟

17.2 KB

html2text {} ¶


Offset 210, 46 lines modified		Offset 210, 42 lines modified
210	·····foo·bar········baz·qux	210	·····foo·bar········baz·qux
211	idx	211	idx
212	0······1···a·2018-01-01···a	212	0······1···a·2018-01-01···a
213	1······2···b·2018-01-02···b	213	1······2···b·2018-01-02···b
214	2······3···c·2018-01-03···c	214	2······3···c·2018-01-03···c
215	3······4···d·2018-01-04···c	215	3······4···d·2018-01-04···c

216	[4·rows·x·4·columns]

217	In·[3]:·df.dtypes	216	In·[3]:·df.dtypes
218	Out[3]:	217	Out[3]:
219	foo·············int64	218	foo·············int64
220	bar············object	219	bar············object
221	baz····datetime64[ns]	220	baz····datetime64[ns]
222	qux··········category	221	qux··········category
223	~~Length:·4,·~~dtype:·object	222	dtype:·object

224	In·[4]:·df.to_json('test.json',·orient='table')	223	In·[4]:·df.to_json('test.json',·orient='table')

225	In·[5]:·new_df·=·pd.read_json('test.json',·orient='table')	224	In·[5]:·new_df·=·pd.read_json('test.json',·orient='table')

226	In·[6]:·new_df	225	In·[6]:·new_df
227	Out[6]:	226	Out[6]:
228	·····foo·bar········baz·qux	227	·····foo·bar········baz·qux
229	idx	228	idx
230	0······1···a·2018-01-01···a	229	0······1···a·2018-01-01···a
231	1······2···b·2018-01-02···b	230	1······2···b·2018-01-02···b
232	2······3···c·2018-01-03···c	231	2······3···c·2018-01-03···c
233	3······4···d·2018-01-04···c	232	3······4···d·2018-01-04···c

234	[4·rows·x·4·columns]

235	In·[7]:·new_df.dtypes	233	In·[7]:·new_df.dtypes
236	Out[7]:	234	Out[7]:
237	foo·············int64	235	foo·············int64
238	bar············object	236	bar············object
239	baz····datetime64[ns]	237	baz····datetime64[ns]
240	qux··········category	238	qux··········category
241	~~Length:·4,·~~dtype:·object	239	dtype:·object
242	Please·note·that·the·string·index·is·not·supported·with·the·round·trip·format,	240	Please·note·that·the·string·index·is·not·supported·with·the·round·trip·format,
243	as·it·is·used·by·default·in·write_json·to·indicate·a·missing·index·name.	241	as·it·is·used·by·default·in·write_json·to·indicate·a·missing·index·name.
244	In·[8]:·df.index.name·=·'index'	242	In·[8]:·df.index.name·=·'index'

245	In·[9]:·df.to_json('test.json',·orient='table')	243	In·[9]:·df.to_json('test.json',·orient='table')

246	In·[10]:·new_df·=·pd.read_json('test.json',·orient='table')	244	In·[10]:·new_df·=·pd.read_json('test.json',·orient='table')
Offset 258, 47 lines modified		Offset 254, 41 lines modified
258	Out[11]:	254	Out[11]:
259	···foo·bar········baz·qux	255	···foo·bar········baz·qux
260	0····1···a·2018-01-01···a	256	0····1···a·2018-01-01···a
261	1····2···b·2018-01-02···b	257	1····2···b·2018-01-02···b
262	2····3···c·2018-01-03···c	258	2····3···c·2018-01-03···c
263	3····4···d·2018-01-04···c	259	3····4···d·2018-01-04···c

264	[4·rows·x·4·columns]

265	In·[12]:·new_df.dtypes	260	In·[12]:·new_df.dtypes
266	Out[12]:	261	Out[12]:
267	foo·············int64	262	foo·············int64
268	bar············object	263	bar············object
269	baz····datetime64[ns]	264	baz····datetime64[ns]
270	qux··········category	265	qux··········category
271	~~Length:·4,·~~dtype:·object	266	dtype:·object
272	\x8\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8d·.\x8.a\x8as\x8ss\x8si\x8ig\x8gn\x8n(\x8()\x8)·a\x8ac\x8cc\x8ce\x8ep\x8pt\x8ts\x8s·d\x8de\x8ep\x8pe\x8en\x8nd\x8de\x8en\x8nt\x8t·a\x8ar\x8rg\x8gu\x8um\x8me\x8en\x8nt\x8ts\x8s_\x8#\x8#·\x8\x8\x8\x8	267	\x8\x8\x8\x8·M\x8Me\x8et\x8th\x8ho\x8od\x8d·.\x8.a\x8as\x8ss\x8si\x8ig\x8gn\x8n(\x8()\x8)·a\x8ac\x8cc\x8ce\x8ep\x8pt\x8ts\x8s·d\x8de\x8ep\x8pe\x8en\x8nd\x8de\x8en\x8nt\x8t·a\x8ar\x8rg\x8gu\x8um\x8me\x8en\x8nt\x8ts\x8s_\x8#\x8#·\x8\x8\x8\x8
273	The·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8a_\x8s_\x8s_\x8i_\x8g_\x8n_\x8(_\x8)·now·accepts·dependent·keyword·arguments·for·python	268	The·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8a_\x8s_\x8s_\x8i_\x8g_\x8n_\x8(_\x8)·now·accepts·dependent·keyword·arguments·for·python
274	version·later·than·3.6·(see·also·_\x8P_\x8E_\x8P_\x8·_\x84_\x86_\x88).·Later·keyword·arguments·may·now	269	version·later·than·3.6·(see·also·_\x8P_\x8E_\x8P_\x8·_\x84_\x86_\x88).·Later·keyword·arguments·may·now
275	refer·to·earlier·ones·if·the·argument·is·a·callable.·See·the·_\x8d_\x8o_\x8c_\x8u_\x8m_\x8e_\x8n_\x8t_\x8a_\x8t_\x8i_\x8o_\x8n_\x8·_\x8h_\x8e_\x8r_\x8e	270	refer·to·earlier·ones·if·the·argument·is·a·callable.·See·the·_\x8d_\x8o_\x8c_\x8u_\x8m_\x8e_\x8n_\x8t_\x8a_\x8t_\x8i_\x8o_\x8n_\x8·_\x8h_\x8e_\x8r_\x8e
276	(_\x8G_\x8H_\x8·_\x81_\x84_\x82_\x80_\x87)	271	(_\x8G_\x8H_\x8·_\x81_\x84_\x82_\x80_\x87)
277	In·[13]:·df·=·pd.DataFrame({'A':·[1,·2,·3]})	272	In·[13]:·df·=·pd.DataFrame({'A':·[1,·2,·3]})

278	In·[14]:·df	273	In·[14]:·df
279	Out[14]:	274	Out[14]:
280	···A	275	···A
281	0··1	276	0··1
282	1··2	277	1··2
283	2··3	278	2··3

284	[3·rows·x·1·columns]

285	In·[15]:·df.assign(B=df.A,·C=lambda·x:·x['A']·+·x['B'])	279	In·[15]:·df.assign(B=df.A,·C=lambda·x:·x['A']·+·x['B'])
286	Out[15]:	280	Out[15]:
287	···A··B··C	281	···A··B··C
288	0··1··1··2	282	0··1··1··2
289	1··2··2··4	283	1··2··2··4
290	2··3··3··6	284	2··3··3··6

291	[3·rows·x·3·columns]
292	Warning	285	Warning
293	This·may·subtly·change·the·behavior·of·your·code·when·you’re·using·.assign()·to	286	This·may·subtly·change·the·behavior·of·your·code·when·you’re·using·.assign()·to
294	update·an·existing·column.·Previously,·callables·referring·to·other·variables	287	update·an·existing·column.·Previously,·callables·referring·to·other·variables
295	being·updated·would·get·the·“old”·values	288	being·updated·would·get·the·“old”·values
296	Previous·behavior:	289	Previous·behavior:
297	In·[2]:·df·=·pd.DataFrame({"A":·[1,·2,·3]})	290	In·[2]:·df·=·pd.DataFrame({"A":·[1,·2,·3]})

Offset 311, 16 lines modified		Offset 301, 14 lines modified
311	New·behavior:	301	New·behavior:
312	In·[16]:·df.assign(A=df.A·+·1,·C=lambda·df:·df.A·*·-1)	302	In·[16]:·df.assign(A=df.A·+·1,·C=lambda·df:·df.A·*·-1)
313	Out[16]:	303	Out[16]:
314	···A··C	304	···A··C
315	0··2·-2	305	0··2·-2
316	1··3·-3	306	1··3·-3
317	2··4·-4	307	2··4·-4

318	[3·rows·x·2·columns]
319	\x8\x8\x8\x8·M\x8Me\x8er\x8rg\x8gi\x8in\x8ng\x8g·o\x8on\x8n·a\x8a·c\x8co\x8om\x8mb\x8bi\x8in\x8na\x8at\x8ti\x8io\x8on\x8n·o\x8of\x8f·c\x8co\x8ol\x8lu\x8um\x8mn\x8ns\x8s·a\x8an\x8nd\x8d·i\x8in\x8nd\x8de\x8ex\x8x·l\x8le\x8ev\x8ve\x8el\x8ls\x8s_\x8#\x8#·\x8\x8\x8\x8	308	\x8\x8\x8\x8·M\x8Me\x8er\x8rg\x8gi\x8in\x8ng\x8g·o\x8on\x8n·a\x8a·c\x8co\x8om\x8mb\x8bi\x8in\x8na\x8at\x8ti\x8io\x8on\x8n·o\x8of\x8f·c\x8co\x8ol\x8lu\x8um\x8mn\x8ns\x8s·a\x8an\x8nd\x8d·i\x8in\x8nd\x8de\x8ex\x8x·l\x8le\x8ev\x8ve\x8el\x8ls\x8s_\x8#\x8#·\x8\x8\x8\x8
320	Strings·passed·to·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8m_\x8e_\x8r_\x8g_\x8e_\x8(_\x8)·as·the·on,·left_on,·and·right_on·parameters	309	Strings·passed·to·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8m_\x8e_\x8r_\x8g_\x8e_\x8(_\x8)·as·the·on,·left_on,·and·right_on·parameters
321	may·now·refer·to·either·column·names·or·index·level·names.·This·enables·merging	310	may·now·refer·to·either·column·names·or·index·level·names.·This·enables·merging
322	DataFrame·instances·on·a·combination·of·index·levels·and·columns·without	311	DataFrame·instances·on·a·combination·of·index·levels·and·columns·without
323	resetting·indexes.·See·the·_\x8M_\x8e_\x8r_\x8g_\x8e_\x8·_\x8o_\x8n_\x8·_\x8c_\x8o_\x8l_\x8u_\x8m_\x8n_\x8s_\x8·_\x8a_\x8n_\x8d_\x8·_\x8l_\x8e_\x8v_\x8e_\x8l_\x8s·documentation·section.	312	resetting·indexes.·See·the·_\x8M_\x8e_\x8r_\x8g_\x8e_\x8·_\x8o_\x8n_\x8·_\x8c_\x8o_\x8l_\x8u_\x8m_\x8n_\x8s_\x8·_\x8a_\x8n_\x8d_\x8·_\x8l_\x8e_\x8v_\x8e_\x8l_\x8s·documentation·section.
324	(_\x8G_\x8H_\x8·_\x81_\x84_\x83_\x85_\x85)	313	(_\x8G_\x8H_\x8·_\x81_\x84_\x83_\x85_\x85)
325	In·[17]:·left_index·=·pd.Index(['K0',·'K0',·'K1',·'K2'],·name='key1')	314	In·[17]:·left_index·=·pd.Index(['K0',·'K0',·'K1',·'K2'],·name='key1')
Offset 342, 16 lines modified		Offset 330, 14 lines modified
342	In·[21]:·left.merge(right,·on=['key1',·'key2'])	330	In·[21]:·left.merge(right,·on=['key1',·'key2'])
343	Out[21]:	331	Out[21]:
344	·······A···B·key2···C···D	332	·······A···B·key2···C···D
345	key1	333	key1
346	K0····A0··B0···K0··C0··D0	334	K0····A0··B0···K0··C0··D0
347	K1····A2··B2···K0··C1··D1	335	K1····A2··B2···K0··C1··D1
348	K2····A3··B3···K1··C3··D3	336	K2····A3··B3···K1··C3··D3

349	[3·rows·x·5·columns]
350	\x8\x8\x8\x8·S\x8So\x8or\x8rt\x8ti\x8in\x8ng\x8g·b\x8by\x8y·a\x8a·c\x8co\x8om\x8mb\x8bi\x8in\x8na\x8at\x8ti\x8io\x8on\x8n·o\x8of\x8f·c\x8co\x8ol\x8lu\x8um\x8mn\x8ns\x8s·a\x8an\x8nd\x8d·i\x8in\x8nd\x8de\x8ex\x8x·l\x8le\x8ev\x8ve\x8el\x8ls\x8s_\x8#\x8#·\x8\x8\x8\x8	337	\x8\x8\x8\x8·S\x8So\x8or\x8rt\x8ti\x8in\x8ng\x8g·b\x8by\x8y·a\x8a·c\x8co\x8om\x8mb\x8bi\x8in\x8na\x8at\x8ti\x8io\x8on\x8n·o\x8of\x8f·c\x8co\x8ol\x8lu\x8um\x8mn\x8ns\x8s·a\x8an\x8nd\x8d·i\x8in\x8nd\x8de\x8ex\x8x·l\x8le\x8ev\x8ve\x8el\x8ls\x8s_\x8#\x8#·\x8\x8\x8\x8
351	Strings·passed·to·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8s_\x8o_\x8r_\x8t_\x8__\x8v_\x8a_\x8l_\x8u_\x8e_\x8s_\x8(_\x8)·as·the·by·parameter·may·now·refer·to	338	Strings·passed·to·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e_\x8._\x8s_\x8o_\x8r_\x8t_\x8__\x8v_\x8a_\x8l_\x8u_\x8e_\x8s_\x8(_\x8)·as·the·by·parameter·may·now·refer·to
352	either·column·names·or·index·level·names.·This·enables·sorting·DataFrame	339	either·column·names·or·index·level·names.·This·enables·sorting·DataFrame
353	instances·by·a·combination·of·index·levels·and·columns·without·resetting	340	instances·by·a·combination·of·index·levels·and·columns·without·resetting
354	indexes.·See·the·_\x8S_\x8o_\x8r_\x8t_\x8i_\x8n_\x8g_\x8·_\x8b_\x8y_\x8·_\x8I_\x8n_\x8d_\x8e_\x8x_\x8e_\x8s_\x8·_\x8a_\x8n_\x8d_\x8·_\x8V_\x8a_\x8l_\x8u_\x8e_\x8s·documentation·section.·(_\x8G_\x8H	341	indexes.·See·the·_\x8S_\x8o_\x8r_\x8t_\x8i_\x8n_\x8g_\x8·_\x8b_\x8y_\x8·_\x8I_\x8n_\x8d_\x8e_\x8x_\x8e_\x8s_\x8·_\x8a_\x8n_\x8d_\x8·_\x8V_\x8a_\x8l_\x8u_\x8e_\x8s·documentation·section.·(_\x8G_\x8H
355	_\x81_\x84_\x83_\x85_\x83)	342	_\x81_\x84_\x83_\x85_\x83)
Max diff block lines reached; 13348/17569 bytes (75.97%) of diff not shown.

⊟

2.93 KB

./usr/share/doc/python-pandas-doc/html/whatsnew/v0.24.0.html ¶

⊟

711 B

html2text {} ¶


Offset 268, 18 lines modified		Offset 268, 18 lines modified
268	each·time.	268	each·time.
269	In·[18]:·idx.values	269	In·[18]:·idx.values
270	Out[18]:	270	Out[18]:
271	array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),	271	array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),
272	·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)	272	·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)

273	In·[19]:·id(idx.values)	273	In·[19]:·id(idx.values)
274	Out[19]:·1402120~~96832~~912	274	Out[19]:·140400324419792

275	In·[20]:·id(idx.values)	275	In·[20]:·id(idx.values)
276	Out[20]:·140~~212096832912~~	276	Out[20]:·140400324417488
277	If·you·need·an·actual·NumPy·array,·use·_\x8S_\x8e_\x8r_\x8i_\x8e_\x8s_\x8._\x8t_\x8o_\x8__\x8n_\x8u_\x8m_\x8p_\x8y_\x8(_\x8)·or·Index.to_numpy().	277	If·you·need·an·actual·NumPy·array,·use·_\x8S_\x8e_\x8r_\x8i_\x8e_\x8s_\x8._\x8t_\x8o_\x8__\x8n_\x8u_\x8m_\x8p_\x8y_\x8(_\x8)·or·Index.to_numpy().
278	In·[21]:·idx.to_numpy()	278	In·[21]:·idx.to_numpy()
279	Out[21]:	279	Out[21]:
280	array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),	280	array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),
281	·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)	281	·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)

282	In·[22]:·pd.Series(idx).to_numpy()	282	In·[22]:·pd.Series(idx).to_numpy()


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

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

1247	In·[143]:·%timeit·arr[indexer]	1247	In·[143]:·%timeit·arr[indexer]
1248	···.....:·%timeit·arr.take(indexer,·axis=0)	1248	···.....:·%timeit·arr.take(indexer,·axis=0)
1249	···.....:	1249	···.....:
1250	~~544~~·us·+-·4~~9.3~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)	1250	350·us·+-·169·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)
1251	122·us·+-·~~6.36~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10,000·loops·each)	1251	106·us·+-·19.1·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10,000·loops·each)
1252	In·[144]:·ser·=·pd.Series(arr[:,·0])	1252	In·[144]:·ser·=·pd.Series(arr[:,·0])

1253	In·[145]:·%timeit·ser.iloc[indexer]	1253	In·[145]:·%timeit·ser.iloc[indexer]
1254	···.....:·%timeit·ser.take(indexer)	1254	···.....:·%timeit·ser.take(indexer)
1255	···.....:	1255	···.....:
1256	284·us·+-·22.1·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)
1257	266·us·+-·16.8·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)	1256	251·us·+-·69.4·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·10,000·loops·each)
		1257	The·slowest·run·took·7.62·times·longer·than·the·fastest.·This·could·mean·that
		1258	an·intermediate·result·is·being·cached.
		1259	499·us·+-·435·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·1,000·loops·each)
1258	\x8\x8\x8\x8\x8·I\x8In\x8nd\x8de\x8ex\x8x·t\x8ty\x8yp\x8pe\x8es\x8s_\x8#\x8#·\x8\x8\x8\x8\x8	1260	\x8\x8\x8\x8\x8·I\x8In\x8nd\x8de\x8ex\x8x·t\x8ty\x8yp\x8pe\x8es\x8s_\x8#\x8#·\x8\x8\x8\x8\x8
1259	We·have·discussed·MultiIndex·in·the·previous·sections·pretty·extensively.	1261	We·have·discussed·MultiIndex·in·the·previous·sections·pretty·extensively.
1260	Documentation·about·DatetimeIndex·and·PeriodIndex·are·shown·_\x8h_\x8e_\x8r_\x8e,·and	1262	Documentation·about·DatetimeIndex·and·PeriodIndex·are·shown·_\x8h_\x8e_\x8r_\x8e,·and
1261	documentation·about·TimedeltaIndex·is·found·_\x8h_\x8e_\x8r_\x8e.	1263	documentation·about·TimedeltaIndex·is·found·_\x8h_\x8e_\x8r_\x8e.
1262	In·the·following·sub-sections·we·will·highlight·some·other·index·types.	1264	In·the·following·sub-sections·we·will·highlight·some·other·index·types.
1263	\x8\x8\x8\x8·C\x8Ca\x8at\x8te\x8eg\x8go\x8or\x8ri\x8ic\x8ca\x8al\x8lI\x8In\x8nd\x8de\x8ex\x8x_\x8#\x8#·\x8\x8\x8\x8	1265	\x8\x8\x8\x8·C\x8Ca\x8at\x8te\x8eg\x8go\x8or\x8ri\x8ic\x8ca\x8al\x8lI\x8In\x8nd\x8de\x8ex\x8x_\x8#\x8#·\x8\x8\x8\x8
1264	_\x8C_\x8a_\x8t_\x8e_\x8g_\x8o_\x8r_\x8i_\x8c_\x8a_\x8l_\x8I_\x8n_\x8d_\x8e_\x8x·is·a·type·of·index·that·is·useful·for·supporting·indexing·with	1266	_\x8C_\x8a_\x8t_\x8e_\x8g_\x8o_\x8r_\x8i_\x8c_\x8a_\x8l_\x8I_\x8n_\x8d_\x8e_\x8x·is·a·type·of·index·that·is·useful·for·supporting·indexing·with


Offset 1086, 16 lines modified		Offset 1086, 16 lines modified
1086	<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>	1086	<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>
1087	<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>	1087	<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>
1088	<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>	1088	<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>
1089	<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>	1089	<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>
1090	<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="s2">"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>	1090	<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="s2">"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>
1091	<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>	1091	<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>
1092	<span·class="gp">···....:·</span>	1092	<span·class="gp">···....:·</span>
1093	<span·class="go">CPU·times:·user·~~625~~·us,·sys:·244·us,·total:·~~869~~·us</span>	1093	<span·class="go">CPU·times:·user·331·us,·sys:·287·us,·total:·618·us</span>
1094	<span·class="go">Wall·time:·~~879~~·us</span>	1094	<span·class="go">Wall·time:·627·us</span>
1095	<span·class="gh">Out[32]:·</span><span·class="go">Series([],·dtype:·int64)</span>	1095	<span·class="gh">Out[32]:·</span><span·class="go">Series([],·dtype:·int64)</span>
1096	</pre></div>	1096	</pre></div>
1097	</div>	1097	</div>
1098	<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	1098	<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
1099	<code·class="docutils·literal·notranslate"><span·class="pre">chunksize</span></code>·when·reading·a·single·file.</p>	1099	<code·class="docutils·literal·notranslate"><span·class="pre">chunksize</span></code>·when·reading·a·single·file.</p>
1100	<p>Manually·chunking·is·an·OK·option·for·workflows·that·don’t	1100	<p>Manually·chunking·is·an·OK·option·for·workflows·that·don’t
1101	require·too·sophisticated·of·operations.·Some·operations,·like·<a·class="reference·internal"·href="../reference/api/pandas.DataFrame.groupby.html#pandas.DataFrame.groupby"·title="pandas.DataFrame.groupby"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">pandas.DataFrame.groupby()</span></code></a>,·are	1101	require·too·sophisticated·of·operations.·Some·operations,·like·<a·class="reference·internal"·href="../reference/api/pandas.DataFrame.groupby.html#pandas.DataFrame.groupby"·title="pandas.DataFrame.groupby"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">pandas.DataFrame.groupby()</span></code></a>,·are


Offset 965, 18 lines modified		Offset 965, 20 lines modified

965	······In·[94]:·df1,·df2,·df3,·df4·=·[pd.DataFrame(np.random.randn(nrows,	965	······In·[94]:·df1,·df2,·df3,·df4·=·[pd.DataFrame(np.random.randn(nrows,
966	······ncols))	966	······ncols))
967	·········....:·······················for·_·in·range(4)]	967	·········....:·······················for·_·in·range(4)]
968	·········....:	968	·········....:
969	······#·eval·with·NumExpr·backend	969	······#·eval·with·NumExpr·backend
970	······In·[95]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4')	970	······In·[95]:·%timeit·pd.eval('df1·+·df2·+·df3·+·df4')
		971	······The·slowest·run·took·4.05·times·longer·than·the·fastest.·This·could·mean
		972	······that·an·intermediate·result·is·being·cached.
971	······13.6·ms·+-·~~397~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	973	······12.1·ms·+-·6.53·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)
972	······#·pure·Python·evaluation	974	······#·pure·Python·evaluation
973	······In·[96]:·%timeit·df1·+·df2·+·df3·+·df4	975	······In·[96]:·%timeit·df1·+·df2·+·df3·+·df4
974	······18.6·ms·+-·~~955~~·us·per·loop·(mean·+-·std.·dev.·of·7·runs,·100·loops·each)	976	······16.1·ms·+-·2.06·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)
975	······For·more·details,·see·the·_\x8t_\x8h_\x8e_\x8·_\x8d_\x8o_\x8c_\x8s	977	······For·more·details,·see·the·_\x8t_\x8h_\x8e_\x8·_\x8d_\x8o_\x8c_\x8s
976	····*·Similar·to·pandas.eval,·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e·has·a·new·DataFrame.eval·method·that	978	····*·Similar·to·pandas.eval,·_\x8D_\x8a_\x8t_\x8a_\x8F_\x8r_\x8a_\x8m_\x8e·has·a·new·DataFrame.eval·method·that
977	······evaluates·an·expression·in·the·context·of·the·DataFrame.·For·example,	979	······evaluates·an·expression·in·the·context·of·the·DataFrame.·For·example,
978	······In·[97]:·df·=·pd.DataFrame(np.random.randn(10,·2),·columns=['a',·'b'])	980	······In·[97]:·df·=·pd.DataFrame(np.random.randn(10,·2),·columns=['a',·'b'])

979	······In·[98]:·df.eval('a·+·b')	981	······In·[98]:·df.eval('a·+·b')
980	······Out[98]:	982	······Out[98]:


Offset 820, 18 lines modified		Offset 820, 18 lines modified
820	a·new·ndarray·of·period·objects·each·time.</p>	820	a·new·ndarray·of·period·objects·each·time.</p>
821	<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>	821	<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>
822	<span·class="gh">Out[18]:·</span>	822	<span·class="gh">Out[18]:·</span>
823	<span·class="go">array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),</span>	823	<span·class="go">array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),</span>
824	<span·class="go">·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)</span>	824	<span·class="go">·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)</span>

825	<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>	825	<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>
826	<span·class="gh">Out[19]:·</span><span·class="go">1402120~~96832~~912</span>	826	<span·class="gh">Out[19]:·</span><span·class="go">140400324419792</span>

827	<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>	827	<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>
828	<span·class="gh">Out[20]:·</span><span·class="go">140~~212096832912~~</span>	828	<span·class="gh">Out[20]:·</span><span·class="go">140400324417488</span>
829	</pre></div>	829	</pre></div>
830	</div>	830	</div>
831	<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·<code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">Index.to_numpy()</span></code>.</p>	831	<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·<code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">Index.to_numpy()</span></code>.</p>
832	<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>	832	<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>
833	<span·class="gh">Out[21]:·</span>	833	<span·class="gh">Out[21]:·</span>
834	<span·class="go">array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),</span>	834	<span·class="go">array([Period('2000-01-01',·'D'),·Period('2000-01-02',·'D'),</span>
835	<span·class="go">·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)</span>	835	<span·class="go">·······Period('2000-01-03',·'D'),·Period('2000-01-04',·'D')],·dtype=object)</span>


Offset 6256, 84 lines modified		Offset 6256, 84 lines modified
6256	-rw-r--r--···0·root·········(0)·root·········(0)···210184·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reference/series.html	6256	-rw-r--r--···0·root·········(0)·root·········(0)···210184·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reference/series.html
6257	-rw-r--r--···0·root·········(0)·root·········(0)····48665·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reference/style.html	6257	-rw-r--r--···0·root·········(0)·root·········(0)····48665·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reference/style.html
6258	-rw-r--r--···0·root·········(0)·root·········(0)····48657·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reference/testing.html	6258	-rw-r--r--···0·root·········(0)·root·········(0)····48657·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reference/testing.html
6259	-rw-r--r--···0·root·········(0)·root·········(0)····53295·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reference/window.html	6259	-rw-r--r--···0·root·········(0)·root·········(0)····53295·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reference/window.html
6260	-rw-r--r--···0·root·········(0)·root·········(0)······244·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/release.html	6260	-rw-r--r--···0·root·········(0)·root·········(0)······244·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/release.html
6261	-rw-r--r--···0·root·········(0)·root·········(0)······269·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reshaping.html	6261	-rw-r--r--···0·root·········(0)·root·········(0)······269·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/reshaping.html
6262	-rw-r--r--···0·root·········(0)·root·········(0)····17010·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/search.html	6262	-rw-r--r--···0·root·········(0)·root·········(0)····17010·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/search.html
6263	-rw-r--r--···0·root·········(0)·root·········(0)··2358676·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/searchindex.js	6263	-rw-r--r--···0·root·········(0)·root·········(0)··2358806·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/searchindex.js
6264	-rw-r--r--···0·root·········(0)·root·········(0)······259·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/sparse.html	6264	-rw-r--r--···0·root·········(0)·root·········(0)······259·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/sparse.html
6265	-rw-r--r--···0·root·········(0)·root·········(0)······244·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/style.html	6265	-rw-r--r--···0·root·········(0)·root·········(0)······244·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/style.html
6266	-rw-r--r--···0·root·········(0)·root·········(0)······255·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/text.html	6266	-rw-r--r--···0·root·········(0)·root·········(0)······255·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/text.html
6267	-rw-r--r--···0·root·········(0)·root·········(0)······256·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/timedeltas.html	6267	-rw-r--r--···0·root·········(0)·root·········(0)······256·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/timedeltas.html
6268	-rw-r--r--···0·root·········(0)·root·········(0)······277·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/timeseries.html	6268	-rw-r--r--···0·root·········(0)·root·········(0)······277·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/timeseries.html
6269	-rw-r--r--···0·root·········(0)·root·········(0)······272·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/tutorials.html	6269	-rw-r--r--···0·root·········(0)·root·········(0)······272·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/tutorials.html
6270	drwxr-xr-x···0·root·········(0)·root·········(0)········0·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/	6270	drwxr-xr-x···0·root·········(0)·root·········(0)········0·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/
6271	-rw-r--r--···0·root·········(0)·root·········(0)···171380·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/10min.html	6271	-rw-r--r--···0·root·········(0)·root·········(0)···171380·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/10min.html
6272	-rw-r--r--···0·root·········(0)·root·········(0)···283~~834~~·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/advanced.html	6272	-rw-r--r--···0·root·········(0)·root·········(0)···283975·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/advanced.html
6273	-rw-r--r--···0·root·········(0)·root·········(0)···436075·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/basics.html	6273	-rw-r--r--···0·root·········(0)·root·········(0)···436075·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/basics.html
6274	-rw-r--r--···0·root·········(0)·root·········(0)····36646·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/boolean.html	6274	-rw-r--r--···0·root·········(0)·root·········(0)····36646·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/boolean.html
6275	-rw-r--r--···0·root·········(0)·root·········(0)···217515·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/categorical.html	6275	-rw-r--r--···0·root·········(0)·root·········(0)···217515·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/categorical.html
6276	-rw-r--r--···0·root·········(0)·root·········(0)····18313·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/cookbook.html	6276	-rw-r--r--···0·root·········(0)·root·········(0)····18313·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/cookbook.html
6277	-rw-r--r--···0·root·········(0)·root·········(0)····66125·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/copy_on_write.html	6277	-rw-r--r--···0·root·········(0)·root·········(0)····66125·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/copy_on_write.html
6278	-rw-r--r--···0·root·········(0)·root·········(0)···160414·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/dsintro.html	6278	-rw-r--r--···0·root·········(0)·root·········(0)···160414·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/dsintro.html
6279	-rw-r--r--···0·root·········(0)·root·········(0)····81376·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/duplicates.html	6279	-rw-r--r--···0·root·········(0)·root·········(0)····81376·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/duplicates.html
6280	-rw-r--r--···0·root·········(0)·root·········(0)···115483·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/enhancingperf.html	6280	-rw-r--r--···0·root·········(0)·root·········(0)···115461·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/enhancingperf.html
6281	-rw-r--r--···0·root·········(0)·root·········(0)···107882·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/gotchas.html	6281	-rw-r--r--···0·root·········(0)·root·········(0)···107882·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/gotchas.html
6282	-rw-r--r--···0·root·········(0)·root·········(0)···300850·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/groupby.html	6282	-rw-r--r--···0·root·········(0)·root·········(0)···300850·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/groupby.html
6283	-rw-r--r--···0·root·········(0)·root·········(0)····59715·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/index.html	6283	-rw-r--r--···0·root·········(0)·root·········(0)····59715·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/index.html
6284	-rw-r--r--···0·root·········(0)·root·········(0)···395484·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/indexing.html	6284	-rw-r--r--···0·root·········(0)·root·········(0)···395484·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/indexing.html
6285	-rw-r--r--···0·root·········(0)·root·········(0)····41778·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/integer_na.html	6285	-rw-r--r--···0·root·········(0)·root·········(0)····41778·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/integer_na.html
6286	-rw-r--r--···0·root·········(0)·root·········(0)··1145820·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/io.html	6286	-rw-r--r--···0·root·········(0)·root·········(0)··1145820·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/io.html
6287	-rw-r--r--···0·root·········(0)·root·········(0)···208885·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/merging.html	6287	-rw-r--r--···0·root·········(0)·root·········(0)···208885·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/merging.html
6288	-rw-r--r--···0·root·········(0)·root·········(0)···178690·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/missing_data.html	6288	-rw-r--r--···0·root·········(0)·root·········(0)···178690·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/missing_data.html
6289	-rw-r--r--···0·root·········(0)·root·········(0)···112153·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/options.html	6289	-rw-r--r--···0·root·········(0)·root·········(0)···112153·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/options.html
6290	-rw-r--r--···0·root·········(0)·root·········(0)···147524·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/pyarrow.html	6290	-rw-r--r--···0·root·········(0)·root·········(0)···147524·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/pyarrow.html
6291	-rw-r--r--···0·root·········(0)·root·········(0)···162660·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/reshaping.html	6291	-rw-r--r--···0·root·········(0)·root·········(0)···162660·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/reshaping.html
6292	-rw-r--r--···0·root·········(0)·root·········(0)···115581·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/scale.html	6292	-rw-r--r--···0·root·········(0)·root·········(0)···115581·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/scale.html
6293	-rw-r--r--···0·root·········(0)·root·········(0)····65546·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/sparse.html	6293	-rw-r--r--···0·root·········(0)·root·········(0)····65546·2025-02-01·18:39:17.000000·./usr/share/doc/python-pandas-doc/html/user_guide/sparse.html


Offset 592, 31 lines modified		Offset 592, 31 lines modified
592	<span·class="gp">···...:·</span>········<span·class="n">s</span>·<span·class="o">+=</span>·<span·class="n">f</span><span·class="p">(</span><span·class="n">a</span>·<span·class="o">+</span>·<span·class="n">i</span>·<span·class="o">*</span>·<span·class="n">dx</span><span·class="p">)</span>	592	<span·class="gp">···...:·</span>········<span·class="n">s</span>·<span·class="o">+=</span>·<span·class="n">f</span><span·class="p">(</span><span·class="n">a</span>·<span·class="o">+</span>·<span·class="n">i</span>·<span·class="o">*</span>·<span·class="n">dx</span><span·class="p">)</span>
593	<span·class="gp">···...:·</span>····<span·class="k">return</span>·<span·class="n">s</span>·<span·class="o">*</span>·<span·class="n">dx</span>	593	<span·class="gp">···...:·</span>····<span·class="k">return</span>·<span·class="n">s</span>·<span·class="o">*</span>·<span·class="n">dx</span>
594	<span·class="gp">···...:·</span>	594	<span·class="gp">···...:·</span>
595	</pre></div>	595	</pre></div>
596	</div>	596	</div>
597	<p>We·achieve·our·result·by·using·<a·class="reference·internal"·href="../reference/api/pandas.DataFrame.apply.html#pandas.DataFrame.apply"·title="pandas.DataFrame.apply"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">DataFrame.apply()</span></code></a>·(row-wise):</p>	597	<p>We·achieve·our·result·by·using·<a·class="reference·internal"·href="../reference/api/pandas.DataFrame.apply.html#pandas.DataFrame.apply"·title="pandas.DataFrame.apply"><code·class="xref·py·py-meth·docutils·literal·notranslate"><span·class="pre">DataFrame.apply()</span></code></a>·(row-wise):</p>
598	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[5]:·</span><span·class="o">%</span><span·class="k">timeit</span>·df.apply(lambda·x:·integrate_f(x["a"],·x["b"],·x["N"]),·axis=1)	598	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[5]:·</span><span·class="o">%</span><span·class="k">timeit</span>·df.apply(lambda·x:·integrate_f(x["a"],·x["b"],·x["N"]),·axis=1)
599	<span·class="go">~~211~~·ms·+-·18.6·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)</span>	599	<span·class="go">159·ms·+-·68.7·ms·per·loop·(mean·+-·std.·dev.·of·7·runs,·10·loops·each)</span>
600	</pre></div>	600	</pre></div>
601	</div>	601	</div>
602	<p>Let’s·take·a·look·and·see·where·the·time·is·spent·during·this·operation	602	<p>Let’s·take·a·look·and·see·where·the·time·is·spent·during·this·operation
603	using·the·<a·class="reference·external"·href="https://ipython.readthedocs.io/en/stable/interactive/magics.html#magic-prun">prun·ipython·magic·function</a>:</p>	603	using·the·<a·class="reference·external"·href="https://ipython.readthedocs.io/en/stable/interactive/magics.html#magic-prun">prun·ipython·magic·function</a>:</p>
604	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·most·time·consuming·4·calls</span>	604	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·most·time·consuming·4·calls</span>
605	<span·class="gp">In·[6]:·</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	605	<span·class="gp">In·[6]:·</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
606	<span·class="go">·········605946·function·calls·(605928·primitive·calls)·in·1.~~397~~·seconds</span>	606	<span·class="go">·········605946·function·calls·(605928·primitive·calls)·in·0.618·seconds</span>

607	<span·class="go">···Ordered·by:·internal·time</span>	607	<span·class="go">···Ordered·by:·internal·time</span>
608	<span·class="go">···List·reduced·from·159·to·4·due·to·restriction·<4></span>	608	<span·class="go">···List·reduced·from·159·to·4·due·to·restriction·<4></span>

609	<span·class="go">···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)</span>	609	<span·class="go">···ncalls··tottime··percall··cumtime··percall·filename:lineno(function)</span>
610	<span·class="go">·····1000····0.~~758~~····0.001····1.~~236~~····0.001·<ipython-input-4-c2a74e076cf0>:1(integrate_f)</span>	610	<span·class="go">·····1000····0.362····0.000····0.512····0.001·<ipython-input-4-c2a74e076cf0>:1(integrate_f)</span>
611	<span·class="go">···552423····0.~~478~~····0.000····0.~~478~~····0.000·<ipython-input-3-c138bdd570e3>:1(f)</span>	611	<span·class="go">···552423····0.150····0.000····0.150····0.000·<ipython-input-3-c138bdd570e3>:1(f)</span>
		612	<span·class="go">········1····0.015····0.015····0.615····0.615·apply.py:1070(apply_series_generator)</span>
612	<span·class="go">·····3000····0.025····0.000····0.~~111~~····0.000·series.py:1~~095~~(__get~~item__~~)</span>	613	<span·class="go">·····3000····0.014····0.000····0.029····0.000·series.py:1220(_get_value)</span>
613	<span·class="go">····16098····0.018····0.000····0.024····0.000·{built-in·method·builtins.isinstance}</span>
614	</pre></div>	614	</pre></div>
615	</div>	615	</div>
616	<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>,	616	<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>,
617	hence·we’ll·concentrate·our·efforts·cythonizing·these·two·functions.</p>	617	hence·we’ll·concentrate·our·efforts·cythonizing·these·two·functions.</p>
618	</section>	618	</section>
619	<section·id="plain-cython">	619	<section·id="plain-cython">
620	<span·id="enhancingperf-plain"></span><h3>Plain·Cython<a·class="headerlink"·href="#plain-cython"·title="Link·to·this·heading">#</a></h3>	620	<span·id="enhancingperf-plain"></span><h3>Plain·Cython<a·class="headerlink"·href="#plain-cython"·title="Link·to·this·heading">#</a></h3>
Offset 634, 15 lines modified		Offset 634, 15 lines modified
634	<span·class="gp">···...:·</span>····for·i·in·range(N):	634	<span·class="gp">···...:·</span>····for·i·in·range(N):
635	<span·class="gp">···...:·</span>········s·+=·f_plain(a·+·i·*·dx)	635	<span·class="gp">···...:·</span>········s·+=·f_plain(a·+·i·*·dx)
636	<span·class="gp">···...:·</span>····return·s·*·dx	636	<span·class="gp">···...:·</span>····return·s·*·dx
637	<span·class="gp">···...:·</span>	637	<span·class="gp">···...:·</span>
638	</pre></div>	638	</pre></div>


Offset 835, 16 lines modified		Offset 835, 14 lines modified
835	<span·class="gh">Out[12]:·</span>	835	<span·class="gh">Out[12]:·</span>
836	<span·class="go">············group··val</span>	836	<span·class="go">············group··val</span>
837	<span·class="go">date··················</span>	837	<span·class="go">date··················</span>
838	<span·class="go">2016-01-03······1····5</span>	838	<span·class="go">2016-01-03······1····5</span>
839	<span·class="go">2016-01-10······1····6</span>	839	<span·class="go">2016-01-10······1····6</span>
840	<span·class="go">2016-01-17······2····7</span>	840	<span·class="go">2016-01-17······2····7</span>
841	<span·class="go">2016-01-24······2····8</span>	841	<span·class="go">2016-01-24······2····8</span>

842	<span·class="go">[4·rows·x·2·columns]</span>
843	</pre></div>	842	</pre></div>
844	</div>	843	</div>
845	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="n">In</span><span·class="p">[</span><span·class="mi">1</span><span·class="p">]:</span>·<span·class="n">df</span><span·class="o">.</span><span·class="n">groupby</span><span·class="p">(</span><span·class="s2">"group"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">apply</span><span·class="p">(</span><span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span><span·class="o">.</span><span·class="n">resample</span><span·class="p">(</span><span·class="s2">"1D"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">ffill</span><span·class="p">())</span>	844	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="n">In</span><span·class="p">[</span><span·class="mi">1</span><span·class="p">]:</span>·<span·class="n">df</span><span·class="o">.</span><span·class="n">groupby</span><span·class="p">(</span><span·class="s2">"group"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">apply</span><span·class="p">(</span><span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span><span·class="o">.</span><span·class="n">resample</span><span·class="p">(</span><span·class="s2">"1D"</span><span·class="p">)</span><span·class="o">.</span><span·class="n">ffill</span><span·class="p">())</span>
846	<span·class="n">Out</span><span·class="p">[</span><span·class="mi">1</span><span·class="p">]:</span>	845	<span·class="n">Out</span><span·class="p">[</span><span·class="mi">1</span><span·class="p">]:</span>
847	··················<span·class="n">group</span>··<span·class="n">val</span>	846	··················<span·class="n">group</span>··<span·class="n">val</span>
848	<span·class="n">group</span>·<span·class="n">date</span>	847	<span·class="n">group</span>·<span·class="n">date</span>
849	<span·class="mi">1</span>·····<span·class="mi">2016</span><span·class="o">-</span><span·class="mi">01</span><span·class="o">-</span><span·class="mi">03</span>······<span·class="mi">1</span>····<span·class="mi">5</span>	848	<span·class="mi">1</span>·····<span·class="mi">2016</span><span·class="o">-</span><span·class="mi">01</span><span·class="o">-</span><span·class="mi">03</span>······<span·class="mi">1</span>····<span·class="mi">5</span>
Offset 907, 54 lines modified		Offset 905, 48 lines modified

907	<span·class="gp">In·[14]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">where</span><span·class="p">(</span><span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span>·<span·class="o">></span>·<span·class="mi">4</span><span·class="p">,</span>·<span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span>·<span·class="o">+</span>·<span·class="mi">10</span><span·class="p">)</span>	905	<span·class="gp">In·[14]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">where</span><span·class="p">(</span><span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span>·<span·class="o">></span>·<span·class="mi">4</span><span·class="p">,</span>·<span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span>·<span·class="o">+</span>·<span·class="mi">10</span><span·class="p">)</span>
908	<span·class="gh">Out[14]:·</span>	906	<span·class="gh">Out[14]:·</span>
909	<span·class="go">····A···B··C</span>	907	<span·class="go">····A···B··C</span>
910	<span·class="go">0··11··14··7</span>	908	<span·class="go">0··11··14··7</span>
911	<span·class="go">1··12···5··8</span>	909	<span·class="go">1··12···5··8</span>
912	<span·class="go">2··13···6··9</span>	910	<span·class="go">2··13···6··9</span>

913	<span·class="go">[3·rows·x·3·columns]</span>
914	</pre></div>	911	</pre></div>
915	</div>	912	</div>
916	</section>	913	</section>
917	<section·id="methods-loc-iloc-ix">	914	<section·id="methods-loc-iloc-ix">
918	<h4>Methods·<code·class="docutils·literal·notranslate"><span·class="pre">.loc[]</span></code>,·<code·class="docutils·literal·notranslate"><span·class="pre">.iloc[]</span></code>,·<code·class="docutils·literal·notranslate"><span·class="pre">.ix[]</span></code><a·class="headerlink"·href="#methods-loc-iloc-ix"·title="Link·to·this·heading">#</a></h4>	915	<h4>Methods·<code·class="docutils·literal·notranslate"><span·class="pre">.loc[]</span></code>,·<code·class="docutils·literal·notranslate"><span·class="pre">.iloc[]</span></code>,·<code·class="docutils·literal·notranslate"><span·class="pre">.ix[]</span></code><a·class="headerlink"·href="#methods-loc-iloc-ix"·title="Link·to·this·heading">#</a></h4>
919	<p>These·can·accept·a·callable,·and·a·tuple·of·callable·as·a·slicer.·The·callable	916	<p>These·can·accept·a·callable,·and·a·tuple·of·callable·as·a·slicer.·The·callable
920	can·return·a·valid·boolean·indexer·or·anything·which·is·valid·for·these·indexer’s·input.</p>	917	can·return·a·valid·boolean·indexer·or·anything·which·is·valid·for·these·indexer’s·input.</p>
921	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·callable·returns·bool·indexer</span>	918	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="go">#·callable·returns·bool·indexer</span>
922	<span·class="gp">In·[15]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">loc</span><span·class="p">[</span><span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span><span·class="o">.</span><span·class="n">A</span>·<span·class="o">>=</span>·<span·class="mi">2</span><span·class="p">,</span>·<span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">()</span>·<span·class="o">></span>·<span·class="mi">10</span><span·class="p">]</span>	919	<span·class="gp">In·[15]:·</span><span·class="n">df</span><span·class="o">.</span><span·class="n">loc</span><span·class="p">[</span><span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span><span·class="o">.</span><span·class="n">A</span>·<span·class="o">>=</span>·<span·class="mi">2</span><span·class="p">,</span>·<span·class="k">lambda</span>·<span·class="n">x</span><span·class="p">:</span>·<span·class="n">x</span><span·class="o">.</span><span·class="n">sum</span><span·class="p">()</span>·<span·class="o">></span>·<span·class="mi">10</span><span·class="p">]</span>
923	<span·class="gh">Out[15]:·</span>	920	<span·class="gh">Out[15]:·</span>
924	<span·class="go">···B··C</span>	921	<span·class="go">···B··C</span>
925	<span·class="go">1··5··8</span>	922	<span·class="go">1··5··8</span>


Offset 756, 49 lines modified		Offset 756, 41 lines modified
756	<span·class="gp">In·[3]:·</span><span·class="n">left</span>	756	<span·class="gp">In·[3]:·</span><span·class="n">left</span>
757	<span·class="gh">Out[3]:·</span>	757	<span·class="gh">Out[3]:·</span>
758	<span·class="go">····a·left_val</span>	758	<span·class="go">····a·left_val</span>
759	<span·class="go">0···1········a</span>	759	<span·class="go">0···1········a</span>
760	<span·class="go">1···5········b</span>	760	<span·class="go">1···5········b</span>
761	<span·class="go">2··10········c</span>	761	<span·class="go">2··10········c</span>

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

763	<span·class="gp">In·[4]:·</span><span·class="n">right</span>	762	<span·class="gp">In·[4]:·</span><span·class="n">right</span>
764	<span·class="gh">Out[4]:·</span>	763	<span·class="gh">Out[4]:·</span>
765	<span·class="go">···a··right_val</span>	764	<span·class="go">···a··right_val</span>
766	<span·class="go">0··1··········1</span>	765	<span·class="go">0··1··········1</span>
767	<span·class="go">1··2··········2</span>	766	<span·class="go">1··2··········2</span>
768	<span·class="go">2··3··········3</span>	767	<span·class="go">2··3··········3</span>
769	<span·class="go">3··6··········6</span>	768	<span·class="go">3··6··········6</span>
770	<span·class="go">4··7··········7</span>	769	<span·class="go">4··7··········7</span>

771	<span·class="go">[5·rows·x·2·columns]</span>
772	</pre></div>	770	</pre></div>
773	</div>	771	</div>
774	<p>We·typically·want·to·match·exactly·when·possible,·and·use·the·most	772	<p>We·typically·want·to·match·exactly·when·possible,·and·use·the·most
775	recent·value·otherwise.</p>	773	recent·value·otherwise.</p>
776	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[5]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">merge_asof</span><span·class="p">(</span><span·class="n">left</span><span·class="p">,</span>·<span·class="n">right</span><span·class="p">,</span>·<span·class="n">on</span><span·class="o">=</span><span·class="s2">"a"</span><span·class="p">)</span>	774	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[5]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">merge_asof</span><span·class="p">(</span><span·class="n">left</span><span·class="p">,</span>·<span·class="n">right</span><span·class="p">,</span>·<span·class="n">on</span><span·class="o">=</span><span·class="s2">"a"</span><span·class="p">)</span>
777	<span·class="gh">Out[5]:·</span>	775	<span·class="gh">Out[5]:·</span>
778	<span·class="go">····a·left_val··right_val</span>	776	<span·class="go">····a·left_val··right_val</span>
779	<span·class="go">0···1········a··········1</span>	777	<span·class="go">0···1········a··········1</span>
780	<span·class="go">1···5········b··········3</span>	778	<span·class="go">1···5········b··········3</span>
781	<span·class="go">2··10········c··········7</span>	779	<span·class="go">2··10········c··········7</span>

782	<span·class="go">[3·rows·x·3·columns]</span>
783	</pre></div>	780	</pre></div>
784	</div>	781	</div>
785	<p>We·can·also·match·rows·ONLY·with·prior·data,·and·not·an·exact·match.</p>	782	<p>We·can·also·match·rows·ONLY·with·prior·data,·and·not·an·exact·match.</p>
786	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[6]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">merge_asof</span><span·class="p">(</span><span·class="n">left</span><span·class="p">,</span>·<span·class="n">right</span><span·class="p">,</span>·<span·class="n">on</span><span·class="o">=</span><span·class="s2">"a"</span><span·class="p">,</span>·<span·class="n">allow_exact_matches</span><span·class="o">=</span><span·class="kc">False</span><span·class="p">)</span>	783	<div·class="highlight-ipython·notranslate"><div·class="highlight"><pre><span></span><span·class="gp">In·[6]:·</span><span·class="n">pd</span><span·class="o">.</span><span·class="n">merge_asof</span><span·class="p">(</span><span·class="n">left</span><span·class="p">,</span>·<span·class="n">right</span><span·class="p">,</span>·<span·class="n">on</span><span·class="o">=</span><span·class="s2">"a"</span><span·class="p">,</span>·<span·class="n">allow_exact_matches</span><span·class="o">=</span><span·class="kc">False</span><span·class="p">)</span>
787	<span·class="gh">Out[6]:·</span>	784	<span·class="gh">Out[6]:·</span>
788	<span·class="go">····a·left_val··right_val</span>	785	<span·class="go">····a·left_val··right_val</span>
789	<span·class="go">0···1········a········NaN</span>	786	<span·class="go">0···1········a········NaN</span>