development environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 330 3.3.6 Creating a Windows development environment . . . . . . . . . . . . . . . . . . . . . . . . 331 3.3.7 Making changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 607 15.2.2 Rolling Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 608 15.2.3 Time-aware vs. Resampling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 612 15.2.5 Centering Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 613 15.2.6 Binary

development environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 332 3.3.6 Creating a Windows development environment . . . . . . . . . . . . . . . . . . . . . . . . 333 3.3.7 Making changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 609 15.2.2 Rolling Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 610 15.2.3 Time-aware vs. Resampling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 614 15.2.5 Centering Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 615 15.2.6 Binary

development environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 380 3.3.6 Creating a Windows development environment . . . . . . . . . . . . . . . . . . . . . . . . 381 3.3.7 Making changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 677 14.2.2 Rolling Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 678 14.2.3 Time-aware vs. Resampling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 14.2.6 Centering Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 14.2.7 Binary

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 707 14.2.2 Rolling Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 708 14.2.3 Time-aware vs. Resampling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 713 14.2.6 Centering Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 713 14.2.7 Binary different functions to DataFrame columns . . . . . . . . . . . . . . . . . . . . . . 719 14.4 Expanding Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 720 14.4.1

development environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 378 3.3.6 Creating a Windows development environment . . . . . . . . . . . . . . . . . . . . . . . . 379 3.3.7 Making changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 675 14.2.2 Rolling Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 676 14.2.3 Time-aware vs. Resampling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 681 14.2.6 Centering Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 681 14.2.7 Binary

20.0 (GH24985) • DataFrame.to_stata() is now faster when outputting data with any string or non-native endian columns (GH25045) • Improved performance of Series.searchsorted(). The speedup is especially Fixed bug in missing text when using to_clipboard() if copying utf-16 characters in Python 3 on Windows (GH25040) • Bug in read_json() for orient='table' when it tries to infer dtypes by default, which keyword is used (GH16718) • Bug in read_csv() not properly interpreting the UTF8 encoded filenames on Windows on Python 3.6+ (GH15086) • Improved performance in pandas.read_stata() and pandas.io.stata.StataReader

20.0 (GH24985) • DataFrame.to_stata() is now faster when outputting data with any string or non-native endian columns (GH25045) • Improved performance of Series.searchsorted(). The speedup is especially Fixed bug in missing text when using to_clipboard() if copying utf-16 characters in Python 3 on Windows (GH25040) • Bug in read_json() for orient='table' when it tries to infer dtypes by default, which keyword is used (GH16718) • Bug in read_csv() not properly interpreting the UTF8 encoded filenames on Windows on Python 3.6+ (GH15086) • Improved performance in pandas.read_stata() and pandas.io.stata.StataReader

np.inf into a string representation, customizable by the inf_rep keyword argu- ment (Excel has no native inf representation) (GH6782) • Replace pandas.compat.scipy.scoreatpercentile with numpy.percentile All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included dialects). The functionality of providing DBAPI connection pandas: powerful Python data analysis toolkit, Release 0.14.0 Enhancements • HDFStore now can read native PyTables table format tables • You can pass nan_rep = ’my_nan_rep’ to append, to change the default

This change only affects when running on Windows, where '\r\n' was used for line terminator even when '\n' was passed in line_terminator. Previous Behavior on Windows: In [1]: data = pd.DataFrame({"string_with_lf": print(f.read()) Out[5]: b'string_with_lf,string_with_crlf\n"a\nbc","a\r\nbc"\n' New Behavior on Windows: Passing line_terminator explicitly, set thes line terminator to that character. In [1]: data = as f: ...: print(f.read()) Out[3]: b'string_with_lf,string_with_crlf\n"a\nbc","a\r\nbc"\n' On Windows, the value of os.linesep is '\r\n', so if line_terminator is not set, '\r\n' is used for line terminator

SciPy stack (IPython, NumPy, Matplotlib, ...) is with Anaconda, a cross-platform (Linux, macOS, Windows) Python distribution for data analytics and scientific computing. After running the installer, the pandas: powerful Python data analysis toolkit, Release 1.5.0rc0 source activate name_of_my_env On Windows the command is: activate name_of_my_env The final step required is to install pandas. This can System Conda PyPI Linux Successful Failed(pyarrow==3.0 Successful) macOS Successful Failed Windows Failed Failed Access data in the cloud Dependency Minimum Version Notes fsspec 2021.5.0 Handling