remove semicolon from CREATE TABLE legacy template

It's not necessary and causes some DB engines to choke (e.g., Impala)
ENH: add method='dense' to rank
DOC: Add common error message to byte-ordering gotcha.
Merge pull request #6521 from danielballan/endian-gotcha

DOC: Add common error message to byte-ordering gotcha.
BUG: fix _ref_locs corruption when slice indexing across columns axis
Merge pull request #6525 from immerrr/fix-df-column-slice-indexer

BUG: fix DataFarame column slice indexer
BUG: Regression from 0.13 in the treatmenet of numpy datetime64 non-ns dtypes in Series creation (GH6529)
Merge pull request #6530 from jreback/datetime_convert

BUG: Regression from 0.13 in the treatmenet of numpy datetime64 non-ns dtypes in Series creation (GH6429)
BUG/API groupby head and tail act like filter, since they dont aggregage, fixes column selection
ENH: Preserve .names in df.set_index(df.index)

Preserve .names in df.set_index(df.index)

Check that df.set_index(df.index) doesn't convert a MultiIndex to an Index

Handle general case of df.set_index([df.index,...])

Cleanup

Add to release notes

Add equality checks

Fix issue on 2.6

Add example to whatsnew
informative error message
Merge pull request #6535 from clarkfitzg/error_message

BUG: informative error message with Series ValueError
Merge pull request #6459 from qwhelan/set_index_names

ENH: Preserve .names in df.set_index(df.index)
BUG: Bug in setitem with a duplicate index and an alignable rhs (GH6541)
Merge pull request #6542 from jreback/dup_assign

BUG: Bug in setitem with a duplicate index and an alignable rhs (GH6541)
BUG: Bug in setitem with loc on mixed integer Indexes (GH6546)
Merge pull request #6548 from jreback/loc_setitem

BUG: Bug in setitem with loc on mixed integer Indexes (GH6546)
BUG/API: Fix stata io to deal with wrong data types and missing values (GH6335)

BUG: Changes types used in packing structs

Corrected incorrect data type conversion between pandas and Stata

Remove unnecessary, potentially precision degrading cast to Series when writing data
Added function to cast columns from NumPy data types to Stata data types
Corrected tests for correct Stata datatypes
Fixed formatting in comparison after casting

Added docstring for new function and warning class

BUG: Fixes and tests for extreme values in all data types

The extreme values of float and double (Stata, pandas eqiv: float 32 and
float64) were not correct.  This resulted in incorrect truncation. The
handling of missing values have been improved and code to convert missing
values in any format has been added.  The improvement differentiated between
valid ranges for data and missing values.

Additional issues were found when handling missing Dates, where missing Dates
(NaT) were converted to non-missing dates when written.

A test has been added for extreme numeric values as well as missing values.

Fixed legacy date issue with format 114 files
Added test for 114 files

Added format 114 (Stata 9/10/11) data file

Add test for Stata data with file format 114

Added additional data files for testing alternative Stata file formats

Added expected result to test
Renamed Stata data files to include file format

Types used for integer conversion where always half the size they should be.
Produced a bug when exporting data tables with long integer data (np.int64).

Added test for integer conversion bug

Added test for incorrect integer conversion from int16, int32 and int64

Added additional data files for testing alternative Stata file formats

Added expected result to test
Renamed Stata data files to include file format

Disabled the big endian skips
BUG/TST: fix several issues with slice bound checking code

BUG/TST: fix handling of slice.stop < -len, obj.iloc[:-len(obj)] should be empty

BUG/TST: fix exceptions raised by Series.iloc when slice.start > len

CLN: remove unused _check_slice_bound function and raise_on_error params
Merge pull request #6531 from immerrr/fix-out-of-bounds-slice-issues

BUG/TST: fix several issues with slice bound checking code