The simplest way to install not only pandas, but Python and the most popular packages that make up the SciPy stack (IPython, NumPy, Matplotlib, ) is with Anaconda, a cross-platform (Linux, macOS, Windows) Python distribution for data analytics and scientific computing. Pandas is a Python library used for working with data sets. It has functions for analyzing, cleaning, exploring, and manipulating data. The name 'Pandas' has a reference to both 'Panel Data', and 'Python Data Analysis' and was created by Wes McKinney in 2008.
|Original author(s)||Wes McKinney|
|Initial release||11 January 2008; 13 years ago|
|Written in||Python, Cython, C|
|License||New BSD License|
pandas is a software library written for the Python programming language for data manipulation and analysis. In particular, it offers data structures and operations for manipulating numerical tables and time series. It is free software released under the three-clause BSD license. The name is derived from the term 'panel data', an econometrics term for data sets that include observations over multiple time periods for the same individuals. Its name is a play on the phrase 'Python data analysis' itself.Wes McKinney started building what would become pandas at AQR Capital while he was a researcher there from 2007 to 2010.
Python Pandas Groupby
- DataFrame object for data manipulation with integrated indexing.
- Tools for reading and writing data between in-memory data structures and different file formats.
- Data alignment and integrated handling of missing data.
- Reshaping and pivoting of data sets.
- Label-based slicing, fancy indexing, and subsetting of large data sets.
- Data structure column insertion and deletion.
- Group by engine allowing split-apply-combine operations on data sets.
- Data set merging and joining.
- Hierarchical axis indexing to work with high-dimensional data in a lower-dimensional data structure.
- Time series-functionality: Date range generation and frequency conversion, moving window statistics, moving window linear regressions, date shifting and lagging.
- Provides data filtration.
The library is highly optimized for performance, with critical code paths written in Cython or C.
Pandas is mainly used for data analysis. Pandas allows importing data from various file formats such as comma-separated values, JSON, SQL, Microsoft Excel. Pandas allows various data manipulation operations such as merging, reshaping, selecting, as well as data cleaning, and data wrangling features.
Developer Wes McKinney started working on pandas in 2008 while at AQR Capital Management out of the need for a high performance, flexible tool to perform quantitative analysis on financial data. Before leaving AQR he was able to convince management to allow him to open source the library.
Another AQR employee, Chang She, joined the effort in 2012 as the second major contributor to the library.
In 2015, pandas signed on as a fiscally sponsored project of NumFOCUS, a 501(c)(3) nonprofit charity in the United States.
Python Panda Tutorial
- ^'Release 1.2.4'. 12 April 2021. Retrieved 13 April 2021.
- ^'License – Package overview – pandas 1.0.0 documentation'. pandas. 28 January 2020. Retrieved 30 January 2020.
- ^Wes McKinney (2011). 'pandas: a Foundational Python Library for Data Analysis and Statistics'(PDF). Retrieved 2 August 2018.
- ^McKinney, Wes (2017). Python for Data Analysis, Second Edition. O'Reilly Media. p. 5. ISBN9781491957660.
- ^Kopf, Dan. 'Meet the man behind the most important tool in data science'. Quartz. Retrieved 17 November 2020.
- ^'pandas.date_range – pandas 1.0.0 documentation'. pandas. 29 January 2020. Retrieved 30 January 2020.
- ^'Python Data Analysis Library – pandas: Python Data Analysis Library'. pandas. Retrieved 13 November 2017.
- ^'NumFOCUS – pandas: a fiscally sponsored project'. NumFOCUS. Retrieved 3 April 2018.
Python Pandas Install
- Chen, Daniel Y. (2018). Pandas for Everyone : Python Data Analysis. Boston: Addison-Wesley. ISBN978-0-13-454693-3.
- McKinney, Wes (2017). Python for Data Analysis : Data Wrangling with Pandas, NumPy, and IPython (2nd ed.). Sebastopol: O'Reilly. ISBN978-1-4919-5766-0.
- VanderPlas, Jake (2016). 'Data Manipulations with Pandas'. Python Data Science Handbook: Essential Tools for Working with Data. O'Reilly. pp. 97–216. ISBN978-1-4919-1205-8.
- Pathak, Chankey (2018). 'Pandas Cookbook'. Pandas Cookbook. pp. 1–8.