Topics

• Getting started with pandas
• Arrays
• Reshaping and pivoting
• Creating DataFrames
• Indexing and selecting data
• Grouping Data
• Missing Data
• Merge, join, and concatenate
• Generating random data
• Duplicated data
• String manipulation
• Data Types
• Meta: Documentation Guidelines
• Grouping Time Series Data
• IO for Google BigQuery
• Simple manipulation of DataFrames
• Getting information about DataFrames

Examples

• Delete a column in a DataFrame
• Get DataFrame information and memory usage
• Rename a column
• List DataFrame column names
• Adding a new column
• Slicing with labels
• Mixed position and label based selection
• Basic grouping
• Grouping numbers
• Filling missing values
• Dropping missing values
• Merging two DataFrames
• Transposing an array
• Boolean indexing
• Reshaping an array
• Creating a simple random array
• Setting the seed
• Creating random integers
• Selecting a random sample from an array
• Generating random numbers drawn from specific distributions
• Cross Tabulation
• Select duplicated
• Drop duplicated
• Aggregating by size versus by count
• Counting and getting unique elements
• Descriptive statistics
• Aggregating groups
• Locate and replace data in a column
• Dataframe's various summary statistics.
• Filtering columns (selecting "interesting", dropping unneeded, using RegEx, etc.)
• Checking the types of columns
• Changing dtypes
• Selecting columns based on dtype
• Summarizing dtypes
• Checking for missing values
• Slicing strings
• Checking for contents of a string
• Capitalization of strings
• Adding a new row to DataFrame
• Delete / drop rows from DataFrame
• Reading data from BigQuery with service account credentials
• Get the first/last n rows of a dataframe
• Reorder columns