Pandas cookbook recipes for scientific computing, time series analysis and data visualization using Python
Over 95 hands-on recipes to leverage the power of pandas for efficient scientific computation and data analysis About This Book Use the power of pandas to solve most complex scientific computing problems with ease Leverage fast, robust data structures in pandas to gain useful insights from your data...
Otros Autores: | |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Birmingham, England ; Mumbai, [India] :
Packt
2017.
|
Edición: | 1st edition |
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631110706719 |
Tabla de Contenidos:
- Cover
- Title Page
- Copyright
- Credits
- About the Author
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
- Customer Feedback
- Table of Contents
- Preface
- Chapter 1: Pandas Foundations
- Introduction
- Dissecting the anatomy of a DataFrame
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Accessing the main DataFrame components
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Understanding data types
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Selecting a single column of data as a Series
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Calling Series methods
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Working with operators on a Series
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Chaining Series methods together
- Getting ready
- How to do it...
- How it works...
- There's more...
- Making the index meaningful
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Renaming row and column names
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating and deleting columns
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Chapter 2: Essential DataFrame Operations
- Introduction
- Selecting multiple DataFrame columns
- Getting ready
- How to do it...
- How it works...
- There's more...
- Selecting columns with methods
- Getting ready
- How it works...
- How it works...
- There's more...
- See also
- Ordering column names sensibly
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Operating on the entire DataFrame.
- Getting ready
- How to do it...
- How it works...
- There's more...
- Chaining DataFrame methods together
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Working with operators on a DataFrame
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Comparing missing values
- Getting ready
- How to do it...
- How it works...
- There's more...
- Transposing the direction of a DataFrame operation
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Determining college campus diversity
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Chapter 3: Beginning Data Analysis
- Introduction
- Developing a data analysis routine
- Getting ready
- How to do it...
- How it works...
- There's more...
- Data dictionaries
- See also
- Reducing memory by changing data types
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Selecting the smallest of the largest
- Getting ready
- How to do it...
- How it works...
- There's more...
- Selecting the largest of each group by sorting
- Getting ready
- How to do it...
- How it works...
- There's more...
- Replicating nlargest with sort_values
- Getting ready
- How to do it...
- How it works...
- There's more...
- Calculating a trailing stop order price
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Chapter 4: Selecting Subsets of Data
- Introduction
- Selecting Series data
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Selecting DataFrame rows
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Selecting DataFrame rows and columns simultaneously
- Getting ready
- How to do it.
- How it works...
- There's more...
- Selecting data with both integers and labels
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Speeding up scalar selection
- Getting ready
- How to do it...
- How it works...
- There's more...
- Slicing rows lazily
- Getting ready
- How to do it...
- How it works...
- There's more...
- Slicing lexicographically
- Getting ready
- How to do it...
- How it works...
- There's more...
- Chapter 5: Boolean Indexing
- Introduction
- Calculating boolean statistics
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Constructing multiple boolean conditions
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Filtering with boolean indexing
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Replicating boolean indexing with index selection
- Getting ready
- How to do it...
- How it works...
- There's more...
- Selecting with unique and sorted indexes
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Gaining perspective on stock prices
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Translating SQL WHERE clauses
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Determining the normality of stock market returns
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Improving readability of boolean indexing with the query method
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Preserving Series with the where method
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Masking DataFrame rows
- Getting ready
- How to do it.
- How it works...
- There's more...
- See also
- Selecting with booleans, integer location, and labels
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Chapter 6: Index Alignment
- Introduction
- Examining the Index object
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Producing Cartesian products
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Exploding indexes
- Getting ready
- How to do it...
- How it works...
- There's more...
- Filling values with unequal indexes
- Getting ready
- How to do it...
- How it works...
- There's more...
- Appending columns from different DataFrames
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Highlighting the maximum value from each column
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Replicating idxmax with method chaining
- Getting ready
- How to do it...
- How it works...
- There's more...
- Finding the most common maximum
- Getting ready
- How to do it...
- How it works...
- There's more...
- Chapter 7: Grouping for Aggregation, Filtration, and Transformation
- Introduction
- Defining an aggregation
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Grouping and aggregating with multiple columns and functions
- Getting ready
- How to do it...
- How it works...
- There's more...
- Removing the MultiIndex after grouping
- Getting ready
- How to do it...
- How it works...
- There's more...
- Customizing an aggregation function
- Getting ready
- How to do it...
- How it works...
- There's more...
- Customizing aggregating functions with *args and **kwargs
- Getting ready
- How to do it...
- How it works...
- There's more.
- See also
- Examining the groupby object
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Filtering for states with a minority majority
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Transforming through a weight loss bet
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Calculating weighted mean SAT scores per state with apply
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Grouping by continuous variables
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Counting the total number of flights between cities
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Finding the longest streak of on-time flights
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Chapter 8: Restructuring Data into a Tidy Form
- Introduction
- Tidying variable values as column names with stack
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Tidying variable values as column names with melt
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Stacking multiple groups of variables simultaneously
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Inverting stacked data
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Unstacking after a groupby aggregation
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Replicating pivot_table with a groupby aggregation
- Getting ready
- How to do it...
- How it works...
- There's more...
- Renaming axis levels for easy reshaping
- Getting ready
- How to do it.
- How it works.