v0.8.38

What's Changed

• Answer cross and anti merges as pandas does by @tamnd in #1338
• Read a list of integers with a gap as float64 by @tamnd in #1339
• Answer str.partition and str.rpartition with expand=False by @tamnd in #1340
• Answer seven parameters that used to refuse by @tamnd in #1341
• Count days, hours, minutes and floats in to_datetime, and fill every gap in align by @tamnd in #1342
• Add pivot_table margins by @tamnd in #1343
• Refuse pivot_table margins beside column keys that are not text by @tamnd in #1344
• Add the masked text type string by @tamnd in #1346
• Reduce across rows, and sort with a key by @tamnd in #1347
• Take a positional axis on the reductions, with pandas' warning by @tamnd in #1348
• Apply with raw and result_type, and transform with lists by @tamnd in #1349
• Take skipna, min_count and numeric_only on group by reductions by @tamnd in #1350
• PIVOT with no IN list pivots on the values the column holds by @tamnd in #1351
• Widen where, mask and shift the way pandas does by @tamnd in #1352
• CHANGELOG: put the PIVOT entry at the top of Unreleased by @tamnd in #1353
• A VALUES column takes the type that holds every row by @tamnd in #1354
• Keep the row labels' frequency and shift by a frequency by @tamnd in #1355
• Take skipna=False on group first and last, and keep picked categories by @tamnd in #1356
• Hold flags beside a gap as objects, as pandas does by @tamnd in #1357
• Write flags cast to text as True and False by @tamnd in #1358
• Fuse a group by whose text key is coded by @tamnd in #1359
• Put a blank line before changelog headings by @tamnd in #1360
• Take a dropna of its own on group value counts by @tamnd in #1361
• Read a gap on a level of numbers back as NaN by @tamnd in #1362
• Take dtype on the Index constructor and read instants and spans by dtype by @tamnd in #1363
• Parse instants asked for by dtype one by one by @tamnd in #1364
• CAST of a date or a timestamp to VARCHAR writes the instant by @tamnd in #1365
• Hold an index of objects as pandas does by @tamnd in #1366
• Hold an index of a masked type as pandas does by @tamnd in #1367
• Keep a masked key's type on the answer by @tamnd in #1368
• Keep a masked column's type under group reductions by @tamnd in #1369
• Export a masked column to Arrow at its own width by @tamnd in #1370
• Parse text through astype to instants and spans, and close three smaller gaps by @tamnd in #1371
• Read each text on its own when astype parses instants by @tamnd in #1372
• Read a list of tuples as levels where pandas does by @tamnd in #1373
• Give the axes and names the setters pandas has by @tamnd in #1374
• Refuse text and number arithmetic with pandas' TypeError, let df.a write column a by @tamnd in #1375
• Sum and scan text as pandas does, refuse the other reductions in pandas' words by @tamnd in #1376
• Decay ewm by real instants with times= as pandas does by @tamnd in #1377
• Take a DatetimeIndex and read infinities as gaps in ewm times= by @tamnd in #1378
• Read infinities in rolling, expanding and ewm windows as missing values as pandas does by @tamnd in #1379
• Lay resample bins from origin= end, end_day or a timestamp and move them by offset= as pandas does by @tamnd in #1380
• Answer float64 counts and positions for text with a gap as pandas does by @tamnd in #1381
• Name the column axis as pandas does by @tamnd in #1382
• Pivot into columns of several levels as pandas does by @tamnd in #1383
• Total pivot tables beside several values as pandas does by @tamnd in #1384
• Refuse a window over a column that is not numbers with pandas' DataError by @tamnd in #1385
• Take labels as well as column names in set_index as pandas does by @tamnd in #1386
• Resample on weeks, months, quarters and years as pandas does by @tamnd in #1387
• Drop missing values with thresh, across the columns and numbering again by @tamnd in #1388
• Print boolean column names flush left to one width as pandas does by @tamnd in #1389
• Concat with keys across the columns as pandas does by @tamnd in #1390
• Describe moments and spans, and pick columns by type by @tamnd in #1391
• Take tz, dtype and copy in the temporal index constructors by @tamnd in #1392
• Drop repeated row labels, refuse a lossy transpose, keep categories handed in whole by @tamnd in #1393
• Make CategoricalIndex a class with pandas' lookups and category methods by @tamnd in #1394
• Look labels up beside a gap in a CategoricalIndex, and map a gap as pandas does by @tamnd in #1395
• Name a missing row label in drop as pandas does by @tamnd in #1396
• Answer in and drop for a label of another type as pandas does by @tamnd in #1397
• Settle a repeated or skipped hour in Timestamp.tz_localize as pandas does by @tamnd in #1398
• A zone on one level of a MultiIndex, and numpy codes from factorize by @tamnd in #1399
• A list of reductions over a window of a frame by @tamnd in #1400
• corr and cov of every pair of columns over a window by @tamnd in #1401
• rename of the row labels by @tamnd in #1402
• mean, median and the spreads over a whole frame by @tamnd in #1403
• Arithmetic on one level of a MultiIndex by @tamnd in #1404
• Keep int64 when a Series covers every MultiIndex column by @tamnd in #1405
• Fold flags beside numbers or text down the columns as pandas does by @tamnd in #1406
• Reduce rows of flags beside numbers as objects as pandas does by @tamnd in #1407
• SET, RESET, PRAGMA, PREPARE and enable_external_access by @tamnd in #1408
• Scan across the rows of a frame and down object columns as pandas does by @tamnd in #1410
• Rank, shift, diff, pct_change and fill across the rows as pandas does by @tamnd in #1411
• Count values in bins and verify set_index labels as pandas does by @tamnd in #1412
• Take a list of quantiles and the picking rules in a group by's quantile by @tamnd in #1413
• Take a slice of places in a group by's nth by @tamnd in #1414
• Sort the index with a direction per level as pandas does by @tamnd in #1415
• firepanda.sql and DataFrame.sql run a query over the frames in scope by @tamnd in #1416
• Shift by a list of periods as pandas does by @tamnd in #1417
• Take DataFrame.quantile across the rows as pandas does by @tamnd in #1418
• Unstack several levels at once by @tamnd in #1419
• Answer at on a repeated label as pandas does by @tamnd in #1420
• Series.compare with align_axis=0 by @tamnd in #1421
• DataFrame.mode along the rows by @tamnd in #1422
• from_records with several index columns by @tamnd in #1423
• Group idxmax and idxmin with as_index=False by @tamnd in #1424
• Group by the levels of a MultiIndex by @tamnd in #1425
• Groupers and levels beside other keys in groupby by @tamnd in #1426
• Kendall's tau and callables in corr by @tamnd in #1427
• Whole number levels with a gap stay whole by @tamnd in #1428
• FrozenList for names, levels and codes by @tamnd in #1429
• Selecting a key column with as_index=False by @tamnd in #1430
• apply answering one value a group with as_index=False by @tamnd in #1431
• Take arguments and every pandas name in GroupBy.transform by @tamnd in #1432
• Run functions over resample bins, ohlc over a frame, and level= on a MultiIndex by @tamnd in #1433
• Resample timestamps with a zone by @tamnd in #1434
• Add MultiIndex to_frame, value_counts, sort keys, several-level lookups and fill indexers by @tamnd in #1435
• ambiguous="infer", align by a level of a MultiIndex, quantiles as an array by @tamnd in #1436
• numeric_only windows, blanked filters, counted nth, resample group_keys and copy= by @tamnd in #1437
• crosstab with several keys on an axis by @tamnd in #1438
• limit_area on ffill and bfill by @tamnd in #1439
• The join refusal no longer names POSITIONAL, which runs by @tamnd in #1440
• shift by a frequency across columns and on periods by @tamnd in #1441
• numeric_only on series reductions and group by folds by @tamnd in #1442
• group counts from the end, nunique with gaps, and shift fills by @tamnd in #1443
• Take skipna=False on group by any, all, idxmax and idxmin by @tamnd in #1445
• Take freq on pct_change by @tamnd in #1446
• Take include and exclude on a group by's describe by @tamnd in #1447
• Take bins on a group by's value_counts, with intervals as row labels by @tamnd in #1448
• Send an IntervalIndex to Arrow as pandas sends it by @tamnd in #1449
• Add method, limit and tolerance to Index.get_indexer and Index.reindex by @tamnd in #1450
• Take every sort_index argument on the column labels by @tamnd in #1451
• Melt columns of several levels, and take col_level by @tamnd in #1452
• Take reset_index names on row labels of one level by @tamnd in #1453
• Count the rows for a count of a constant by @tamnd in #1409
• Take round_ok=False on as_unit, and warn of truncate copy by @tamnd in #1454
• Take origin on to_datetime by @tamnd in #1455
• to_datetime with exact=False by @tamnd in #1456
• reset_index on MultiIndex columns, with col_level and col_fill by @tamnd in #1457
• DataFrame.quantile with method="table" by @tamnd in #1458
• skipna on groupby cumsum, cumprod, cummin and cummax by @tamnd in #1459
• Refuse axis=None where pandas refuses it by @tamnd in #1460
• Take quantile over a category column the way pandas does by @tamnd in #1461
• Accept allow_duplicates=True when no column label repeats by @tamnd in #1462
• Read Index.view(cls) as pandas does and match pct_change fill_method errors by @tamnd in #1463
• Join a list of frames the way pandas does by @tamnd in #1464
• Keep categories of instants and spans in their own type by @tamnd in #1465
• Fix isin on instant and span columns by @tamnd in #1466
• Add nlargest keep='all' and several columns, and str.repeat per row by @tamnd in #1467
• Add aligned isin, get_dummies types, verified keyed concat and row squeeze by @tamnd in #1468
• Add bitwise operators on integers, callable str.replace and categorical factorize by @tamnd in #1469
• Take several patterns in replace with regex by @tamnd in #1471
• Join repeated row labels in align and combine_first by @tamnd in #1472
• Pivot over several columns keys by @tamnd in #1473
• Fix nunique with NaN and keep column level names on reductions by @tamnd in #1474
• Bin instants and spans in cut and qcut by @tamnd in #1475
• Build interval_range of instants and spans by @tamnd in #1476
• Build a column from an IntervalIndex by @tamnd in #1477
• Interpolate by labels that do not rise by @tamnd in #1478
• Interpolate zoned instants and describe intervals by @tamnd in #1479
• Correlate instants, spans and categories by @tamnd in #1480
• Cross sections across columns of several levels by @tamnd in #1481
• Index classes show pandas' signatures by @tamnd in #1482
• Take an alias on a table function by @tamnd in #1483
• Make IntervalIndex an Index of interval labels by @tamnd in #1484
• Resample rows labelled by periods by @tamnd in #1485
• Export period labels to Arrow as pandas does by @tamnd in #1486
• Run resample apply functions in pandas' order by @tamnd in #1487
• Take Timestamp fold and MultiIndex sortorder as pandas does by @tamnd in #1488
• Carry level names, reindex by level and sparsify as pandas does by @tamnd in #1489
• Keep a CategoricalIndex handed over as the labels by @tamnd in #1490
• Group every category in pivot_table and keep names in a mixed concat by @tamnd in #1491
• Let an inner join skip putting an exchanged pairing back in left row order by @tamnd in #1492
• Put a sieve in front of a sparse direct join table by @tamnd in #1493
• Gather a short join output's columns side by side by @tamnd in #1494
• Pair a tall side against a sparse short side in one pass by @tamnd in #1495
• Count distinct over codes through SQL by @tamnd in #1470
• Note the distinct count on codes in the changelog by @tamnd in #1496
• Release 0.8.38 by @tamnd in #1498

Full Changelog: v0.8.37...v0.8.38